RE: Base table for v_$session ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 22 Sep 2014 17:49:50 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901E10C10_at_exmbx05.thus.corp>

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> <http://tinyurl.com/ahpvms8> Expert RAC Practices 12c.<http://tinyurl.com/expert-rac-12c> Expert PL/SQL practices<http://tinyurl.com/book-expert-plsql-practices>

<http://tinyurl.com/book-expert-plsql-practices>

On Mon, Sep 22, 2014 at 7:59 AM, sumit Tyagi <dba.tyagisumit_at_gmail.com<mailto: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 - 19:49:50 CEST