OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » check statistics (oracle 8.1.7, solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

check statistics [message #339197]

Thu, 07 August 2008 01:17

daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india

Member

Hi All,
I have updated the schema statistics using
dbms_stats procedure.
i got the message procedure successfully completed.
when i checked the last_analyzed column in dba_tables view
i got the result as no rows selected.
could you please let me know how to check whether statistics are gathered or not?

Report message to a moderator

Re: check statistics [message #339223 is a reply to message #339197]

Thu, 07 August 2008 02:08

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you have "no rows selected" then there is no table unless you add a where clause but as you don't think sharing your query should be important we can't say more on what you did.

please read OraFAQ Forum Guide

Regards
Michel

Report message to a moderator

Re: check statistics [message #339233 is a reply to message #339223]

Thu, 07 August 2008 02:15

daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india

Member

i run the query
select last_analyzed from dba_tables where owner='SCHEMANAME';

Report message to a moderator

Re: check statistics [message #339246 is a reply to message #339233]

Thu, 07 August 2008 02:40

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So you have no table in SCHEMANAME.

Regards
Michel

Report message to a moderator

Re: check statistics [message #339997 is a reply to message #339246]

Sun, 10 August 2008 20:44

daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india

Member

I have table in schema.

Report message to a moderator

Re: check statistics [message #339998 is a reply to message #339197]

Sun, 10 August 2008 20:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

Using sqlplus please post proof via CUT & PASTE

Report message to a moderator

Previous Topic:	Log_checkpoint_interval and Log_checkpoint_timeout
Next Topic:	catlog.sql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 15:39:58 CDT 2024