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.
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.
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.
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).