Re: V$session.command

You are close.
v$session joins to v$sqlarea.
You can select some fields from v$sqlarea to get the exact query that the session is running.
John Doe <john.doe_at_trw.com> wrote:

>Can anyone tell me, is there an Oracle table which gives the text
>equivalent to the column "v$session.command" ?
 

>This column contains numeric values. I believe they equate to commands
>for example:
> 2 = insert
> 3 = select
>15 = alter table
>...
 

>I am looking for a table which provides the above text which corresponds
>to the "v$session.command" numeric value. I believe that this is done by
>Oracle's Session Monitor. But is it hard coded within Session Monitor?
>Or is there a function or table which provides this?
 

>TIA
Received on Thu May 16 1996 - 00:00:00 CEST