Prev | Current Page 119 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"


LDAP_DIRECTORY_SYSAUTH Enables or disables directory-based authorization for users with the
SYSDBA and SYSOPER roles.
LOG_ARCHIVE_DEST_n For ARCHIVELOG mode, up to ten locations for sending archived
log files.
LOG_ARCHIVE_DEST_STATE_n Sets the availability of the corresponding LOG_ARCHIVE_DEST_n
sites.
NLS_LANGUAGE Specifies the default language of the database, including messages,
day and month names, and sorting rules (for example, ???AMERICAN??™).
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 this 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.


Pages:
107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131
noclegi hel tanie pensjonaty nad morzem Lokaty jednodniowe projekty domków letniskowych męskie skarpetki rowerowe