All Discussions Tagged 'tablespace' - OracleConnections2024-03-28T10:41:44Zhttp://www.oracleconnections.com/forum/topic/listForTag?tag=tablespace&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> How to free tablespace after delete command.?tag:www.oracleconnections.com,2013-06-19:6612035:Topic:143612013-06-19T07:25:32.556ZKaran Raymohttp://www.oracleconnections.com/profile/KaranRaymo
<p>Hi</p>
<p>I have table with the huge number of records, but after i delete some records in the table the table space used by that table remains the same.</p>
<p>Please let me know how we can free the table space after delete command to increase the performance?</p>
<p>Hi</p>
<p>I have table with the huge number of records, but after i delete some records in the table the table space used by that table remains the same.</p>
<p>Please let me know how we can free the table space after delete command to increase the performance?</p> reduce the system tablespace sizetag:www.oracleconnections.com,2013-06-18:6612035:Topic:137462013-06-18T10:42:53.341ZAlysha Robinettehttp://www.oracleconnections.com/profile/AlyshaRobinette
<p>hi,<br/> Please let me know how to reduce the system tablespace size<br/> my system01.dbf size is 6gb<br/> i want reduce from 6gb to 2gb</p>
<p>hi,<br/> Please let me know how to reduce the system tablespace size<br/> my system01.dbf size is 6gb<br/> i want reduce from 6gb to 2gb</p>