---

M

M variable in SQLDA

how value is set, PC_ 15-11

purpose of, PC_ 15-11

macro precompiler options, PC_ 10-5

maintainability, PLS 7-3

maintaining bootstrap information, LEG 4-9

maintenance release number, SAD 1-21

MAKE_REF function, SQL 4-23

malloc()

example of using, PC_ 15-32

purpose of, PC_ 15-32

man pages, UNIX, LEG 1-12

manage snapshot site, RAR 7-5

drop site, RAR 7-9

push deferred transaction queue, RAR 7-8

using a group owner, RAR 7-5

MANAGE TABLESPACE system privilege, SQL 7-500

managed recovery

of database, SQL 7-8

MANAGED STANDBY RECOVERY clause

of ALTER DATABASE, SQL 7-14

managed targets, defined, PSC 2-4

management and use new features, REP A-3

Management Information Base (MIB), STU 12-5

management of master and snapshot groups

advanced, REP 7-2

Management Server

OMSCONFIG.PROPERTIES file, PSC 5-14

starting, PSC 5-14, PSC 6-14

Management Server, defined, PSC 2-3, PSC 5-2

managing

auditing, SAD 25-1

cluster indexes, SAD 17-1

clustered tables, SAD 17-1

clusters, SAD 17-1

indexes, SAD 16-1, SAD 16-15

jobs, SAD 8-3

object dependencies, SAD 20-23

profiles, SAD 23-17

roles, SAD 24-4

rollback segments, SAD 21-1

sequences, SAD 15-9

synonyms, SAD 15-11

tables, SAD 14-1

users, SAD 23-11

views, SAD 15-1, SAD 15-9

managing RMAN metadata, SBR 6-1

managing roles with RADIUS server, OAS 3-28

managing update conflict resolution, REP 6-16

manual archiving, SPS 21-3, SPS 21-4, SRF 1-66

dropping a redo log file, SPS 14-9

in ARCHIVELOG mode, SAD 7-10

manual bootstrap backup, LEG 4-9

manual conflict resolution

versus automatic, REP 6-7

manual locking, ADG 8 - 11, SCN 1-33, SCN 27-31

LOCK TABLE command, ADG 8 - 12

manual recovery mode, SBR 16-5

manual refresh, STU 32-6

manual refreshes, REP 3-24

manual striping, STU 26-39

many-to-many references

simple subquery snapshots, REP 3-13

many-to-one references

simple subquery snapshots, REP 3-13

MAP MEMBER clause

of ALTER TYPE, SQL 7-175

of CREATE TYPE, SQL 7-417, SQL 7-423

map method, PLS 9-10

MAP methods

specifying, SQL 7-175

map methods, ADG 16 - 19, ADG 18 - 8, DCI 3-5, SCN 1-57, SCN 13-7

mapping DCE groups

to Oracle roles, OAS 13-6

marked user session, SAD 4-17

marking

objects, OCI 13-9

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

massively parallel processing (MPP)

affinity, SCN 26-6, SCN 26-48, SCN 26-49

multiple Oracle instances, SCN 5-3

parallel SQL execution, SCN 26-2

massively parallel system, SPS 1-5, SPS 11-15, STU 26-3

application profile, SPS 3-2

disk access, SPS 3-3

hardware architecture, SPS 3-7

master and snapshot groups

advanced management of, REP 7-2

master databases, SQL 7-301

master definition sites, REP 1-4, SCN 34-5

relocating, SPR 34 - 67, RAR 8-151

master free list, SPS 11-6

master groups, REP 1-4, SCN 34-5

adding destination master sites, REP 2-31, REP 2-32

adding replication objects, REP 2-19, REP 2-24

adding sites with tables having circular dependencies, REP 2-33

adding sites with tables having self-referential constraints, REP 2-33

administration requests

deleting, REP 7-6

altering object definition, REP 2-28

applying administration requests for, REP 7-5

creating, REP 2-19

definition sites for

relocating, REP 7-3

deleting, REP 2-21

deleting master sites from, REP 2-33

destination master sites, REP 2-19

displaying destination maps for, REP 2-39

displaying generated objects, REP 2-39

executing DDL within, REP 7-2

generating replication support for changes, REP 2-35

link qualifiers, REP 2-20

listing, REP 2-38

listing objects in, REP 2-38

managing, REP 2-19

objects

generating support for, REP 2-36

propagating DDL to sites in, REP 7-2

removing replication objects, REP 2-30

resuming replication activity, REP 2-23

suspending replication activity, REP 2-22

viewing information about, REP 2-38

Master Groups folder, REP 2-38

master node, SPS 8-9

master sites, REP 1-4, SCN 34-5

adding to master groups, REP 2-31

administrator accounts, REP 2-8

creating, SPR 34 - 7, RAR 8-80

creating, for multimaster replication, REP 2-8

customizing settings, REP 2-10

default propagation characteristics, REP 2-9

deleting from master groups, REP 2-33

determining differences, REP 7-19

diagnosing problems with, REP 7-30

dropping, SPR 34 - 69, RAR 8-153

fine grained quiesce, REP A-3

incremental migration of, REP B-7

manually loading table data from, REP 2-27

master groups

managing, REP 2-19

minimizing data propagation, REP 2-37

offline instantiation, REP 8-16 to REP 8-17

propagating changes between, SPR 10 - 15, RAR 8-37

propagator accounts, REP 2-8

receiver accounts, REP 2-8

replicating data to, REP 2-27

replicating object definitions to, REP 2-26

manual, REP 2-27

scheduled links for, REP 2-12

guidelines, REP 2-14

scheduled purges for

guidelines, REP 2-17

schema creation for, REP 2-9

snapshot registration, REP A-4

master sites and migration, REP B-2

master table

columns

number restriction for simple subquery snapshots, REP 3-13

reorganizing, REP 7-25

snapshots

Import, SUT 2-51

master tables, SQL 7-301

reorganizing

methods, REP 7-26 to REP 7-28

