Re: how to find the name for SQL_OPCODE

  • From: Tanel Poder <tanel@xxxxxxxxxxxxxx>
  • To: lzeng@xxxxxxxxxxxxx
  • Date: Fri, 6 May 2011 13:33:26 +0300

In newer Oracle versions you can use: DBA_HIST_SQLCOMMAND_NAME or
V$SQLCOMMAND
In older versions read the manual  :-)

--
Tanel Poder
http://blog.tanelpoder.com

On Fri, May 6, 2011 at 6:33 AM, Lei Zeng <lzeng@xxxxxxxxxxxxx> wrote:

>  Hi, list:
>
>
>
> I am on 10g, not 11g. How to find out the complete list of names for
> SQL_OPCODE? I want to do something like
>
>
>
> decode(OPCODE
>
> 0,'BACKGROUND',
>
> 1,'Create Table',
>
> 2,'INSERT', ….)
>
>
>
> Thanks,
>
> Lei
>
>
>

Other related posts: