 |
|
|
The last thing to keep in mind regarding objects with unlimited extents is that it is still possible for an object not to be able to extend, even if it has an unlimited extent limit. The three primary reasons an object will fail to extend include: · No file autoextend - The tablespace that the object resides in does not have autoextend enabled, and there is not enough room in the tablespace to add the object's new extent · No filesystem space - The tablespace that the object resides in has autoextend enabled, but the drive/file system that the tablespace is on is out of free space and will not allow the tablespace to automatically grow. · Fragmentation problem - The dictionary managed tablespace that the object resides in has enough total free space to add the object's new extent, but the free space is not contiguous in nature (because of bubble fragmentation ), and therefore, the object cannot extend.
Bubble fragmentation , as well as general fragmentation, will be covered further in an upcoming section. The above is an excerpt from Oracle Performance Troubleshooting by Robin Schumacher. It's only $19.95 and you can order it and get instant access to the Oracle scripts here: http://www.rampant-books.com/book_2003_1_perf.htm
|
|
|
