M

M variable in SQLDA

how value is set, PC_ 15-11

purpose of, PC_ 15-11

macro precompiler options, PC_ 10-5

mail

sending from PL/SQL, ADG 12-1

mail()

function of UTL_SMTP, SPR 65-6

main(String[]) - oracle.xml.parser.v2.oraxsl.main(java.lang.String[]), JPR 4-43

maintainability, PLS 7-3

maintaining bootstrap information, LEG 4-11

Maintaining Context - Java, DCI 14-3

maintenance

standby database

overview, SBY 1-26

MAKE_REF function, SQL 4-49

malloc()

example of using, PC_ 15-32

purpose of, PC_ 15-32

man pages, UNIX, LEG 1-12

MANAGE TABLESPACE system privilege, SQL 7-527

managed recovery

of database, SQL 7-8

of standby databases, SBY 2-5, SBY 3-13

canceling, SBY 3-16

preparing for, SBY 2-5

starting, SBY 3-14

managed recovery mode, SBY 1-21, SBY 3-13

managed standby database, SCN 368

MANAGED STANDBY RECOVERY clause

of ALTER DATABASE, SQL 7-14

managed targets, defined, PSG 2-3

Management Information Base (MIB), STU 11-5

Management Server

described, PSG 2-3, PSG 6-3

OMSCONFIG.PROPERTIES file, PSG 6-11

starting, PSG 6-11

managing

attributes

overview, OID 6-18

using command line tools, OID 6-31

using Oracle Directory Manager, OID 6-19

configuration set entries, OID 5-2

directory schema, OID 6-1

entries

using command line tools, OID 7-25

using Oracle Directory Manager, OID 4-13, OID 7-2

knowledge references, OID 2-20

object classes

using command line tools, OID 6-17

managing datafiles, SAD 10-1 to SAD 10-14

managing job queues, SAD 8-3 to SAD 8-14

managing RMAN metadata, RMN 3-1, RMN 7-1

managing roles, SAD 23-4

managing roles with RADIUS server, OAS 4-24

managing sequences, SAD 18-12 to SAD 18-13

managing synonyms, SAD 18-14 to SAD 18-15

managing tables, SAD 13-1 to SAD 13-26

managing views, SAD 18-2 to SAD 18-12

mandatory attributes, OID 2-7, OID 6-2

adding to existing object classes, OID 6-4

adding to object classes in use, OID 7-22

entering values for, OID 7-14

in object classes, OID 6-7

redefining, OID 6-3

MANDATORY option

LOG_ARCHIVE_DEST_n initialization parameter, SBY 2-17

manual

refresh, DWG 14-18

striping, DWG 4-3

manual archiving, PSA 13-4, SRF 1-61

dropping a redo log file, PSA 3-8

in ARCHIVELOG mode, SAD 7-9

manual bootstrap backup, LEG 4-11

manual locking, ADG 7-11, SCN 1-32, SCN 242

LOCK TABLE command, ADG 7-12

manual overrides

in-doubt transactions, DDS 5-13

manual recovery

of standby databases, SBY 1-17, SBY 2-6

preparing for, SBY 2-6

manual recovery mode, SBY 1-8

manual resolution of conflicts, OID 10-26

Many Producers, Many Consumers - Discrete Messages, ADQ 7-3

Many Producers, One Consumer, ADQ 7-3

many-to-many references

simple subquery snapshots, REP 3-15

many-to-one references

simple subquery snapshots, REP 3-15

MAP MEMBER clause

of ALTER TYPE, SQL 7-189

of CREATE TYPE, SQL 7-443, SQL 7-449

Map Message, ADQ 12-26

MAP methods

specifying, SQL 7-189

map methods, ADO 1-5, ADO 6-7, ADO 9-17, DCI 3-5, PLS 9-10, SCN 1-56, SCN 13-7

mapping blocks to PCM locks, PSA 7-7

mapping DCE groups

to Oracle roles, OAS 14-7

marking

objects, OCI 13-9

mass deployment, REP 3-4, REP 4-2, REP A-6

massively parallel processing (MPP)

affinity, SCN 162, SCN 205, SCN 206

multiple Oracle instances, SCN 5-3

parallel SQL execution, SCN 158

Massively Parallel Processing System, PSC 7-21

Massively Parallel Processing Systems, PSC 2-7

massively parallel system, STU 9-15

application profile, PSC 8-7

massively parallel systems, DWG 5-2, DWG 18-2

master databases, SQL 7-320

master definition site, REP 1-5, REP 2-2, SCN 425

Master Definition Site (MDS), OID 10-3

designating, OID 10-3

master definition sites

relocating, SPR 37-75, RAR 8-141

master groups, REP 1-5, REP 2-26, SCN 425

adding objects to, RAR 3-5

creating, SPR 37-37, RAR 3-2, RAR 3-5, RAR 8-103

dropping, SPR 37-51, RAR 8-117

flowchart for creating, RAR 3-4

quiescing, SPR 37-83, RAR 8-149

resuming replication activity, SPR 37-78, RAR 8-144

master sites, REP 1-5, SCN 425

adding, RAR 3-7, RAR 7-3

adding using offline instantiation, RAR 7-29

advantages of, REP 7-9

bulk updates, REP B-4

changing master definition site, RAR 7-2

compared with snapshot sites, REP 7-8

constraints

violations, REP B-4

creating, SPR 37-7, RAR 8-73

creating users, RAR 2-6

database links, RAR 2-12

DDL changes not propagated, REP B-3

determining differences, RAR 7-41

diagnosing problems with, REP B-2

DML changes not propagated, REP B-3

dropping, SPR 37-76, RAR 7-4, RAR 8-142

fine grained quiesce, REP A-7

flowchart for setting up, RAR 2-3

incremental migration of, MIG G-7

internal triggers, REP 3-19

managing, RAR 7-2

metadata

cleaning up, RAR 7-14

migration, MIG G-3

propagating changes between, SPR 11-19, RAR 8-34

replicated objects not created at new, REP B-2

replication, REP 2-6, REP 2-11

roles, REP 2-11

schedule purge, RAR 2-6

scheduled links, RAR 2-13

scheduled links for

guidelines, REP 7-10

scheduled purge, REP 3-34

scheduled purges for

guidelines, REP 7-11

setup, RAR 2-4

snapshot registration, REP 3-16

snapshots, REP 3-19

users, REP 2-11

master table

snapshots

Import, SUT 2-48

master tables, SQL 7-320

columns

number restriction for simple subquery snapshots, REP 3-15

reorganizing, RAR 7-20

methods, RAR 7-21

snapshot logs, REP 3-20

snapshots, REP 3-19

truncating, RAR 7-21

matching foreign keys

full, partial, or none, SCN 266

matching rules

attribute, OID 2-6

cannot add to subSchemaSubentry, OID 2-10

recognized by Oracle Internet Directory, OID F-9

stored in schema, OID 2-10

tab in Oracle Directory Manager, OID 6-10

materialized join views, SQL 7-335

materialized view logs, SCN 10-19, SQL 7-334

creating, SQL 7-334

excluding new values from, SQL 7-61

logging changes to, SQL 7-60

parallelizing creation of, SQL 7-336

partition attributes

changing, SQL 7-60

