quick snapshot

We have Oracle 9.2.0.8 on Solaris 8.

I was wondering whether there was something similar to "top" for Oracle to display what it's doing at the moment (last 5 seconds basically).

There is an Oracle "bin" directory with things like oerr in it, so I looked up the Oracle manuals master index to see if I could get a list of those tools to see if one of them was related to performance. But I didn't find it in the master index.

I'm mainly interested in knowing what the top 10 physical I/O SQL statements are, what the top 10 logical I/O SQL statements are, and what the top 10 CPU SQL statements are. Read MB/sec and write MB/sec would be good.

Is there something that will come close to any of that? At the moment we're only getting statistics for an hour's processing which is not what I'm after. I want to be able to sample the system immediately when there's a problem to see what Oracle is up to.

Although I'm not the DBA, if I have an exact thing to ask for, I can probably get it.

Thanks. Paul. Received on Thu Mar 27 2008 - 03:09:10 CDT