Checking of uncommitted transaction in tablespace
Hi All,
I want to alter a table space read-only. This can be done only when there is no uncommitted transaction in that table space.
I've seen a number of queries to get it from different web pages. But exactly could not find the exact one that suit my requirement.
However I am using the following query at the moment to check it:
However I am using the following query at the moment to check it:
---
SELECT count(*)
FROM v$transaction t, v$rollname r, v$session s
WHERE t.xidusn = r.usn
AND t.ses_addr = s.saddr;
---
If the above yields any value greater than zero then it shows that there is uncommitted transaction.
SELECT count(*)
FROM v$transaction t, v$rollname r, v$session s
WHERE t.xidusn = r.usn
AND t.ses_addr = s.saddr;
---
If the above yields any value greater than zero then it shows that there is uncommitted transaction.
0