Re: Base table for v_$session ?

v$session is a dynamic performance view. It does not have underlying tables. It displays information directly from memory.

Seth Miller
 On Sep 22, 2014 10:00 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