| 10 % Hit Ratio [message #64806] |
Mon, 09 February 2004 03:29  |
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  |
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 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
