The LOGFILE_DEFAULTS keyword in Oracle

The LOGFILE_DEFAULTS keyword contains parameters to specify the storage of ArcSDE log file tables. If custom logfile keywords are not created, the settings in the LOGFILE_DEFAULTS keyword are used to specify storage for log file tables for all connecting users.

Tip:

See Custom configuration keywords for information on creating custom keywords.

The following are the default log file parameters as they would appear in the dbtune files available with ArcSDE for Oracle. To provide storage information for the parameters that are commented out, uncomment them by removing the pound sign (#), and provide a tablespace name. You can also change the other storage parameters. Uncomment and set these parameters in the dbtune.sde file prior to creating the geodatabase. If you do not alter the values prior to geodatabase creation, you can use the sdeconfig command to set them after the geodatabase is set up. Consult the ArcSDE Administration Command Reference included with the ArcSDE component of ArcGIS Server at the Enterprise level for details on the sdeconfig command.

##LOGFILE_DEFAULTS
LF_STORAGE  "PCTFREE 0 INITRANS 4"
# TABLESPACE <SDE_LOGFILES default table tablespace name>
LF_INDEXES   "PCTFREE 0 INITRANS 4 
# TABLESPACE <SDE_LOGFILE index tablespace name> NOLOGGING"
LD_STORAGE  "PCTFREE 0 INITRANS 4"
# TABLESPACE  <SDE_LOGFILE_DATA default table tablespace name>
LD_INDEX_ROWID  "PCTFREE 0 INITRANS 4 
# TABLESPACE <SDE_LOGFILE_DATA index tablespace name> NOLOGGING"
LD_INDEX_DATA_ID  "PCTFREE 0 INITRANS 4 
# TABLESPACE <SDE_LOGFILE_DATA index tablespace name> NOLOGGING"
SESSION_STORAGE  "PCTFREE 0 INITRANS 4"
# TABLESPACE <SDE_LOGFILES default table tablespace name>
SESSION_INDEX  "PCTFREE 0 INITRANS 4 
# TABLESPACE <SDE_LOGFILE_DATA index tablespace name> NOLOGGING"
SESSION_TEMP_TABLE 0

END