Re: Base table for v_$session ?
- From: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx>
- To: dba.tyagisumit@xxxxxxxxx
- Date: Mon, 22 Sep 2014 09:58:16 -0700
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*
>
Other related posts:
