Saturday, November 14, 2009

uncommited TRANSACTION

SQL> SELECT A.TERMINAL,A.OSUSER, A.USERNAME FROM V$SESSION A,V$TRANSACTION B
2 WHERE
3 B.SES_ADDR = A.SADDR AND
4 A.AUDSID <> USERENV('SESSIONID')
5 ;

TERMINAL OSUSER USERNAME
------------------------------ ------------------------------ --------
applbkp APPS

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...