OraFAQ Forum: Server Administration » gathering database statistics

Home » RDBMS Server » Server Administration » gathering database statistics (Oracle 10.2.0.4.0, RedHatLinux-5)

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

gathering database statistics [message #594815]

Tue, 03 September 2013 06:20

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?

Report message to a moderator

Re: gathering database statistics [message #594816 is a reply to message #594815]

Tue, 03 September 2013 06:38

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

SQL> select last_analyzed from dba_tables where table_name='<table_name>';

Report message to a moderator

Re: gathering database statistics [message #594817 is a reply to message #594815]

Tue, 03 September 2013 06:49

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: gathering database statistics [message #594846 is a reply to message #594817]

Tue, 03 September 2013 08:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

query ALL_TAB_COL_STATISTICS

Report message to a moderator

Re: gathering database statistics [message #594861 is a reply to message #594846]

Tue, 03 September 2013 11:04

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.

Report message to a moderator

Re: gathering database statistics [message #594862 is a reply to message #594861]

Tue, 03 September 2013 11:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

Re: gathering database statistics [message #594864 is a reply to message #594861]

Tue, 03 September 2013 11:12

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	DB link access to user
Next Topic:	Idle Instance issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 14:51:28 CST 2024