RE: how to find the name for SQL_OPCODE
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 May 2011 17:06:47 +0000
If you have auditing then there should be a table sys.audit_actions whose
actions I believe will match up to the v$session command. This table is
available back to at least 8.1 and through 10.3.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Tanel Poder
Sent: Friday, May 06, 2011 6:33 AM
To: lzeng@xxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: how to find the name for SQL_OPCODE
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<mailto: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:
