Martin, Another Martin did good posts about this subject. http://mwidlake.wordpress.com/2009/12/10/command_type-values/<http://mwidlake.wordpress.com/2009/12/10/> http://mwidlake.wordpress.com/2010/01/08/more-on-command_type-values/ Hope it helps On 3 March 2010 10:38, Martin Bach <development@xxxxxxxxxxxxxxxxx> wrote: > Dear list members, > > I am trying to find out more about the sql_opcode column in > gv$active_session_history. The reference is not very helpful by stating > the obvious (command type executed). > > I was hoping to get more clues from the view defition, but all it does > (from v$fixed_view_definition) is telling me that > v$active_session_history references x$ash and x$kewash. > > I found x$ash in v$fixed_table but can't see how it's defined. Maybe > that's a dead end anyway... > > Any pointers appreciated. > > Martin > > -- > Martin Bach > OCM 10g > http://martincarstenbach.wordpress.com > http://www.linkedin.com/in/martincarstenbach > -- > //www.freelists.org/webpage/oracle-l > > > -- Coskan GUNDOGAR Oracle DBA Email: gundogar@xxxxxxxxx Blog: http://coskan.wordpress.com Twitter: http://www.twitter.com/coskan Linkedin: http://uk.linkedin.com/in/coskan