partitioned, SQL 7-336

physical attributes

changing, SQL 7-60

specifying, SQL 7-336

removing from the database, SQL 7-487

required for fast refresh, SQL 7-334

saving new values in, SQL 7-61

saving old values in, SQL 7-337

storage characteristics

specifying, SQL 7-336

materialized views, GTK 2-11, SCN 10-18, SUT 2-48

allowing update of, SQL 7-327

altering, DWG 8-36

build methods, DWG 8-18

compatibility, MIG 9-14

complete refresh, SQL 7-52, SQL 7-325

complex, DWG 14-27

constraints on, SQL 7-244

containing only joins, DWG 8-13

creating, DWG 8-16, SQL 7-320

creating comments about, SQL 7-228

for data warehousing, SQL 7-320

deallocating extents, SCN 4-16

degree of parallelism, SQL 7-51, SQL 7-60

during creation, SQL 7-323

delta joins, DWG 19-14

detail table of, dropping, SQL 7-486

downgrading, MIG 13-16

BUILD DEFERRED clause, MIG 13-17

FAST REFRESH mode, MIG 13-17

NEVER REFRESH mode, MIG 13-17

PREBUILT TABLE clause, MIG 13-17

REFRESH ON COMMIT mode, MIG 13-17

dropping, DWG 8-30, DWG 8-36

enabling and disabling query rewrite, SQL 7-327

estimating size, DWG 15-7

examples, SQL 7-329, SQL 7-337

fast refresh, SQL 7-52, SQL 7-324, SQL 7-325

forced refresh, SQL 7-53

from existing tables, SQL 7-323

granting

system privileges on, SQL 7-523

guidelines, DWG 8-35

index characteristics

changing, SQL 7-51

indexes that maintain, SQL 7-324

invalidating, DWG 8-34

join, SQL 7-335

joins and aggregates, DWG 8-11

LOB storage characteristics of, SQL 7-51

logging changes to, SQL 7-50

logs, DWG 11-8

materialized view logs, SCN 10-19

naming, DWG 8-17

nested, DWG 8-23

overview, SCN 1-23

partitioned, SCN 10-19, SCN 11-2

partitioning, DWG 8-31

partitions of, SQL 7-51

physical and storage attributes

changing, SQL 7-50

physical attributes of, SQL 7-322

prebuilt, DWG 8-16

primary key, SQL 7-326

recording values in master table, SQL 7-61

query rewrite

eligibility for, SQL 7-244

enabling and disabling, SQL 7-54

hints, DWG 19-5, DWG 19-28

matching join graphs, DWG 8-18

parameters, DWG 19-5

privileges, DWG 19-6

recommending, DWG 15-5

re-creating during refresh, SQL 7-52

refresh dependent, DWG 14-21

refresh mode

changing, SQL 7-52

refresh time

changing, SQL 7-52

refreshing, DWG 8-20, DWG 14-16, SCN 10-19

refreshing after DML on master table, SQL 7-53, SQL 7-325

refreshing all, DWG 14-20

refreshing on next COMMIT, SQL 7-53, SQL 7-325

refreshing with DBMS_MVIEW, SPR 22-1

registration, DWG 8-29

removing from the database, SQL 7-485

removing incompatibilities, MIG 13-16

for replication, SQL 7-320

restrictions, DWG 8-19

retrieving data from, SQL 7-572

revalidating, SQL 7-54

rewrites

enabling, DWG 19-5

rowid, SQL 7-326

rowid values

recording in master table, SQL 7-61

same as snapshots, SCN 1-24

saving blocks in a cache, SQL 7-51

schema design guidelines, DWG 8-8

security, DWG 8-35

single table aggregate, DWG 8-12

storage characteristics, DWG 8-17

storage characteristics of, SQL 7-322

subquery, SQL 7-328

synonyms for, SQL 7-377

types of, DWG 8-10

uses for, DWG 8-2

when to populate, SQL 7-323

materialized views. See summary management

MAX aggregate function, PLS 5-3

MAX function, SQL 4-50

max session memory statistic, STU 19-24

MAX_COMMIT_PROPAGATION_DELAY initialization parameter, SRF 1-66

MAX_COMMIT_PROPAGATION_DELAY parameter, PSA 1-8, PSA 1-11, PSA 7-18, PSC 6-6

MAX_DUMP_FILE_SIZE

SQL Trace parameter, STU 6-4

MAX_DUMP_FILE_SIZE initialization parameter, SAD 4-16, SRF 1-67, STU 6-4

MAX_DUMP_FILE_SIZE parameter

of ALTER SESSION, SQL 7-90

of ALTER SYSTEM, SQL 7-114

MAX_ENABLED_ROLES initialization parameter, REP 7-4, SRF 1-67

enabling roles and, SAD 23-18

MAX_ENABLED_ROLES parameter, ADG 11-24, ADG 11-27

MAX_FREELIST_BUFFERS parameter, NET C-73

MAX_ROLLBACK_SEGMENTS initialization parameter, SRF 1-68

MAX_SORT_SIZE, PSC A-12

MAX_TRANSACTION_BRANCHES initialization parameter: obsolete

maxcorrupt parameter

set command (RMAN), RMN 10-143

MAXDATAFILES clause, PSA 3-3, PSA 3-9

MAXDATAFILES parameter, PSA 3-9

changing, SAD 5-5

of CREATE CONTROLFILE, SQL 7-265

OF CREATE DATABASE, SQL 7-270

maxextents, OID 10-5

MAXEXTENTS keyword, DWG 14-13, DWG 18-44

MAXEXTENTS parameter

of STORAGE clause, SQL 7-608

MAXEXTENTS storage parameter

automatic allocations, PSA 8-11, PSC 7-25

description, SAD 12-10

preallocating extents, PSA 8-13

rollback segments, SAD 11-5, SAD 11-8

setting for the data dictionary, SAD 19-27

MAXEXTENTS UNLIMITED storage parameter, SCN 197

maximizing data transfer, by adjusting SDU size, NET 5-8

Maximum number of properties (integer) exceeded - error, ADQ D-6

Maximum Open Connections field, NET 6-63

maximum precision, PLS 2-13

Maximum Prespawned Servers field, NET 7-16

maximum size

CHAR value, PLS 2-15

identifier, PLS 2-5

LOB, PLS 2-22

LONG RAW value, PLS 2-16

LONG value, PLS 2-16

NCHAR value, PLS 2-20

NVARCHAR2 value, PLS 2-21

Oracle error message, PLS 6-18

RAW value, PLS 2-16

VARCHAR2 value, PLS 2-19

Maximum size of property value exceeded - error, ADQ D-10

maximum value conflict resolution method, REP 5-18

Maximum Wait Each Attempt field, NET 6-63

MAXIMUM_CONNECT_DATA parameter, NET C-73

MAXIMUM_RELAYS parameter, NET C-73

MAXINSTANCES clause, PSA 3-3

changing, PSA 3-9

MAXINSTANCES option, PSC 7-21

MAXINSTANCES parameter, PSA 3-9, PSC 7-23

assigning free lists to instances, PSC 7-20, PSC 7-23

changing, SAD 5-5

of CREATE CONTROLFILE, SQL 7-266

OF CREATE DATABASE, SQL 7-270

MAXLITERAL, PCO B-3

default value for, PC_ 2-13

MAXLITERAL precompiler option, PC_ 10-29, PCO 14-28

MAXLOGFILES clause, PSA 3-3, PSA 3-9

MAXLOGFILES option

CREATE DATABASE statement, SAD 6-10

MAXLOGFILES parameter, PSA 3-9

changing, SAD 5-5

of CREATE CONTROLFILE, SQL 7-265

OF CREATE DATABASE, SQL 7-270

MAXLOGHISTORY clause, PSA 3-3, PSA 13-7

changing, PSA 3-9

CREATE CONTROLFILE, PSA 13-7

log history, PSA 13-7

MAXLOGHISTORY option, PSC 7-5

MAXLOGHISTORY parameter, PSA 3-9

changing, SAD 5-5

of CREATE CONTROLFILE, SQL 7-265

OF CREATE DATABASE, SQL 7-270

MAXLOGMEMBERS

clause, PSA 3-3, PSA 3-9

MAXLOGMEMBERS clause, PSA 3-3

MAXLOGMEMBERS parameter, PSA 3-9

changing, SAD 5-5

CREATE DATABASE statement, SAD 6-10

of CREATE CONTROLFILE, SQL 7-265

OF CREATE DATABASE, SQL 7-270

MAXOPENCURSORS

precompiler option

effect on performance, PC_ C-10

for multiple cursors, PC_ 6-13

specifying for separate precompilation, PC_ 2-16

what it affects, PC_ C-7

MAXOPENCURSORS clause, STU 19-10

MAXOPENCURSORS option, PCO D-7

using for separate precompilation, PCO 2-27

MAXOPENCURSORS precompiler option, PC_ 10-30, PCO 14-29

MAXOPENFILES parameter

tuning backups, STU 20-63

MAXSIZE clause

of ALTER DATABASE, SQL 7-10

of CREATE DATABASE, SQL 7-268

of CREATE TABLESPACE, SQL 7-420

of CREATE TEMPORARY TABLESPACE, SQL 7-424

MAXTRANS option, ADG 2-6

MAXTRANS parameter

of ALTER CLUSTER, SQL 7-4

of ALTER INDEX, SQL 7-31, SQL 7-36

of ALTER MATERIALIZED VIEW, SQL 7-49

of ALTER MATERIALIZED VIEW LOG, SQL 7-58

of CREATE CLUSTER, SQL 7-256

of CREATE INDEX. See CREATE TABLE

of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG. See CREATE TABLE

of CREATE MATERIALIZED VIEW/SNAPSHOT. See CREATE TABLE

of CREATE TABLE, SQL 7-394

MAXTRANS storage parameter

altering, SAD 13-12

guidelines for setting, SAD 12-7

MAXVALUE

partitioned tables and indexes, SCN 11-20

MAXVALUE clause

of CREATE SEQUENCE, SQL 7-373

MAXVALUE parameter

of ALTER SEQUENCE. See CREATE SEQUENCE

MD5 algorithm, OAS 1-5

used by the Biometric Authentication Service, OAS 8-2

MD5 message digest algorithm, OAS 2-5

MDN parameter, NET B-3

MDO. See method descriptor object

MDS. See Master Definition Site (MDS)

mean time between failures

definition of, PSC 9-2

mean time to recover

definition of, PSC 9-2

measures, DWG 8-7, DWG 16-2

media failure, PSA 14-7, PSC A-24, SCN 1-45, SCN 345

access to files, PSC 7-2

archived redo log file loss, SBR 6-11

automatic recovery, PSA 13-8

complete recovery, SBR 5-19 to SBR 5-25

control file loss, SBR 6-12, SBR 6-13

datafile loss, SBR 6-2

definition, SBR 1-13

description, SBR 6-2

disk controller, SBR 6-2

NOARCHIVELOG mode, SBR 5-15

online redo log group loss, SBR 6-7

online redo log loss, SBR 6-5

online redo log member loss, SBR 6-5

permanent, SBR 6-2

recovery, PSC A-24, SBR 5-19 to SBR 5-31

distributed databases, SBR 6-16

recovery procedures

examples, SBR 6-2

understanding types, SBR 6-2

media index, LEG 2-5

Pending Messages Window

recovery waiting for tape volume name, LEG 3-21

waiting for backup tape, LEG 3-21

removing storage volumes, LEG 3-20

volume labels, LEG 3-21

media index directory

contents, UNIX, LEG 5-12

contents, Windows NT, LEG 5-20

media management

auto enabled, behavior, LEG 3-19

auto for tape devices, LEG 3-19

auto not enabled, LEG 3-19, LEG 3-23

automatic for tape devices, LEG 3-19

backing up files, RMN 1-20

Backup Solutions Program, RMN 1-23

Legato Storage Manager (LSM), RMN 1-23

changing the volume modes, LEG 3-20

crosschecking, RMN 1-21

device configuration on UNIX

adding a device resource, LEG 3-7

modifying a device resource, LEG 3-8

overview, LEG 3-7

removing a device resource, LEG 3-8

device configuration on Windows NT

adding a device resource, LEG 3-9

moving a device resource, LEG 3-10

overview, LEG 3-8

removing a device resource, LEG 3-10

device resources, LEG 3-2

error codes, RMN 9-4

labeling a volume

on UNIX, LEG 3-14

on Windows, LEG 3-15, LEG 3-16

labeling and mounting volumes, LEG 3-13

linking to software, RMN 2-20

maximum file size, RMN 2-21

mounting a volume

on UNIX, LEG 3-16

on Windows, LEG 3-17

proxy copy, RMN 1-22

relinking to the API, RMN 9-21

requirements, RMN 2-20

restoring files, RMN 1-21

sbttest program, RMN 1-23, RMN 9-10

sending device-specific strings, RMN 2-22

storage devices, LEG 3-2, LEG 3-4, LEG 3-6, LEG 3-7

testing the API, RMN 9-10

troubleshooting, RMN 2-22

unique filenames, generating, RMN 2-21

unlabeled volumes, LEG 3-19

unmounting a volume

on UNIX, LEG 3-18

on Windows, LEG 3-18

viewing

details of save sets on volume, LEG 3-21

inventory of backup volumes, LEG 3-20

volume-specific information, LEG 3-21

volume pools

default attributes, LEG 3-12

default resource attributes, LEG 3-12

label templates, LEG 3-10, LEG 3-11, LEG 3-12

Media Management API

version 2.0, GTK 3-53

Media Management Library (MML), RMN 1-20

Media Management Library (MML), Oracle8, LEG 1-11

media protection

disabling for direct path loads

SQL*Loader, SUT 8-19

media recoveries, DWG 18-52

media recovery, PSA 14-7, SBR 5-1 to SBR 5-38

ADD DATAFILE operation, SBR 6-3

after control file damage, SBR 6-13

after OPEN RESETLOGS operation, SBR 5-36

applying archived redo logs, SBR 5-9

cancel-based, SBR 3-16, SBR 5-22, SBR 5-25, SBR 5-28

change-based, SBR 3-16, SBR 5-25, SBR 5-30

complete, SBR 1-24, SBR 3-16, SBR 5-19 to SBR 5-25

completion of, SBR 5-22, SBR 5-24

datafiles

