What does V$SESSION REALLY contain ??
From: <monsri_at_my-deja.com>
Date: Thu, 17 Aug 2000 15:08:25 GMT
Message-ID: <8ngv4n$vb9$1_at_nnrp1.deja.com>
Date: Thu, 17 Aug 2000 15:08:25 GMT
Message-ID: <8ngv4n$vb9$1_at_nnrp1.deja.com>
Hello,
What I mean here is that I wonder why I can't see my Pro*C
program execution SQL statements (which lasts about 11
seconds) when I query V$SESSION at the same time... What
don't these transactions (2 INSERTs and an UPDATE) appear
in this view ?!?
Is it because the real execution time is too fast (and the view already doesn't contain anything anymore when I think it should), or could V$SESSION miss my statements ??
Thanks a lot !
Seb
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Aug 17 2000 - 17:08:25 CEST