truncating, REP 7-26

mastering, lock, SPS 8-9, SPS 19-8

matching foreign keys

full, partial, or none, SCN 28-16

materialized join views, SQL 7-315

materialized view logs, SCN 10-18, SQL 7-314

creating, SQL 7-314

logging changes to, SQL 7-56

parallelizing creation of, SQL 7-316

partition attributes

changing, SQL 7-56

partitioned, SQL 7-316

physical attributes

changing, SQL 7-55

specifying, SQL 7-315

removing from the database, SQL 7-461

required for fast refresh, SQL 7-314

saving old values in, SQL 7-57, SQL 7-316

storage characteristics

specifying, SQL 7-315

materialized views, SCN 10-17, STU 11-2, SUT 2-50, SUT 2-51

allowing update of, SQL 7-307

build methods, STU 29-5

compatibility, MIG 8-13

complete refresh, SQL 7-49, SQL 7-305

constraints on, SQL 7-226

containing only joins, STU 29-13

creating, SQL 7-301, STU 29-3

creating comments about, SQL 7-212

for data warehousing, SQL 7-301

deallocating extents, SCN 4-15

degree of parallelism, SQL 7-48, SQL 7-56

during creation, SQL 7-303

delta joins, STU 31-12

dependencies, STU 29-21

detail table of, dropping, SQL 7-460

downgrading, MIG 12-9

BUILD DEFERRED clause, MIG 12-10

FAST REFRESH mode, MIG 12-10

NEVER REFRESH mode, MIG 12-10

PREBUILT TABLE clause, MIG 12-10

REFRESH ON COMMIT mode, MIG 12-9

dropping, STU 29-17, STU 29-23

enabling and disabling query rewrite, SQL 7-307

estimating size, STU 32-20

examples, SQL 7-309, SQL 7-317

fast refresh, SQL 7-49, SQL 7-304, SQL 7-305

forced refresh, SQL 7-49

from existing tables, SQL 7-303

granting

system privileges on, SQL 7-497

index characteristics

changing, SQL 7-49

indexes that maintain, SQL 7-304

join, SQL 7-315

LOB storage characteristics of, SQL 7-48

logging changes to, SQL 7-48

materialized view logs, SCN 10-18

naming, STU 29-4

overview, SCN 1-25

partitioned, SCN 10-18, SCN 11-2

partitioning, STU 29-18

partitions of, SQL 7-48

physical and storage attributes

changing, SQL 7-48

physical attributes of, SQL 7-302

prebuilt, STU 29-4

primary key, SQL 7-306

recording values in master table, SQL 7-56

query rewrite

eligibility for, SQL 7-226

enabling and disabling, SQL 7-50

hints, STU 31-4, STU 31-21

initialization parameters, STU 31-4

matching join graphs, STU 29-6

privileges, STU 31-4

re-creating during refresh, SQL 7-49

refresh dependent, STU 32-8

refresh mode

changing, SQL 7-49

refresh options, STU 29-7

refresh time

changing, SQL 7-49

refreshing, SCN 10-18, STU 29-8

refreshing after DML on master table, SQL 7-50, SQL 7-305

refreshing all, STU 32-8

refreshing on next COMMIT, SQL 7-49, SQL 7-305

registration, STU 29-16

removing from the database, SQL 7-459

removing incompatibilities, MIG 12-9

for replication, SQL 7-301

restrictions, STU 29-6

retrieving data from, SQL 7-544

revalidating, SQL 7-51

rewrites

enabling, STU 31-4

rowid, SQL 7-306

rowid values

recording in master table, SQL 7-56

same as snapshots, SCN 1-25, SCN 34-3

saving blocks in a cache, SQL 7-48

schema design guidelines, STU 28-7

security, STU 29-22

selecting views to create, STU 29-22

single table aggregate, STU 29-12

storage characteristics of, SQL 7-302

subquery, SQL 7-307

synonyms for, SQL 7-355

uses for, STU 28-2

when to populate, SQL 7-303

materialized views. See summary management

MAX aggregate function, PLS 5-3

MAX function, SQL 4-24

max session memory statistic, STU 19-22

MAX_COMMIT_PROPAGATION_DELAY parameter, PSC 6-10, PSC 6-11, SPS 4-7, SPS 10-4, SPS 18-10, SPS 18-11, SRF 1-70

MAX_DUMP_FILE_SIZE, STU 14-4

SQL Trace parameter, STU 14-4

MAX_DUMP_FILE_SIZE parameter, SAD 4-11, SRF 1-71

of ALTER SESSION, SQL 7-84

of ALTER SYSTEM, SQL 7-105

MAX_ENABLED_ROLES parameter, SRF 1-71

default roles and, ADG 12 - 13, SAD 24-8

enabling roles and, SAD 24-8

MAX_FREELIST_BUFFERS parameter, NET C-79

MAX_ROLLBACK_SEGMENTS parameter, SRF 1-72

MAX_SORT_SIZE, SPS A-10

MAX_TRANSACTION_BRANCHES parameter, SRF 1-72

MAXDATAFILES option, SPS 14-10

MAXDATAFILES parameter

changing, SAD 5-5

of CREATE CONTROLFILE, SQL 7-247

OF CREATE DATABASE, SQL 7-252

MAXEXTENTS keyword, STU 26-66, STU 27-13

MAXEXTENTS parameter

of STORAGE clause, SQL 7-578

MAXEXTENTS storage parameter

about, SAD 12-8

automatic allocations, SPS 11-17, SPS 17-13

preallocating extents, SPS 17-15

setting for the data dictionary, SAD 20-27

MAXEXTENTS UNLIMITED storage parameter, SCN 26-40

maximizing data transfer, by adjusting SDU size, NET 3-13

maximum length

CHAR value, PLS 2-14

identifier, PLS 2-5

LONG RAW value, PLS 2-15

LONG value, PLS 2-15

NCHAR value, PLS 2-19

NVARCHAR2 value, PLS 2-20

Oracle error message, PLS 6-18

