Re: Base table for v_$session ?

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 22 Sep 2014 18:05:43 +0100
Message-ID: <CABe10saA7Z5sXNPL4JbgA2S=7MTBBAqsGTs03rmozpmjyi31pw_at_mail.gmail.com>

The memory structures are exposed as x$ 'tables' to the sql engine. v$session is based on (from memory) x$ksuse . You can query the view definition views to find the definition of v$ views. On 22 Sep 2014 17:48, "Seth Miller" <sethmiller.sm_at_gmail.com> wrote:

> Sumit,
>
> 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

Received on Mon Sep 22 2014 - 19:05:43 CEST