ArcGIS Server Banner

Oracle DBTUNE configuration parameters

Oracle DBTUNE configuration parameters

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
Configuration parameters, which are stored in the parameter_name column of the DBTUNE table, identify the database object to be configured or denote a specific setting. Their corresponding values, which are stored in the config_string column of DBTUNE, identify how the object or setting will be configured. The parameters and their configuration strings are grouped together in the DBTUNE table by configuration keywords. Keyword/Parameter_name combinations are unique, but most parameter_names are not and are reused under a number of different keywords throughout the DBTUNE table.

Valid values for the parameter_names column are fixed; you cannot invent new parameter_names. Likewise, the config_strings accept only certain numeric values or SQL strings. In most cases, these strings are appended to SQL CREATE TABLE and CREATE INDEX statements.

In geodatabases stored in an Oracle database, parameter name–configuration string pairs are used by ArcSDE for the following purposes:

By default, Oracle stores tables and indexes in the user's default tablespace using the tablespace's default storage parameters. You can determine a user's default tablespace by querying the DEFAULT_TABLESPACE field of the USER_USERS Oracle system table when connected as that user. As the Oracle database administrator (DBA), query the DEFAULT_TABLESPACE field of the DBA_USERS table using a WHERE clause to specify the user.

SQL> connect <user>/<password>
SQL> select default_tablespace from user_users;

or

SQL> connect system/<password>
SQL> select default_tablespace from dba_users where username = <user>;

Obtain a list of default storage parameters for a tablespace by querying USER_TABLESPACES:

SQL> connect <user>/<password>
SQL> select * from user_tablespaces where tablespace_name = <tablespace>;

To specify different tablespaces using configuration keywords, you need to uncomment some parameters under the DEFAULTS and other configuration keywords in the dbtune file and edit the associated configuration strings to specify a tablespace name. Commented lines are prefaced with a single pound sign (#). Remove this pound sign and replace the <text> with the name of the correct tablespace. Then import the dbtune file into the DBTUNE table. Users can then specify that keyword (or accept the DEFAULTS) and the tables and indexes of the datasets they create will be stored in the tablespace you specified in the dbtune file.

See The dbtune file and the DBTUNE table for specifics on editing the dbtune file and table.

The following table is an alphabetic list of all the possible configuration parameters that can be used in a geodatabase in Oracle. Following that is a more in-depth explanation of the parameters grouped by their functionality, followed by a list of parameters that are specific to ArcSDE geodatabases stored in Oracle Spatial.


Parameter name Description Values Notes
A_INDEX_RASTER Storage definition for the Adds table raster column index See your Oracle documentation for CREATE INDEX parameters.

A_INDEX_ROWID Storage definition for the Adds table object ID column index See your Oracle documentation for CREATE INDEX parameters.

A_INDEX_SHAPE Storage definition for the Adds table spatial column index See your Oracle documentation for CREATE INDEX parameters.

A_INDEX_STATEID Storage definition for the Adds table sde_state_id column index See your Oracle documentation for CREATE INDEX parameters.

A_INDEX_USER Defines storage for the Adds table index See your Oracle documentation for CREATE INDEX parameters.

A_INDEX_XML Storage definition for the Adds table XML column index See your Oracle documentation for CREATE INDEX parameters.

A_STORAGE Defines the storage of the Adds table See your Oracle documentation for CREATE TABLE parameters.

ATTRIBUTE_BINARY Indicates storage type for binary attribute (nonspatial) fields) BLOB or LONGRAW

AUX_INDEX_COMPOSITE Raster AUX table composite column index storage definition See your Oracle documentation for CREATE INDEX parameters.

AUX_STORAGE Raster AUX table storage definition See your Oracle documentation for CREATE TABLE parameters.

B_INDEX_RASTER Business table raster column index storage definition See your Oracle documentation for CREATE INDEX parameters.

B_INDEX_ROWID Business table object ID column index and aster rowid index R<N>_SDE_ROWID_UK storage definition See your Oracle documentation for CREATE INDEX parameters.

B_INDEX_SHAPE Business table spatial column index storage definition See your Oracle documentation for CREATE INDEX parameters.

B_INDEX_TO_DATE Storage parameter info for creating the index R<registration_id>_sde_todate, which is used when updating the history table during an archive operation See your Oracle documentation for CREATE INDEX parameters.

B_INDEX_USER Business table user index storage definition See your Oracle documentation for CREATE INDEX parameters.

B_INDEX_XML Business table XML column index table storage definition See your Oracle documentation for CREATE INDEX parameters.

B_STORAGE Business table and raster attribute table storage definition See your Oracle documentation for CREATE TABLE parameters.

