If we have set auto extend on in any tablespace and did not define the max size
What is the maximum size tablespace can grow?
Can it be unlimited?
Please share your thoughts on it.
Thanks in advance.
No Comments Posted for this Article.
The size of table TST03 grows
The size of table TST03 and thus the corresponding tablespace increases continually. Unfavorable block length for table TST03, especially for oracle as block length a) Explanation of the problem ...
Oracle Locally Managed Table Spaces
Default table spaces from 10g which manage the extents locally instead of dictionary management.. It collase the space that is left in all the extents before allocating an extent. It reduces...
SAP Table Space Daily Check List
When any of the table space hit 100% usage, the SAP server will hang. Users will get this message when they tried to execute any posting "Update Delay. Please wait." If the table extent hit 300...