OraFAQ Forum: Performance Tuning » How can we get statistics on a table being used 24/7 in a database

Home » RDBMS Server » Performance Tuning » How can we get statistics on a table being used 24/7 in a database

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

How can we get statistics on a table being used 24/7 in a database [message #266058]

Sun, 09 September 2007 07:57

coolboy2005in
Messages: 12
Registered: July 2007
Location: Herndon

Junior Member

Hi Guys,
I am a new DBA and we have a table that is being used by various applications and users on a 24/7 basis. I have to generate statistics on that table.

I believe that we cannot use analyze command on an active table.
So how can we get this table statistics.

My environment is RHEL 3 & 4. We have both 9i & 10 g database.

Any help will be appreciated. Thanks in advance...

Report message to a moderator

Re: How can we get statistics on a table being used 24/7 in a database [message #266059 is a reply to message #266058]

Sun, 09 September 2007 08:01

coolboy2005in
Messages: 12
Registered: July 2007
Location: Herndon

Junior Member

The database version is Oracle 9i R2 and Oracle 10g R1.

Report message to a moderator

Re: How can we get statistics on a table being used 24/7 in a database [message #266060 is a reply to message #266058]

Sun, 09 September 2007 08:02

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

You can use

SQL>exec dbms_stats.gather_table_stats('TABLE','&table_name');

In 10g Database statistics is automatically generated.

Regards
Taj

Report message to a moderator

Re: How can we get statistics on a table being used 24/7 in a database [message #266063 is a reply to message #266060]

Sun, 09 September 2007 08:10

coolboy2005in
Messages: 12
Registered: July 2007
Location: Herndon

Junior Member

Thanks Taj...

Thanks for the help.

Report message to a moderator

Re: How can we get statistics on a table being used 24/7 in a database [message #266087 is a reply to message #266063]

Sun, 09 September 2007 10:46

mson77
Messages: 208
Registered: August 2007
Location: Brazil

Senior Member

Hello coolboy2005in,

Besides Taj information, you can also use this:

SQL> exec dbms_stats.gather_schema_stats('schema',NULL);

Regards,

mson77

Report message to a moderator

Previous Topic:	Instance Efficiency
Next Topic:	How to identify a parse of SQL statement?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 10:08:46 CDT 2024