M[ Top ]
MANAGE TABLESPACE privilege, 459
manual network configuration, 90
Map component (OEM), 173
MAX_COMMIT_PROPAGATION_DELAY parameter, 249
MAX_DUMP_FILE_SIZE parameter, 137, 249
ALTER SESSION command, 306
ALTER SYSTEM command, 320
MAX_ENABLED_ROLES parameter, 105, 250
MAX_ROLLBACK_SEGMENTS parameter, 250
MAX_TRANSACTION_BRANCHES parameter, 250
MAXDATAFILES clause, 30
DATAFILE parameter (CREATE CONTROLFILE), 351
LOGFILE parameter (CREATE DATABASE), 353
MAXEXTENTS clause (ALTER CLUSTER), 284
(see also DEFAULT STORAGE parameter; STORAGE parameter)
MAXEXTENTS parameter (ALTER CLUSTER), 47
maximizing performance (see performance)
MAXINSTANCES clause
DATAFILE parameter (CREATE CONTROLFILE), 351
LOGFILE parameter (CREATE DATABASE), 353
MAXLOGFILES clause
DATAFILE parameter (CREATE CONTROLFILE), 351
LOGFILE parameter (CREATE DATABASE), 353
MAXLOGHISTORY clause
DATAFILE parameter (CREATE CONTROLFILE), 351
LOGFILE parameter (CREATE DATABASE), 353
MAXLOGMEMBERS clause
DATAFILE parameter (CREATE CONTROLFILE), 351
LOGFILE parameter (CREATE DATABASE), 353
MAXSIZE clause (autoextend_clause)
ALTER TABLESPACE command, 337
CREATE DATABASE command, 355
CREATE TABLESPACE command, 391
MAXTRANS parameter, 48
ALTER CLUSTER command, 284
ALTER INDEX command, 288
ALTER INDEX REBUILD command, 291
ALTER INDEX REBUILD PARTITION command, 293
ALTER SESSION command, 312
ALTER SNAPSHOT LOG command, 315
ALTER TABLE command, 327
CREATE CLUSTER command, 348
CREATE INDEX command, 359
CREATE SNAPSHOT command, 373
CREATE SNAPSHOT LOG command, 377
segment_attrib_clause parameter (CREATE TABLE), 387
USING INDEX clause
column_constraint_clause parameter (ALTER TABLE), 332
table_constraint_clause parameter (CREATE TABLE), 383
MAXVALUE parameter
ALTER SEQUENCE command, 302
CREATE SEQUENCE command, 371
MDSYS user, 466
medium for Oracle installation, 21
memory, 18
database blocksize, 28
monitoring, 109-111
sort areas, 49
structures for, 180, 187-192
memory (continued)
user resource control, 100-102
utilization, tuning, 52
MERGE hint, 156-157
MERGE_AJ hint, 152
merge joins, 134
MERGE_SJ hint, 152
message queues, data dictionary views for, 419, 437
MINEXTENTS clause, 205
DEFAULT STORAGE parameter (CREATE TABLESPACE), 389
STORAGE parameter
(see also STORAGE parameter)
STORAGE parameter (CREATE CLUSTER), 348
USING INDEX parameter (ALTER SNAPSHOT), 313
MINIMUM EXTENT parameter
ALTER TABLESPACE command, 335
CREATE TABLESPACE command, 390
MINVALUE parameter
ALTER SEQUENCE command, 302
CREATE SEQUENCE command, 371
MODIFY parameter (ALTER TABLE), 327
MODIFY PARTITION parameter (ALTER TABLE), 329
monitoring, 108
(see also auditing; security)
Motif mode (Oracle installation), 23
MPI (MultiProtocol Interchange), 84-85
MTS (Multi-Threaded Server)
configuring, 43
data dictionary views for, 440
Dispatcher processes, 185
Shared Server processes, 184
user processes and, 187
MTS_DISPATCHERS parameter (ALTER SYSTEM), 250, 320
MTS_LISTENER_ADDRESS parameter, 251
MTS_MAX_DISPATCHERS parameter, 185, 251
MTS_MAX_SERVERS parameter, 185, 251
MTS_MULTIPLE_LISTENERS parameter, 251
MTS_RATE_LOG_SIZE parameter, 251
MTS_RATE_SCALE parameter, 252
MTS_SERVERS parameter (ALTER SYSTEM), 184, 253, 320
MTS_SERVICE parameter, 253
MultiProtocol Interchange (MPI), 84-85
Multi-Threaded Server (MTS)
configuring, 43
Dispatcher processes, 185
Shared Server processes, 184
user processes and, 187
N[ Top ]
name resolution, 83
named user licenses, 14
names.ora file, 89
naming
control files, 31
databases and instances, 29
directories, 26
network services, 81, 83
NATIONAL CHARACTER SET parameter (CREATE DATABASE), 354
native mode ODBC, 85
Navigator component (OEM), 173
nested loops, 134
Net8
configuring, 42
data dictionary views for, 422
Easy Config utility, 94
Oracle Net8 Assistant, 89
(see also SQLxNet)
Network Manager, 170
network transparency, 79
networking, 77-96
ANO (Advanced Networking Option), 81-83
configuring networks
manual configuration, 90
Oracle Net8 Assistant, 89
Oracle Network Manager, 87-89
connecting to non-Oracle databases, 85-86
MPI (MultiProtocol Interchange), 84-85
Oracle architecture for, 77-83
Oracle Network Manager, 170
security, 81
services, 80
SQLxNet (see SQLxNet)
NEW[PAGE] command (SQLxPlus), 495
NEXT clause, 284
ARCHIVE_LOG parameter, 324
autoextend_clause parameter
ALTER TABLESPACE command, 337
CREATE DATABASE command, 355
CREATE TABLESPACE command, 391
DEFAULT STORAGE parameter, 47
REFRESH parameter, 314, 375
(see also DEFAULT STORAGE parameter; STORAGE parameter)
NEXT parameter (SQLxLoader), 519
NEXT parameter (STORAGE clause), 205
NLS_CALENDAR parameter (ALTER SESSION), 307
NLS_CURRENCY parameter (ALTER SESSION), 253, 306
NLS_DATABASE_PARAMETERS view, 426
NLS_DATE_FORMAT parameter (ALTER SESSION), 254, 306
NLS_DATE_LANGUAGE parameter (ALTER SESSION), 254, 306
NLS_INSTANCE_PARAMETERS view, 426
NLS_ISO_CURRENCY parameter (ALTER SESSION), 254, 306
NLS_LANGUAGE parameter (ALTER SESSION), 254, 306
NLS_NUMERIC_CHARACTERS parameter (ALTER SESSION), 255, 306
NLS_SESSION_PARAMETERS view, 426
NLS_SORT parameter (ALTER SESSION), 255, 307
NLS_TERRITORY parameter (ALTER SESSION), 256, 306
nmcbild.sql script, 88
nmcdrop.sql script, 88
nmcgrnt.sql script, 88
nmcrvke.sql script, 88
NO FORCE parameter (CREATE VIEW), 396-397
NO_PUSH_JOIN_PRED hint, 157
NOAPPEND hint, 155
NOARCHIVELOG clause
DATAFILE parameter (CREATE CONTROLFILE), 352
LOGFILE parameter (CREATE DATABASE), 353
NOARCHIVELOG parameter (ALTER DATABASE ARCHIVELOG), 286
NOAUDIT command, 118, 410
NOCACHE hint, 156
NOCACHE parameter
ALTER SEQUENCE command, 302
ALTER SESSION command, 312
ALTER TABLE command, 329
CREATE CLUSTER command, 350
CREATE SEQUENCE command, 372