Home » RDBMS Server » Performance Tuning » Hit Rate. (Oracle10g, Windows 2003)
Hit Rate. [message #327987] Wed, 18 June 2008 09:19 Go to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member
Hi

I want to know the hit rate of a table Tab_A,
Ideally i want know how many times it accessed from datafile and how many times from buffers.

Please advise how -->

Wishes

Report message to a moderator

Re: Hit Rate. [message #328002 is a reply to message #327987] Wed, 18 June 2008 10:27 Go to previous message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you have a look at AWR tables?
Also V$SEGMENT_STATISTICS view.

Regards
Michel

Report message to a moderator

Previous Topic: SQL Tune
Next Topic: Self join removal
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 13:25:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.