Re: H E L P H E L P

From: William Dangren <wdangren_at_navisent.com>
Date: Sat, 29 May 1999 09:41:07 -0400
Message-ID: <374FEE73.2D57E05F@navisent.com>

There is a SID and serial number associated to the user and the transaction. You can find them by looking at the v$session view. You can then find the SQL_ADDRESS, then view it in the SQL_TEXT column of the v$sqlarea view. There is also SCN (system change number) associated

with all transactions committed and uncommitted. This is how Oracle keeps data consistency. The SCN is used like a time stamp. Hope this helps.

Bill
--
William Dangren
Navis Enterprises
407.348.6401
800.219.0207 Received on Sat May 29 1999 - 08:41:07 CDT