Re: how to find the name for SQL_OPCODE

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Fri, 6 May 2011 13:33:26 +0300
Message-ID: <BANLkTikR-OqukO2PvarfnP3brReOTeGVFg_at_mail.gmail.com>



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_at_yahoo-inc.com> 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
>
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Fri May 06 2011 - 05:33:26 CDT

Original text of this message