guidelines for, RMN 1-61, RMN 6-18

without backup, SBR 5-5

deciding which files need recovery, SBR 5-2

direct path load, SUT 8-14

SQL*Loader, SUT 8-14

disabling, SQL 7-17

distributed databases, SBR 6-16

coordinated time-based, SBR 6-17

effects of archiving on, SAD 7-4

error messages, SBR 5-14

errors with redo log files, SBR 5-14

incomplete, PSA 14-8, SBR 3-16, SBR 5-25

definition, SBR 1-25

interrupting, SBR 5-14

log history, PSA 3-3, PSA 13-8, PSA 14-8

log sequence recovery, SBR 3-16

lost files

lost archived redo log files, SBR 6-11

lost control files, SBR 6-12

lost datafiles, SBR 6-2

lost mirrored control files, SBR 6-12

methods

choosing, SBR 3-19

NOARCHIVELOG mode, SBR 5-15

of database, SQL 7-12

of datafiles, SQL 7-12

of standby database, SQL 7-12

of tablespaces, SQL 7-12

offline tablespaces in open database, SBR 5-22

online redo log files, SBR 6-5

opening database after, SBR 5-34

O/S utilities, PSA 14-8

overview, SBR 1-24

parallelizing, SQL 7-15

restarting, SBR 5-14

restoring

archived redo log files, SBR 5-6

damaged files, SBR 5-4

whole database backups, SBR 5-15

restrictions, SQL 7-13

resuming after interruption, SBR 5-14

roll forward phase, SBR 5-9

See also recovery

snapshots, SBR 6-18

successfully applied redo logs, SBR 5-14

sustained standby recovery, SQL 7-14

SYSTEM tablespace, SBR 5-22

time-based, SBR 5-25

transportable tablespaces, SBR 6-4

types

distributed databases, SBR 6-16

undamaged tablespaces online, SBR 5-22

unsuccessfully applied redo logs, SBR 5-14

using Import utility, SBR 4-20

using Recovery Manager, RMN 1-61, RMN 6-18

member

MAXLOGMEMBERS, PSA 3-3

member attribute, OID 7-20

MEMBER clause

of ALTER TYPE, SQL 7-188

of CREATE TYPE, SQL 7-441

of CREATE TYPE BODY, SQL 7-448

member method, DCI 3-2, DCI 5-2

Member, multiple-valued attribute, OID 7-20

membership conditions, SQL 5-17

membership test, PLS 2-47

memory

allocation for SQL statements, SCN 7-11

amount used for sorting, SRF 1-112

cache, PSC 1-4

cached data, PSC 1-4

configure at 2 levels, DWG 18-17

content of, SCN 7-2

controlling SQL*Loader use, SUT 5-24

cursors (statement handles), SCN 1-15

DLM requirements, PSC 5-34

extended buffer cache (32-bit), SCN 7-14

in capacity planning, OID 12-2

insufficient, OID 13-8, STU 16-5

overview of structures in, SCN 1-12

physical, OID 12-13

process classification, DWG 18-35

processes use of, SCN 8-2

reducing usage, STU 19-42

requirements, OID 12-13

scalability, ADG 9-70

SGA, PSC 8-14

shared SQL areas, SCN 7-8

software code areas, SCN 7-18

sort areas, SCN 7-17

stored procedures, SCN 51, SCN 60

structures in, SCN 7-2

system global area (SGA)

allocation in, SCN 7-2

initialization parameters, SCN 7-13, SCN 7-14

locking into physical memory, SCN 7-14, SCN 7-18

SGA size, SCN 7-13

starting address, SCN 7-14

tuning, OID 13-7, STU 2-11

viewing per user, SAD 22-29

virtual, OID 12-13, DWG 18-18, SCN 7-18, SRF 1-11

See also system global area

memory access, PSC 2-2

memory allocation

buffer caches, STU 19-31

importance, STU 19-2

library cache, STU 19-16

shared SQL areas, STU 19-16

sort areas, STU 20-35

tuning, STU 19-2, STU 19-42

users, STU 19-6

memory requirements

concurrent access, MIG 3-17

migration, MIG 3-15, MIG 4-6, MIG 5-4

memory-mapped IPCs

how used in Oracle Parallel Server, PSC 2-4

menu bar, Oracle Directory Manager, OID 4-10

MERGE hint, SQL 2-67, STU 7-31

MERGE PARTITIONS clause, SAD 15-21

of ALTER TABLE, SQL 7-162

MERGE_AJ hint, SQL 2-65, STU 4-61, STU 7-22, STU 7-23

MERGE_SJ hint, SQL 2-65, STU 4-62, STU 7-23

merging complex views, STU 4-78

merging partitions, SCN 11-14

merging views into statements, STU 4-76

message

ALERT file, PSC 7-2

distributed lock manager, PSC 5-22

Message Enqueuing, ADQ 11-5

message files

naming conventions, DCI 2-6

Message Grouping, ADQ 8-52, ADQ 12-66

message grouping, ADQ 1-11

Message History, ADQ 8-24

Message History and Retention, ADQ 12-16

Message is not defined to contain (string) - error, ADQ D-11

Message must be specified - error, ADQ D-6

Message Navigation in Dequeue, ADQ 8-65

Message Navigation in Receive, ADQ 12-74

Message not Readable - error, ADQ D-10

Message not Writeable - error, ADQ D-10

Message Ordering, ADQ 8-38

Message Payload must be specified, ADQ D-2

Message Producer Features, ADQ 12-57

Message Propagation, ADQ 4-7, ADQ 7-15

message properties, specification, ADQ 2-3

message queuing, SCN 66

exporting queue tables, SCN 79

messages, SCN 70

publish-subscribe support

event publication, SCN 99

publish/subscribe support, SCN 77

queue monitor process, SCN 1-19, SCN 8-14, SCN 72

interval statistics, SCN 78

window of execution, SCN 73

queue tables, SCN 70

recipients, SCN 71

rule-based subscriptions, SCN 72

subscription lists, SCN 71

remote databases, SCN 76

message rate, STU 16-7

message recipients, definition, ADQ 7-6

message stacks, SMS 1-3

message text, PCO 8-9

message_grouping, ADQ 2-5

MessageFormat Exception

(string) - error, ADQ D-10

messages

access to files, PSA 14-4, PSC 7-2

ALERT file, PSA 14-4

display on UNIX, LEG 4-12

error, NLS A-4

trapping, DDS 3-12

Export, SUT 1-40

Import, SUT 2-44

instance shutdown, PSA 4-5

logs on Windows NT, LEG 4-12

logs UNIX, LEG 4-12

producers and consumers, ADQ 1-17

translated, NLS A-4

Messages in Queue Table, Selecting, ADQ 10-21

Messages of type (string) not allowed with Destinations containing payload of type {1} - error, ADQ D-2

messages, definition, ADQ 1-17

Messages, Error, ADQ xi, ADQ D-1

Messages, Fanning-Out, ADQ 7-15

Messages, Funneling-in, ADQ 7-15

Messaging Systems, ADQ 1-2

meta-attributes

of objects, OCI 10-17

of persistent objects, OCI 10-17

of transient objects, OCI 10-20

metadata, PC_ 18-16

index, DCI 11-37