RAW value, PLS 2-15

VARCHAR2 value, PLS 2-18

Maximum Open Connections option, NET 6-39

maximum precision, PLS 2-12

Maximum Prespawned Servers option, NET 6-73

maximum size

LOB, PLS 2-21

maximum value conflict resolution method, RAR 6-5, REP 6-19

Maximum Wait Each Attempt option, NET 6-39

MAXIMUM_CONNECT_DATA parameter, NET C-79

MAXIMUM_RELAYS parameter, NET C-79

MAXINSTANCES option, SPS 11-15, SPS 14-3

changing, SPS 14-10

MAXINSTANCES parameter, SPS 11-13, SPS 23-4

assigning free lists to instances, SPS 11-13, SPS 11-15

calculating non-PCM resources, SPS 16-4

changing, SAD 5-5

conversion to multi-instance, SPS 23-4, SPS 23-6

of CREATE CONTROLFILE, SQL 7-248

OF CREATE DATABASE, SQL 7-252

MAXLITERAL, PCO B-3

default value for, PC_ 2-15

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

MAXLOGFILES option, SPS 14-4, SPS 14-10

CREATE DATABASE command, SAD 6-10

MAXLOGFILES parameter

changing, SAD 5-5

of CREATE CONTROLFILE, SQL 7-247

OF CREATE DATABASE, SQL 7-252

MAXLOGHISTORY

changing, SAD 5-5

MAXLOGHISTORY option, SPS 6-5, SPS 14-4, SPS 21-7

changing, SPS 14-10

CREATE CONTROLFILE, SPS 21-6

log history, SPS 21-6

MAXLOGHISTORY parameter, SPS 23-6

of CREATE CONTROLFILE, SQL 7-247

OF CREATE DATABASE, SQL 7-252

MAXLOGMEMBERS

option, SPS 14-4, SPS 14-10

MAXLOGMEMBERS option

CREATE DATABASE command, SAD 6-10

MAXLOGMEMBERS parameter

changing, SAD 5-5

of CREATE CONTROLFILE, SQL 7-247

OF CREATE DATABASE, SQL 7-252

MAXOPENCURSORS, STU 19-10

precompiler option

effect on performance, PC_ C-10

for multiple cursors, PC_ 6-13

specifying for separate precompilation, PC_ 2-17

what it affects, PC_ C-7

MAXOPENCURSORS option, PCO D-7

using for separate precompilation, PCO 2-28

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

MAXOPENFILES parameter

tuning backups, STU 20-53

MAXSIZE clause

of ALTER DATABASE, SQL 7-10

of CREATE DATABASE, SQL 7-250

of CREATE TABLESPACE, SQL 7-394

of CREATE TEMPORARY TABLESPACE, SQL 7-398

MAXTRANS option, ADG 3 - 6

MAXTRANS parameter

of ALTER CLUSTER, SQL 7-4

of ALTER INDEX, SQL 7-30, SQL 7-35

of ALTER MATERIALIZED VIEW, SQL 7-46

of ALTER MATERIALIZED VIEW LOG, SQL 7-54

of CREATE CLUSTER, SQL 7-238

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-370

MAXTRANS storage parameter

altering, SAD 14-11

default, SAD 12-9

guidelines for setting, SAD 12-9

transaction entries and, SAD 12-9

MAXVALUE

partitioned tables and indexes, SCN 11-20

MAXVALUE clause

of CREATE SEQUENCE, SQL 7-351

MAXVALUE parameter

of ALTER SEQUENCE. See CREATE SEQUENCE.

MD5, NET 4-31

MD5 algorithm, OAS 1-4

used by the Biometric Authentication Service, OAS 7-2

MDN parameter, NET 6-78

MDO. See method descriptor object

media failure, SCN 1-46, SCN 32-5, SPS 22-1, SPS 22-7, SPS A-22

access to files, SPS 6-2

archived redo log file loss, SBR 15-10

automatic recovery, SPS 21-7

complete recovery, SBR 14-20 to SBR 14-25

control file loss, SBR 15-11, SBR 15-13

datafile loss, SBR 15-2

definition, SBR 1-13

description, SBR 15-2

disk controller, SBR 15-2

NOARCHIVELOG mode, SBR 14-17

online redo log group loss, SBR 15-6

online redo log loss, SBR 15-5

permanent, SBR 15-2

recovery, SBR 14-20 to SBR 14-32, SPS A-22

distributed databases, SBR 15-15

recovery procedures

examples, SBR 15-2 to SBR 15-15

understanding types, SBR 15-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, SBR 4-17

Backup Solutions Program, SBR 4-20

Legato Storage Manager (LSM), SBR 4-20

changing the volume modes, LEG 3-20

crosschecking, SBR 4-18

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

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, SBR 5-19

maximum file size, SBR 5-20

mounting a volume

on UNIX, LEG 3-16

on Windows, LEG 3-17

proxy copy, SBR 4-19

requirements, SBR 5-19

restoring files, SBR 4-18

sbttest program, SBR 4-19

sending device-specific strings, SBR 5-20

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

troubleshooting, SBR 5-21

unique filenames, generating, SBR 5-19

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 2-53

Media Management Library (MML), SBR 4-17

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

media manager

requirements for creating backups, SPS 21-9

media protection

disabling for direct path loads

SQL*Loader, SUT 8-19

media recovery, SBR 14-1 to SBR 14-36, SPS 22-7, STU 26-70

ADD DATAFILE operation, SBR 15-3

after control file damage, SBR 15-12

after OPEN RESETLOGS operation, SBR 14-35

applying archived redo logs, SBR 14-10

applying redo logs during, SBR 14-10

cancel-based, SBR 3-29, SBR 14-20, SBR 14-23, SBR 14-26, SBR 14-29

change-based, SBR 3-29, SBR 14-26, SBR 14-32 to SBR 14-35

commands, SBR 14-2 to SBR 14-10

complete, SBR 1-19, SBR 3-28, SBR 14-20 to SBR 14-25

