OraFAQ Forum: Server Administration » how to find most frequently accessed objects

Home » RDBMS Server » Server Administration » how to find most frequently accessed objects

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

how to find most frequently accessed objects [message #274911]

Wed, 17 October 2007 11:35

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

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

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

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

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

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

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:18:30 CDT 2024