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: 22
Registered: March 2007
Junior Member
can some one help me in finding the most frequently accessed database objects. ( like top 20 segments)

Thanks
Ram

Report message to a moderator

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: 4963
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.

Report message to a moderator

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: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
v$segment_statistics

Regards
Michel

Report message to a moderator

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: 22
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.

Report message to a moderator

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

Report message to a moderator

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: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What does this add to my answer?

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

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: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Ah, ok!

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 21 13:08:40 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.