What do V$SQL[..] views contain that V$SESSION doesn't ?
From: <monsri_at_my-deja.com>
Date: Thu, 25 Jan 2001 15:28:02 GMT
Message-ID: <94pgll$gve$1_at_nnrp1.deja.com>
Date: Thu, 25 Jan 2001 15:28:02 GMT
Message-ID: <94pgll$gve$1_at_nnrp1.deja.com>
If you do
> select count(distinct address||hash_value)
> from v$sqlarea
> /
and
> select count(distinct sql_address||sql_hash_value)
> from v$session
> /
[Quoted] 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/
Received on Thu Jan 25 2001 - 16:28:02 CET