Edit the DBTUNE table

DBTUNE table in SDE schema stores the DBTUNE storage parameters that control how ArcSDE clients create objects within an Oracle database. The table is populated with specific default values. sdedbtune utility is used to initialize or alter DBTUNE table contents.

To edit the DBTUNE table, the following steps can be followed:

1. Use "sdedbtune -o export" to export the DBTUNE table to a text file.
sdedbtune -o export -f dbtune_out.sde -i 5151 -s sdeserver -u sde -p password

ArcSDE 9.1 Oracle10g Build 371 Tue May 9 10:13:38 PDT 2006Attribute Administration Utility-----------------------------------------------------
Successfully exported to file SDEHOME\etc\dbtune_out.sde on server sdeserver

2. Edit the resulting file with vi (UNIX) or Notepad (Windows).

3. Use "sdedbtune -o import" to import the modified file into DBTUNE table.

sdedbtune -o import -f dbtune_out.sde -i 5151 -s sdeserver -u sde -p password

ArcSDE 9.1 Oracle10g Build 371 Tue May 9 10:13:38 PDT 2006Attribute Administration Utility-----------------------------------------------------
Import DBTUNE Table. Are you sure? (Y/N): y
Successfully imported from file SDEHOME\etc\dbtune_out.sde

4. Test. Always.

sdedbtune tool in ArcSDE 9.1 always exports and imports from the $SDEHOME/etc directory. In ArcSDE 9.2, the tool picks up the directory the command is issued if no directory is specified with the path name.