| I have problems with I/O [message #56964] |
Fri, 09 May 2003 09:45 |
Fersixty
Messages: 1
Registered: May 2003
|
Junior Member |
|
|
I have problems with I/O, i tunnne SGA area, the hits ratios are fine, the Buffer Cache Hit Ratio is 96%, the Dictionary Cache Hit Ratio is 99%, Disk Sort Ratio is 99%; some days ago, we set in the database the CHOOSE Optimizer metod, and the querys I/O decrease; some times i think that the proble was the waits in the database, but de wait don't cause I/O; the I/O problem is only in the datafile of data.
if someone can help me.. i apreciate it
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
