Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X

Index: M

mailboxes : (see message buffers)

major_pkg package

(see also specific program names)

5.7.8. Working with Multiple Consumers

MAKE procedure

14.2.1. Getting Started with DBMS_REFRESH

14.2.2.1. The DBMS_REFRESH.MAKE procedure

MAKE_COLUMN_GROUP procedure

16.1.1. DBMS_REPCAT Programs

16.2.2.3. The DBMS_REPCAT.MAKE_COLUMN_GROUP procedure

MAKE_DATA_BLOCK_ADDRESS function

10.1.1. Getting Started with DBMS_UTILITY

10.1.2.16. The DBMS_UTILITY.MAKE_DATA_BLOCK_ADDRESS function

make_payment procedure : 5.7.5. Searching by Correlation Identifier

makepipe function : 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function

mark_for_sale procedure : 5.7.6. Using Time Delay and Expiration

master databases : (see master sites)

master definition site : 15.3.2.1. The DBMS_REPCAT.CREATE_MASTER_REPGROUP procedure

concepts : 15.3.5. Adding and Removing Master Sites with DBMS_REPCAT

relocating : 15.3.5.4. The DBMS_REPCAT.RELOCATE_MASTERDEF procedure

master sites

(see also master definition site; replicated and replication headings)

15.3.5.1. The DBMS_REPCAT.ADD_MASTER_DATABASE procedure

adding : 15.3.5.1. The DBMS_REPCAT.ADD_MASTER_DATABASE procedure

comments, adding or changing : 15.3.5.3. The DBMS_REPCAT.COMMENT_ON_REPSITES procedure

definition and concepts : 15.3.5. Adding and Removing Master Sites with DBMS_REPCAT

dropping replication groups and : 15.3.2.2. The DBMS_REPCAT.DROP_MASTER_REPGROUP procedure

instantiation : 15.4. DBMS_OFFLINE_OG: Performing Site Instantiation

beginning import : 15.4.2.2. The DBMS_OFFLINE_OG.BEGIN_LOAD procedure

beginning instantiation : 15.4.2.1. The DBMS_OFFLINE_OG.BEGIN_INSTANTIATION procedure

difference rectification versus : 15.5.2.2. The DBMS_RECTIFIER_DIFF.RECTIFY procedure

ending import : 15.4.2.4. The DBMS_OFFLINE_OG.END_LOAD procedure

ending instantiation : 15.4.2.3. The DBMS_OFFLINE_OG.END_INSTANTIATION procedure

process steps : 15.4.2.1. The DBMS_OFFLINE_OG.BEGIN_INSTANTIATION procedure

resuming replication activity : 15.4.2.5. The DBMS_OFFLINE_OG.RESUME_SUBSET_OF_MASTERS procedure

resynchronizing object identifiers : 15.3.8.1. The DBMS_REPCAT.REPCAT_IMPORT_CHECK procedure

remote destinations and : 17.1.1. About Remote Destinations

removing : 15.3.5.2. The DBMS_REPCAT.REMOVE_MASTER_DATABASES procedure

switching snapshot replication groups : 14.4.6.1. The DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER procedure

mastsnap.sql : 14.1.6.2. The DBMS_SNAPSHOT.UNREGISTER_SNAPSHOT procedures (Oracle8 only)

memory

cursor reuse and : 2.4.4. Minimizing Memory for Cursors

freeing user memory : 11.1.4.2. The DBMS_SESSION.FREE_UNUSED_USER_MEMORY procedure

resetting package variables and : 11.1.4.3. The DBMS_SESSION.RESET_PACKAGE procedure

measuring usage : 11.1.5.8. The memory procedure

tables and use of : 11.1.4.2. The DBMS_SESSION.FREE_UNUSED_USER_MEMORY procedure

memory procedure : 11.1.5.8. The memory procedure

message buffers

(see also DBMS_PIPE package; messages (pipes); pipes)

3.1.3.3. The DBMS_PIPE.RESET_BUFFER procedure

3.1.2.1. Memory structures

compressed data in

3.1.4.2. The DBMS_PIPE.PACK_MESSAGE_RAW procedure

3.1.7.2. Exploring DBMS_PIPE

encrypted data in : 3.1.4.2. The DBMS_PIPE.PACK_MESSAGE_RAW procedure

exception handling and

3.1.3.3. The DBMS_PIPE.RESET_BUFFER procedure

3.1.6.5. Using RESET_BUFFER

resetting

3.1.3.3. The DBMS_PIPE.RESET_BUFFER procedure

3.1.6.5. Using RESET_BUFFER

message groups

5.1.2. Enqueue Features

5.1.5. A Glossary of Terms

dequeuing and : 5.4.2.6. Dequeuing with message grouping