completion of, SBR 14-23, SBR 14-25

datafiles

guidelines for, SBR 4-49, SBR 9-16

without backup, SBR 14-6

deciding which files need recovery, SBR 14-3

definition, SBR 14-2

direct path load, SUT 8-14

SQL*Loader, SUT 8-14

disabling, SQL 7-17

distributed databases, SBR 15-15

coordinated time-based, SBR 15-16

dropped table, SBR 15-15

effects of archiving on, SAD 7-4, SBR 2-16

error messages, SBR 14-16

errors with redo log files, SBR 14-16

incomplete, SBR 3-28, SBR 14-26 to SBR 14-35, SPS 22-8

incomplete, definition, SBR 1-20

interrupting, SBR 14-16

log history, SPS 14-4, SPS 21-7, SPS 22-9

log sequence recovery, SBR 3-29

lost control file, SBR 15-11

lost files

lost archived redo log files, SBR 15-10

lost control files, SBR 15-11

lost datafiles, SBR 15-2

lost mirrored control files, SBR 15-12

methods

choosing, SBR 3-31

NOARCHIVELOG mode, SBR 14-17

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 14-23

online redo log files, SBR 15-5

open database-offline tablespace, SBR 14-23

opening database after, SBR 14-33

O/S utilities, SPS 22-8

overview, SBR 1-19 to SBR 1-23

parallelizing, SQL 7-14

restarting, SBR 14-16

restoring

archived redo log files, SBR 14-7

damaged files, SBR 14-6

whole database backups, SBR 14-17

restrictions, SQL 7-12

resuming after interruption, SBR 14-16

roll forward phase, SBR 14-10

rolling back, SBR 14-2

rolling forward, SBR 14-2

See Also recovery

snapshots, SBR 15-17

successfully applied redo logs, SBR 14-15

sustained standby recovery, SQL 7-14

SYSTEM tablespace, SBR 14-23

time-based, SBR 14-26

transportable tablespaces, SBR 15-4

types

distributed databases, SBR 15-15

undamaged tablespaces online, SBR 14-23

using Import utility, SBR 13-18

using Recovery Manager, SBR 4-49, SBR 9-15

media recovery enqueue, SRF B-2

member

MAXLOGMEMBERS, SPS 14-4

MEMBER clause

of ALTER TYPE, SQL 7-174

of CREATE TYPE, SQL 7-415

of CREATE TYPE BODY, SQL 7-422

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

members

altering priority for, REP 6-27

membership conditions, SQL 5-16

membership test, PLS 2-46

memory

allocation for SQL statements, SCN 7-11

amount used for sorting, SRF 1-117

cache, SPS 4-5

cached data, SPS 4-5

configure at 2 levels, STU 26-20

content of, SCN 7-2

controlling SQL*Loader use, SUT 5-24

cursors (statement handles), SCN 1-17

distributed locks, SPS 5-5

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

IDLM requirements, SPS 8-10

insufficient, STU 17-4

overview of structures in, SCN 1-14

process classification, STU 27-3

processes use of, SCN 8-2

reducing usage, STU 19-42

scalability, ADG 10 - 70

SGA, SPS 6-7

shared SQL areas, SCN 7-8

software code areas, SCN 7-17

sort areas, SCN 7-16

stored procedures, SCN 18-8, SCN 18-17

structures in, SCN 7-2

system global area (SGA)

allocation in, SCN 7-2

initialization parameters, SCN 7-12, SCN 7-13

locking into physical memory, SCN 7-13, SCN 7-17

SGA size, SCN 7-12

starting address, SCN 7-13

tuning, STU 2-10

viewing per user, SAD 23-25

virtual, SCN 7-17, SRF 1-11, STU 26-20

See also system global area

memory allocation

and MTS, STU 19-21

buffer cache, STU 19-29

importance, STU 19-1

library cache, STU 19-15

shared SQL areas, STU 19-15

sort areas, STU 20-34

tuning, STU 19-2, STU 19-41

users, STU 19-6

memory requirements

concurrent access, MIG 2-16

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

memory/user/server relationship, STU 27-2

MERGE hint, SCN 23-17, SQL 2-62, STU 7-64

MERGE PARTITIONS clause

of ALTER TABLE, SQL 7-151

MERGE_AJ hint, SCN 24-13, SQL 2-59, STU 7-49, STU 7-55, STU 7-56

MERGE_SJ hint, SCN 24-13, SQL 2-59, STU 7-56

merging complex views, SCN 23-17

merging partitions, SCN 11-16

merging views into statements, SCN 23-15

message

access to files, SPS 6-2, SPS 22-4

ALERT file, SPS 6-2, SPS 22-4

distributed lock manager, SPS 9-8

instance shutdown, SPS 18-26

parameter values, SPS 6-1

message files

naming conventions, DCI 2-6

message grouping, ADQ 1-9

message properties, specification, ADQ 3-5

message queuing, SCN 19-2

exporting queue tables, SCN 19-12

messages, SCN 19-4

publish/subscribe support, SCN 19-10

event publication, SCN 20-18

queue monitor process, SCN 1-20, SCN 8-13, SCN 19-6

interval statistics, SCN 19-11

window of execution, SCN 19-7

queue tables, SCN 19-4

recipients, SCN 19-5

rule-based subscriptions, SCN 19-5, SCN 19-6

subscription lists, SCN 19-5

remote databases, SCN 19-9

message rate, STU 17-5

message recipients, definition, ADQ 1-23

message stacks, SMS 1-3

message text, PCO 8-22

messages

display on UNIX, LEG 4-10

error, NLS A-4

trapping, DDS 4-11

Export, SUT 1-39

Import, SUT 2-47

logs on Windows NT, LEG 4-10

logs UNIX, LEG 4-10

producers and consumers, ADQ 1-15

messages, definition, ADQ 1-15

messaging

in parallel processing, SPS 1-11

messaging systems, DDS 5-3

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, SBR 6-1

