Re: Base table for v_$session ?

From: sumit Tyagi <dba.tyagisumit_at_gmail.com>
Date: Tue, 23 Sep 2014 01:02:01 +0530
Message-ID: <CAFW4NVy_y1eEJKjcj6xpmmuTQAFghrpsAUWstsFA7kZCQDhgag_at_mail.gmail.com>

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_at_maboc.nl> 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_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*
> >>>
> >>
> >>
> >>
> >
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1
>
> iQEcBAEBAgAGBQJUIHHaAAoJEBpyqcd0ZMlvcKwH/1NI9dcXI8Mr/KBS1XMUzCak
> ueWqn0Dz3zK8d7OoxMg+GkPpOWLMKzkAX7lvEEae5LK4RUsxYMjMHJnhVcR0j0xT
> SCxDp2nzdjfySQC3AyYbamRdE3tnokh3Jru4B/PQQgGKfZl6oWFYITaRX2flR0Oj
> ELYT1qRH6FWos/8OQw4uHB8c+Ld0pcMbEeL8ZTIOZn9zZKHX+k5lAmIXyMrFRwuT
> JsImExGxxWOSMhxA47AY7gtosdTZcM3oicpSgE1Kar63diA1aaBkdPNA08ykhyap
> t5S2FcPB3A9xZfkc5oEazoiqxNTO5KlLuam3nBZCSXPIfFlOmjhGJbVN8Qpv6eo=
> =L1dX
> -----END PGP SIGNATURE-----
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Sep 22 2014 - 21:32:01 CEST