BLK_INDEX_COMPOSITE Raster BLK table composite column index storage definition See your Oracle documentation for CREATE INDEX parameters.

BLK_STORAGE Raster BLK table storage definition See your Oracle documentation for CREATE TABLE parameters.

BND_INDEX_COMPOSITE Raster BND table composite column index storage definition See your Oracle documentation for CREATE INDEX parameters.

BND_INDEX_ID Raster BND table RID column index storage definition See your Oracle documentation for CREATE INDEX parameters.

BND_STORAGE Raster BND table storage definition See your Oracle documentation for CREATE TABLE parameters.

COMMENT Line used for comments Can place any comment up to 8000 characters

COMPRESS_ROLLBACK_SEGMENT Version compression rollback segment (only applies to databases that are using manual undo space management) Name of a rollback segment

D_INDEX_DELETED_AT Deletes table sde_deleted_at column index storage definition See your Oracle documentation for CREATE INDEX parameters.

D_INDEX_ STATE_ROWID Deletes table sde_states_id and sde_deletes_row_id column index storage definition See your Oracle documentation for CREATE INDEX parameters.

D_STORAGE Deletes table storage definition See your Oracle documentation for CREATE TABLE parameters.

F_INDEX_AREA Feature table area column index storage definition See your Oracle documentation for CREATE INDEX parameters. Binary geometry storage only
F_INDEX_FID Feature table FID column index storage definition See your Oracle documentation for CREATE INDEX parameters. Binary geometry storage only
F_INDEX_LEN Feature table length column index storage definition See your Oracle documentation for CREATE INDEX parameters. Binary geometry storage only
F_STORAGE Feature table storage definition See your Oracle documentation for CREATE TABLE parameters. Binary geometry storage only
GEOMETRY_STORAGE Indicates storage data type for spatial column ST_GEOMETRY,SDEBINARY, SDELOB, OGCWKB, or SDO_GEOMETRY

LD_INDEX_DATA_ID SDE_LOGFILE_DATA and SDE_LOGPOOL tables' index storage definition See your Oracle documentation for CREATE INDEX parameters.

LD_INDEX_ROWID SDE_LOGFILE_DATA and SDE_LOGPOOL tables' SDE_ROWID column index storage definition See your Oracle documentation for CREATE INDEX parameters.

LD_STORAGE SDE_LOGFILE_DATA and SDE_LOGPOOL_<SDE_ID> tables' storage definition See your Oracle documentation for CREATE TABLE parameters.

LF_INDEXES SDE_LOGFILES table column indexes storage definition See your Oracle documentation for CREATE INDEX parameters.

LF_STORAGE SDE_LOGFILES table storage definition See your Oracle documentation for CREATE TABLE parameters.

MVTABLES_MODIFIED_INDEX MVTABLES_MODIFIED index storage definition See your Oracle documentation for CREATE INDEX parameters.

MVTABLES_MODIFIED_TABLE MVTABLES_MODIFIED table storage definition See your Oracle documentation for CREATE TABLE parameters.

RAS_INDEX_ID Raster RAS table RID index storage definition See your Oracle documentation for CREATE INDEX parameters.

RAS_STORAGE Raster RAS table storage definition See your Oracle documentation for CREATE TABLE parameters.

RASTER_STORAGE Indicates the storage type used for raster data BLOB, LONGRAW, or SDO_GEORASTER

RDT_INDEX_COMPOSITE Contains the storage information for the composite index that is created on the SDO_GEORASTER blocks table

The index is named SDE_RDT_<N>_PK, where N is the rastercolumn_id value of the raster column.
See your Oracle documentation for CREATE INDEX parameters. Oracle Spatial only
RDT_STORAGE Contains the storage information for the SDO_GEORASTER blocks table

The blocks table is named sde_rdt_<N>, where N is the rastercolumn_id value for the raster column.
See your Oracle documentation for CREATE TABLE parameters. Oracle Spatial only
S_INDEX_ALL Spatial index table first index storage definition when using binary geometry storage See your Oracle documentation for CREATE INDEX parameters. Binary geometry storage only
S_INDEX_SP_FID Spatial index table second index storage definition See your Oracle documentation for CREATE INDEX parameters. Binary geometry storage only
S_STORAGE Represents the spatial index storage definition See your Oracle documentation for CREATE TABLE parameters.

SDO_COMMIT_INTERVAL Number of rows inserted into the spatial index table between each database COMMIT.

This becomes a parameter in the CREATE INDEX statement.
1000

Refer to your Oracle Spatial Users Guide for information about all these values.
Oracle Spatial only
SDO_DIMNAME_1

SDO_DIMNAME_2

SDO_DIMNAME_3