Recovery Manager, SBR 4-13

storing in control file, SBR 4-15

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

applying, STU 2-12

constructor, DCI 3-4

COUNT, PLS 4-22

DELETE, PLS 4-26

EXISTS, PLS 4-22

EXTEND, PLS 4-24

FIRST, PLS 4-23

implementing, DCI 5-2

invoking, DCI 5-4

LAST, PLS 4-23

LIMIT, PLS 4-22

map, DCI 3-5, PLS 9-10

member, DCI 3-2, DCI 5-2

NEXT, PLS 4-23

object, PLS 9-3, PLS 9-8

order, DCI 3-5, PLS 9-10

PRIOR, PLS 4-23

referencing attributes, DCI 5-5

TRIM, PLS 4-25

tuning, STU 2-1

tuning steps, STU 2-4

method calls

chaining, PLS 9-26

method descriptor object, OCI 11-23

METHOD parameter, NET C-44, PSC 4-45

method, collection, PLS 4-21

methods, ADG 18 - 27

choosing a language for, ADG 18 - 27

comparison, ADG 16 - 22

comparison methods, SCN 13-6

constructor methods, SCN 13-6

literal invocation, SCN 14-4

function-based indexes, ADG 18 - 32

map, ADG 16 - 19, ADG 18 - 8

of object types, ADG 16 - 23

order, ADG 16 - 19, ADG 16 - 25, ADG 18 - 8

privileges on, SCN 30-11

static, ADG 18 - 29

methods of collections

constructor methods, SCN 1-57

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

constructor methods, SCN 1-57, SCN 14-18

execution privilege for, SCN 14-13

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

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

PL/SQL, SCN 13-14

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

selfish style of invocation, SCN 13-6

use of empty parentheses with, SCN 14-9

MI date format element, SQL 2-41

MI number format element, SQL 2-36

MIB, STU 12-5

micro precompiler options, PC_ 10-5

Microsoft Transaction Server integration, GTK 2-86

MIGRATE user

avoid, MIG 3-10, MIG 4-8

MIGRATE.BSQ script, MIG 3-19

migrated rows, STU 20-30

migrating

from Server Manager to SQL*Plus, MIG 10-1

migrating data across partitions, SUT 2-34

migrating, Oracle Parallel Server issues, PSC 3-8

migration

7.x to 8.0, OCI 1-22

abandoning, MIG 3-30, MIG 4-20

advanced replication, MIG 3-7

ALTER DATABASE CONVERT command, MIG 3-4, MIG 3-26

re-running, MIG A-19

ALTER DATABASE OPEN RESETLOGS command, MIG 3-4, MIG 3-26

AUDIT_TRAIL initialization parameter, MIG A-3

avoiding common problems, MIG 2-18

backup strategy, MIG 2-18

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

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

choosing a method, MIG 2-3

control files, MIG 3-22

copying data, MIG 2-14

data migration, SPS B-1

database migration, SAD 2-3

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

exclusive password file, MIG A-18

Export/Import, MIG 2-10

steps, MIG 5-2

features requiring, REP B-12

include files, PC_ 5-36

incremental, REP B-4

initialization parameters, MIG 3-24, MIG 4-10, MIG B-1

master sites, REP B-2

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

MIGRATE user, avoid, MIG 3-10, MIG 4-8

MIGRATE.BSQ script, MIG 3-19

Migration utility, MIG 2-6

NCHAR and NLS, MIG 8-27

new administrative procedures, MIG 6-7

obsolete procedures, REP B-13

offline datafiles, MIG 3-4

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

OPTIMAL setting for SYSTEM rollback segment, MIG A-4

Oracle Data Migration Assistant, MIG 2-8

Oracle Parallel Server, MIG 3-7

rolling upgrade, MIG 1-5

OUTLN user, avoid, MIG 3-10, MIG 4-8

overview, REP B-2

overview of steps, MIG 1-6

parallel execution, MIG 6-3

planning for future, SPS 1-15

post-migration actions, MIG 6-1, MIG 10-1

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

preparing to migrate, MIG 2-2

read-only tablespaces, MIG 3-4

returning to exclusive mode, SPS 17-11

role of application developer, MIG 1-10

role of database administrator, MIG 1-10

rollback segments, MIG 3-4

ROWID format, ADG 4 - 21

scripts

CATALOG.SQL, MIG 3-4, MIG 3-27

CATPARR.SQL, MIG 3-28

CATPROC.SQL, MIG 3-4, MIG 3-27

CATREP.SQL, MIG 3-28, MIG 4-17

errors while running, MIG 1-3

R0703040.SQL, MIG 3-28, MIG 4-17

rerunning, MIG 3-27, MIG 4-17

U0703040.SQL, MIG 3-27

UTLRP.SQL, MIG 3-28, MIG 4-18

session, OCI 8-11, OCI 15-103

snapshot sites, REP B-6

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

system requirements, MIG 2-15

SYSTEM tablespace, MIG A-2

temporary tablespace, MIG A-2

terminology, MIG 1-2

testing, MIG 2-19

testing results, MIG 6-6

troubleshooting, MIG A-1

ALTER DATABASE CONVERT command, MIG A-16

AUDIT_TRAIL initialization parameter, MIG A-3

database name mismatch, MIG A-19

datafile version integrity, MIG A-20

Migration utility error messages, MIG A-5

missing convert file, MIG A-17

MULTIPLIER option, MIG A-4

NOMOUNT database start mode, MIG A-17

OPTIMAL setting, MIG A-4

Oracle7 control file, MIG A-16

password file, MIG A-18

running the Migration utility, MIG A-2

running the Oracle Data Migration Assistant, MIG A-2

SYSTEM tablespace, MIG A-2

temporary tablespace, MIG A-2

tuning after, MIG 6-6

upgrading to primary key snapshots, REP B-10

using import and export, REP B-9

Migration Assistant. See Oracle Data Migration Assistant

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

migration scripts, SRF 5-7

Migration utility

advantages and disadvantages, MIG 2-6

