 |
|
|
Oracle locally managed tablespace benefits
There are a number of benefits that locally-managed tablespaces offer:
· Less contention - OLTP systems profit from fewer dictionary concurrency problems because Oracle manages space in the tablespace rather than the data dictionary. Recursive space management calls become a thing of the past. Folks who endure parallel server (or RAC) installations will appreciate this success indicator, as "pinging" between nodes may be substantially reduced · No high extent penalty - Objects can have nearly unlimited numbers of space extents with apparently no performance degradation. Such a feature eliminates the problem of object extent fragmentationoutright. · Better free space management - Free space found in datafiles does not have to be coalesced because bitmaps track free space and allocate it much more effectively than dictionary-managed tablespaces. This benefit eliminates the problem of honeycomb fragmentation completely. · Efficient space management - Uniform or system-managed extent sizes are automatically controlled for the database administrator, resulting in a much more efficient space management process. The result is an end to the problem of tablespace bubble fragmentation
Without a doubt, locally-managed tablespaces are a great storage aid for the Oracle DBA. More will be said about them later in this chapter. 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
|
|
|
