Home » RDBMS Server » Server Administration » how to find most frequently accessed objects
how to find most frequently accessed objects [message #274911] Wed, 17 October 2007 11:35 Go to next message
DRDBA
Messages: 20
Registered: March 2007
Junior Member
can some one help me in finding the most frequently accessed database objects. ( like top 20 segments)

Thanks
Ram
Re: how to find most frequently accessed objects [message #274914 is a reply to message #274911] Wed, 17 October 2007 12:16 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
Auditing should be able to help you with part of your question not in parenthesis.

Please clarify what you mean by top 20 segments.
Re: how to find most frequently accessed objects [message #274918 is a reply to message #274911] Wed, 17 October 2007 12:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
v$segment_statistics

Regards
Michel
Re: how to find most frequently accessed objects [message #274925 is a reply to message #274911] Wed, 17 October 2007 13:27 Go to previous messageGo to next message
DRDBA
Messages: 20
Registered: March 2007
Junior Member
In AWR report I receive top 5 segments by logical/physical reads. How to tweak AWR report to show top 20 segments.
Re: how to find most frequently accessed objects [message #274961 is a reply to message #274911] Wed, 17 October 2007 23:04 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member



select object_name, value from v$segment_statistics order by 2
Re: how to find most frequently accessed objects [message #274972 is a reply to message #274961] Wed, 17 October 2007 23:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What does this add to my answer?

Regards
Michel
Re: how to find most frequently accessed objects [message #274974 is a reply to message #274911] Wed, 17 October 2007 23:56 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Actually, Nothing.
Re: how to find most frequently accessed objects [message #275001 is a reply to message #274974] Thu, 18 October 2007 01:31 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ah, ok!

Previous Topic: ORA-342 & ORA-312
Next Topic: OLTP template and license
Goto Forum:
  


Current Time: Fri Dec 09 01:44:30 CST 2016

Total time taken to generate the page: 0.16433 seconds