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 > > >