Re: v$session

From: joel garry <>
Date: Tue, 5 Feb 2008 11:38:39 -0800 (PST)
Message-ID: <>

On Feb 5, 11:14 am, Ben <> wrote:
> 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

-- is bogus.
What's in your database?;amp;in_page_id=1770
Received on Tue Feb 05 2008 - 13:38:39 CST

Original text of this message