Initialization parameters, Parameter name default value range of values – Oracle A423961 User Manual

Page 132

Advertising
background image

Admin.

Guide

C – 4

Oracle7 Server Getting Started for Windows NT

control file for the initial database,

CTL1ORCL.ORA

, in

\ORANT\DATABASE.

If you created your database with the CREATE DATABASE command,
Oracle7 Server for Windows NT creates the control file,

CTL1sid.ORA

,

where sid is the SID of that database.

At least two (identical) control files, each located on a separate storage
device, should be used. The size of Oracle7 Server for Windows NT
control files vary according to the complexity of your database structure.
The maximum size of an Oracle7 Server for Windows NT control file is
2500 database blocks.

Additional Information:

See Oracle7 Server Administrator’s

Guide for more information on initialization parameters.

Initialization Parameters

Oracle7 Server Administrator’s Guide includes descriptions of all
initialization parameters and instructions for setting and displaying
their values.

Parameter Name

Default Value

Range of Values

BACKGROUND_DUMP_DEST

%RDBMSnn%\TRACE\

Any valid directory

COMMIT_POINT_STRENGTH

1

0 – 255

CONTROL_FILES

%ORACLE_HOME%\DATABASE\CTL1%ORACLE_SID%.ORA

Any valid path and filename.

DB_BLOCK_SIZE

2048

512 – 8192

DB_FILES

32

254, cannot exceed DB_BLOCK_BUFFERS

DB_FILE_MULTIBLOCK_READ_COUNT

4

1 – 32

DB_FILE_SIMULTANEOUS_WRITES

4

1 – 24

DISTRIBUTED_TRANSACTIONS

25 * TRANSACTIONS

0 – TRANSACTIONS

LOG_ARCHIVE_BUFFER_SIZE

127

1 – 127

LOG_ARCHIVE_BUFFERS

4

1 – 8

LOG_ARCHIVE_DEST

%RDBMSnn%\

Any valid directory

LOG_ARCHIVE_FORMAT

ARC%S.%T

A valid filename format

LOG_CHECKPOINT_INTERVAL

8000

2 – Unlimited

LOG_FILES

255

2 – 255

LOG_SMALL_ENTRY_MAX_SIZE

800

0 – Unlimited

MTS_MAX_DISPATCHERS

(unused)

(unused)

MTS_MAX_SERVERS

(unused)

(unused)

MTS_SERVERS

(unused)

(unused)

NLS_LANGUAGE

AMERICAN

Any valid language

NLS_SORT

(Language dependent)

(Language dependent)

NLS_TERRITORY

AMERICA

Any valid territory

Advertising