Re: CPU waiting for... what? (mistery)

"Juergen Lueters" <jlueters_at_intranet-engineering.de> wrote:

>
>Use statspack (as someone has metionend earlier.). With statspack you
>can identify the exact resource consumption for every sql statement.
>Might be a locking problem, statspack will show you everything.

I don't know what statspack would help if the whole bunch of metrics collected with the Performance Monitor (OEM Diagnostics Pack) did not help either, including wait events, wait time, file based I/O statistics, locks, etc.

Oracle has already been continuously optimized during the last two years or so. I don't blame the DB performance per se. This is just a suitable example for me to show that there is a performance problem with I/O, but rather on the host side. There have been other cases, not DB related, with overwhelming evidences of such a problem. But every time I check the fundamentals, I get no further than confirming the problem using the usual tools. No word about how to actually SOLVE the problem (except the usual advice to distribute I/O operations etc.).

Bye
Rick Denoire Received on Fri Apr 11 2003 - 15:32:35 CDT