Skip Headers
Oracle® Database Administrator's Reference
10g Release 2 (10.2) for hp OpenVMS

Part Number B25416-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

D Logical Names and Parameters

This appendix provides information about Oracle Database 10g logical names and utilities, and the default and recommended values for various initialization parameters. Refer to Oracle Database Administrator's Guide for general information about all the initialization parameters.

This appendix contains the following topics:

D.1 Oracle Database 10g Logical Names

During installation, several logical names are set up. These assignments are referenced through the ORA_ROOT:[BIN]ORA_DB_LOGICALS.COM file that is referenced whenever you start up, upgrade, link, or relink Oracle Database 10g or other Oracle products.

This section contains the following topics:

D.1.1 Process Quota Logical Names

If you do not set quotas for the background processes, then Oracle Database 10g uses built-in formulas to determine how to set the quota logical names.

Table D-1 shows each quota logical name, the minimum and maximum values that you can use if you are setting the logical names, and the current formula.

Table D-1 Components of Quota Logical Names

Calculation Component Value or Formula

COMFORT_ZONE

2.5 MB

P0_DYNAMIC_SIZE

Process private storage + room for expansion. 20 MB

P0_IMAGE_SIZE

30 MB size of P0 image

P0_TABLE_SIZE

Size of page tables needed to map SGA

PQL$_PGFLQUOTA

PAGE_TABLE_SIZE(SGA)+P0_DYNAMIC_SIZE+COMFORT_ZONE

PQL$_WSEXTENT

If backing file used:

PAGE_TABLE_SIZE (SGA) + 4 *

P0_IMAGE_SIZE + P0_DYNAMIC_SIZE +

COMFORT_ZONE))/512 + 1

Without backing file used:

4 * (P0_IMAGE_SIZE + P0_DYNAMIC_SIZE + -

COMFORT_ZONE))/512 + 1

PQL$_WSQUOTA

If backing file used:

(SGA_SIZE/512 + PAGE_TABLE_SIZE

(SGA_SIZE) + 4 * (P0_IMAGE_SIZE

(PAGE_IMAGE_SIZE) + .6 * (P0_DYNAMIC_SIZE) +

COMFORT_ZONE))/512 +1

Without backing file used:

PAGE_TABLE_SIZE (SGA_SIZE) + 4 *

(PAGE_TABLE_SIZE (P0_IMAGE_SIZE) + .6 *

(P0_DYNAMIC_SIZE) + COMFORT_ZONE))/512 +1


See Also:

Section 5.5.3, "Process Quotas" for more information about modifying Oracle process quotas through logical names

D.1.2 Logical Name Definitions for the MTS Dispatcher

In Oracle Database 10g, the MTS Dispatcher requires larger BIOLM and ASTLM process quotas than in past releases.

For each number of anticipated MTS Dispatcher connections, both BIOLM and ASTLM must be set to 100 + 5 x number_of_simultaneous_connections. For example, if it is required that the MTS Dispatcher should handle 100 connections, then set both BIOLM and ASTLM to 100 + (5 * 100) = 600. When determining the maximum number of connections, you must consider both inbound and outbound connections. Outbound connections could be made while establishing database links or links to LDAP servers. Failure to set these quotas results in the MTS Dispatcher becoming blocked in a mutex wait state. Therefore, it is better to estimate the highest number of connections possible.

Both quotas may be controlled by setting the system-wide PQL$_BIOLM and PQL$_ASTLM values. They may also be controlled by adding instance-specific or process-specific logical names to ORA_ROOT:[BIN]ORA_DB_LOGICALS.COM.

The process-specific logicals for these are ORA_sid_Dxxx_PQL$_BIOLM and ORA_sid_Dxxx_PQL$_ASTLM.

The instance-wide logicals for these are ORA_sid_PQL$_BIOLM and ORA_sid_Dxxx_PQL$_ASTLM.

Both logical names must be set in the system logical name table. For example, to configure one dispatcher for 100 connections, add the following command to ORA_ROOT:[BIN]ORA_DB_LOGICALS.COM:

"$DEFINE/SYSTEM ORA_your_sid_name_D000_PQL$_BIOLM 600

Note:

For more information on setting the BIOLM and ASTLM values, refer to Metalink Note 156484.1.

D.2 System-Dependent Initialization Parameters

All parameters used in INIT.ORA require an equal sign (=). For example, DB_BLOCK_SIZE = 8192 is correct.

This section contains the following topics:

D.2.1 BACKGROUND_ DUMP_DEST

Purpose

Identifies the directory where the trace files created by the detached Oracle Database 10g processes are sent.

Recommended Value

None

Default Value

ORA_ROOT:[ADMIN.dbname.BDUMP]

Distributed Value

None

D.2.2 DB_BLOCK_SIZE

Purpose

Identifies size (in bytes) of Oracle Database 10g database blocks and the database buffers in the SGA.

Recommended Value

A binary multiple of 512 bytes (which is the OpenVMS I/O block size). The maximum value is 32768.

Default Value

8192

Distributed Value

None

D.2.3 LOG_ARCHIVE_DEST

Purpose

Specifies a default text string to indicate the location and name of the disk file when archiving log files. Archiving directly to tape is not supported.

Recommended Value

Any valid disk file name.

Default Value

ORA_ARCHIVE

Distributed Value

None

D.2.4 LOG_ARCHIVE_ FORMAT

Purpose

Specifies a default file name format for archived redo log files. LOG_ARCHIVE_FORMAT is appended to the string specified in the LOG_ARCHIVE_DEST parameter.

The redo log file format specifications can contain variables that are substituted with a unique archived redo log file name.

Recommended Value

Any valid file name format.

Default Value

ARCH%T_%S_%R.ARC

Distributed Value

None

D.2.5 PRE_PAGE_SGA

Purpose

Determines whether or not the SGA pages will be paged into each user's working set at connect time. This parameter can be manipulated to reduce page faults.

Recommended Value

Define this parameter as TRUE if the current system load has not produced a high rate of page faults.

Default Value

FALSE

Distributed Value

None

D.2.6 SHARED_POOL_SIZE

Purpose

Determines the size of the shared pool. The shared pool contains shared cursors and stored procedures.

Recommended Value

Larger values of this parameter improve performance in multiuser systems. Smaller values use less memory. This parameter's minimum is 300 KB and its maximum is determined by the size of the SGA. Although there are no SGA size limitations, the minimum value is 30 MB.

Default Value

160 MB

Distributed Value

None

D.2.7 SORT_AREA_SIZE

Purpose

Identifies the size of real memory (in bytes) that will be available for sorting processes

Recommended Value

The amount of real memory that you can reasonably expect to have available for sorting. For example, on a system with 256 MB of real memory, with 1/8 available to sort processes and 4 sorts occurring at the same time, you may set this parameter to 256/8/4 = 8 MB.

Default Value

Generally, a large size improves the efficiency of large sort operations only. In most cases, however, the default works for most database operations.

Distributed Value

None

D.2.8 USER_DUMP_DEST

Purpose

Identifies the location to which trace files created by user processes are sent.

Recommended Value

None

Default Value

ORA_ROOT:[ADMIN.dbname.UDUMP]

Distributed Value

None