SDO_DIMNAME_4
The name of each dimension for Oracle Spatial geometry types; corresponding values are:

1 = X

2 = Y

3 = Z

4 = M
The dimension name

Refer to your Oracle Spatial Users Guide for information about all these values.
Oracle Spatial only
SDO_INDEX_SHAPE The Oracle Spatial geometry types spatial index storage parameters Various spatial index storage parameters, including <tablespace_name> and sdo_indx_dims=# (default is 2), which specifies how many dimensions should be indexed with an R-tree spatial index

Refer to your Oracle Spatial Users Guide for information about all these values.
Oracle Spatial only
SDO_LB_1

SDO_LB_2

SDO_LB_3

SDO_LB_4
Lower dimension boundary for Oracle Spatial geometry type; units specified in coordinate system of the data

Default values based on extent of data to be loaded; for data with geodetic SRID, SDO_LB_1 must be 180, and SDO_LB_2 must be 90
a value less than the corresponding SDO_UB values

Refer to your Oracle Spatial Users Guide for information about all these values.
Oracle Spatial only
SDO_SRID Oracle Spatial coordinate reference identifier assigned to the SDO_GEOMETRY column If a coordinate reference system is provided during the creation of a feature class, the SDO_SRID parameter is ignored and not written to the Oracle USER_SDO_GEOM_METADATA view. Oracle Spatial only
SDO_TOLERANCE_1 SDO_TOLERANCE_2 SDO_TOLERANCE_3 SDO_TOLERANCE_4
  • The distance two ordinates can be apart in the given dimension and still be considered the same
  • Used by Oracle Spatial functions
  • Must be greater than zero
  • For geodetic data, units are meters; otherwise, units are specified in coordinate system of the data
A value greater than 0

Refer to your Oracle Spatial Users Guide for information about all these values.
Oracle Spatial only
SDO_UB_1

SDO_UB_2

SDO_UB_3

SDO_UB_4
  • Upper dimension boundary for Oracle Spatial geometry type
  • Used by Oracle Spatial functions
  • Must be greater than zero
  • For geodetic data, units are degrees; otherwise, units are specified in coordinate system of the data
  • Default value based on extent of data to be loaded
  • For Oracle9i data with geodetic SRID, SDO_UB_1 must be 180, and SDO_UB_2 must be 90
A value greater than the corresponding SDO_LB values

Refer to your Oracle Spatial Users Guide for information about all these values.
Oracle Spatial only
SESSION_INDEX ArcSDE session-based and stand-alone log file indexes storage definition See your Oracle documentation for CREATE INDEX parameters.

SESSION_STORAGE ArcSDE session-based and stand-alone log file tables storage definition See your Oracle documentation for CREATE TABLE parameters.

ST_GEOM_LOB_STORAGE Controls the storage of the SHAPE.POINTS column for an ST_Geometry object See your Oracle documentation for CREATE TABLE and the LOB storage clause parameters. ST_Geometry storage only;

for more information on storing LOBs, see BLOB data storage in Oracle geodatabases
ST_INDEX_PARTITION_LOCAL Specifies if a partitioned table's sde.st_spatial_index is created as a global or local index

FALSE indicates the st_spatial_index will be created as a global index; TRUE specifies the spatial index will be created as a local index.
True or False Only applies to partitioned business tables containing ST_Geometry columns
STATES_INDEX STATES table storage definition See your Oracle documentation for CREATE INDEX parameters.

STATES_LINEAGES_TABLE STATE_LINEAGES table storage definition See your Oracle documentation for CREATE TABLE parameters.

STATES_TABLE STATES table storage definition See your Oracle documentation for CREATE TABLE parameters.

UI_NETWORK_TEXT User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of network configuration Description up to 8000 characters

UI_TERRAIN_TEXT User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of terrain configuration Description up to 8000 characters

UI_TEXT User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of associated noncomposite configuration keyword Description up to 8000 characters

UI_TOPOLOGY_TEXT User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of topoology configuration Description up to 8000 characters

UNICODE_STRING Determines whether Unicode text types will be used or not; If set to TRUE, character fields will be stored in UNICODE compliant data types.

For example, if the UNICODE_STRING parameter is set to FALSE, a string data type would be VARCHAR2. If UNICODE_STRING is set to TRUE, the data type of the field would be NVARCHAR2.
TRUE or FALSE

VERSIONS_INDEX VERSIONS table index storage definition See your Oracle documentation for CREATE INDEX parameters.

VERSIONS_TABLE VERSIONS table storage definition See your Oracle documentation for CREATE TABLE parameters.

XML_DOC_INDEX Storage clause for xmldoc<n>_pk and xml_doc<n>_ix indexes on the sde_xml_doc<n> table See your Oracle documentation for CREATE INDEX parameters.