managing RMAN, RMN 1-13, RMN 3-1, RMN 7-1

storing in control file, RMN 1-17

metadata, stored in schema, OID 2-10

method, DCI 1-8, DCI 1-15, DCI 11-2

applying, STU 2-14

constructor, DCI 3-4

implementing, DCI 5-2

invoking, DCI 5-4

map, DCI 3-5

member, DCI 3-2, DCI 5-2

order, DCI 3-5

referencing attributes, DCI 5-5

tuning, STU 2-1

tuning steps, STU 2-5

method calls, chaining, PLS 9-26

method descriptor object, OCI 11-23

METHOD parameter, NET 8-13, NET C-44, PSG 5-3

methods, ADO 1-3

choosing a language for, ADO 6-26

collection, PLS 4-21

comparison, ADO 9-20

comparison methods, ADO 1-4, SCN 13-7

constructor methods, ADO 1-4, SCN 13-6

literal invocation, ADO 2-3

COUNT, PLS 4-22

DELETE, PLS 4-26, PLS 11-20

EXISTS, PLS 4-22

EXTEND, PLS 4-24

FIRST, PLS 4-23

function-based indexes, ADO 6-30

LAST, PLS 4-23

LIMIT, PLS 4-22

map, ADO 6-7, ADO 9-17, PLS 9-10

NEXT, PLS 4-23

object, PLS 9-3, PLS 9-8

of object types, ADO 1-3, ADO 9-21

constructor methods, ADO 7-2

execution privilege for, ADO 2-11

map methods, ADO 1-5

order methods, ADO 1-5

PL/SQL, ADO 3-2

selfish style of invocation, ADO 1-4

use of empty parentheses with, ADO 2-8

order, ADO 6-7, ADO 9-17, ADO 9-23, PLS 9-10

PRIOR, PLS 4-23

privileges on, SCN 314

static, ADO 6-28

TRIM, PLS 4-25

methods of collections

constructor methods, SCN 1-56

methods of object types, SCN 1-56, SCN 13-4

constructor methods, SCN 1-56

map methods, SCN 1-56, SCN 13-7

order methods, SCN 1-56, SCN 13-7

PL/SQL, SCN 13-14

purchase order example, SCN 13-2, SCN 13-5

selfish style of invocation, SCN 13-6

MI date format element, SQL 2-46

MI number format element, SQL 2-41

MIB, STU 11-5

micro precompiler options, PC_ 10-5

Microsoft Transaction Server integration, GTK 3-87

Microsoft's Active Directory, NET 2-39

middle tier systems, ADG 11-42, ADG 11-64, ADG 11-65, ADG 11-66

migprep utility

running, MIG 4-18

MIGRATE user

avoid, MIG 4-10, MIG 5-9

MIGRATE.BSQ script, MIG 4-25

migrated rows, STU 20-31

listing, SQL 7-207

migrated tablespaces

correcting transient segments, MIG 13-7, MIG 13-11

removing migrated tablespaces, MIG 13-6, MIG 13-10

migrating

Oracle Parallel Server issues, PSG 3-21

single instance to Oracle Parallel Server, PSG 9-2 to PSG 9-7

migrating data across partitions, SUT 2-32

migration, ADL 1-5

7.x to 8.0, OCI 1-22

abandoning, MIG 4-35, MIG 5-23

after migrating, MIG 8-1, MIG 8-12

ALTER DATABASE CONVERT statement, MIG 4-4, MIG 4-32

re-running, MIG A-19

ALTER DATABASE OPEN RESETLOGS statement, MIG 4-4, MIG 4-32

AUDIT_TRAIL initialization parameter, MIG A-3

avoiding common problems, MIG 3-19

backup strategy, MIG 3-21

block size minimums, MIG 4-6, MIG 5-5

character set, MIG 4-8, MIG 5-6

choosing a method, MIG 3-3

control files, MIG 4-25, MIG 7-17, MIG 13-58

copying data, MIG 3-14

data migration, PSC B-2

database migration, SAD 2-4

definition, MIG 1-3

error message codes, PC_ A-6, PCO A-8

exclusive password file, MIG A-17

Export/Import, MIG 3-10

steps, MIG 6-2

features requiring, MIG G-13

include files, PC_ 5-36

incremental, MIG G-5

initialization parameters, MIG 4-29, MIG 5-11, MIG B-1

listener.ora file, MIG 8-6

master sites, MIG G-3

memory requirements, MIG 3-15, MIG 4-6, MIG 5-4

methods

choosing, MIG 3-3

migprep utility, MIG 4-18

MIGRATE user, avoid, MIG 4-10, MIG 5-9

MIGRATE.BSQ script, MIG 4-25

Migration utility, MIG 3-6

NCHAR and NLS, MIG 9-28

new administrative procedures, MIG 8-8

obsolete replication procedures, MIG G-14

offline datafiles, MIG 4-4

offline tablespaces, MIG 4-10, MIG 5-8

OPTIMAL setting for SYSTEM rollback segment, MIG A-4

Oracle Data Migration Assistant, MIG 3-8

Oracle Parallel Server, MIG 4-7

rolling upgrade, MIG 1-13

ORADIM, MIG 4-24, MIG 7-16

OUTLN user, avoid, MIG 4-10, MIG 5-9

overview for replication, MIG G-2

overview of steps, MIG 2-2

parallel execution, MIG 8-5

post migration, MIG 8-1, MIG 8-12

post-migration actions, MIG 8-1, MIG 11-1, SPR 6-1, SPR 23-1

prepare the Oracle7 source database, MIG 4-9, MIG 5-7

Windows platforms, MIG 4-12, MIG 5-12

preparing to migrate, MIG 3-2

read-only tablespaces, MIG 4-4

replication, MIG 4-7

returning to exclusive mode, PSA 8-9

role of application developer, MIG 2-7

role of database administrator, MIG 2-7

rollback segments, MIG 4-4

ROWID format, ADG 3-23

rowids, MIG 12-1

FAQ, MIG 12-7

scripts, SRF 5-7

CATALOG.SQL, MIG 4-4, MIG 4-33

CATPARR.SQL, MIG 4-33

CATPROC.SQL, MIG 4-4, MIG 4-33

CATREP.SQL, MIG 4-33, MIG 5-20

errors while running, MIG 1-11

R0703040.SQL, MIG 4-33, MIG 5-20

rerunning, MIG 4-33, MIG 5-21

U0703040.SQL, MIG 4-32

UTLRP.SQL, MIG 4-33, MIG 5-21

session, OCI 8-12, OCI 15-106

snapshot sites, MIG G-6

space requirements, MIG 3-15, MIG 4-6, MIG 5-4

SQL*Net requirement

Windows platforms, MIG 4-12, MIG 5-12

standby database, MIG 8-6

system requirements, MIG 3-15

SYSTEM tablespace, MIG A-2

temporary tablespace, MIG A-2

terminology, MIG 1-2

testing, MIG 3-21

testing results, MIG 8-13

troubleshooting, MIG A-1

ALTER DATABASE CONVERT statement, MIG A-16

AUDIT_TRAIL initialization parameter, MIG A-3

database name mismatch, MIG A-18

datafile version integrity, MIG A-19

Migration utility error messages, MIG A-5

missing convert file, MIG A-17

