Re: Base table for v_$session ?
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: sethmiller.sm@xxxxxxxxx
- Date: Mon, 22 Sep 2014 18:05:43 +0100
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@xxxxxxxxx> 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@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:
