Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to find which transaction is occupying a particular segment in UNDO tablespace?

3052772Oct 16 2015 — edited Oct 18 2015

Hello,

I am facing an issue where UNDO tablespace has shot up over 95 percent quickly. I tried to find the active transactions from below query(there are no rows returned).

SELECT  *

FROM V$TRANSACTION t, V$SESSION s

WHERE t.addr = s.taddr;

When I check dba_segments and dba_free_space , I find one particular segment occupying maximum bytes.

Is there any way to identify which transaction is using that segment?

Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2015
Added on Oct 16 2015
7 comments
3,837 views