Re: What do V$SQL[..] views contain that V$SESSION doesn't ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 28 Jan 2001 22:03:16 +0800
Message-ID: <3A7426A4.1CAD_at_yahoo.com>


monsri_at_my-deja.com wrote:
>
> If you do
> > select count(distinct address||hash_value)
> > from v$sqlarea
> > /
> and
>
> > select count(distinct sql_address||sql_hash_value)
> > from v$session
> > /
>
> you obtain VERY different results... What is all this stuff in
> the V$SQL<something> views ?? Is this SQL statements that are
> still in the buffer ?
>
> And what does the STATUS field of V$SESSION mean ?
>
> Thks !
> seb
>
> Sent via Deja.com
> http://www.deja.com/

v$session - people logged on (so sql's that they are currently or just ran).

v$sqlarea - sql's in memory (not necessarily being run by the people that are currently logged on)

hth

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"
Received on Sun Jan 28 2001 - 15:03:16 CET

Original text of this message