Apologies to all I have not replied to yet. I managed to run the above
code when the db hung this afternoon. Results (sorry unformatted) are
below.
SIDC USERNAME EVENT SECS
SQLHASHVAL
131, 10790 REPADMIN@¡(|) PL/SQL lock timer 6000,0,0 2
2346439507
118,12409 SYS_at_ncluxora1¡(orace svrmgrl_at_ncluxora1 (TNS
V1-V3))SQL*Net message from client 1650815232 ,1,0
0 3671668246
121,2849 OSGDBA_at_ncluxora1¡(oracle|sqlplus_at_ncluxora1 (TNS
V1-V3)) log file sync 1264,0,0 0 3796088010
REPADMIN is the user we use to run Oracle Advanced Replication.
OSGDBA is out standard dba account.
Received on Tue May 17 2005 - 10:33:44 CDT
