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: 188
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
Re: Hit Rate. [message #328002 is a reply to message #327987] Wed, 18 June 2008 10:27 Go to previous message
Michel Cadot
Messages: 64139
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
Previous Topic: SQL Tune
Next Topic: Self join removal
Goto Forum:
  


Current Time: Fri Dec 09 02:10:53 CST 2016

Total time taken to generate the page: 0.07155 seconds