character set used, MIG 3-8

command-line options, MIG 3-14

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

documentation roadmap, MIG 3-2

errors and messages, MIG A-5

migrating to a different operating system, MIG 3-7

MULTIPLIER option, MIG A-4

options

CHECK_ONLY, MIG 3-14, MIG 3-18

DBNAME, MIG 3-14

MULTIPLIER, MIG 3-14

NEW_DBNAME, MIG 3-14

NLS_NCHAR, MIG 3-14

NO_SPACE_CHECK, MIG 3-14

PFILE, MIG 3-14

SPOOL, MIG 3-14

overview, MIG 3-3

privileges required, MIG 3-16

space required for SYSTEM tablespace, MIG 3-6

SYSTEM tablespace, MIG 2-6

using, MIG 3-16

migration utility, GTK 3-14

migrations, NET 5-1 to NET 5-30

defined, NET 5-16

INTCHG.ORA file, NET 5-22

LISTENER.ORA changes, NET 5-20

modifying configuration files, NET 5-19

NAMESINI.SQL script for Oracle Names, NET 5-29

NAMESUPG.SQL script, NET 5-27

NAMESUPG.SQL script for Oracle Names, NET 5-23, NET 5-29

of software, NET 5-18

of TNSNAMES.ORA with Net8 Assistant, NET 5-11

Oracle Connection Manager, NET 5-21

Oracle Names, NET 5-23 to NET 5-30

SQLNET.ORA changes, NET 5-19

TNSNAMES.ORA changes, NET 5-19

TNSNAV.ORA file, NET 5-22

TNSNET.ORA file, NET 5-22

to Oracle Names from ROSFILES, NET 5-26

to Oracle Names v. 8 from Oracle Names with Dynamic Discovery Option, NET 5-24

to Oracle Names, using a region database, NET 5-23

verifying service name and instance name, NET 5-17

MIN aggregate function, PLS 5-3

MIN function, SQL 4-24

Min(imize) Communications setting

Edit Replication Object property sheet, REP 2-37

min_communication

examples of, REP 6-43

MINEXTENTS parameter

of STORAGE clause, SQL 7-577

MINEXTENTS storage parameter

about, SAD 12-8

altering, SAD 14-11

automatic allocations, SPS 11-17, SPS 17-13, SPS 17-14

default, SPS 17-13

Minimal install type, NET 4-21

Minimal installation type, PSC 3-2

Minimize Communication setting

Replication Manager, REP 5-11

MINIMIZE RECORDS PER BLOCK clause

of ALTER TABLE, SQL 7-143

minimizing

updates and min_communication, REP 6-43

MINIMUM EXTENT

parallel DML, SCN 25-9, SCN 25-10

MINIMUM EXTENT clause

of ALTER TABLESPACE, SQL 7-168

of CREATE TABLESPACE, SQL 7-395

MINIMUM EXTENT parameter, SCN 26-33

minimum value conflict resolution method, RAR 6-5, REP 6-19

MINUS operator, SQL 3-12, SQL 7-550

compound queries, SCN 23-4

optimizing view queries, SCN 23-16

MINUS set operator, PLS 5-6

MINVALUE

of ALTER SEQUENCE. See CREATE SEQUENCE.

MINVALUE clause

of CREATE SEQUENCE, SQL 7-351

mirrored control files

importance of, SAD 5-2

mirrored disk storage, SBR 2-9

mirrored files

control files, SBR 2-9

loss of, SBR 15-12

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

location, SAD 6-9

loss of, SBR 15-5

loss of member, SBR 15-5

size, SAD 6-9

splitting, SBR 13-9

suspend/resume mode, SBR 13-9

mirroring

compared to multiplexing, SBR 2-7

control files, SAD 2-10

disks, STU 26-44

redo log files, STU 20-21

miscellaneous functions, OCI 15-215

missing data columns

SQL*Loader, SUT 5-42

mixed notation, PLS 7-13

MLSLABEL datatype, ADG 4 - 23

MM

API

Oracle8, LEG 1-11

MM date format element, SQL 2-41

mobile computing environment

materialized views, SCN 10-17

MOD, SMS 34-1

MOD function, SQL 4-24

MODE

equivalent values, PCO 14-31

precompiler option

effect on OPEN, PC_ 6-13

mode

ARCHIVELOG, SBR 1-10

archiving, SPS 4-6, SPS 14-2, SPS 14-9, SPS 21-3

database access, SPS 4-1, SPS 18-12, SPS 18-15

full database

Export, SUT 1-20, SUT 1-27

incompatible, SPS 8-2

lock compatibility, SPS 9-11

lock element, SPS 9-20

NOARCHIVELOG, SBR 1-10

recovery from failure, SBR 14-17

objects exported by each, SUT 1-5

PCM lock, SPS 4-15

table

Export, SUT 1-24, SUT 1-31

user

Export, SUT 1-21, SUT 1-30

MODE clause

of LOCK TABLE, SQL 7-521

MODE interaction with DBMS, PC_ 10-17

mode of propagation, REP 8-9

MODE option

effects of, PCO 4-32

status variables, PCO 8-2

MODE parameter, NET 6-78

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

mode, parameter, PCO 6-5

IN, PLS 7-14

IN OUT, PLS 7-16

OUT, PLS 7-14

modes

archive log, SCN 32-18

archiving, SRF 1-66

exclusive, SAD 3-6

of parameters, ADG 10 - 6

parallel, SAD 3-6

restricted, SAD 3-4, SAD 3-8

table lock, SCN 27-22

two-task, SCN 8-3

modes, parameter, PC_ 7-3

modifiable join view

definition of, ADG 3 - 28, SAD 15-4

modified data

instance recovery, SPS 22-3

updates, SPS 5-5

MODIFY clause

of ALTER TABLE, SQL 7-133

MODIFY CONSTRAINT clause

of ALTER TABLE, SQL 7-134

MODIFY CONSTRAINT option, SCN 28-23

