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_at_navisent.com>
Date: Sat, 29 May 1999 09:41:07 -0400
Message-ID: <374FEE73.2D57E05F_at_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.0207Received on Sat May 29 1999 - 15:41:07 CEST