bibi92
asked on
how can I detect session in rollback status
Hello,
How can I detect session in rollback status, I see in the alert.log that there isn't enough space in TBS UNDO but the session are always active.
Thanks
bibi
How can I detect session in rollback status, I see in the alert.log that there isn't enough space in TBS UNDO but the session are always active.
Thanks
bibi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks bibi
yep,
but you won't see it actually reach 0 though, when it does, that row will disappear from the query results because it will no longer be consuming rollback
but you won't see it actually reach 0 though, when it does, that row will disappear from the query results because it will no longer be consuming rollback
ASKER
Thanks
Bibi