MULTIPLIER option, MIG A-4

NOMOUNT database start mode, MIG A-16

OPTIMAL setting, MIG A-4

Oracle7 control file, MIG A-16

password file, MIG A-17

running the Migration utility, MIG A-2

running the Oracle Data Migration Assistant, MIG A-2

scripts run long, MIG A-20

SYSTEM tablespace, MIG A-2

temporary tablespace, MIG A-2

tuning after, MIG 8-14

upgrading to primary key snapshots, MIG G-11

using import and export, MIG G-10

Migration Assistant. See Oracle Data Migration Assistant

migration from earlier releases, PC_ A-6, PCO A-9

Migration utility

advantages and disadvantages, MIG 3-6

character set used, MIG 4-8

command-line options, MIG 4-17

differences from the Oracle Data Migration Assistant, MIG 3-9

documentation roadmap, MIG 4-2

errors and messages, MIG A-5

migrating to a different operating system, MIG 4-8

MULTIPLIER option, MIG A-4

options

CHECK_ONLY, MIG 4-17, MIG 4-21

DBNAME, MIG 4-17

MULTIPLIER, MIG 4-17

NEW_DBNAME, MIG 4-17

NLS_NCHAR, MIG 4-17

NO_SPACE_CHECK, MIG 4-17

PFILE, MIG 4-17

SPOOL, MIG 4-17

overview, MIG 4-3

privileges required, MIG 4-19

running, MIG 4-21

on UNIX, MIG 4-21

on Windows platforms, MIG 4-23

space required for SYSTEM tablespace, MIG 4-6

SYSTEM tablespace, MIG 3-6

using, MIG 4-19

migration utility, GTK 4-14

MIN aggregate function, PLS 5-3

min communication, REP 2-38

conflict resolution, REP 5-26

MIN function, SQL 4-52

MINEXTENTS parameter

of STORAGE clause, SQL 7-607

MINEXTENTS storage parameter

altering, SAD 13-12

automatic allocations, PSA 8-11, PSA 8-12, PSC 7-25

cannot alter, SAD 12-13

deallocating unused space, SAD 12-15

default, PSA 8-11

description, SAD 12-10

rollback segments, SAD 11-5, SAD 11-8

Minimal installation type, PSG 3-2

MINIMIZE RECORDS PER BLOCK clause

of ALTER TABLE, SQL 7-153

MINIMUM EXTENT clause

of ALTER TABLESPACE, SQL 7-180

of CREATE TABLESPACE, SQL 7-421

MINIMUM EXTENT parameter, SCN 190

minimum value conflict resolution method, REP 5-20

MINUS operator

compound queries, STU 4-48

optimizing view queries, STU 4-77

MINUS set operator, PLS 5-6, SQL 3-13, SQL 7-579

MINVALUE

of ALTER SEQUENCE. See CREATE SEQUENCE

MINVALUE clause

of CREATE SEQUENCE, SQL 7-373

mirrored control files, SAD 5-3

mirrored files, SBR 2-8

control files, SBR 2-8

loss of, SBR 6-12

online redo log, SAD 6-6, SBR 2-13

location, SAD 6-9

loss of, SBR 6-5

size, SAD 6-9

splitting, SBR 4-9

suspend/resume mode, SBR 4-9

using RMAN, RMN 5-12

mirroring

backups using, RMN 5-12

compared to multiplexing, SBR 2-6

control files, SAD 2-21, SBR 1-7

disks, DWG 4-8

redo logs, STU 20-21

miscellaneous functions, OCI 15-221

missing data columns

SQL*Loader, SUT 5-43

MISSING datafiles, SAD 5-8

MIXED - oracle.xml.parser.v2.ElementDecl.MIXED, JPR 4-33

mixed notation, PLS 7-13

MM

API

Oracle8, LEG 1-11

MM date format element, SQL 2-46

mobile computing environment

materialized views, SCN 10-18

MOD, SMS 34-1

MOD function, SQL 4-53

MODE

equivalent values, PCO 14-30

precompiler option

effect on OPEN, PC_ 6-13

mode

archiving, PSA 3-2, PSA 3-8, PSA 13-3, PSC 1-5

MODE clause

of LOCK TABLE, SQL 7-548

MODE interaction with DBMS, PC_ 10-17

MODE option

effects of, PCO 4-29

MODE parameter, NET B-3

MODE precompiler option, PC_ 10-31, PCO 14-30

mode, parameter, PCO 6-5

Modeling and Design, ADQ x, ADQ 7-1

Modeling Queue Entities, ADQ 7-2

modes

archive log, SCN 358

ARCHIVELOG, SBR 1-11

archiving, SRF 1-61

choosing between ARCHIVELOG and NOARCHIVELOG, SBR 2-17

full database

Export, SUT 1-21, SUT 1-28

incompatible, PSC 5-27

lock compatibility, PSC 5-26

NOARCHIVELOG, SBR 1-11

recovery from failure, SBR 5-15

objects exported by each, SUT 1-5

of parameters, ADG 9-6

PCM lock, PSC 4-12

PCM locks, PSC 4-12

setting archiving, SBR 2-20

table

Export, SUT 1-25, SUT 1-32

table lock, SCN 232

two-task, SCN 8-3

user

Export, SUT 1-22, SUT 1-31

Modes of Dequeuing, ADQ 8-69

modes, parameter, PC_ 7-3

IN, PLS 7-14

IN OUT, PLS 7-16

OUT, PLS 7-14

modifiable join view

definition of, ADG 2-21

modified data

instance recovery, PSA 14-3

MODIFY clause

of ALTER TABLE, SQL 7-143

MODIFY CONSTRAINT clause

of ALTER TABLE, SQL 7-144

MODIFY DEFAULT ATTRIBUTES clause, SAD 15-23, SAD 15-24

of ALTER INDEX, SQL 7-33, SQL 7-41

of ALTER TABLE, SQL 7-155

MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause, SAD 15-23

modify DN

using ldapmoddn, OID 4-14

MODIFY LOB clause

of ALTER TABLE, SQL 7-146

MODIFY LOB storage clause

of ALTER MATERIALIZED VIEW, SQL 7-48, SQL 7-51

of ALTER TABLE, SQL 7-146

MODIFY NESTED TABLE clause

of ALTER TABLE, SQL 7-145

MODIFY PARTITION clause, SAD 15-24, SAD 15-26, SAD 15-28

of ALTER INDEX, SQL 7-33, SQL 7-41

of ALTER MATERIALIZED VIEW, SQL 7-51

of ALTER TABLE, SQL 7-156

MODIFY SUBPARTITION clause, SAD 15-25

of ALTER INDEX, SQL 7-34, SQL 7-42

of ALTER TABLE, SQL 7-157

MODIFY VARRAY clause

of ALTER TABLE, SQL 7-146

modifyDN

audit log event, OID 5-27

modifying

a user entry, OID 7-24

ACI directives, by using Oracle Directory Manager, OID 9-17

ACPs, by using Oracle Directory Manager, OID 9-17

attribute syntaxes, OID 6-19

attributes

concurrently, OID 4-14

guidelines for, OID 6-18

using command line tools, OID 7-25

using ldapmodify, OID 4-14

using ldapmodifymt, OID 4-14

