No edit summary
(where to find [W])
 
(8 intermediate revisions by 5 users not shown)
Line 1: Line 1:
Initialization Parameter Description
'''Wikedbox HELPS YOU CONVERT HTML (WEB FORMATTED CONTENT) TO MEDIAWIKI.'''. More instructions at [[Appropedia:WikEd]].


{| class="wikitable" border="1"
INSTRUCTIONS:
| JOB_QUEUE_PROCESSES The maximum number of processes allowed for executing jobs,ranging from 0 to 1000.
 
|-
1. If you're not in edit mode, click the "edit" tab now.
| LDAP_DIRECTORY_SYSAUTH Enables or disables directory-based authorization for users with the SYSDBA and SYSOPER roles.
 
|-
2. Paste in your content.
| LOG_ARCHIVE_DEST_n For ARCHIVELOG mode, up to ten locations for sending archived log files.
 
|-
3. Click the red [W] to convert. (Middle row, second block from the left.)
| LOG_ARCHIVE_DEST_STATE_n Sets the availability of the corresponding LOG_ARCHIVE_DEST_n sites.
 
|-
4. Your text is ready to be copied and used on your wiki page. (You may need to make further corrections.)
| NLS_LANGUAGE Specifies the default language of the database, including messages, day and month names, and sorting rules (for example, ‘AMERICAN’).
 
|-
5. '''DO NOT SAVE THIS PAGE'''. (You'll be blocked from doing so, anyway, unless you're an admin.)
| NLS_TERRITORY The territory name used for day and week numbering (for example,‘SWEDEN’, ‘TURKEY’, or ‘AMERICA’).
|-
| OPEN_CURSORS The maximum number of open cursors per session.
|-
| PGA_AGGREGATE_TARGET The total memory to allocate for all server processes in this instance.
|-
| PROCESSES The maximum number of operating system processes that can connect to Oracle simultaneously. SESSIONS and TRANSACTIONS are derived from is value.
|-
| REMOTE_LISTENER A network name resolving to an Oracle Net remote listener.
|-
| REMOTE_LOGIN_PASSWORDFILE Specifies how Oracle uses password files. Required for RAC.
|-
| ROLLBACK_SEGMENTS Names of private rollback segments to bring online, if undo management is not used for transaction rollback.
|-
| SESSIONS The maximum number of sessions, and therefore simultaneous users, in the instance. Defaults to 1.1*PROCESSES + 5.
|-
| SGA_TARGET Specifies the total size of all SGA components; this parameter automatically determines DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, STREAMS_POOL_SIZE, and JAVA_POOL_SIZE.
|-
| SHARED_SERVERS The number of shared server processes to allocate when an instance is started.
|-
| STAR_TRANSFORMATION_ENABLED Controls query optimization when start queries are executed.
|-
| UNDO_MANAGEMENT Specifies whether undo management is automatic (AUTO) or manual (MANUAL). If MANUAL is specified, rollback segments are used for undo  management.
|-
| UNDO_TABLESPACE The tablespace to use when UNDO_MANAGEMENT is set to AUTO.
|}

Latest revision as of 00:26, 15 July 2013

Wikedbox HELPS YOU CONVERT HTML (WEB FORMATTED CONTENT) TO MEDIAWIKI.. More instructions at Appropedia:WikEd.

INSTRUCTIONS:

1. If you're not in edit mode, click the "edit" tab now.

2. Paste in your content.

3. Click the red [W] to convert. (Middle row, second block from the left.)

4. Your text is ready to be copied and used on your wiki page. (You may need to make further corrections.)

5. DO NOT SAVE THIS PAGE. (You'll be blocked from doing so, anyway, unless you're an admin.)

Cookies help us deliver our services. By using our services, you agree to our use of cookies.