Re: Base table for v_$session ?

  • From: Tim Gorman <tim@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 22 Sep 2014 11:12:53 -0600

...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@xxxxxxxxx <mailto:dba.tyagisumit@xxxxxxxxx>> 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/

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2014