Re: Basic query tracing and profiling question...

On Tue, 17 Apr 2007 19:23:57 GMT, Brian K <brikeener_at_geemail.invalid> wrote:

>So, you CAN'T tell me how to identify the currently executing queries?
>
>Because, on a one-user test system with a relatively small database, I
>don't think I'm really concerned about the rest.

Obviously he can. But he is trying to point out that tuning those queries won't help much, as your database configuration runs on too few spindles.
If it really is an one-user test system I should really get concerned about the rest. Likely it just won't work ever with multiple users connected.

As to your request: v$sqlarea holds all the pertinent data. But of course running statspack, forbidden by the vendor (and what has a vendor to do with a test system) would identify them right away.

-- 
Sybrand Bakker
Senior Oracle DBA