Chapter 3 DBMS Reference Guide
You can define values for the following common entries for the Storage object in the DBMS definition.
| Entry | Example (Oracle 8) |
|---|---|
| Enable | Enable = Yes |
| Create | - |
| Drop | - |
| Options |
initial %d : default=10K next %d : default=10K minextents %d : default=1 maxextents %d pctincrease %d : default=50 freelists %d : default=1 freelist groups %d : default=1 optimal %d buffer_pool %s : list=keep | recycle | default |
| DefOptions | — |
| SqlList Query | — |
| SqlAttrQuery |
{STORAGE, OPTIONS}
SELECT SEGMENT_NAME, 'INITIAL ' || INITIAL_EXTENT ||
' NEXT ' || NEXT_EXTENT || ' MIN_EXTENTS ' || MIN_EXTENTS ||
' MAX_EXTENTS ' || MAX_EXTENTS || ' PCTINCREASE ' || PCT_INCREASE ||
' FREELISTS ' || FREELISTS || ' FREELIST_GROUPS ' || FREELIST_GROUPS OPTS
FROM USER_SEGMENTS
|
| ModifiableAttributes | List of extended attributes that will be taken into account in the merge dialog box during database synchronization |
| ReversedStatements | List of statements that will be reverse engineered |
For a description of each of the common object entries, see section "Common object entries".
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |