Re: Base table for v_$session ?
- From: Martijn Bos <maboc@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 22 Sep 2014 21:00:49 +0200
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Insert on a v$xxxx view?
V$views represent internal memory structures.
I wonder how you are going to insert into those structures directly.
Anyway...maybe I misunderstood the question completely.
Best regards,
Martijn
On 09/22/2014 08:44 PM, sumit Tyagi wrote:
> 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@xxxxxxxxxxxxxxxxxx>
> 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
>> @jloracle ------------------------------ *From:*
>> oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on
>> behalf of Tim Gorman [tim@xxxxxxxxx] *Sent:* 22 September 2014
>> 18:12 *To:* oracle-l@xxxxxxxxxxxxx *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@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*
>>>
>>
>>
>>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
iQEcBAEBAgAGBQJUIHHaAAoJEBpyqcd0ZMlvcKwH/1NI9dcXI8Mr/KBS1XMUzCak
ueWqn0Dz3zK8d7OoxMg+GkPpOWLMKzkAX7lvEEae5LK4RUsxYMjMHJnhVcR0j0xT
SCxDp2nzdjfySQC3AyYbamRdE3tnokh3Jru4B/PQQgGKfZl6oWFYITaRX2flR0Oj
ELYT1qRH6FWos/8OQw4uHB8c+Ld0pcMbEeL8ZTIOZn9zZKHX+k5lAmIXyMrFRwuT
JsImExGxxWOSMhxA47AY7gtosdTZcM3oicpSgE1Kar63diA1aaBkdPNA08ykhyap
t5S2FcPB3A9xZfkc5oEazoiqxNTO5KlLuam3nBZCSXPIfFlOmjhGJbVN8Qpv6eo=
=L1dX
-----END PGP SIGNATURE-----
--
//www.freelists.org/webpage/oracle-l
Other related posts:
