|
 |
|
Oracle Tips by Burleson |
Oracle10g Grid Computing
with RAC
Chapter 8 - RAC Administration
Automatic Segment Space Management
Automatic segment-space management is a simpler
and more efficient way of managing space within a segment. It
completely eliminates any need to specify and tune the
pctused,
freelists, and
freelist groups storage
parameters for schema objects created in the tablespace. If any of
these attributes are specified, they are ignored.
When you create a locally managed tablespace
using the create TABLESPACE statement, the SEGMENT SPACE
MANAGEMENT clause lets you specify how free and used space within a
segment is to be managed.
For example, the following statement creates
tablespace mytbs1 with automatic segment-space management:
CREATE TABLESPACE mytbs1
DATAFILE '/u01/oracle/data/mytbs01.dbf' SIZE
500M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
The above text is
an excerpt from:
Oracle 10g Grid & Real Application
Clusters
Oracle 10g
Grid
Computing with RAC
ISBN 0-9744355-4-6
by Mike Ault, Madhu Tumma
|
