Message-ID: <4B8E3C17.9020409@the-playground.de>
Date: Wed, 03 Mar 2010 10:38:15 +0000
From: Martin Bach <development@the-playground.de>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.5) Gecko/20091130 SUSE/3.0.0-1.1.1 Thunderbird/3.0
MIME-Version: 1.0
To: ORACLE-L <oracle-l@freelists.org>
Subject: Is it possible to peek at the definition of x$tables?
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: development@the-playground.de

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