Home » RDBMS Server » Server Administration » check statistics (oracle 8.1.7, solaris)
check statistics [message #339197] Thu, 07 August 2008 01:17 Go to next message
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?

Re: check statistics [message #339223 is a reply to message #339197] Thu, 07 August 2008 02:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: check statistics [message #339233 is a reply to message #339223] Thu, 07 August 2008 02:15 Go to previous messageGo to next message
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';
Re: check statistics [message #339246 is a reply to message #339233] Thu, 07 August 2008 02:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you have no table in SCHEMANAME.

Regards
Michel
Re: check statistics [message #339997 is a reply to message #339246] Sun, 10 August 2008 20:44 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
I have table in schema.
Re: check statistics [message #339998 is a reply to message #339197] Sun, 10 August 2008 20:51 Go to previous message
BlackSwan
Messages: 25033
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
Previous Topic: Log_checkpoint_interval and Log_checkpoint_timeout
Next Topic: catlog.sql
Goto Forum:
  


Current Time: Sat Dec 03 03:37:48 CST 2016

Total time taken to generate the page: 0.04993 seconds