Re: Is it possible to peek at the definition of x$tables?
Date: Wed, 3 Mar 2010 10:49:26 +0000
Another Martin did good posts about this subject.
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 Bach
> OCM 10g
-- 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-lReceived on Wed Mar 03 2010 - 04:49:26 CST