example of use : 5.7.7. Working with Message Groups

message identifiers

5.1.5. A Glossary of Terms

5.3.7. Enqueue Options Record Type

5.3.8. Dequeue Options Record Type

message properties record type : 5.3.6. Message Properties Record Type

message queues : (see queues)

messages (AQ)

(see also queues)

5.1. Oracle AQ Concepts

5.1.5. A Glossary of Terms

broadcasting : (see broadcasting)

browsing

5.1.3. Dequeue Features

5.3.8. Dequeue Options Record Type

example : 5.7.4. Browsing a Queue's Contents

correlation identifiers : (see correlation identifiers)

data typing : 5.1.1. General Features

dequeuing : (see dequeuing)

enqueuing : (see enqueuing)

expiration time : 5.3.6. Message Properties Record Type

funneling in : 5.1.4. Propagation Features

groups : (see message groups)

identifiers

5.1.5. A Glossary of Terms

5.3.7. Enqueue Options Record Type

5.3.8. Dequeue Options Record Type

modifying properties of (example) : 5.4.1.2. Examples

next message received : 5.3.8. Dequeue Options Record Type

object types for : 5.3.3. Queue Type Names

obtaining information about (example) : 5.4.1.2. Examples

order of in queues

5.1.2. Enqueue Features

5.5.1.2. The DBMS_AQADM.CREATE_QUEUE_TABLE procedure

priority

5.3.6. Message Properties Record Type

5.4.2.5. Dequeue navigation

propagating : (see propagating messages)

retention of : 5.1.1. General Features

rollback and : 5.1.3. Dequeue Features

scheduling processing of : 5.1.2. Enqueue Features

states of : 5.3.6. Message Properties Record Type

statistics, views for : 5.6.2.4. The GV$AQ and V$AQ dynamic statistics views

tables and : 5.1.1. General Features

waiting for : 5.3.8. Dequeue Options Record Type

messages (pipes)

(see also DBMS_PIPE package; message buffers; pipes)

3.1.7.3. The dbpipe utility package

3.1.3.1. The DBMS_PIPE.CREATE_PIPE function

buffers for : (see message buffers)

data typing : 3.1.6.1. Defining message types and encapsulating communications logic

datatype values, returning : 3.1.4.7. The DBMS_PIPE.NEXT_ITEM_TYPE function

examining : 3.1.7.3. The dbpipe utility package

forwarding to another pipe : 3.1.7.3. The dbpipe utility package

logging : 3.1.7.4. Implementing a server program

packing : 3.1.4.1. The DBMS_PIPE.PACK_MESSAGE procedure

private pipes

3.1. DBMS_PIPE: Communicating Between Sessions

3.1.3.1. The DBMS_PIPE.CREATE_PIPE function

public pipes : 3.1. DBMS_PIPE: Communicating Between Sessions

receiving : 3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function

sending : 3.1.5.1. The DBMS_PIPE.SEND_MESSAGE function

relationship to unpacking : 3.1.7.2. Exploring DBMS_PIPE

separating for specific recipients : 3.1.6.2. Separating messages

unpacking : 3.1.4.4. The DBMS_PIPE.UNPACK_MESSAGE procedure

memory required for : 3.1.7.3. The dbpipe utility package

relationship to sending : 3.1.7.2. Exploring DBMS_PIPE

Method 4 : (see dynamic SQL, Method 4)

methods for dynamic SQL : 2.2.4. Types of Dynamic SQL

mode_name function : 5.7.4. Browsing a Queue's Contents

module names : (see program names)

module procedure : 7.3.1. About the register_app Package

modules : (see programs)

msgcount function : 5.7.1. Improving AQ Ease of Use

msgdata function : 5.7.1. Improving AQ Ease of Use

multiple consumers

5.1.2. Enqueue Features

5.1.5. A Glossary of Terms

example : 5.7.8. Working with Multiple Consumers

granting access

5.2.3. Authorizing Accounts to Use Oracle AQ

5.5.1.1. The DBMS_AQADM.GRANT_TYPE_ACCESS procedure

multiple rows : (see arrays)

multiple-character substitution (%) : 5.7.5.1. Wildcarded correlation identifiers

multithreaded server environments, releasing locks and : 4.1.2.2. The DBMS_LOCK.REQUEST function

my_session package

(see also specific program names)

1.3.5.1. Examples of encapsulation packages

11.1.5.1. Adding value to DBMS_SESSION

myfile package : 1.3.6.2. Handling exceptions in Oracle Developer/2000 Release 1

myfile.spp : 1.3.6.2. Handling exceptions in Oracle Developer/2000 Release 1

mysess.sql : 11.1.5.1. Adding value to DBMS_SESSION

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.