Home -> Usenet -> c.d.o.server -> Re: v$session

Re: v$session

From: joel garry <joel-garry_at_home.com>
Date: Tue, 5 Feb 2008 11:38:39 -0800 (PST)
Message-ID: <b9bcf099-b9ff-4872-93ef-e4c940e67346@i72g2000hsd.googlegroups.com> 





On Feb 5, 11:14 am, Ben <benal..._at_yahoo.com> wrote:


> 10.2.0.2 ent ed

>

> what underlying table is v_$session built on?

>

> create or replace public synonym v$session for v_$session;

> create or replace view v_$session as select * from v$session;

>

> These are the only ddl statements I can find related to it, they

> reference each other.




You can figure it out like this:



desc v$fixed_view_definition



select view_name from v$fixed_view_definition
  where view_name like '%SESS%';



SELECT view_definition FROM v$fixed_view_definition WHERE view_name='GV
$SESSION';


jg

--
@home.com is bogus.
What's in your database?
http://www.mailonsunday.co.uk/pages/live/articles/news/news.html?in_article_id=509289&amp;amp;in_page_id=1770


Received on Tue Feb 05 2008 - 13:38:39 CST












Original text of this message