All Discussions Tagged 'optimum' - OracleConnections2024-03-28T21:32:59Zhttp://www.oracleconnections.com/forum/topic/listForTag?tag=optimum&feed=yes&xn_auth=noundo tablespace optimum sizetag:www.oracleconnections.com,2013-07-24:6612035:Topic:262252013-07-24T05:14:43.009ZAraceli Gordyhttp://www.oracleconnections.com/profile/2llwy4wilb90x
<p>hi all,</p>
<p>We have oracle 11gr2 database on linux 5.5. for this database undo tablespace is 7GB.<br></br> Frequently we are receiving alerts for this table space like 100% full.</p>
<p>I tried to figure out the optimum size for this undo tablespace and found one formula for this: (undo blocks generating per second* undo retention * undo tablespace block size)<br></br> I took blocks generating per second from v$undostat view. when i calculated, strange it give the value only 1.2GB. that mean theā¦</p>
<p>hi all,</p>
<p>We have oracle 11gr2 database on linux 5.5. for this database undo tablespace is 7GB.<br/> Frequently we are receiving alerts for this table space like 100% full.</p>
<p>I tried to figure out the optimum size for this undo tablespace and found one formula for this: (undo blocks generating per second* undo retention * undo tablespace block size)<br/> I took blocks generating per second from v$undostat view. when i calculated, strange it give the value only 1.2GB. that mean the optimum size is 1.2GB</p>
<p>but i allocated 7gb of undo tablespace but still receiving the alerts.</p>
<p>is there any reason for this kind of alerts and am i following the right formula.</p>
<p>Please help to fix this.</p>
<p>thanks</p>