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 if exported to a text file from the DBTUNE table using the sdedbtune command. You can add more parameters, such as tablespace name and logging. See your Oracle documentation for table and index creation parameters.

You can also change the other storage parameters using the sdedbtune command, which is installed with the ArcSDE application server installation. See the ArcSDE Administration Command Reference included with the ArcSDE application server installation and Altering the contents of the DBTUNE table for details on using the sdedbtune command.

##LOGFILE_DEFAULTS
LF_STORAGE  "PCTFREE 0 INITRANS 4"
LF_INDEXES   "PCTFREE 0 INITRANS 4" 
LD_STORAGE  "PCTFREE 0 INITRANS 4"
LD_INDEX_ROWID  "PCTFREE 0 INITRANS 4" 
LD_INDEX_DATA_ID  "PCTFREE 0 INITRANS 4"
SESSION_STORAGE  "PCTFREE 0 INITRANS 4"
SESSION_INDEX  "PCTFREE 0 INITRANS 4" 
SESSION_TEMP_TABLE 0

END