Re: Is it possible to peek at the definition of x$tables?

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_at_the-playground.de> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Coskan GUNDOGAR

Oracle DBA

Email: gundogar_at_gmail.com
Blog: http://coskan.wordpress.com
Twitter: http://www.twitter.com/coskan
Linkedin: http://uk.linkedin.com/in/coskan

--
http://www.freelists.org/webpage/oracle-l