Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

Oracle Tips by Burleson

Oracle9i Tablespace Changes

Administrators are also able to specify that the tablespace is managed with uniform extents of a specific size by specifying UNIFORM SIZE in the tablespace’s definition or by specifying INITIAL = NEXT and PCTINCREASE = 0. This specification tells Oracle to create a uniform locally managed tablespace with uniform extent size = INITIAL.

• The tablespace datafile will have a 2K blocksize. Oracle9i allows administrators to specify a nonstandard block size for tablespaces. In order for the tablespace specification to override the standard database blocksize specified during database creation, the db_cache_size and db_nk_cache_size (where nk matches the tablespace block size) must be set in the initialization parameter file. Oracle9i allows administrators to choose from 2K, 4K, 8K, 16K and 32K blocksizes.
   

• Finally, it will be autoextensible (the file will be able to automatically grow in size) because autoextensible is the default for an Oracle managed file.

Let’s take a look at our tablespace definition again. This time we will provide all of the specifications for some of the features we have just discussed:

CREATE TABLESPACE oracle_local_auto DATAFILE SIZE 5M BLOCKSIZE 2K AUTOEXTEND ON EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT MANUAL;

Oracle9i’s new tablespace definitions allow administrators to tailor their environments to meet application requirements. We’ll end our discussion on Oracle9i tablespaces with a few quick recommendations:
 

Download your Oracle scripts now: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA