Below script can be used to find the active transactions in the oracle database.

col name format a10 
col username format a8 
col osuser format a8 
col start_time format a17 
col status format a12 
tti 'Active transactions' 

select s.sid,username,t.start_time,, t.used_ublk "USED BLKS", 
decode(, 'YES', 'SPACE TX', 
decode(t.recursive, 'YES', 'RECURSIVE TX', 
decode(t.noundo, 'YES', 'NO UNDO TX', t.status) 
)) status 
from sys.v_$transaction t, sys.v_$rollname r, sys.v_$session s 
where t.xidusn = r.usn 
and t.ses_addr = s.saddr 

Related Topics

Find pending distributed pending transactions in oracle
Find user commits per minute in oracle database
How to monitor parallel queries in oracle db
Find the active transactions in oracle database
Get sid from ospid
Script to get cpu usage and wait event information in oracle database
How to find execution history of an sql_id
Find sessions consuming lot of CPU
How to find cpu and memory information of oracle database server
How to get tablespace quota details of an user in oracle

You May Also Like

Exception in thread -main" java.lang.OutOfMemoryError: GC overhead limit exceeded with
Multinode Hadoop installation steps
How to multiplex control file in standalone database
Unified audit trail in Oracle 12c
Purge AUD$ table using DBMS_AUDIT_MGMT
How to Downgrade oracle 19C Grid to 12C GRID
How to move controlfile to a new location in oracle
Ansible script to run script on remote server and fetch the output
ORA-16855: transport lag has exceeded specified threshold
How to use expdp to export data from physical standby database

From This Website

Standby redologs in oracle dataguard
How to create encrypted tablespace in PDB( oracle 12c)
how to Print execution time of tasks in ansible
How to generate AWR report in RAC
How to keep or delete columns/Variable of a data frame in R
LREG Background Process in oracle
Multinode Hadoop installation steps
Shell script to report failed login attempt in oracle
how to change archivelog destination in oracle
ORA-16855: transport lag has exceeded specified threshold