RE: Base table for v_$session ?

From: sumit Tyagi <dba.tyagisumit_at_gmail.com>
Date: Tue, 23 Sep 2014 00:14:22 +0530
Message-ID: <CAFW4NVwCQpbQn-3abUtk0-sZCiCVq7FMzuA70cr7ThS_qkddeA_at_mail.gmail.com>

Thanks. I will go through all the above suggestions 2marrow morning . BTW can we create a trigger after-insert on v$ views. On 22 Sep 2014 23:22, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>
> Thought v$session will be in the fixed view definitions, with a definition
> something like:
>
> select * from gv$session where inst_id = (select userenv('instance')
> from dual)
>
>
>
> you remember that userenv() thing - deprecated about 15 years ago for
> sys_context('userenv',{parameter})
>
>
>
>
>
>
>
> Regards
> Jonathan Lewis
> http://jonathanlewis.wordpress.com
> _at_jloracle
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on
> behalf of Tim Gorman [tim_at_evdbt.com]
> *Sent:* 22 September 2014 18:12
> *To:* oracle-l_at_freelists.org
> *Subject:* Re: Base table for v_$session ?
>
> ...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 - 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>
> 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 - 20:44:22 CEST