How to check active transactions in Oracle Database? DBA scripts to check active transactions in Oracle Database ?
Ezana Answered question 20/04/2023
DBA scripts to view active transactions in Oracle database:
1 2 3 4 5 6 7 | SELECT S.SID,S.SERIAL#,P.SPID "SPID",S.USERNAME,S.STATUS,S.OSUSER,S.MACHINE,t.ses_addr FROM V$SESSION S,V$PROCESS p,v$transaction t WHERE S.PADDR=P.ADDR AND S.USERNAME IS NOT NULL AND S.STATUS='ACTIVE' and t.ses_addr=s.saddr ORDER BY S.USERNAME; |
Ezana Answered question 20/04/2023