Contents Index Initial option settings Compatibility options

ASA Database Administration Guide
  Database Options

Database options


This section lists all database options.

OPTION VALUES DEFAULT
AUDITING option [database] ON, OFF OFF
BACKGROUND_PRIORITY option [database] ON, OFF OFF
BLOCKING option [database] ON, OFF ON
BLOCKING_TIMEOUT option [database] Integer 0
CHECKPOINT_TIME option [database] Number of minutes 60
CIS_ROWSET_SIZE option [database] Integer 50
COOPERATIVE_COMMIT_TIMEOUT option [database] Integer 250
COOPERATIVE_COMMITS option [database] ON, OFF ON
DATE_FORMAT option [compatibility] String 'YYYY-MM-DD'
DATE_ORDER option [compatibility] 'YMD', 'DMY', 'MDY' 'YMD'
DEFAULT_TIMESTAMP_INCREMENT option [database] Integer 1
DELAYED_COMMIT_TIMEOUT option [database] Integer 500
DELAYED_COMMITS option [database] ON, OFF OFF
EXTENDED_JOIN_SYNTAX option [database] ON/OFF ON
EXCLUDE_OPERATORS option [database] reserved reserved
FIRST_DAY_OF_WEEK option [database] 1, 2, 3, 4, 5, 6, 7 7
GLOBAL_DATABASE_ID option [database] Integer 2147483647
ISOLATION_LEVEL option [compatibility] 0, 1, 2, 3 0
JAVA_HEAP_SIZE option [database] Number of bytes 1 000 000
JAVA_NAMESPACE_SIZE option [database] Number of bytes 4 000 000
LOGIN_MODE option [database] STANDARD, MIXED, INTEGRATED STANDARD
LOGIN_PROCEDURE option [database] String sp_login_environment
MAX_CURSOR_COUNT option [database] Integer 50
MAX_HASH_SIZE option [database] Integer 10
MAX_PLANS_CACHED option [database] Integer 20
MAX_STATEMENT_COUNT option [database] Integer >=0 50
MAX_WORK_TABLE_HASH_SIZE option [database] Integer 20
MIN_PASSWORD_LENGTH option [database] Integer 0
MIN_TABLE_SIZE_FOR_HISTOGRAM option [database] Integer 1 000 rows
ON_CHARSET_CONVERSION_FAILURE option [database] IGNORE, WARNING, ERROR IGNORE
OPTIMISTIC_WAIT_FOR_COMMIT ON, OFF OFF
OPTIMIZATION_GOAL option [database] First-row or all-rows all-rows
PINNED_CURSOR_PERCENT_OF_CACHE option [database] 0-100 10
PRECISION option [database] Number of digits 30
PREFETCH option [database] ON, OFF ON
PRESERVE_SOURCE_FORMAT option [database] ON, OFF ON
PREVENT_ARTICLE_PKEY_UPDATE option [database] ON, OFF ON
READ_PAST_DELETED option [database] ON, OFF ON
RECOVERY_TIME option [database] Number of minutes 2
RETURN_DATE_TIME_AS_STRING option [database] ON, OFF OFF
RETURN_JAVA_AS_STRING option [database] ON, OFF OFF
ROW_COUNTS option [database] ON, OFF OFF
SCALE option [database] Number of digits 6
SORT_COLLATION option [database] any valid collation_name or collation_ID Internal
SUBSUME_ROW_LOCKS option [database] ON, OFF ON
SUPPRESS_TDS_DEBUGGING option [database] ON, OFF OFF
TDS_EMPTY_STRING_IS_NULL option [database] ON, OFF OFF
TIME_FORMAT option [compatibility] String 'HH:NN:SS.SSS'
TIME_ZONE_ADJUSTMENT option [database] Integer, or Negative integer enclosed in quotation marks, or String representing time in hours and minutes, preceded by + or - Set by either the client's or the server's time zone, depending on the client's connection type
TIMESTAMP_FORMAT option [compatibility] String 'YYYY-MM-DD HH:NN:SS.SSS'
TRUNCATE_DATE_VALUES option [database] ON, OFF ON (post version 7 databases) OFF (pre version 7 databases)
TRUNCATE_TIMESTAMP_VALUES option [database] ON, OFF OFF
TRUNCATE_WITH_AUTO_COMMIT option [database] ON, OFF OFF
USER_ESTIMATES option [database] ENABLED, OVERRIDE-MAGIC, DISABLED OVERRIDE-MAGIC
UPDATE_STATISTICS option [database] ON, OF ON
WAIT_FOR_COMMIT option [database] ON, OFF OFF

Contents Index Initial option settings Compatibility options