<div>
Thanks I see that USED_BLOCK decrease so I suppose the rollback will be finished when the USED_BLOCK are 0.<br />
<br />
Thanks<br />
<br />
Bibi
</div>


<div>
yep, <br />
<br />
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
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
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.<br />
<br />
Thanks<br />
<br />
bibi
</div>
</div>


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

Thanks I see that USED_BLOCK decrease so I suppose the rollback will be finished when the USED_BLOCK are 0.

Thanks

Bibi

yep, 

but you won&#39;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

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&#39;t enough space in TBS UNDO but the session are always active.

Thanks

bibi

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.