MODIFY DEFAULT ATTRIBUTES clause

of ALTER INDEX, SQL 7-32, SQL 7-39

of ALTER TABLE, SQL 7-145

MODIFY LOB clause

of ALTER TABLE, SQL 7-136

MODIFY LOB storage clause

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

of ALTER TABLE, SQL 7-136

MODIFY NESTED TABLE clause

of ALTER TABLE, SQL 7-136

MODIFY PARTITION clause

ALTER TABLE command, SAD 13-10

of ALTER INDEX, SQL 7-32, SQL 7-39

of ALTER MATERIALIZED VIEW, SQL 7-49

of ALTER TABLE, SQL 7-145

MODIFY SUBPARTITION clause

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

of ALTER TABLE, SQL 7-146

MODIFY VARRAY clause

of ALTER TABLE, SQL 7-136

modifying

a join view, SAD 15-4

tables

without replicating changes, REP 8-34

modifying space for each cluster key, SQL 7-4

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

modulo, SPS 11-13, SPS 11-15, SPS 17-10, SPS 17-12

MON date format element, SQL 2-41, SQL 2-43

monetary parameters, NLS 2-20

monetary units characters, NLS 2-23

monitor

performance, SRF 1-68

MONITOR command

default instance in display screen, SPS 18-19

specifying an instance, SPS 18-21

monitor, transaction processing, PCO 3-32

monitoring, STU 12-5

datafiles, SAD 10-13

locks, SAD 4-8

parallel processing, STU 26-78

performance tables, SAD 4-9

processes of an instance, SAD 4-8

rollback segments, SAD 21-6

tablespaces, SAD 10-13

MONITORING clause

of ALTER TABLE, SQL 7-142

of CREATE TABLE, SQL 7-383

monitoring user actions, SCN 1-44, SCN 31-2

month

format element, NLS 2-14

language of names, NLS 2-14

MONTH date format element, SQL 2-41, SQL 2-43

MONTHS_BETWEEN function, SQL 4-25

MOST_RELAYS, NET A-91

MOUNT clause

of ALTER DATABASE, SQL 7-11

mount lock, SPS 7-2, SPS 10-5

MOUNT option, SPS 18-13

STARTUP command, SBR 14-28, SBR 14-30

MOUNT STANDBY DATABASE option

ALTER DATABASE command, SBR 16-6, SBR 16-29

mounting a database, SAD 3-4

exclusive mode, SAD 3-6

parallel mode, SAD 3-6

MOVE clause

of ALTER TABLE, SQL 7-134

MOVE ONLINE clause

of ALTER TABLE, SQL 7-134

MOVE PARTITION clause

ALTER TABLE command, SAD 13-11

of ALTER TABLE, SQL 7-147

MOVE PARTITION command

no-logging mode, SCN 11-58, SCN 25-7

rules of parallelism, SCN 26-25

MOVE SUBPARTITION clause

of ALTER TABLE, SQL 7-147

moving

control files, SAD 5-5

index partitions, SAD 13-11

relocating, SAD 10-9

table partition, SAD 13-10

MPP

disk affinity, STU 26-39

See massively parallel processing

MPP systems, SPS 1-5

MTS, NET 9-4

large pool, STU 19-21

shared pool, STU 19-21

MTS dispatcher request statistics, SRF 3-85

MTS_DISPATCHERS parameter, NET 7-32, NET 7-49, NET 9-4, SRF 1-72, STU 21-8, STU 21-9

ADDRESS attribute, NET 7-63, NET 9-4

CONNECTIONS attribute, NET 7-49, NET 9-5

DISPATCHERS attribute, NET 7-49, NET 7-63, NET 9-5

LISTENER, NET 7-60

LISTENER attribute, NET 4-23, NET 6-66, NET 7-59, NET 7-60, NET 9-5

MULTIPLEX attribute, NET 7-32, NET 9-6

of ALTER SYSTEM, SQL 7-106

POOL attribute, NET 7-49, NET 9-6

PRESENTATION attribute, NET 7-52, NET 7-54, NET 7-57, NET 7-63, NET 9-7

PROTOCOL attribute, NET 7-32, NET 7-49, NET 7-54, NET 7-57, NET 9-4

SERVICE attribute, NET 9-7

SESSIONS attribute, NET 9-7

setting initially, NET 9-8, SAD 4-5

TICKS attribute, NET 7-49, NET 9-7

MTS_LISTENER_ADDRESS parameter, SRF 1-75

obsolete for 8.0.4, SPS A-5

MTS_MAX_DISPATCHERS parameter, SRF 1-75, STU 21-8, STU 23-3

MTS_MAX_SERVERS parameter, SCN 8-19, SRF 1-75, STU 21-12, STU 23-4

artificial deadlocks and, SCN 8-20

MTS_MULTIPLE_LISTENERS parameter, SRF 1-75

obsolete for 8.0.4, SPS A-5

MTS_RATE_LOG_SIZE parameter, SRF 1-76

MTS_RATE_SCALE parameter, SRF 1-76

MTS_SERVERS parameter, SCN 8-19, SRF 1-76, STU 23-4

of ALTER SYSTEM, SQL 7-106

setting, STU 21-13

MTS_SERVICE parameter, NET 9-7, SRF 1-76

multi-block reads, STU 20-27

multiblock writes, SCN 8-8

MULTIBLOCK_READ_COUNT parameter, STU 26-66

multi-byte character sets, NLS 3-14, PCO 4-41

blanks with SQL*Loader, SUT 5-46

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

SQL*Loader, SUT 5-30

storing data, NLS 3-14

multi-byte NLS features

datatypes, PCO 2-17

with PL/SQL, PCO 4-41

multi-instance database

converting application, SPS 23-3

definition, SPS 1-16

reasons not to convert to, SPS 23-2

reasons to convert to, SPS 23-2

requirements, SPS 23-3

multi-line comment, PLS 2-9

multimaster replication, REP 1-5, SCN 34-6

advanced options, REP 2-40 to REP 2-44

