iu use Toad to monitor my Oraclr databases.
I got the following in one of the databases.
1) Parse to execute ratio : 100.13
2) redo space wait ratio 0.0074
3)library cache hit ratio 90% (application using literal sql)
4) Buffer hit ratio : 99.987
My logbuffer is 10MB.
Redo log size = 5 of them 20 MB each.
How do I optimize the performace ?
Geo