Re: v$session

Ben 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.

v_$ objects are dynamic performance views created against x$ arrays in memory.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org