Online Documentation for SQL Manager for Oracle
The Physical Attributes / Storage tab available in object editors lets you specify how a database object should be stored in the database. Storage parameters affect both how long it takes to access data stored in the database and how efficiently space in the database is used.
A tablespace is an allocation of space in the database that can contain schema objects. Use the drop-down list to select the tablespace where the object will be stored.
This option allows you to specify a default buffer pool or cache for the object. All blocks for the object are stored in the specified cache. Use the drop-down list to select one of the following values:
KEEP: the buffer pool retains the schema object's data blocks in memory;
RECYCLE: the buffer pool eliminates data blocks from memory as soon as they are no longer needed.
DEFAULT: the buffer pool contains data blocks from schema objects that are not assigned to any buffer pool, as well as schema objects that are explicitly assigned to the DEFAULT pool.
Initial number of transactions
Specify the initial number of concurrent transaction entries allocated within each data block allocated to the database object, or select DEFAULT from the drop-down list.
Use this option to indicate how Oracle Database should store blocks in the buffer cache.
Select this option if you want to enable row-level dependency tracking. This setting is useful primarily to allow for parallel propagation in replication environments.
An extent is a logical unit of database storage space allocation made up of a number of contiguous data blocks. One or more extents in turn make up a segment. When the existing space in a segment is completely used, Oracle allocates a new extent for the segment.
Specify the size (in bytes) of the first extent of the object. Oracle allocates space for this extent when you create the schema object, or select DEFAULT from the drop-down list.
Specify the size (in bytes) of the next extent to be allocated to the object, or select DEFAULT from the drop-down list.
Specify the percent by which the third and subsequent extents grow over the preceding extent, or select DEFAULT from the drop-down list (the default value is 50, meaning that each subsequent extent is 50 per cent larger than the preceding extent)
Specify the total number of extents to allocate when the object is created, or select DEFAULT from the drop-down list. This parameter lets you allocate a large amount of space when you create an object, even if the space available is not contiguous.
Specify the total number of extents, including the first, that Oracle can allocate for the object, or select DEFAULT or UNLIMITED from the drop-down list.
Parameters of this group allow you to control the use of free space for inserts and updates to the rows in all the data blocks of a particular segment.
This parameter sets the minimum percentage of a data block to be reserved as free space for possible updates to rows that already exist in that block. Specify a value, or select DEFAULT from the drop-down list.
This parameter sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block. Specify a value, or select DEFAULT from the drop-down list.
Specify the number of free lists that can be contained in each free list group, or select DEFAULT from the drop-down list (the default and minimum value for this parameter is 1, meaning that each free list group contains one free list).
Specify the number of groups of free lists for the database object being created, or select DEFAULT from the drop-down list (the default and minimum value for this parameter is 1).
Use this group to specify the degree of parallel access to the object.
No parallel (serial execution)
Parallel (parallelized execution)
Specify the degree of parallelism which is the number of parallel threads used in the parallel operation, or select DEFAULT from the drop-down list.
A degree of parallelism equals to the number of CPUs available on all participating Instances.
Data storage options
This group is only available for tables which store data.
Use this option to instruct the database whether to compress data segments to reduce disk and memory use (for heap-organized tables).
Enable row movement
This option allows you to specify whether the database can move a table row. It is possible for a row to move, for example, during table compression or an update operation on partitioned data. Note that when a row is moved, the rowid is changed.
Use this group to specify the table compression mode:
All operations (Oracle Database attempts to compress data during all DML operations on the table)
Direct load operation (Oracle Database attempts to compress data during direct-path INSERT operations when it is productive to do so)