Home » RDBMS Server » Performance Tuning » 10 % Hit Ratio
10 % Hit Ratio [message #64806] Mon, 09 February 2004 03:29 Go to next message
Qavi
Messages: 24
Registered: August 2002
Junior Member
-

Hello Masters,

   i'm facing problem with performance on Oracle 9i database for last 1 month, its taking 2 Min to commit 1 record in a table, and my HIT RATIO is 100% with very hig consistent gets , how to reduce hit ration > 90% and increase the performance, its urgent please , Thx in advance

Rgds

Qavi
-
Re: 10 % Hit Ratio [message #64809 is a reply to message #64806] Mon, 09 February 2004 06:51 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Good & sensible question. Recognising that 100% hit ratio could infact be bad for performance is certainly ,in the right direction.
Did you have a chance to look at v$sql for high buffer_gets ? and tune those queries.

-Thiru
Re: 10 % Hit Ratio [message #64816 is a reply to message #64809] Wed, 11 February 2004 19:46 Go to previous messageGo to next message
Qavi
Messages: 24
Registered: August 2002
Junior Member
Dear Thiru can u give me the solution , i mean the sample codes for v$sql for high buffer_gets, please waiting for ur precious reply

Rgds
Qavi
Re: 10 % Hit Ratio [message #64817 is a reply to message #64816] Thu, 12 February 2004 09:59 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member

-- for eg, the following query gives you the top 10 sql based on  buffer_gets

SQL> select * from ( select sql_text,executions,FIRST_LOAD_TIME,DISK_READS,BUFFER_GETS,CPU_TIME from v$sql order by  buffer_gets desc) where rownum <= 10;



-Thiru
Previous Topic: Sample database for tuning tests
Next Topic: number of stmts executed against an oracle instance
Goto Forum:
  


Current Time: Thu Mar 28 08:59:14 CDT 2024