Oracle Apps DBA: Keeping E-Business Suite Alive · Module 12 · Space, growth and purging
Growing a tablespace
Lesson 126 of 184 · 2 min
Adding a datafile, autoextend, and THE CEILING THAT AUTOEXTEND DOES NOT REMOVE. A tablespace runs out of space when its datafiles are full, and there are two ways to give it more. ADDING A DATAFILE IS EXPLICIT AND IMMEDIATE. You decide the size and where it goes, which is the property that matters — you are choosing which file system absorbs the growth, rather than letting it land wherever the existing files are. AUTOEXTEND LETS A DATAFILE GROW ON DEMAND, AND IT IS GENUINELY USEFUL. It prevents the three-in-the-morning failure where a transaction fails because a file was one megabyte short. AND THE CEILING IT DOES NOT REMOVE IS THE FILE SYSTEM. A datafile can autoextend only while there is room underneath it. So an estate that considers space solved because autoextend is on has moved the failure rather than removed it — and moved it somewhere with a worse…
The full lesson is part of the course
The video, the complete written lesson and the module quiz are included in Oracle Apps DBA: Keeping E-Business Suite Alive, with a certificate on completion and a fourteen-day refund window.