Hi ,
I am runnign oracle 8i database.
I used TOAD to check the hit ratio and later I found that
the redo space wait ratio = 1.7567.
What do I do to improve performace.
I am also seeing high parse to execute ratio = 100.54
Please advice.
Geo
Printable View
Hi ,
I am runnign oracle 8i database.
I used TOAD to check the hit ratio and later I found that
the redo space wait ratio = 1.7567.
What do I do to improve performace.
I am also seeing high parse to execute ratio = 100.54
Please advice.
Geo
high parse to execute ratio,look at this recent thread
http://www.dbasupport.com/forums/sho...threadid=11292
Gert
Thanks,
What about the redo space wait ratio = 1.7567.
geo
Add more redo logs. To reduce the waits, also make sure that they are sufficient enough.
Sam