RE: Base table for v_$session ?

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Mon, 22 Sep 2014 14:54:29 -0400
Message-ID: <065e01cfd696$a44e3120$ecea9360$_at_rsiz.com>



And if you're diving into this rabbit hole, this is the point where Laurence Fishburne asks you what color pill you want.  

There is some really interesting stuff in the fixed views based on the x$ "table" aka memory structures but they behave differently than the usual read consistent model for real tables.

Some of it is documented, somewhere, and much of it is unlikely to change but all of it CAN change. And most (all?) of it is unlatched memory, at least from the perspective of querying it. (The Oracle program probably has lots of various memory locks on some bits of it - but that has nothing to do with your read consistent start of query.)  

Usually the views are forward compatible, but the underlying structure of the x$tables should be considered something Oracle can change at whim and without notice.  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jonathan Lewis
Sent: Monday, September 22, 2014 1:50 PM To: tim_at_evdbt.com; oracle-l_at_freelists.org Subject: RE: Base table for v_$session ?    

Thought v$session will be in the fixed view definitions, with a definition something like:

  select * from gv$session where inst_id = (select userenv('instance') from dual)  

you remember that userenv() thing - deprecated about 15 years ago for sys_context('userenv',{parameter})          

Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle


From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Tim Gorman [tim_at_evdbt.com]
Sent: 22 September 2014 18:12
To: oracle-l_at_freelists.org
Subject: Re: Base table for v_$session ?

...and you'd want to use V$FIXED_VIEW_DEFINITION to look at the definition of GV$SESSION, as looking at V$SESSION will make you more frustrated. :-)

On 9/22/14, 10:58, Riyaj Shamsudeen wrote:

Sumit

   You can find the definition of fixed views in: v$fixed_view_definition

Cheers

Riyaj Shamsudeen
Principal DBA,
Ora!nternals - http://www.orainternals.com <http://www.orainternals.com/> - Specialists in Performance, RAC and EBS Blog: http://orainternals.wordpress.com/ Oracle ACE Director and OakTable member <http://www.oaktable.com/>

Co-author of the books: Expert Oracle Practices
<http://tinyurl.com/book-expert-oracle-practices/> , Pro Oracle SQL,
<http://tinyurl.com/ahpvms8> Expert RAC Practices 12c.
<http://tinyurl.com/expert-rac-12c>
<http://tinyurl.com/book-expert-plsql-practices> Expert PL/SQL practices
   

On Mon, Sep 22, 2014 at 7:59 AM, sumit Tyagi <dba.tyagisumit_at_gmail.com> wrote:

Hi experts ,  

Can you please guide how to find the base table for v_$session . I checked v$session = SYNONYM v_$session is the view .  

I checked the DDL of v_$session view thinking that i can get the base table from here but no success :out  

SQL> select DBMS_METADATA.GET_DDL('VIEW','V_$SESSION','SYS') res from dba_views where view_name='V_$SESSION';  

output:  

 select columns... ........... from v$session.  

Thanks and Regards

Sumit    

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 22 2014 - 20:54:29 CEST

Original text of this message