XML_DOC_LOB_STORAGE Storage and access information for XML documents in the xml_doc column of the sde_xml_doc<n> table See your Oracle documentation for LOB storage clause parameters. For more information on storing LOBs, see BLOB data storage in Oracle geodatabases.
XML_DOC_MODE Storage type for XML documents COMPRESSED or UNCOMPRESSED

XML_DOC_STORAGE Storage clause for sde_xml_doc<n> table See your Oracle documentation for CREATE TABLE parameters.

XML_DOC_TEXT_TYPE Data type for document text column BLOB or LONGRAW Obsolete after ArcSDE release 9.0
XML_DOC_UNCOMPRESSED_TYPE When the XML_DOC_MODE parameter is set to UNCOMPRESSED, the XML_DOC_UNCOMPRESSED_TYPE parameter determines the storage format for XML documents Since XML_DOC_MODE is set to COMPRESSED by default, the XML_DOC_UNCOMPRESSED_TYPE parameter is not present by default.

Possible values:

CLOB or NCLOB

XML_DOC_VAL_LOB_STORAGE Storage and access information for the XML document content in the xml_doc_val column of the sde_xml_doc<n> table See your Oracle documentation for LOB storage clause parameters. For more information on storing LOBs, see BLOB data storage in Oracle geodatabases.
XML_IDX_INDEX_DOUBLE Storage clause for the xmlix<n>_db index on the double_tag column of the sde_xml_idx<n> table See your Oracle documentation for CREATE INDEX parameters.

XML_IDX_INDEX_ID Storage clause for the xmlix<n>_id index on the ID column of the xml_idx<n> table See your Oracle documentation for CREATE INDEX parameters.

XML_IDX_INDEX_PK Storage clause for xmlix<n>_pk index on the xml_key_column identity column of the sde_xml_idx<n> table See your Oracle documentation for CREATE INDEX parameters.

XML_IDX_INDEX_STRING Storage clause for xmlix<n>_st index on the string_tag column of the sde_xml_idx<n> table See your Oracle documentation for CREATE INDEX parameters.

XML_IDX_INDEX_TAG Storage clause for the xmlix<n>_tg index on the tag_id column of the sde_xml_idx<n> table See your Oracle documentation for CREATE INDEX parameters.

XML_IDX_INDEX_TEXT XML index creation parameters (see Oracle Text Reference) See your Oracle documentation for CREATE INDEX parameters.

XML_IDX_STORAGE Storage clause for sde_xml_idx<n> table (the index table of an XML column) See your Oracle documentation for CREATE TABLE parameters.

XML_IDX_TEXT_TAG_STORAGE Storage and access information for the contents of the text_tag column in the sde_xml_idx<n> table (the index table of an XML column); if no value is specified (default) or if DISABLE STORAGE IN ROW is not specified, this LOB data is stored in line. <no value>, ENABLE STORAGE IN ROW,or DISABLE STORAGE IN ROW

XML_IDX_TEXT_UPDATE_MEMORY The amount of memory to use when building and updating the text index, such as "2M" to allocate 2 MB An integer, greater than 0 but less than the amount of available RAM given in MB (indicated with M); consult your Oracle documentation for recommended settings.

XML_IDX_TEXT_UPDATE_METHOD Oracle Text index change tracking method:

  • NONE—Manual update by running Oracle Text package (default)
  • BUFFERED—ArcSDE updates when stream is closed
  • IMMEDIATE—ArcSDE updates on row insert or update
NONE, BUFFERED, or IMMEDIATE

XML_INDEX_TAGS_INDEX Storage clause for xml_indextags_pk index of the sde_xml_indexes table See your Oracle documentation for CREATE INDEX parameters.

XML_INDEX_TAGS_TABLE Storage clause for sde_xml_index_tags table and the xml_indextags_ix1 and xml_indextags_ix2 indexes on the tag_name and tag_alias columns, respectively See your Oracle documentation for CREATE TABLE parameters.

NOTE: For the XML parameters, <n> refers to the xml_column_id associated with a specific XML column.

Functional descriptions of parameters

Configuration parameters specific to geodatabases in Oracle Spatial

Oracle Spatial feature classes are ArcSDE feature classes with Oracle's SDO_GEOMETRY data type to store feature geometry in a column in the business table. Many of the storage parameters used for ArcSDE compressed binary feature classes apply to Oracle Spatial feature classes. Also, some storage parameters exist solely to establish how Oracle Spatial feature classes are stored, indexed, and accessed.

For a description of Oracle Spatial, consult the Oracle Spatial User's Guide and Reference.

See Also

  • DBTUNE configuration parameter name-configuration string pairs