audit level, OID 5-29

audit log events, OID 5-27

base schema attributes, OID 6-19

configuration parameters, OID 2-32

configuration set entries, OID 2-32, OID 3-9, OID 5-2

using command line tools, OID 7-25

using ldapmodify, OID 5-14

using Oracle Directory Manager, OID 5-4, OID 5-11

content access items, OID 9-33

DNs, using command line tools, OID 7-25

entries

by using ldapmodify, OID A-11

by using Oracle Directory Manager, OID 7-22

concurrently, using ldapmodifymt, OID A-14

LDAP conventions, OID 7-22

rules, OID 7-22

garbage collection intervals in replication, OID 10-12

initsid.ora, OID 10-5

large numbers of entries, OID A-23

multiple entries, using command line tools, OID 7-25

number of worker threads in change log processing, OID 10-13

object classes, OID 6-3

in the base schema, OID 6-4

using command line tools, OID 6-17

using Oracle Directory Manager, OID 6-16

objects

by using ldapmodify, OID 4-14

by using Oracle Directory Manager, OID 4-10

Oracle wallet parameter, OID 5-10, OID F-6

parameters for an active instance, OID 8-3

parameters in an active server instance, OID 5-4

passwords, to Oracle data servers, OID 4-16

RDN, using command line tools, OID 7-25

replication agreement parameters, OID 10-15

using command line tools, OID 10-16

replication configuration parameters, by using Oracle Directory Manager, OID 10-11

SSL configuration parameters, OID 8-3

structural access items, OID 9-28

tables

without replicating changes, REP 6-17

wallet passwords, OID 5-10, OID F-6

modifying configuration set entries, OID 5-2

modifying objects

using Oracle Directory Manager, OID 4-12

modifying space for each cluster key, SQL 7-4

modularity, PLS 1-11, PLS 7-3, PLS 8-5

modulo, PSC 7-20, PSC 7-23

MON date format element, SQL 2-46, SQL 2-48

monetary

parameters, NLS 2-22

units characters, NLS 2-26

monitor

performance, SRF 1-63

MONITOR command, PSA 3-6

monitoring, STU 11-5

parallel processing, DWG 18-70

refresh, DWG 14-28

statistics for, PSA 11-2

MONITORING clause

of ALTER TABLE, SQL 7-152

of CREATE TABLE, SQL 7-408

monitoring datafiles, SAD 10-13

monitoring RMAN, RMN 9-12

monitoring standby databases, SBY 4-2

monitoring tablespaces, SAD 10-13

monitoring user actions, SCN 1-43, SCN 330

MONTH date format element, SQL 2-46, SQL 2-48

months

format element, NLS 2-17

language of names, NLS 2-17

MONTHS_BETWEEN function, SQL 4-54

More than one queue matches query - error, ADQ D-13

More than one queue table matches query (string) - error, ADQ D-11

MOST_RELAYS, NET A-94

MOUNT clause

of ALTER DATABASE, SQL 7-11

mount locks, PSA 7-19, PSC 4-8

MOUNT option

STARTUP statement, SAD 3-5, SBR 5-27, SBR 5-29

MOUNT STANDBY DATABASE clause

ALTER DATABASE statement, SBY 3-4, SBY 4-15

mounting a database, SAD 3-5

MOVE clause

of ALTER TABLE, SQL 7-144

MOVE ONLINE clause

of ALTER TABLE, SQL 7-144

MOVE PARTITION clause, SAD 15-24, SAD 15-25

of ALTER TABLE, SQL 7-157

MOVE PARTITION statement

no-logging mode, SCN 11-58, SCN 151

rules of parallelism, SCN 181

MOVE SUBPARTITION clause, SAD 15-24, SAD 15-26

of ALTER TABLE, SQL 7-158

moving

entries, OID 7-25

subtrees, OID 7-25

moving control files, SAD 5-5

MPP

disk affinity, DWG 4-4

MPP. See massively parallel processing

mpstat utility, OID 13-2

MTBF

definition of, PSC 9-2

MTS

see multi-threaded server

MTS dispatcher request statistics, SRF 3-84

MTS. See multi-threaded server

MTS. See multi-threaded server.

MTS_CIRCUITS initialization parameter, SRF 1-68

MTS_DISPATCHERS

parameter for the multi-threaded server, PSA 1-13

MTS_DISPATCHERS initialization parameter, REP 7-5, SRF 1-68

setting initially, SAD 4-6

MTS_DISPATCHERS parameter, NET 8-29, NET 9-4, NET 9-9, PSA 1-13, PSG 4-8, STU 21-8

ADDRESS attribute, NET 9-4

CONNECTIONS attribute, NET 9-5

DISPATCHERS attribute, NET 9-5

LISTENER attribute, NET 9-5, PSG 4-8

MULTIPLEX attribute, NET 8-29, NET 9-6

of ALTER SYSTEM, SQL 7-114

POOL attribute, NET 9-6

PROTOCOL attribute, NET 8-29, NET 9-4, PSG 4-8

SERVICE attribute, NET 9-6

SESSIONS attribute, NET 9-7

setting initially, NET 9-7

TICKS attribute, NET 9-7

MTS_LISTENER_ADDRESS initialization parameter: obsolete

MTS_LISTENER_ADDRESS parameter

obsolete for 8.0.4, PSC A-7

MTS_MAX_DISPATCHERS initialization parameter, SRF 1-71

MTS_MAX_DISPATCHERS parameter, STU 21-8

MTS_MAX_SERVERS initialization parameter, SRF 1-72

MTS_MAX_SERVERS parameter, SCN 8-20, STU 21-11

artificial deadlocks and, SCN 8-21

MTS_MULTIPLE_LISTENERS initialization parameter: obsolete

MTS_MULTIPLE_LISTENERS parameter

obsolete for 8.0.4, PSC A-7

MTS_RATE_LOG_SIZE initialization parameter: obsolete

MTS_RATE_SCALE initialization parameter: obsolete

MTS_SERVERS initialization parameter, SRF 1-72

initial setting, SAD 4-7

MTS_SERVERS parameter, SCN 8-20

of ALTER SYSTEM, SQL 7-115

MTS_SERVICE initialization parameter: obsolete

MTS_SESSIONS initialization parameter, SRF 1-73

MTTR, PSC 9-5

definition of, PSC 9-2

MTTR (mean time to recover), SBR 1-7

multiblock reads, STU 20-28

multiblock writes, SCN 8-8

MULTIBLOCK_READ_COUNT parameter, DWG 14-13

multi-byte character sets, NLS 3-15, PCO 4-37

storing data, NLS 3-15

multibyte character sets

blanks with SQL*Loader, SUT 5-46

Export and Import issues, SUT 1-56, SUT 2-54

SQL*Loader, SUT 5-30

multi-byte NLS features

datatypes, PCO 2-17

with PL/SQL, PCO 4-37

multihomed hosts, NET 7-7

multi-instance database

converting application, PSG 9-3

reasons not to convert to, PSG 9-2

reasons to convert to, PSG 9-2

requirements, PSG 9-3

multi-line comments, PLS 2-10

multi-master flag, OID 10-17

toggling, OID 10-17

multi-master replication, OID 1-4, OID 2-14

and high availability, OID 14-7