building environment, REP 2-1 to REP 2-7

example, REP 2-6

creating

master groups, REP 2-19

customizing master site settings, REP 2-10

database preparation, REP 2-7

local job queues, REP 7-14

master site creation, REP 2-8

monitoring system, REP 2-38 to REP 2-40

monitoring systems, REP 7-4 to REP 7-16

reviewing configuration settings, REP 2-10

scheduled links, REP 2-12

schema creation for, REP 2-9

security for, REP 8-18

setup wizard, REP 2-7

transaction propagation protection, REP 2-42 to REP 2-44

multimedia data, GTK 3-13

multimedia datatypes, SCN 13-3

multiple addresses, NET 7-3, NET 7-11

configuring client load balancing, NET 7-12

configuring connect-time failover, NET 7-12

multiple archiver processes, STU 26-75

multiple buffer pools, STU 19-31, STU 19-32, STU 19-35

multiple column groups

ensuring data integrity with, REP 6-7

multiple conflicts

resolution methods

for backups, REP 6-11

using, REP 6-10

using for notification, REP 6-11

multiple CPUs

SQL*Loader, SUT 8-26

multiple hierarchies, STU 30-6

multiple Oracle homes

UNIX, PSC 3-9

Windows NT, PSC 3-9

multiple rows

buffering, DDS 7-8

multiple servers

executing statement against, OCI 4-5

multiple shared mode, SPS 4-2, SPS 10-5

multiple table load

discontinued, SUT 5-34

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

SQL*Loader control file specification, SUT 5-51

multiple user handles, STU 25-23

multiple-column indexes

SQL*Loader, SUT 8-17

multiple-process systems

number of processes, SRF 1-103

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

MULTIPLEX (MUL or MULT) attribute, NET 7-32, NET 9-6

multiplexed redo log files, SPS 6-3

example, SPS 6-4

log history, SPS 21-7

total number of files, SPS 14-4

multiplexing, NET 4-30

archived redo logs, SAD 7-11, SBR 2-19, SBR 16-10

compared to mirroring, SBR 2-7

control files, SBR 2-7, SBR 2-8, SBR 2-9, SCN 1-49, SCN 32-22

datafiles with Recovery Manager, SBR 4-32

recovery and, SCN 32-5

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

groups, SAD 6-6, SBR 2-13

used in connection concentration, NET 3-11

with multi-threaded server, STU 23-1

multiplexing during RMAN backups, LEG 4-4

multiplexing, connection, GTK 3-6

MULTIPLIER

Migration utility option, MIG 3-14, MIG A-4

Multi-Protocol Interchange, NET 5-2

MultiProtocol Interchange, not supported, OAS 11-5

multi-protocol support, NET 2-49, NET 4-30, NET 5-2, NET 5-22

configuring, NET 7-35

multi-purpose applications, STU 3-5

multi-threaded (MTS) servers and shared database links, DDS 2-10

multithreaded applications

sample program, PC_ 11-12

user-interface features

embedded SQL statements and directives, PC_ 11-8

multi-threaded development

basic concepts, OCI 8-15

multi-threaded recovery, SBR 14-13

Multi-threaded Server, SPS 8-10

for connection load balancing, SPS 18-32

multi-threaded server, SCN 8-16, STU 27-3

artificial deadlocks in, SCN 8-19

benefits, STU 23-1

configuring dispatchers, SAD 4-5, STU 23-3

connection pooling, STU 23-3

context area size, STU 2-10

database startup and, SAD 3-2

dedicated server contrasted with, SAD 4-3, SCN 8-16

definition, STU 23-1

described, SCN 8-3, SCN 8-16

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

enabling and disabling, SAD 4-6

example of use, SCN 8-20

large pool, STU 19-21

limiting private SQL areas, SCN 29-18

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

not supported, OAS 11-5

OS role management restrictions, SAD 24-19

parallel SQL execution, SCN 26-8

performance issues, STU 23-8

private SQL areas, SCN 7-9

sort areas, SCN 7-16

processes needed for, SCN 8-16

reducing contention, STU 21-5

restricted operations in, SCN 8-20

restrictions on OS role authorization, SAD 24-7

server processes, SCN 1-18, SCN 8-14, SCN 8-19

session information, SCN 7-14

session memory in the large pool, SCN 7-12

setting up, STU 23-1

shared pool, STU 19-21

shared pool and, STU 19-21

shared server processes, SCN 8-14, SCN 8-19

starting, SAD 4-4

system parameters, SQL 7-105

tuning, STU 21-5, STU 23-1

tuning memory, STU 23-6

views with statistics for, STU 23-7

multithreaded server

requirements for running, MIG 8-46

shared, MIG 2-17

shared and local/remote connections, MIG 2-16

multi-threaded server

connection multiplexing, STU 23-3

multi-threaded server (MTS)

BFILEs, ADL 5-10

HASH_MULTIBLOCK_IO_COUNT, SRF 1-48

SESSIONS parameter, SRF 1-114

multi-threaded server mode, DDS 2-6

multi-threaded servers

configuring dispatchers, NET 9-8

connection load balancing, NET 2-30

connection pooling, NET 2-50

dedicated server contrasted with, NET 9-2

described, NET 2-4, NET 2-20

dispatchers, NET 2-20

initialization parameters, NET 9-4

routing session requests to, NET 2-20

starting, NET 9-4

using with connection pooling, NET 7-49

using with Oracle Connection Manager, NET 2-48, NET 7-31

with dedicated servers, NET 9-10

multi-tier authentication and authorization, GTK 2-77

multi-tier systems, STU 18-12

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

multiverison consistency model, SCN 1-31

multiversion concurrency control, SCN 27-5

multiversion read consistency, SPS 4-6

multi-versioning, MIG 8-50

mutating errors and triggers, SCN 20-22

mutating tables, ADG 13 - 22

mutual recursion, PLS 7-40

MVIEW_REWRITE_ENABLED parameter, SRF 1-103

---