Home » RDBMS Server » Server Administration » gathering database statistics (Oracle 10.2.0.4.0, RedHatLinux-5)
gathering database statistics [message #594815] Tue, 03 September 2013 06:20 Go to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi Michel,I need to view database statistics after executing
SQL> exec dbms_stats.gather_database_stats;
is that really possible? how to check it?


Re: gathering database statistics [message #594816 is a reply to message #594815] Tue, 03 September 2013 06:38 Go to previous messageGo to next message
gazzag
Messages: 367
Registered: November 2010
Location: Bristol, UK
Senior Member
SQL> select last_analyzed from dba_tables where table_name='<table_name>';
Re: gathering database statistics [message #594817 is a reply to message #594815] Tue, 03 September 2013 06:49 Go to previous messageGo to next message
Michel Cadot
Messages: 59816
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you mean by "view database statistics"?
If this is the date then gazzag gave you the answer for the tables, you have the same kind of thing for indexes, partitions...

Regards
Michel
Re: gathering database statistics [message #594846 is a reply to message #594817] Tue, 03 September 2013 08:24 Go to previous messageGo to next message
BlackSwan
Messages: 23061
Registered: January 2009
Senior Member
query ALL_TAB_COL_STATISTICS
Re: gathering database statistics [message #594861 is a reply to message #594846] Tue, 03 September 2013 11:04 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi Gazzag, iam not asking for tables alone, first understand the question, iam asking for the whole database.
Re: gathering database statistics [message #594862 is a reply to message #594861] Tue, 03 September 2013 11:10 Go to previous messageGo to next message
BlackSwan
Messages: 23061
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/


How will you, I or anyone recognize when a correct solution has been posted?
Re: gathering database statistics [message #594864 is a reply to message #594861] Tue, 03 September 2013 11:12 Go to previous message
Michel Cadot
Messages: 59816
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
srajagopal wrote on Tue, 03 September 2013 18:04
Hi Gazzag, iam not asking for tables alone, first understand the question, iam asking for the whole database.


Explain what you want, I, and I bet I'm not the only one, don't understand what it is.
So explain IN DETAILS.

Regards
Michel
Previous Topic: DB link access to user
Next Topic: Idle Instance issue
Goto Forum:
  


Current Time: Fri Nov 28 07:59:05 CST 2014

Total time taken to generate the page: 0.06851 seconds