Re: Base table for v_$session ?

From: Tim Gorman <tim_at_evdbt.com>
Date: Mon, 22 Sep 2014 11:12:53 -0600
Message-ID: <54205895.8010402_at_evdbt.com>

...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:12:53 CEST