<div>
I wouldn't worry about the undo tablespace. &nbsp;Oracle manages that on its own. &nbsp;Are you getting any errors? &nbsp;Specifically ORA-01555? &nbsp;That would indicate that you may need to change your parameters or increase the size of undo.
</div>


I wouldn't worry about the undo tablespace.  Oracle manages that on its own.  Are you getting any errors?  Specifically ORA-01555?  That would indicate that you may need to change your parameters or increase the size of undo.

<div>
As in previous post the undo tablespace is manages automatically by oracle.<br />
<br />
check the below docs for more info on undo.<br />
<br />
<a href="http://asktom.oracle.com/pls/apex/f?p=100:11:0::NO::P11_QUESTION_ID:6894817116500" rel="ugc nofollow">http://asktom.oracle.com/pls/apex/f?p=100:11:0::NO::P11_QUESTION_ID:6894817116500</a><br />
<br />
<a href="http://www.dba-oracle.com/t_undo_tablespace_size_shrink.htm" rel="ugc">http://www.dba-oracle.com/t_undo_tablespace_size_shrink.htm</a><br />
<br />
<a href="http://www.orafaq.com/node/61" rel="ugc">http://www.orafaq.com/node/61</a>
</div>


As in previous post the undo tablespace is manages automatically by oracle.

check the below docs for more info on undo.

http://asktom.oracle.com/pls/apex/f?p=100:11:0::NO::P11_QUESTION_ID:6894817116500 [http://asktom.oracle.com/pls/apex/f?p=100:11:0::NO::P11_QUESTION_ID:6894817116500]

http://www.dba-oracle.com/t_undo_tablespace_size_shrink.htm [http://www.dba-oracle.com/t_undo_tablespace_size_shrink.htm]

http://www.orafaq.com/node/61 [http://www.orafaq.com/node/61]

<div>
I'm pleased to have helped; the &quot;B&quot; grade suggests I was deficient in some manner. &nbsp;How could I have improved your satisfaction?
</div>


I'm pleased to have helped; the "B" grade suggests I was deficient in some manner.  How could I have improved your satisfaction?

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
Can you simply explain me usage of undo Tablespace of Oracle Database?<br />
<br />
My Oracle Database version is 10.2 and it has 8GM undo Tablespace. Every time, once I check it, it fill up with more than 95% with data. <br />
<br />
How can I get increased the free space of undo Tablespace?
</div>
</div>


Dear Experts,

Can you simply explain me usage of undo Tablespace of Oracle Database?

My Oracle Database version is 10.2 and it has 8GM undo Tablespace. Every time, once I check it, it fill up with more than 95% with data. 

How can I get increased the free space of undo Tablespace?

A Question about Oracle undo Tablespace

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.