multimaster replication, REP 1-5, REP 2-1, SCN 425

architecture, REP 2-11

asynchronous, REP 2-7

concepts, REP 2-2

disconnected snapshots, REP 2-5

failover, REP 2-3

load balancing, REP 2-4

security

trusted vs. untrusted, RAR A-2

security for, RAR A-2

synchronous, REP 2-7, REP 2-8

transaction propagation protection, REP 6-20

uses of, REP 2-3

multimedia

content-collection, ADL 8-2

multimedia data, GTK 4-13

multimedia datatypes, SCN 13-3

Multimedia_tab, ADL 9-1

table structure, ADL 8-5

multiple addresses, NET 8-2, NET 8-4

configuring client load balancing, NET 8-7

configuring connect-time failover, NET 8-7

configuring source routing to Oracle Connection Manager, NET 8-38

multiple archiver processes, DWG 18-56

multiple buffer pools, STU 19-32, STU 19-33, STU 19-36

multiple configuration set entries, OID 8-3

multiple CPUs

SQL*Loader, SUT 8-25

multiple entries

adding concurrently, using command line tools, OID 7-25

modifying, OID 7-25

multiple hierarchies, DWG 9-8

multiple nodes

starting from one node, PSA 1-5

multiple Oracle homes

UNIX, PSG 3-22

Windows NT, PSG 3-22

Multiple Recipients, ADQ 8-61

multiple rows

buffering, DDS 9-8

multiple server processes, OID 2-32

multiple servers

executing statement against, OCI 4-5

multiple shared mode, PSA 7-19, PSC 4-8

multiple table load

generating unique sequence numbers using SQL*Loader, SUT 5-57

SQL*Loader control file specification, SUT 5-51

multiple threads, OID A-15

in ldapaddmt, OID A-9

increasing the number of, OID A-9

multiple-column indexes

SQL*Loader, SUT 8-17

Multiple-Consumer Dequeuing of the Same Message, ADQ 7-6

multiple-process systems

number of processes, SRF 1-99

multiple-process systems (multiuser systems), SCN 8-2

multiple-table load

discontinued, SUT 5-35

multiple-valued attributes

adding values to, using ldapmodify, OID A-13

Member, OID 7-20

MULTIPLEX (MUL or MULT) attribute, NET 8-29, NET 9-6

multiplexed control files

importance of, SAD 5-3

multiplexed redo log files, PSC 7-3

example, PSC 7-4

log history, PSA 13-8

total number of files, PSA 3-3

multiplexing

archived redo logs, SAD 7-10, SBR 2-21, SBY 2-16, SBY 5-7

compared to mirroring, SBR 2-6

control files, SAD 5-3, SBR 1-7, SBR 2-6, SBR 2-7, SBR 2-8, SCN 1-48, SCN 363

datafiles with Recovery Manager, RMN 1-42

recovery and, SCN 345

redo log files, SAD 6-5, SBR 2-12, SCN 1-47

groups, SAD 6-6, SBR 2-13

used in connection concentration, NET 5-7

multiplexing during RMAN backups, LEG 4-6

multiplexing, connection, GTK 4-6

MULTIPLIER

Migration utility option, MIG 4-17, MIG A-4

Multi-Protocol Interchange, MIG F-2

Multi-Protocol Interchange, not supported with DCE, OAS 12-5

multi-protocol support, MIG F-2, MIG F-17, NET 4-8

configuring, NET 8-32

multi-purpose applications, STU 3-6

Multi-Purpose database, PSG 1-10

multithreaded applications

sample program, PC_ 11-12, PCO 12-14

user-interface features

embedded SQL statements and directives, PC_ 11-7, PCO 12-7

multithreaded command line tools

ldapaddmt, OID 4-14, OID A-9

ldapmodifymt, OID 4-14, OID A-15

multithreaded development

basic concepts, OCI 8-23

multithreaded LDAP servers, OID 1-4

multi-threaded recovery, SBR 5-12

Multi-Threaded Server, PSC 5-33

and Primary/Secondary Instance, PSC 9-18

multi-threaded server, DWG 18-35, SAD 4-3, SCN 8-16

adjusting number of dispatchers, SAD 4-8

allocating channels, RMN 10-11, RMN 10-15

allocating resources, NET 9-9

and HASH_MULTIBLOCK_IO_COUNT initialization parameter, SRF 1-44

artificial deadlocks in, SCN 8-20

configuring, PSG 3-13

configuring dispatchers, NET 9-7

configuring for use with RMAN, RMN 2-4

connection load balancing, NET 2-26, PSG 3-13

connection pooling, NET 2-12

context area size, STU 2-12

dedicated server contrasted with, NET 9-2, SCN 8-16

described, NET 2-7, SCN 8-3, SCN 8-16

dispatcher processes, SCN 1-18, SCN 8-14

dispatchers, NET 2-7, PSG 3-13

enabling and disabling, SAD 4-8

example of use, SCN 8-21

initialization parameters, NET 9-4, SAD 4-5

limiting private SQL areas, SCN 297

MTS_DISPATCHERS parameter, PSG 4-8

Net8 or SQL*Net V2 requirement, SCN 8-14, SCN 8-16

not supported with DCE, OAS 12-5

OS role management restrictions, SAD 23-22

parallel SQL execution, SCN 164

parameters for, PSA 1-13

performance issues, STU 21-5

private SQL areas, SCN 7-9

sort areas, SCN 7-17

processes needed for, SCN 8-16

reducing contention, STU 21-5

requirements for running, MIG 9-46

restricted operations in, SCN 8-21

restrictions on OS role authorization, SAD 23-9

routing session requests to, NET 2-8, NET 2-14

server processes, SCN 1-16, SCN 8-20

session information, SCN 7-15

session memory in the large pool, SCN 7-12

SESSIONS initialization parameter, SRF 1-109

setting initial number of dispatchers, SAD 4-6

setting initial number of servers, SAD 4-7

setting minimum number of servers, SAD 4-8

shared, MIG 3-17

shared and local/remote connections, MIG 3-17

shared server processes, SCN 8-15, SCN 8-20

starting, NET 9-4

system parameters, SQL 7-114

tnsnames.ora file parameters, NET 2-9

tuning, STU 21-5

tuning memory, STU 19-22

using with connection pooling, NET 9-9

using with Oracle Connection Manager, NET 4-6, NET 8-28

views, SAD 4-10

virtual circuits, NET 2-7

multi-threaded server (MTS)

BFILEs, ADL 11-12

multi-tier authentication, SAD 22-13

OCI interface, SAD 22-14

multi-tier authentication and authorization, GTK 3-78

multi-tier authorization, SAD 22-13

multi-tier environments

auditing clients, SAD 24-11

multi-tier systems, STU 3-9, STU 18-15

multi-tiered application environments, PSC 9-9

multiuser environments, SCN 1-2, SCN 8-2

multi-valued attributes, OID 2-4

converting to single-valued, OID 6-19

orclEntryLevelACI, OID 9-3

multiversion concurrency control, SCN 216

multiversion consistency model, SCN 1-30

multiversion read consistency, PSC 1-4

multiversioning, MIG 1-4

mutating errors and triggers, SCN 104

mutating tables, ADG 13-22

mutual recursion, PLS 7-42