SQL Query To Check Active Transactions

SQL Query To Check Active Transactions set head ONSELECT usn,extents,Round(rssize / 1048576) rssize,hwmsize,xacts,waits,optsize / 1048576 optsize,shrinks,wrapsFROM v$rollstatWHERE xacts > 0ORDER BY rssize; Read More Articles … Read more