Dear Maboc , by insert I actually wanted to ask can we capture the new row/rows that dynamically comes under v$session , when a new session is created by a user and insert these captured rows in a fixed table say. my_session_info. On 23 Sep 2014 00:32, "Martijn Bos" <maboc@xxxxxxxx> wrote: > -----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 > > >