Re: v$session

From: DA Morgan <>
Date: Tue, 05 Feb 2008 16:56:16 -0800
Message-ID: <>

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.

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

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Tue Feb 05 2008 - 18:56:16 CST

Original text of this message