Good advice from Sybaseguru, starting with your memory, next you probably want to find any bottlenecks in your I/O. Are you hitting just a couple tables with lots of physical read/writes, where are those tables located? Are they on the same disk? I think you can find this info in v$datafile and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.