---

P

P code, SCN 18-18

package, PLS 8-1, PLS 8-2

advantages, PLS 8-4

bodiless, PLS 8-6

body, PLS 8-2

initializing, PLS 8-8

private versus public objects, PLS 8-14

referencing, PLS 8-6

scope, PLS 8-5

serially reusable, PLS 5-64

specification, PLS 8-2

syntax, PLS 11-122

package bodies

creating, SQL 7-327

recompiling, SQL 7-59

re-creating, SQL 7-328

removing from the database, SQL 7-465

package body, ADG 10 - 12, DCI 5-5

PACKAGE clause

of ALTER PACKAGE, SQL 7-60

package overview, SPR 1 - 2

package specification, ADG 10 - 12, DCI 5-5

package variables

i_am_a_refresh, RAR 8-254

package, product-specific, PLS 8-16

packaged cursor, PLS 5-12

packaged procedures

dropping, SQL 7-467

packaged subprogram, PLS 1-18, PLS 7-10

calling, PLS 8-6

overloading, PLS 8-14

packages, SCN 18-4, SCN 18-11

advantages of, SCN 18-15

as program units, SCN 1-56

associating statistics with, SQL 7-196

attributes, OCI 6-8

auditing, SCN 31-8

avoiding run-time compilation, SQL 7-59

changing the declaration of, SQL 7-59

corruption, DCI 5-10

creating, ADG 10 - 14, SPR 1 - 2, SQL 7-324

DBMS_APPLICATION_INFO, GTK 2-28, STU 5-2, STU 5-3

DBMS_DEBUG, GTK 2-80

DBMS_JOB, GTK 2-63

DBMS_LOB, GTK 2-34

DBMS_LOGMNR_D.BUILD, SAD 7-28

DBMS_LOGMNR.ADD_LOGFILE, SAD 7-29

DBMS_LOGMNR.START_LOGMNR, SAD 7-30

DBMS_OLAP, GTK 2-23

DBMS_OUTPUT

example of use, ADG 10 - 3

DBMS_PROFILER, GTK 2-80

DBMS_REPAIR, GTK 2-40

DBMS_RESOURCE_MANAGER, GTK 2-49

DBMS_RESOURCE_MANAGER_PRIVS, GTK 2-49

DBMS_RLS, GTK 2-69

DBMS_SHARED_POOL, STU 10-3

DBMS_SQL, GTK 2-79

DBMS_STATS, GTK 2-27

DBMS_TRACE, GTK 2-79

DBMS_TRANSACTION, STU 9-4

DEBUG_EXTPROC, ADG 11 - 48

describing, OCI 6-2

disassociating statistics types from, SQL 7-466

DIUTIL, STU 10-4

dropping, ADG 10 - 11

dynamic SQL, SCN 16-19

examples of, SCN 18-12, SCN 30-9, SCN 30-10

executing, SCN 16-16, SCN 18-18

for locking, SCN 27-39

in PL/SQL, ADG 10 - 12, DCI 5-5

invoker rights, SQL 7-325

naming of, ADG 10 - 15

OUTLN_PKG, GTK 2-37, SCN 22-6, STU 7-30

overview of, SCN 1-26

private, SCN 18-15

privileges

divided by construct, SCN 30-9

executing, SCN 30-7, SCN 30-9

privileges for execution, ADG 10 - 53

privileges for recompiling, SAD 20-25

privileges required to create, ADG 10 - 15

privileges required to create procedures in, ADG 10 - 10, DCI 5-7

public, SCN 18-15

queuing, SCN 19-4

recompiling, SAD 20-25, SQL 7-59

redefining, SQL 7-59, SQL 7-325

referencing, SPR 1 - 5

registering with the database, STU 5-1, STU 12-7

removing from the database, SQL 7-465

serially reusable packages, ADG 10 - 70

session state and, ADG 10 - 15, SCN 21-6

shared SQL areas and, SCN 7-10

specifying schema and privileges of, SQL 7-325

STANDARD, STU 10-4

storing, SCN 18-17

supplied packages, SCN 18-16

invoker or definer rights, SCN 30-8

synonyms, ADG 10 - 56

synonyms for, SQL 7-355

UTL_COLL, GTK 2-34

UTL_REF, GTK 2-79

validity of, SCN 18-18

where documented, ADG 10 - 16, SPR 1 - 6

PACKAGES clause

of ASSOCIATE STATISTICS, SQL 7-194, SQL 7-196

packed decimal data, SUT 5-16

packet

example of trace data, NET 11-41

types of, NET 11-41

pad character

alternate mappings, NLS 4-9

padding of literal strings

SQL*Loader, SUT 5-46

page table, STU 18-4

PAGELEN

precompiler option, PC_ 10-35

PAGELEN precompiler option, PCO 14-34

pages, SCN 4-2

paging, STU 17-4, STU 18-4, STU 26-84, STU 27-5, STU 27-31

library cache, STU 19-15

rate, STU 26-20

reducing, STU 19-4

SGA, STU 19-41

subsystem, STU 27-5

paragraph names

associating with SQL statements, PCO 2-18

coding area for, PCO 2-18

PARALLEL

SQL*Loader command-line parameter, SUT 6-6

parallel ANALYZE, GTK 3-2

parallel aware optimizer, STU 11-6

parallel backup, SPS 21-12

parallel backup operations, SCN 32-16

parallel cache management, SPS 4-12

Parallel Cache Management (PCM)

defined, PSC 1-15

described, PSC 1-17

See PCM

parallel cache management lock

acquiring, SPS 4-15

conversion, SPS 9-5

definition, SPS 7-5, SPS 9-2

disowning, SPS 4-15

exclusive, SPS 4-15

how they work, SPS 9-3

implementations, SPS 7-5

minimizing number of, SPS 12-1

null, SPS 4-15

owned by instance LCK processes, SPS 9-5

owned by multiple instances, SPS 9-5

periodicity, SPS 9-8

read, SPS 4-15

relative number, SPS 7-6

releasable hashed, SPS 9-4, SPS 15-7, SPS 15-9

releasing, SPS 4-15

sequence, SPS 4-7

user control, SPS 7-6

PARALLEL clause, STU 27-22, STU 27-23

DEGREE keyword, MIG 8-35

INSTANCES keyword removed, MIG 8-35

of ALTER CLUSTER, SQL 7-3, SQL 7-5

of ALTER DATABASE, SQL 7-14

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

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

of ALTER MATERIALIZED VIEW LOG, SQL 7-55, SQL 7-56

of ALTER TABLE, SQL 7-153

of CREATE CLUSTER, SQL 7-240

of CREATE INDEX, SQL 7-286

of CREATE MATERIALIZED VIEW / SNAPSHOT, SQL 7-300

of CREATE MATERIALIZED VIEW LOG / SNAPSHOT LOG, SQL 7-314

of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-316

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-303

of CREATE TABLE, SQL 7-365, SQL 7-380

parallelization rules, SCN 26-20

RECOVER command, SBR 14-20

RECOVER statement, STU 25-14

parallel coordinator, defined, PSC 1-20

PARALLEL CREATE INDEX statement, STU 26-25

PARALLEL CREATE TABLE AS SELECT, STU 11-3

external fragmentation, STU 27-13

resources required, STU 26-25

parallel database

and parallel execution, SPS 1-21

availability, SPS 1-14

benefits, SPS 1-13

parallel DDL, SCN 26-30

extent allocation, SCN 26-33

functions, SCN 26-46

parallelism types, SCN 26-3

parallelization rules, SCN 26-20

partitioned tables and indexes, SCN 26-31

building local indexes, SCN 11-30

restrictions

LOBs, SCN 26-31

object types, SCN 26-30, SCN 26-31

parallel DELETE, SCN 26-21

parallel DML, GTK 2-46, GTK 3-4, SCN 26-35

applications, SCN 26-37

bitmap indexes, SCN 10-33

degree of parallelism, SCN 26-20, SCN 26-23

enabling PARALLEL DML, SCN 26-38

functions, SCN 26-46

lock and enqueue resources, SCN 26-42

parallelism types, SCN 26-3

parallelization rules, SCN 26-20

recovery, SCN 26-40

restrictions, SCN 26-43

object types, SCN 26-30, SCN 26-44

remote transactions, SCN 26-46

rollback segments, SCN 26-40

transaction model, SCN 26-39

parallel execution, SCN 26-2, STU 3-4

adjusting workload, STU 27-8

allocated from large pool, MIG B-9

avoiding problems with, MIG 6-3, MIG 7-34

calculating overhead, SPS 16-4

coordinator, SCN 25-3, SCN 26-6

cost-based optimization, STU 27-27

detecting performance problems, STU 27-1

execution processing, SPS 1-2, SPS 1-21, SPS 2-5

full table scans, SCN 26-5

hints, STU 7-57

index creation, STU 27-20

inter-operator parallelism, SCN 26-13

intra-operator parallelism, SCN 26-13

introduction, STU 26-2

I/O parameters, STU 26-28

limiting instances, SPS 18-27

load balancing, SPS 18-33

maximum processes, STU 27-2

of DDL statements, SQL 7-79

of DML statements, SQL 7-79

parallel server, STU 27-13

partitioned tables and indexes, SCN 26-4

plans, STU 27-30

process classification, STU 26-37, STU 26-39, STU 26-72, STU 27-4

processor affinity, SPS A-15

query servers, STU 21-14

resource parameters, STU 26-20

rewriting SQL, STU 27-18

scalability, SPS 12-2

server, SCN 25-3, SCN 26-6

index maintenance, SCN 25-8

NEXT extent size, SCN 25-9

temporary segments, SCN 25-8

solving problems, STU 27-17

space management, STU 27-12

speedup and scaleup, SPS 1-12

tuning, STU 26-1

tuning physical database layout, STU 26-36

tuning query servers, STU 21-14

under Oracle Parallel Server, SPS 1-21

understanding performance issues, STU 27-2

See also parallel SQL

parallel execution coordinator, SCN 26-6

direct-load INSERT, SCN 25-3

parallel execution servers, SCN 26-6

direct-load INSERT, SCN 25-3

index maintenance, SCN 25-8

NEXT extent size, SCN 25-9

temporary segments, SCN 25-8

PARALLEL hint, SCN 26-17, SQL 2-61, STU 7-57, STU 27-17, STU 27-22, STU 27-30

parallelization rules, SCN 26-20

UPDATE and DELETE, SCN 26-21

parallel index, STU 27-21

creation, STU 11-3

parallel index scans, GTK 3-4

parallel joins

and PQ_DISTRIBUTE hint, STU 7-58

PARALLEL keyword

SQL*Loader, SUT 8-27

parallel load, STU 11-4

example, STU 26-68

Oracle Parallel Server, STU 26-69

using, STU 26-63

parallel loads

allocating extents, SUT 6-6

PARALLEL command-line parameter, SUT 6-6

parallel mode

file operation restrictions, SPS A-17, SPS A-19, SPS B-2

instance number, SRF 1-52

of the database, SAD 3-6

recovery restrictions, SPS A-22

sequence restrictions, SPS 6-7, SPS B-3

shutdown, SPS 18-26

startup, SPS 18-9

PARALLEL option, PSC 4-10, SPS 18-13

PARALLEL parameter

obsolete for 8.0.4, SPS A-6

parallel partition-wise joins

performance considerations, STU 26-61

parallel processing

benefits, SPS 1-12

characteristics, SPS 1-4

elements of, SPS 1-6

for integrated operations, SPS 1-5

for MPPs, SPS 1-5

for SMPs, SPS 1-5

hardware architecture, SPS 3-2

implementations, SPS 3-2

messaging, SPS 1-11

misconceptions about, SPS 2-12

Oracle configurations, SPS 1-14

types of workload, SPS 1-12

when advantageous, SPS 2-7

when not advantageous, SPS 2-9

parallel processor affinity, SPS A-15

parallel propagation, REP 2-4, REP A-2

advanced replication environment, REP 2-40 to REP 2-42

dependency

tracking, REP 2-43

planning for, REP 2-40

Parallel Propagation setting

Create New Scheduled Link property sheet, REP 2-13

parallel query, GTK 3-4, SCN 26-28

automated tuning, GTK 2-27

bitmap indexes, SCN 10-33

functions, SCN 26-46

idle time, SRF 1-99

index-organized tables, SCN 26-29

maximum number of instances, SRF 1-94, SRF 1-95

maximum number of servers, SRF 1-96

minimum number of queries, SRF 1-98

object types, SCN 26-29

restrictions, SCN 26-30

OPTIMIZER_PERCENT_PARALLEL, SRF 1-89

parallelization rules, SCN 26-20

restrictions for Oracle objects, ADG 18 - 41

parallel query create server wait event, SRF A-41

parallel query dequeue wait wait event, SRF A-42

parallel query option

number of server processes, SAD 4-13

parallelizing index creation, SAD 16-5

parallelizing table creation, SAD 14-4

query servers, SAD 4-13

parallel query qref latch wait event, SRF A-42

parallel query server shutdown wait event, SRF A-43

parallel query signal server wait event, SRF A-43

parallel recovery, SBR 14-19, SCN 32-10, SCN 32-16, SPS 22-7, SPS 22-14, SPS 22-15, STU 25-14

Parallel Server, SCN 1-8

ALTER CLUSTER..ALLOCATE EXTENT, SAD 17-10

backups and, SBR 8-25

concurrency limits and, SCN 29-21

databases and instances, SCN 5-3

datafile upper bound for instances, SAD 10-3

disk affinity, SCN 26-48

distributed locks, SCN 27-20

DML locks and performance, SCN 11-47

exclusive mode

rollback segments and, SCN 4-27

file and log management locks, SCN 27-30

instance groups, SCN 26-19

isolation levels, SCN 27-11

licensed session limit and, SAD 2-13

limits on named users and, SAD 23-5

lock processes, SCN 1-20, SCN 8-13

mounting a database using, SCN 5-6

named user licensing and, SCN 29-21

named users and, SAD 2-13

own rollback segments, SAD 21-3

parallel SQL, SCN 26-1

PCM locks, SCN 27-20

read consistency, SCN 27-6

reverse key indexes, SCN 10-31

sequence numbers and, SAD 15-10

session and warning limits, SAD 23-4

shared mode

rollback segments and, SCN 4-27

specifying thread for archiving, SAD 7-11

system change numbers, SCN 8-10

system monitor process and, SCN 8-11, SCN 26-41

temporary tablespaces, SCN 3-12

threads of online redo log, SAD 6-2

V$THREAD view, SAD 6-18

parallel server, GTK 2-61 to GTK 2-63, SPS A-4, STU 3-8

cache fusion, GTK 2-61

database configuration, GTK 2-63, SPS A-4

definition, SPS 1-6

disk affinity, STU 27-16

distributed lock manager (DLM), GTK 2-62

distributed locks, ADG 8 - 11

Group Membership Services (GMS), GTK 2-62

installation, GTK 2-63, SPS A-4

instance affinity for jobs, GTK 2-63, SPS A-4

inter process communication protocol, GTK 2-62

listener load balancing, SPS A-3

OPS Assistant, GTK 2-63

Oradebug, GTK 2-62, SPS A-4

parallel execution tuning, STU 27-13

see also, OPSM

sequence numbers and, ADG 3 - 37

startup and shutdown, SPS 18-14, SPS 18-26

tuning, STU 12-12

Parallel Server Active Users by Instance chart, PSC 7-18

Parallel Server Active Users chart, PSC 7-17

Parallel Server Block Ping chart, PSC 7-6

Parallel Server Block Ping Tablespace Instance chart, PSC 7-7

Parallel Server Block Ping Tablespace Object chart, PSC 7-7

Parallel Server Data Block Ping by Instance chart, PSC 7-9

Parallel Server Data Block Ping chart, PSC 7-7

Parallel Server File I/O Rate by Instance chart, PSC 7-12

Parallel Server File I/O Rate by Object chart, PSC 7-11

Parallel Server File I/O Rate chart, PSC 7-10

Parallel Server Instances folder

in Console Navigator window, PSC 6-16

Parallel Server Lock Activity chart, PSC 7-13

Parallel Server Manager, GTK 2-62

Parallel Server Operation Results dialog box, PSC 6-24

PARALLEL SERVER parameter, SCN 5-6

parallel server parameters

FAST_START_PARALLEL_ROLLBACK, SRF 1-42

LM_LOCKS, SRF 1-56

LM_PROCS, SRF 1-57

LM_RESS, SRF 1-57

MTS_DISPATCHERS, SRF 1-72

MTS_LISTENER_ADDRESS, SRF 1-75

OPS_ADMIN_GROUP, SRF 1-85

PARALLEL_ADAPTIVE_MULTI_USER, SRF 1-93

PARALLEL_AUTOMATIC_TUNING, SRF 1-94

PARALLEL_BROADCAST_ENABLE, SRF 1-94

PARALLEL_EXECUTION_MESSAGE_SIZE, SRF 1-95

PARALLEL_INSTANCE_GROUP, SRF 1-96

PARALLEL_MAX_SERVERS, SRF 1-96

PARALLEL_MIN_PERCENT, SRF 1-97

PARALLEL_MIN_SERVERS, SRF 1-98

PARALLEL_SERVER, SRF 1-99

PARALLEL_SERVER_IDLE_TIME, SRF 1-99

PARALLEL_THREADS_PER_CPU, SRF 1-99

PARALLEL_TRANSACTION_RESOURCE_TIMEOUT, SRF 1-100

parallel server process, defined, PSC 1-20

parallel server processes

configuring for advanced replication environments, REP 2-41

Parallel Server. See Oracle Parallel Server

Parallel Server Sessions chart, PSC 7-14

Parallel Server Shutdown dialog box, PSC 6-21

Parallel Server Startup dialog box, PSC 6-18

Parallel Server Users Logged On by Instance chart, PSC 7-16

Parallel Server Users Logged On chart, PSC 7-15

parallel server views, SRF 3-2

parallel slave synchronization enqueue, SRF B-2

parallel slaves enqueue, SRF B-2

parallel SQL, SCN 26-2

allocating rows to parallel execution servers, SCN 26-11

coordinator process, SCN 26-6

direct-load INSERT, SCN 25-3

degree of parallelism, SCN 26-16

instance groups, SCN 26-19

multi-threaded server, SCN 26-8

number of parallel execution servers, SCN 26-7

operations in execution plan, SCN 26-10

optimizer, SCN 26-10

Parallel Server and, SCN 26-1

parallelization rules, SCN 26-20

server processes, SCN 26-6

direct-load INSERT, SCN 25-3, SCN 25-8

NEXT extent size, SCN 25-9

summary or rollup tables, SCN 26-31

See also parallel execution

parallel transaction recovery

changes for 8.1, SPS A-3

parallel UPDATE, SCN 26-21

PARALLEL_ADAPTIVE_MULTI_USER parameter, SRF 1-93, STU 26-7, STU 26-32

of ALTER SYSTEM, SQL 7-107

PARALLEL_AUTOMATIC_TUNING parameter, SRF 1-94, STU 26-4

PARALLEL_BROADCAST_ENABLE parameter, SRF 1-94, STU 26-24

PARALLEL_BROADCAST_ENABLED parameter, SRF 1-94

of ALTER SESSION, SQL 7-87

PARALLEL_DEFAULT_MAX_INSTANCES parameter, PSC 6-11, SRF 1-95

obsolete for 8.1, SPS A-5

PARALLEL_DEFAULT_MAX_SCANS parameter, PSC 6-11

PARALLEL_DEFAULT_MAXSCANS parameter, SPS 18-11

PARALLEL_ENABLE clause

of CREATE FUNCTION, SQL 7-270

PARALLEL_ENABLE keyword, ADG 10 - 63

PARALLEL_EXECUTION_MESSAGE_SIZE parameter, SRF 1-95, STU 26-23

PARALLEL_INDEX hint, SCN 26-17, SQL 2-61

PARALLEL_INSTANCE_GROUP parameter, SPS 18-24, SRF 1-96

of ALTER SESSION, SQL 7-87

of ALTER SYSTEM, SQL 7-107

PARALLEL_MAX_INSTANCES, initialization parameter, SPS 18-27

PARALLEL_MAX_SERVERS initialization parameter, SBR 14-20, STU 25-14, STU 26-10

PARALLEL_MAX_SERVERS initialization parameters, REP 2-42

PARALLEL_MAX_SERVERS parameter, SAD 4-13, SCN 26-8, SPS 18-28, SPS 22-15, SRF 1-96, SRF 3-3, STU 25-14, STU 26-9, STU 26-11, STU 27-6

and parallel execution, STU 26-9

calculating non-PCM resources, SPS 16-4

ensuring LM lock capacity, SPS 16-6

PARALLEL_MIN_MESSAGE_POOL parameter, SRF 1-97

PARALLEL_MIN_PERCENT parameter, SCN 26-18, SRF 1-97, STU 26-10, STU 26-19

of ALTER SESSION parameter, SQL 7-87

PARALLEL_MIN_SERVERS initialization parameters, REP 2-42

PARALLEL_MIN_SERVERS parameter, SAD 4-13, SCN 26-7, SCN 26-8, SRF 1-98, STU 26-11

PARALLEL_SERVER parameter, PSC 6-10, SPS 18-10, SPS 18-13, SPS 18-14, SPS 18-15, SRF 1-99

new for 8.0., SPS A-5

PARALLEL_SERVER_IDLE_TIME initialization parameters, REP 2-42

PARALLEL_SERVER_IDLE_TIME parameter, SAD 4-13, SRF 1-99

PARALLEL_SERVER_INSTANCES

and parallel execution, STU 26-19

PARALLEL_SERVER_INSTANCES parameter, SRF 1-99

PARALLEL_THREADS_PER_CPU parameter, SRF 1-99, STU 26-4, STU 26-8

of ALTER SYSTEM, SQL 7-107

PARALLEL_TRANSACTION_RECOVERY parameter

changes for 8.1, SPS A-3

PARALLEL_TRANSACTION_RESOURCE_TIMEOUT parameter, SRF 1-100

parallelism

degree, overriding, STU 27-17

enabling for tables and queries, STU 26-8

OPTIMIZER_PERCENT_PARALLEL, SRF 1-89

setting degree of, STU 26-7

parallelism attribute, server resource, LEG 2-25

parallelization

channels, SBR 4-26

factors affecting degree of, SBR 4-27

of backups using RMAN, SBR 4-34, SBR 8-23

RMAN backups, SBR 4-34, SBR 8-23

parallelization of aggregate distinct queries, GTK 2-26

parameter

actual versus formal, PLS 7-12

controlling PCM locks, SPS 9-13

cursor, PLS 5-8

database creation, SPS 11-15, SPS 14-3, SPS 14-4

default values, ADG 10 - 9, PLS 7-19

with stored functions, ADG 10 - 60

modes, ADG 10 - 6, PLS 7-14

obsolete, SPS A-21

SELF, PLS 9-9

storage, SPS 6-8, SPS 17-6, SPS 17-8, SPS 17-11

parameter aliasing, PLS 7-21

parameter descriptor, OCI 2-16

attributes, OCI 6-5, OCI A-24

parameter descriptor object, OCI 11-23

parameter file, SPS 18-3, STU 12-4

backing up, SPS 21-1

comments, SUT 1-13, SUT 2-29

common file, SPS 18-5, SPS 18-6, SPS 23-7

conversion to multi-instance, SPS 23-6

duplicate values, SPS 18-7

Export, SUT 1-13, SUT 1-21

identical parameters, SPS 18-7

Import, SUT 2-10, SUT 2-27

maximum size

Export, SUT 1-13

NFS access inadvisable, SPS 23-9

PFILE, SPS 18-6, SPS 18-8, SPS 23-5

remote instance, SPS 18-6, SPS 18-8, SPS 18-20

parameter files, SCN 5-4

character set of, SAD 3-14

common file, SRF 1-50

creating for database creation, SAD 2-4

editing before database creation, SAD 2-5

embedded files, SRF 1-4

embedded parameter files, SRF 1-50

example of, SCN 5-4

individual parameter names, SAD 2-9

line continuation character (), SRF 1-4

location of, SAD 3-15

minimum set of, SAD 2-9

number of, SAD 3-14

sample of, SAD 3-14

used at startup, SCN 5-5

parameter mode, PCO 6-5

parameter modes, PC_ 7-3

parameter passing

by reference, PLS 7-21

by value, PLS 7-21

in dynamic SQL, PLS 10-9

parameter passing by reference, GTK 2-79

parameters

TABLESPACES, SUT 2-29

parameters

ANALYZE, SUT 2-19

attributes, OCI 6-5

authentication, OAS B-1

Kerberos, OAS B-2

RADIUS, OAS B-4

BUFFER

Export, SUT 1-16

COMMIT

Import, SUT 2-20

COMPRESS, SUT 1-16

conflicts between export parameters, SUT 1-27

CONSTRAINTS

Export, SUT 1-18

DESTROY

Import, SUT 2-21

DIRECT

Export, SUT 1-18

encryption and checksumming, OAS 2-9

Export, SUT 1-14

FEEDBACK

Export, SUT 1-19

Import, SUT 2-22

FILE

Export, SUT 1-19

Import, SUT 2-22

FROMUSER

Import, SUT 2-23

FULL

Export, SUT 1-20

GRANTS

Export, SUT 1-20

Import, SUT 2-23

HELP

Export, SUT 1-20

Import, SUT 2-24

IGNORE

Import, SUT 2-24

in syntax diagrams, SBR 11-3

INCTYPE

Export, SUT 1-20

Import, SUT 2-25

INDEXES

Export, SUT 1-21

Import, SUT 2-25

INDEXFILE

Import, SUT 2-26

initialization, SCN 5-4

locking behavior, SCN 27-19

See also initialization parameters

listener configuration reference, NET C-50 to NET C-64

local naming configuration reference, NET C-31 to NET C-49

LOG, SUT 1-39

Export, SUT 1-21

Import, SUT 2-26

modes, OCI 15-2, OCI 18-2

National Language Support, SCN 5-5

new in CMAN.ORA file for release 8.1, NET 4-19

new in LISTENER.ORA file for release 8.1, NET 4-18

new in TNSNAMES.ORA file for release 8.1, NET 4-15 to NET 4-17

obsolete for release 8.1, NET 4-20

obsolete with Net8, NET 5-4

optional, SQL A-2

Oracle Connection Manager configuration reference, NET C-76 to NET C-80

Oracle Names servers configuration reference, NET C-65 to NET C-75

Oracle protocols, NET 6-78

OWNER

Export, SUT 1-21

PARFILE

Export, SUT 1-10, SUT 1-21

passing strings, OCI 2-31

profile configuration reference, NET C-7 to NET C-30

protocol configuration reference, NET C-81

RECORD

Export, SUT 1-23

RECORDLENGTH

Export, SUT 1-23

Import, SUT 2-27

required, SQL A-1

ROWS

Export, SUT 1-23

Import, SUT 2-27

SecurID, OAS B-3

SHOW

Import, SUT 2-28

SKIP_UNUSABLE_INDEXES

Import, SUT 2-28

STATISTICS

Export, SUT 1-23

storage, SCN 4-5, SCN 4-11

string length, OCI 15-3

TABLES

Export, SUT 1-24

Import, SUT 2-28

TOID_NOVALIDATE, SUT 2-30

TOUSER

Import, SUT 2-31

USERID

Export, SUT 1-26

Import, SUT 2-32

PARAMETERS clause

of CREATE INDEX, SQL 7-286

PARAMETERS clause with external procedure, DCI 4-9

parameters for Migration utility. See command-line options

Parameters tab

from Create Job property sheet, PSC 6-37

PARENT_ID column

PLAN_TABLE table, STU 13-4

parent/child table relationships

maintaining, DDS 4-3

parentheses, PLS 2-42

parentheses, use of in method calls, SCN 14-9

PARFILE

Export command-line option, SUT 1-10, SUT 1-13, SUT 1-21

Import command-line option, SUT 2-10, SUT 2-27

SQL*Loader command-line parameter, SUT 6-6

PARSE, DDS 7-3

precompiler option, PC_ 10-35, PC_ 12-4

parse

definition of, PC_ 13-4

parse count (hard) statistic, SRF C-12

parse count (total) statistic, SRF C-13

Parse Elapsed Time data view, STU 15-10

parse error offset, PCO 8-22

how to interpret, PC_ 9-15

use in error reporting, PC_ 9-15

Parse Statistics drilldown data view, STU 15-18

parse time cpu statistic, SRF C-13

parse time elapsed statistic, SRF C-13

parse tree, ADG 13 - 27

parse trees, SCN 18-17

construction of, SCN 16-7

in shared SQL area, SCN 7-8

stored in database, SCN 18-18

PARSED_PIECES view, SRF 2-174

PARSED_SIZE view, SRF 2-175

Parse/Execution Ratio data view, STU 15-10

parsing, SCN 16-11, STU 18-6

DBMS_SQL package, SCN 16-19

embedded SQL, SCN 16-6

Oracle Forms, STU 19-10

Oracle Precompilers, STU 19-10

parse calls, SCN 16-8

parse locks, SCN 16-11, SCN 27-29

performed, SCN 16-8

reducing unnecessary calls, STU 19-9

SQL statements, SCN 16-11, SCN 16-19

parsing dynamic statements

PREPARE statement, PC_ F-96, PCO F-73

PART statement in DB2

not allowed by SQL*Loader, SUT B-4

partial backups, SCN 32-24

partial global object name, DDS 2-17

partial partition-wise joins, STU 26-57

partially dropped columns

dropping, MIG 12-8

partition

adding to index, SAD 13-12

dropping from index, SAD 13-14

pruning, STU 26-51

raw partition, SRF 1-60

storage characteristics, SQL 7-370

PARTITION ... LOB storage clause

of ALTER TABLE, SQL 7-132

PARTITION BY HASH clause

of CREATE TABLE, SQL 7-377

PARTITION BY RANGE clause

of CREATE TABLE, SQL 7-363, SQL 7-378

PARTITION clause

CREATE TABLE command, SAD 13-9

of ANALYZE, SQL 7-188

of CREATE INDEX, SQL 7-284

of CREATE TABLE, SQL 7-379

of DELETE, SQL 7-441

of INSERT, SQL 7-515

of LOCK TABLE, SQL 7-521

of SELECT, SQL 7-546

of UPDATE, SQL 7-587

partition elimination, SCN 11-4, STU 8-6

partition elimination, enhanced, GTK 2-47

PARTITION option, SCN 11-63

partition view, STU 8-6, STU 11-4

partition views, GTK 6-6, SCN 11-11

PARTITION_VIEW_ENABLED parameter, SCN 11-12, SRF 1-100, STU 8-7

of ALTER SESSION, SQL 7-87

partitioned index

rebuilding partitions, SAD 13-20

partitioned indexes, NLS 4-8, SQL 2-64, SQL 7-277, SQL 7-284

user-defined, SQL 7-283

partitioned load

concurrent conventional path loads, SUT 8-25

SQL*Loader, SUT 8-26

partitioned objects, SAD 13-1 to SAD 13-21

adding, SAD 13-11

and EXPLAIN PLAN, STU 13-13

creating, SAD 13-9

definition, SAD 13-2

maintaining, SAD 13-9 to SAD 13-21

merging, SAD 13-18

moving, SAD 13-10

quiescing applications during maintenance of, SAD 13-21

splitting partition, SAD 13-17

truncating, SAD 13-15

partitioned or subpartitioned table

loading, SUT 8-6

partitioned table, STU 11-4

adding partitions, SAD 13-11

converting to non-partitioned, SAD 13-18

data warehouse, STU 26-47

example, STU 26-66

export consistency and, SUT 1-17

exporting, SUT 1-8

importing, SUT 2-6, SUT 2-35

splitting partition, SAD 13-17

partitioned tables, NLS 4-8, SQL 2-64

and dropped partitions, SBR B-18

and split partitions, SBR B-22

example, SUT 4-34

indexes and, REP A-4

performing partial TSPITR, SBR B-15

partitioned tables in DB2

no Oracle equivalent, SUT B-4

partitioned view

converting to partitioned table, SAD 13-18

partition-extended table names, SQL 2-65

in DML statements, SQL 2-65

restrictions on, SQL 2-66

syntax, SQL 2-66

partitioning, GTK 3-2

application, SPS 12-6

by hash, STU 13-14

by range, SQL 7-363, STU 13-13

compatibility, MIG 8-11

composite, STU 26-46

data, SPS 12-7, STU 26-45

distribution value, STU 13-8

downgrading, MIG 12-14

elements, SPS 2-10

examples of, STU 13-15

examples of composite, STU 13-17

guidelines, SPS 2-10

hash, STU 26-46

horizontal, SPS 2-12

indexes, STU 26-46

LOBs

DML locks, SCN 11-46

maintenance operations, SCN 11-57

new partitioning methods

composite, GTK 2-46

hash, GTK 2-46

local indexes, GTK 2-47

queries, DML, and DDL for, GTK 2-47

of index-organized tables, GTK 2-47

of object tables, GTK 2-37

of tables containing user defined types, GTK 2-37

of tables with LOBs, GTK 2-47

Oracle objects, ADG 16 - 41

range, STU 26-46

range partitioning enhancements

merging partitions, GTK 2-46

updatable partition keys, GTK 2-46

removing LOBs, MIG 12-20

start and stop columns, STU 13-15

tables with LOB columns, SCN 11-38

vertical, SPS 2-10

partitioning clauses

of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-316

of ALTER INDEX, SQL 7-31

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

of ALTER MATERIALIZED VIEW LOG, SQL 7-54, SQL 7-56

of ALTER TABLE, SQL 7-145

of CREATE MATERIALIZED VIEW / SNAPSHOT, SQL 7-300

of CREATE MATERIALIZED VIEW LOG / SNAPSHOT LOG, SQL 7-314

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-303

partitioning columns, SCN 11-15

partitioning data, SPS 11-12

data files, SPS 6-2, SPS 17-13

free list, SPS 18-16

free lists, SPS 11-2, SPS 11-15, SPS 17-11

index data, SPS 15-5

PCM locks, SPS 11-15, SPS 15-5, SPS 15-6, SPS 17-11

rollback segments, SPS 6-8, SPS 6-9

table data, SPS 11-12, SPS 11-15, SPS 15-5, SPS 17-11

partitioning keys, SCN 11-15, SCN 11-19

multi-column keys, SCN 11-22

partition-level Export, SUT 1-8

examples, SUT 1-33

partition-level Import, SUT 2-33

guidelines, SUT 2-33

specifying, SUT 1-24

partitions, SCN 11-2, SCN 11-13

adding rows to, SQL 7-513

advantages of, SCN 11-5, SCN 11-7

affinity, SCN 26-48

allocating extents for, SQL 7-140

basic partitioning model, SCN 11-13

bitmap indexes, SCN 10-36

composite, SQL 2-65

specifying, SQL 7-378

concurrent maintenance operations, SCN 11-50

converting into nonpartitioned tables, SQL 7-152

DATE datatype, SCN 11-14, SCN 11-21

deallocating unused space from, SQL 7-141

DML partition locks, SCN 11-45

dropping, SQL 7-149

dynamic partitioning, SCN 26-6

equipartitioning, SCN 11-24

examples, SCN 11-25, SCN 11-30, SCN 11-32

LOB columns, SCN 11-38

local indexes, SCN 11-29

on one dimension, SCN 11-24

overflow of index-organized tables, SCN 11-42, SCN 11-44

range partitioning, SCN 11-24

EXCHANGE PARTITION, SCN 11-11

execution plan, SCN 11-11, SCN 11-14

extents

allocating new, SQL 7-34

global indexes, SCN 11-32, SCN 11-60

hash, SQL 2-65

adding, SQL 7-149

coalescing, SQL 7-149

specifying, SQL 7-377

hash partitioning, SCN 11-16

inserting rows into, SQL 7-515

LOB storage characteristics of, SQL 7-132

local indexes, SCN 11-29, SCN 11-59

building in parallel, SCN 11-30

locking, SQL 7-520

logging attribute of, SQL 7-371

logging insert operations, SQL 7-142

LONG and LONG RAW restriction, SCN 11-14

maintenance operations, SCN 11-48

materialized views, SCN 10-18, SCN 11-2

merging, SCN 11-16, SQL 7-151

modifying, SQL 7-145

moving to a different segment, SQL 7-147

no-logging mode, SCN 25-7

nonprefixed indexes, SCN 11-31, SCN 11-35

OLTP databases, SCN 11-6

parallel DDL, SCN 26-31

parallel queries, SCN 26-4

partition bounds, SCN 11-20

partition elimination, SCN 11-4

partition names, SCN 11-18

partition pruning, SCN 11-4

DATE datatype, SCN 11-22

disk striping and, SCN 26-48

indexes, SCN 11-36

parallelizing by block range, SCN 26-4

partition transparency, SCN 11-10

partition-extended table names, SCN 11-63

partitioning indexes, SCN 11-29, SCN 11-36

partitioning keys, SCN 11-15, SCN 11-19

partitioning tables, SCN 11-27

partition-wise joins, SCN 11-5

physical attributes, SCN 11-27, SCN 11-37

changing, SQL 7-135

prefixed indexes, SCN 11-30

range, SQL 2-65

adding, SQL 7-148

specifying, SQL 7-378

range partitioning, SCN 11-15

disk striping and, SCN 26-48

rebuild partition, SCN 11-60

referencing a partition, SCN 11-19

removing rows from, SQL 7-150, SQL 7-441

renaming, SQL 7-147

replication and, REP 2-26

restrictions

bitmap indexes, SCN 11-14

datatypes, SCN 11-14, SCN 11-21

partition-extended table names, SCN 11-64

revising values in, SQL 7-587

rules of parallelism, SCN 26-25, SCN 26-27

segments, SCN 4-17

splitting, SQL 7-150

statistics, SCN 11-14, SCN 22-11

tablespace for

defining, SQL 7-370

VLDB, SCN 11-5

partitions, creating, LEG 5-7

partition-wise joins, SCN 11-5, STU 26-52

benefits of, STU 26-60

full, STU 13-21

full, and EXPLAIN PLAN output, STU 13-21

parallel, performance considerations for, STU 26-61

partial, STU 26-57

partial, and EXPLAIN PLAN output, STU 13-19

PARTNER_LU_LOCAL_ALIAS parameter, NET 6-78

PARTNER_LU_NAME parameter, NET 6-78

Pascal Calling Standard, ADG 11 - 9

Pass-through SQL, DDS 7-2

pass-through SQL

avoiding SQL interpretation, DDS 7-2

overview, DDS 7-2

restrictions, DDS 7-2

passthrough SQL

non queries, DDS 7-3

queries, DDS 7-3

pass-through SQL statements

executing, DDS 7-3

pass-through SQL statements with bind variables, DDS 7-4

password

defining, PC_ 3-2

for NAMESCTL access, NET A-3, NET A-32

required to stop the listener, NET 8-14

PASSWORD command, NET A-43

PASSWORD EXPIRE clause

of ALTER USER. See CREATE USER.

of CREATE USER, SQL 7-427

password file

migration

exclusive setting, MIG A-18

password file enqueue, SRF B-2

password files

and Recovery Manager, SBR 5-2

connecting to Recovery Manager with, SBR 5-9, SBR 5-11

connecting to Recovery Manager without, SBR 5-10

password management, OCI 8-10, OCI 8-12

application changes required for Oracle8i, MIG 8-37

interoperability, MIG 8-38

password expiration, MIG 8-38

password parameters

of ALTER PROFILE, SQL 7-341

of CREATE PROFILE, SQL 7-338

password, changing, PCO A-8

PASSWORD_GRACE_TIME parameter

of ALTER PROFILE, SQL 7-65

of CREATE PROFILE, SQL 7-340

PASSWORD_LIFE_TIME parameter

of ALTER PROFILE, SQL 7-65

of CREATE PROFILE, SQL 7-340

PASSWORD_LOCK_TIME parameter

of ALTER PROFILE, SQL 7-65

of CREATE PROFILE, SQL 7-340

PASSWORD_REUSE_MAX parameter

of ALTER PROFILE, SQL 7-65

of CREATE PROFILE, SQL 7-340

PASSWORD_REUSE_TIME parameter

of ALTER PROFILE, SQL 7-65

of CREATE PROFILE, SQL 7-340

PASSWORD_VERIFY_FUNCTION parameter

of ALTER PROFILE, SQL 7-65

of CREATE PROFILE, SQL 7-340

passwords

account locking, SCN 29-7

administrator privileges, SCN 5-3

authenticating, SRF 1-92, SRF 1-107

authentication file for, SAD 1-9

changing at runtime, PC_ A-2

changing at runtime with ALTER AUTHORIZATION, PCO 3-11

changing for roles, SAD 24-8

complexity verification, SCN 29-8

connecting with, SCN 8-4

connecting without, SCN 29-4

database user authentication, SCN 29-7

defining, PCO 3-3

encryption, SCN 29-7

expiration, SCN 29-8

hardcoding, PCO 3-3

hiding, SUT 2-8

initial for SYS and SYSTEM, SAD 1-5

password file, SAD 1-12

creating, SAD 1-9

OS authentication, SAD 1-7

relocating, SAD 1-16

removing, SAD 1-16

state of, SAD 1-16

password files, SCN 29-13

password reuse, SCN 29-8

privileges for changing for roles, SAD 24-6

privileges to alter, SAD 23-15

REMOTE_LOGIN_PASSWORDFILE parameter, SRF 1-107

roles, SAD 24-7

security policy for users, SAD 22-4

setting REMOTE_LOGIN_PASSWORD parameter, SAD 1-11

used in roles, SCN 1-42

user authentication, SAD 23-8

PASSWORDS parameter, NET C-62

passwords, expiration of, SQL 7-427

patch release number, SAD 1-22

pattern matching, PLS 2-45

PCB, SMS 38-1

PCF, SMS 39-1

PCM

defined, PSC 1-15

described, PSC 1-17

fine-grain lock usage, PSC 1-19

fine-grain locks, PSC 1-18

GC_FILES_TO_LOCKS parameter, PSC 1-17

GC_RELEASABLE_LOCKS parameter, PSC 1-18

hashed lock usage, PSC 1-19

hashed locks, PSC 1-18

PCM lock, STU 27-13

adding datafiles, SPS 15-12

allocating, SPS 15-2

calculating, SPS 15-17

checking for valid number, SPS 15-11, SPS 15-13

contention, SPS 11-15, SPS 15-5, SPS 15-6, SPS 17-11

conversion time, SPS 15-16

estimating number needed, SPS 15-3

exclusive, SPS 9-25

fixed fine grain, SPS 9-4

fixed hashed, SPS 9-3

index data, SPS 15-5

mapping blocks to, SPS 9-6, SPS 11-15, SPS 17-11, SRF 1-44

planning, SPS 15-2

releasable fine grain, SPS 9-3

releasable hashed, SPS 9-4

resources, SPS 15-17

sessions waiting, SPS 15-17

set of files, SPS 9-7

shared, SPS 9-25, SPS 15-5

specifying total number, SPS 14-10

valid lock assignments, SPS 15-11

worksheets, SPS 15-4

pcode

when generated for triggers, ADG 13 - 27

PCS, SMS 40-1

PCTFREE, SPS 11-5, SPS 19-6, STU 2-11, STU 20-31

value for complex snapshots, REP 3-22

PCTFREE 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, SQL 7-281

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

of CREATE MATERIALIZED VIEW/SNAPSHOT. See CREATE TABLE.

of CREATE TABLE, SQL 7-369

PCTFREE storage parameter

altering, ADG 3 - 9, SAD 14-10

block overhead and, ADG 3 - 7, SAD 12-6

clustered tables, SAD 12-4

default, ADG 3 - 4, SAD 12-3

guidelines for setting, ADG 3 - 4, ADG 3 - 5, ADG 3 - 6, SAD 12-3

how it works, SAD 12-2, SCN 4-6

indexes, SAD 12-4

indexes for, ADG 3 - 6

non-clustered tables, ADG 3 - 5, SAD 12-4

PCTUSED and, SAD 12-6, SCN 4-8

PCTINCREASE parameter, STU 20-36

and SQL.BSQ file, STU 20-33

of STORAGE clause, SQL 7-577

table extents, SPS 17-11

PCTINCREASE storage parameter

about, SAD 12-8

altering, SAD 12-11

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

setting for the data dictionary, SAD 20-27

PCTTHRESHOLD parameter

of ALTER TABLE, SQL 7-144

of CREATE TABLE, SQL 7-372

PCTUSED, SPS 11-5, STU 2-11, STU 20-31

value for complex snapshots, REP 3-22

PCTUSED 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-369

PCTUSED storage parameter

altering, ADG 3 - 9, SAD 14-10

block overhead and, ADG 3 - 7, SAD 12-6

default, ADG 3 - 6, SAD 12-5

guidelines for setting, ADG 3 - 6, SAD 12-5

how it works, SAD 12-4, SCN 4-6

non-clustered tables, ADG 3 - 6

PCTFREE and, SAD 12-6, SCN 4-8

PCTVERSION, ADL 3-9

PCTVERSION parameter

of CREATE TABLE, SQL 7-375

of LOB storage clause, SQL 7-132

PDML Restrictions

for DML_LOCKS parameter, SRF 1-38

PDO. See parameter descriptor object

pending area, SAD 11-5

pending global transaction(s) wait event, SRF A-43

Pending Messages Window

recovery waiting for tape_volume_name, LEG 3-21

waiting for writable backup tape, LEG 3-21

pending transaction tables, DDS 3-29

percent sign

alternate mappings, NLS 4-9

performance, PLS 1-21, SRF 1-11

and lock mastering, SPS 8-9

application, SPS 11-12

benefits of parallel database, SPS 1-13

caching sequences, SPS 6-7

causes of poor, PCO D-2

client/server applications, STU 3-9

clusters, ADG 6 - 15

clusters and, SCN 10-48

constraint effects on, SCN 28-6

decision support applications, STU 3-3

different types of applications, STU 3-1

direct path Export, SUT 1-41, SUT 1-43

direct path loads, SUT 8-16

distributed databases, STU 3-7

DSS database, SCN 11-9, SCN 26-37

dynamic performance tables (V$), SCN 2-7

eliminating extra parsing to improve, PC_ C-7

evaluating, STU 1-10

fine grain locking, SPS 9-20

group commits, SCN 8-10

Import, SUT 2-20

improving, PCO D-3, PLS 5-60

index build, SCN 10-22

index column order, ADG 6 - 4

inserts and updates, SPS 11-12

I/O, SCN 11-9

key factors, STU 17-2

location of datafiles and, SAD 10-4

mainframe, STU 24-4

monitoring registered applications, STU 5-1, STU 12-7

native dynamic SQL, ADG 9 - 15

NT, STU 24-4

OLTP applications, STU 3-1

optimizing reading of SQL*Loader data files, SUT 5-24

optimizing SQL statements to improve, PC_ C-5

Oracle Parallel Server and DML locks, SCN 11-47

Oracle8 features, SPS 4-5

packages, SCN 18-16

parallel recovery and, SCN 32-11

Parallel Server, STU 3-8

partitioned load

SQL*Loader, SUT 8-26

partitions, SCN 11-9

prefixed and nonprefixed indexes, SCN 11-35

reasons for poor, PC_ C-2

recovery, SCN 32-13

resource limits and, SCN 29-16

rollback segments, SPS 6-8, SPS 6-9

ROW_LOCKING parameter, ADG 8 - 19

rule-based optimizer, SRF 1-88

sequence numbers, SPS 6-7

SERIALIZABLE option, ADG 8 - 19

SGA size and, SCN 7-12

shared pool, SRF 1-49, SRF 1-115, SRF 1-116

shared resource system, SPS 1-14

sort operations, SCN 3-12

sort performance, SRF 1-119

structures that improve, SCN 1-26, SCN 1-27

tuning archiving, SAD 7-20

UNIX-based systems, STU 24-4

using embedded PL/SQL to improve, PC_ C-3

using HOLD_CURSOR to improve, PC_ C-12

using host arrays to improve, PC_ C-3

using indexes to improve, PC_ C-6

using RELEASE_CURSOR to improve, PC_ C-12

using row-level locking to improve, PC_ C-6

viewing execution plans, SCN 22-4

performance enhancements, REP A-2

performance improvement

conventional path for small loads, SUT 8-22

Performance Manager, STU 12-10

Performance Monitor, NT, STU 18-4

performance of SSL compared to Net8, OAS 9-11

performance tables

dynamic performance tables, SAD 4-9

performing backups after unrecoverable operations, SBR 3-19

periodic purges

scheduling, REP 2-18

periodic pushes

scheduling, REP 2-14

PERMANENT clause

of ALTER TABLESPACE, SQL 7-169

of CREATE TABLESPACE, SQL 7-396

persistent areas, SCN 7-8

persistent copies of objects, PC_ 17-4

persistent objects, OCI 10-6, PC_ 17-4

meta-attributes, OCI 10-17

persistent queuing, SCN 19-2

persistent resource, SPS 8-10

PFILE

Migration utility option, MIG 3-14

PFILE option, SPS 18-6, SPS 18-8

conversion to multi-instance, SPS 23-5

PG2, SMS 41-1

PGA, SCN 1-17, SCN 7-14

multi-threaded server, SCN 8-19

PGO, SMS 42-1

pgroup, REP 6-23

phantom reads, SCN 27-3, SCN 27-10

PHYRDS column

V$FILESTAT table, STU 20-19

physical attributes clause

of a constraint, SQL 7-220

of ALTER CLUSTER, SQL 7-2

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 ALTER TABLE, SQL 7-135

of CREATE CLUSTER, SQL 7-236

of CREATE MATERIALIZED VIEW / SNAPSHOT, SQL 7-300

of CREATE MATERIALIZED VIEW LOG / SNAPSHOT LOG, SQL 7-314

of CREATE TABLE, SQL 7-361, SQL 7-369

physical database layout, STU 26-36

physical database structures, SBR 1-6 to SBR 1-11, SCN 1-5, SCN 1-11

control files, SCN 1-13, SCN 32-21

datafiles, SCN 1-12, SCN 3-16

redo log files, SCN 1-12, SCN 32-7

physical guesses in logical rowids, SCN 12-20

staleness, SCN 12-21

statistics for, SCN 12-21

physical layer, described, NET 2-8

physical reads statistic, SRF C-13, STU 19-26

physical rowid, PLS 2-16

physical structure of a database, SAD 1-19

physical writes statistic, SRF C-13

PHYWRTS column

V$FILESTAT table, STU 20-19

PIC G for NLS characters, PCO B-3

PIC N for NLS characters, PCO B-3

PICX precompiler option, PCO 4-32, PCO 14-35

PIECED keyword

SQL*Loader, SUT 8-14

piecewise fetch, OCI 5-36

piecewise operations, OCI 5-34

fetch, OCI 5-32, OCI 5-37

in PL/SQL, OCI 5-36

insert, OCI 5-32

update, OCI 5-32

valid datatypes, OCI 5-33

pin count, OCI 10-28

pin duration

example, OCI 13-14

of objects, OCI 13-14

ping UNIX command, STU 12-3

PING utility, NET 8-16, NET A-44

testing Oracle Names servers with, NET 8-16

ping, host table testing, LEG B-3

pinging, SPS 9-8, SPS 9-9, SPS 15-14, SPS 15-16, STU 2-12

definition, SPS 9-2

false, SPS 9-17

rate, SPS 15-15

ping/write ratio, SPS 19-4

pinned buffers inspected statistic, SRF C-14

pinning, OCI 13-7

pinning objects, OCI 13-7

PINPAD cards

using SecurID, OAS 6-14

PINS column

V$LIBRARYCACHE table, STU 19-14

pipe, PLS 8-17

pipe get wait event, SRF A-44

PIPE parameter, NET 6-78

pipe put wait event, SRF A-44

PKI, GTK 2-73, SCN 29-5

placeholder, PLS 10-2

duplicate, PLS 10-10

placeholders

duplicate, PC_ 13-14, PC_ 13-30, PCO 9-30

naming, PC_ 13-14

proper order of, PC_ 13-14

use in dynamic SQL statements, PC_ 13-3

plan

accessing views, SCN 23-19, SCN 23-22, SCN 23-23

complex statements, SCN 23-14

compound queries, SCN 23-27, SCN 23-28, SCN 23-29

joining views, SCN 23-25

joins, SCN 24-2, SCN 24-8

OR operators, SCN 23-12

SQL execution, SCN 16-4, SCN 16-11

star transformation, SCN 24-18

Plan Stability, STU 7-25

limitations of, STU 7-25

preserving execution plans, STU 7-25

procedures for the cost-based optimizer, STU 7-32

use of hints, STU 7-25

plan stability, SPR 55 - 1

compatibility, MIG 8-14

downgrading, MIG 12-36

plan stability for optimization, SCN 22-6

plan stability for optimizer, GTK 2-37

plan, execution, PCO D-5

PLAN_TABLE execution plan table, SRF 2-175

PLAN_TABLE sample table, SQL 7-486

PLAN_TABLE table

ID column, STU 13-4

OBJECT_INSTANCE column, STU 13-4

OBJECT_NAME column, STU 13-4

OBJECT_NODE column, STU 13-4

OBJECT_OWNER column, STU 13-4

OBJECT_TYPE column, STU 13-4

OPERATION column, STU 13-4

OPTIMIZER column, STU 13-4

OPTIONS column, STU 13-4

OTHER column, STU 13-5

PARENT_ID column, STU 13-4

POSITION column, STU 13-5

REMARKS column, STU 13-3

SEARCH_COLUMNS column, STU 13-4

STATEMENT_ID column, STU 13-3

structure, STU 13-2

TIMESTAMP column, STU 13-3

planning

database creation, SAD 2-2

overview, NET 3-2

relational design, SAD 1-19

summary, NET 3-15

the database, SAD 1-18

PLS, SMS 21-1

PLS_INTEGER datatype, PLS 2-13

PL/SQL, ADG 10 - 2, GTK 2-78, OCI 1-9, PC_ 1-4, SCN 16-15

advantages, ADG 1 - 3, PCO 1-4, PLS 1-20

anonymous block

used to open a cursor variable, PC_ 4-28

anonymous blocks, ADG 10 - 2, SCN 16-15, SCN 18-9

architecture, PLS 1-17

auditing of statements within, SCN 31-4

autonomous blocks, GTK 2-78

backward compatibility, MIG 8-19

bind variables

user-defined types, SCN 13-14

binding and defining nested tables, OCI 5-30

binding and defining ref cursors, OCI 5-30

binding placeholders, OCI 2-39

block structure, PLS 1-2

bulk binds, GTK 2-79

calling remote stored procedures, ADG 10 - 55

compatibility, MIG 8-14, MIG 8-20

compatibility with earlier releases, SQL 7-87, SQL 7-107

cursor FOR loop, PC_ 7-3, PCO 6-4

cursor variables, ADG 10 - 38

database triggers, SCN 1-59, SCN 20-1

datatype equivalents, PCO 11-18

datatypes, SPR 11 - 6, SCN 12-2

numeric codes for, SPR 11 - 9

DBMS_LOB package compared with OCI, DCI 6-7

debugging, DCI 5-8

defining output variables, OCI 5-17

demo directory, DCI 4-10

dependencies among library units, ADG 10 - 28

description of, PC_ 1-4

deterministic functions, SCN 23-9

difference from SQL, PC_ 1-4

differences from C and C++, DCI 5-9

dynamic SQL, SCN 16-19

DBMS_SQL package, GTK 2-79

embedded, PCO 6-2

error

ORA-06510, DDS 4-12

exception, PCO 6-13

exception handlers, ADG 10 - 2

exception handling, SCN 16-18

executing, SCN 16-15, SCN 18-18, SCN 18-19

executing a block using the AT clause, PC_ 3-10

execution environments, PLS 1-17

external procedures, SCN 16-20, SCN 18-11

features, ADG 1 - 3

functions

arguments, ADG 10 - 60

desupported in Oracle8i, MIG 8-30

overloading, ADG 10 - 70

parameter default values, ADG 10 - 60

purity level, ADG 10 - 69

RESTRICT_REFERENCES pragma, ADG 10 - 66

using, ADG 10 - 57

hiding source code, ADG 10 - 27

increased package body size, GTK 2-80

integration with database server, PC_ 7-2

integration with server, PCO 6-3

interoperability, MIG 8-20

invoker rights, GTK 2-78

invoking with dynamic SQL, ADG 9 - 7

language constructs, SCN 16-17

main advantage of, PC_ 1-4

modules

recompiling, MIG 7-32

monitoring and analysis of program execution

DBMS_DEBUG, GTK 2-80

DBMS_PROFILER, GTK 2-80

DBMS_TRACE, GTK 2-79

NOCOPY parameter passing mode, GTK 2-79

object views, SCN 15-4

objects, ADG 1 - 5

opening a cursor variable

anonymous block, PCO 6-35

stored procedure, PCO 6-34

optimizer goal, SCN 23-33

overview of, SCN 1-55, SCN 16-15

package, PCO 6-5, STU 12-7

packages, ADG 10 - 12, DCI 5-5, PC_ 7-4, SCN 18-4, SCN 18-11

parameter passing by reference, GTK 2-79

parse locks, SCN 27-29

parsing DDL statements, SCN 16-19

partition-extended table names, SCN 11-65

performance, PLS 1-21

piecewise operations, OCI 5-36

PL/SQL engine, SCN 16-15, SCN 18-2

compiler, SCN 18-17

executing a procedure, SCN 18-19

products containing, SCN 16-16

PL/SQL tables, PC_ 7-5

PLSQL_V2_COMPATIBILITY initialization parameter, MIG 8-20

portability, PLS 1-22

procedural aspects, PLS 1-2

procedures and functions, PC_ 7-3

procedures for supporting REF-based operations

UTL_REF package, GTK 2-79

program units, ADG 10 - 2, SCN 1-25, SCN 7-10, SCN 16-15, SCN 18-2

compiled, SCN 16-16, SCN 18-9, SCN 18-17

dropped tables and, ADG 3 - 10

replaced views and, ADG 3 - 25

shared SQL areas and, SCN 7-10

purity rules relaxed, GTK 2-80

RAISE statement, ADG 10 - 45

RECORD type

cannot be bound to a C struct, PC_ 4-41

relationship with SQL, PC_ 1-4, PCO 1-4

removing incompatibilities for downgrading, MIG 12-25

reserved words, PLS E-1

roles in procedures, SCN 30-20

sample code, ADG 1 - 2

sample programs, PLS A-1

serially reusable packages, ADG 10 - 70

setting SQLCA, PC_ 9-22

stored procedures, SCN 1-25, SCN 16-15, SCN 18-2, SCN 18-6

subprogram, PCO 6-4

support for SQL, PLS 1-20

tables, ADG 10 - 9

of records, ADG 10 - 9

trigger bodies, ADG 13 - 14, ADG 13 - 15

tuning PL/SQL areas, STU 19-7

user locks, SCN 27-39

user-defined datatypes, SCN 13-13

user-defined errors, ADG 10 - 45

user-defined exceptions, DDS 4-11

user-defined record, PCO 6-6

user-defined records, PC_ 7-5

uses in OCI applications, OCI 2-39

using in OCI applications, OCI 2-39

using in OCI programs, OCI 5-7

variables

NCHAR and NLS, MIG 8-27

wrapper to hide code, ADG 10 - 27

see also external procedures (routines)

PL/SQL block

anonymous, PLS 1-2, PLS 7-2

maximum size, PLS 5-50

syntax, PLS 11-7

PL/SQL block execution

effect on SQLCA components, PCO 8-26

PL/SQL blocks

embedded in Oracle7 precompiler programs, PCO F-38

embedded in precompiler programs, PC_ F-51

PL/SQL compiler

how calls are resolved, PLS 7-25

PL/SQL development environment, DDS 7-2

PL/SQL engine, PLS 1-17

in Oracle Server, PLS 1-18

in Oracle tools, PLS 1-19

PL/SQL external procedures, DDS 5-4

PL/SQL lock timer wait event, SRF A-16

PL/SQL program body

of CREATE FUNCTION, SQL 7-271

PL/SQL program units

dropped tables and, SAD 14-12

replaced views and, SAD 15-9

PL/SQL shared memory area, SPS 5-5

PL/SQL subprogram

calling from Pro*COBOL, PCO 6-21

PL/SQL syntax, PLS 11-1

PL/SQL table, PCO 6-6

supported datatype conversions, PCO 6-16

PL/SQL triggers

using with snapshot base tables, REP 5-27

PL/SQL Wrapper, PLS C-1

input and output files, PLS C-3

running, PLS C-2

PLSQL_V2_COMPATIBILITY flag, PLS 5-68

PLSQL_V2_COMPATIBILITY parameter, SRF 1-101

of ALTER SESSION, SQL 7-87

of ALTER SYSTEM, SQL 7-107

PLU parameter, NET 6-78

PLU_LA parameter, NET 6-78

PLUGGABLE_SET_CHECK view, SRF 2-176

PM (P.M.) date format element, SQL 2-41, SQL 2-43

PM\DB_NAME registry key, PSC C-2

PMON background process, SCN 8-11

See also process monitor process

PMON process, PSC 1-10, SPS 5-5

pmon rdomain attach wait event, SRF A-44

pmon timer wait event, SRF A-44

point events in Oracle Trace, STU 15-5

pointer, PLS 5-16

definition of, PC_ 4-46

to cursor variables

restrictions on, PC_ 4-27

pointer variables

declaring, PC_ 4-46

determining size of referenced value, PC_ 4-46

referencing, PC_ 4-46

referencing struct members with, PC_ 4-46

point-in-time recovery

clone database, SCN 5-7

tablespace, SBR A-2 to SBR A-15, SBR B-1 to SBR B-26

policy

browse, LEG 2-6

retention, LEG 2-6

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

POOL_SIZE parameter, NET 6-73

POOL_SIZE parameter, role in listener-created server processes, NET 2-23

pools

label templates, using with, LEG C-5

pools, volume

default resource attributes, LEG 3-12

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

selection considerations

expiration date of the volume, LEG 3-22

number of volumes, LEG 3-23

volume label time, LEG 3-23

volume mode, LEG 3-22

unable to find a mounted volume, LEG 3-23

port, NET B-9, NET C-76

port number range, NET 6-80

PORT parameter, NET 6-80

portability, PLS 1-22, SCN 1-3

portmapper, testing with rpcinfo, LEG B-4

POSITION column

PLAN_TABLE table, STU 13-5

POSITION keyword

specification of field position, SUT 5-15

SQL*Loader, SUT 5-48

SQL*Loader and multiple INTO TABLE clauses, SUT 5-50

tabs, SUT 5-50

with multiple SQL*Loader INTO TABLE clauses, SUT 5-53

positional notation, PLS 7-13

positioned, OCI 2-34

deletes, OCI 2-34

POSITIVE subtype, PLS 2-12

POSITIVEN subtype, PLS 2-12

POST_TRANSACTION option, STU 25-22

power demand cartridge example, DCI 11-1

demo file (extdemo1.sql), DCI 11-15

POWER function, SQL 4-31

PPE, SMS 43-1

PQ_DISTRIBUTE hint, SQL 2-61, STU 7-58

PR number format element, SQL 2-36

PR2, SMS 44-1

pragma, ADG 8 - 33, ADG 8 - 41, ADG 16 - 22, PLS 6-8

AUTONOMOUS_TRANSACTION, PLS 5-53

EXCEPTION_INIT, PLS 6-8

RESTRICT_REFERENCES, PLS 5-59, PLS 7-7, PLS 10-13

RESTRICT_REFERENCES pragma, ADG 10 - 66

SERIALLY_REUSABLE, PLS 5-64

SERIALLY_REUSABLE pragma, ADG 10 - 70, ADG 10 - 71

PRAGMA clause

of ALTER TYPE, SQL 7-175

of CREATE TYPE, SQL 7-412, SQL 7-416

PRAGMA RESTRICT_REFERENCES, SQL 7-175, SQL 7-416

pragma RESTRICT_REFERENCES, DCI 5-6

PRAGMA_EXCEPTION_INIT

assigning exception names, DDS 4-11

PRE_PAGE_SGA parameter, SRF 1-102, STU 19-5

pre-allocating extent, SPS 11-17

prebuilt conflicts

resolution methods

restrictions for, REP 6-9

prebuilt materialized view, STU 29-4

PREBUILT TABLE clause

materialized views and downgrading, MIG 12-10

prebuilt uniqueness conflicts

resolution methods, REP 6-9

prebuilt update conflict resolution methods, REP 6-18

prebuilt update conflicts

resolution methods, REP 6-8

precedence

of operators, SQL 3-2

precedence of precompiler options, PC_ 10-3

precedence of storage parameters, SAD 12-11

precedence, operator, PLS 2-42

precision, PCO 4-4

definition of, PC_ 15-16

NUMBER and FLOAT, SRF 2-249

number of digits of, SQL 2-4

of NUMBER datatype, SQL 2-13

using sqlprc() to extract, PC_ 15-16

when not specified, PC_ 15-16

precision of a numeric field versus length, SUT 5-16

precision of digits

specifying, PLS 2-12

precompilation, PC_ 10-6

conditional, PC_ 2-16, PCO 2-26

generated code, PCO 14-3

separate, PC_ 2-17, PCO 2-27

precompilation unit, PC_ 3-2, PC_ 10-7, PCO 14-9

precompiled header files, PC_ 5-36, PC_ A-2

C++ restrictions, PC_ 5-40

CODE option, PC_ 5-40

PARSE option, PC_ 5-40

precompiler command

required arguments, PCO 14-2

precompiler options

abbreviating name, PCO 14-4

alphabetized list, PC_ 10-7, PC_ 10-11

ANSI Dynamic SQL, PCO 10-12

ASACC, PCO 14-12

ASSUME_SQLCODE, PCO 14-13

AUTO_CONNECT, PC_ 10-11, PCO 3-11, PCO 14-14

case sensitivity, PC_ 10-2

CHAR_MAP, PC_ 5-2, PC_ 10-12, PC_ A-3

CLOSE_ON_COMMIT, PC_ 6-15, PC_ 10-12, PCO 5-13, PCO 14-14, PCO A-5

CODE, PC_ 10-13

COMP_CHARSET, PC_ 10-14

CONFIG, PC_ 10-15, PCO 14-15

configuration files, PC_ 10-5

CPP_SUFFIX, PC_ 10-15

current values, PCO 14-6

DATE_FORMAT, PCO 14-16, PCO A-6

DBMS, PC_ 10-16, PCO 14-17

DECLARE_SECTION, PCO 2-21, PCO 14-18

DEF_SQLCODE, PC_ 10-17

DEFINE, PC_ 10-18, PCO 14-19

determining current value, PC_ 10-4

displaying, PCO 14-4

displaying syntax, default, purpose, PCO 14-10

DURATION, PC_ 10-20

DYNAMIC, PC_ 14-11, PCO 10-12, PCO 14-20

END_OF_FETCH, PCO 14-20

entering, PC_ 10-9, PCO 14-7

entering inline, PCO 14-8

entering on the command line, PC_ 10-9, PCO 14-2

ERRORS, PC_ 10-20, PCO 14-21

ERRTYPE, PC_ 10-21

FIPS, PC_ 10-21, PCO 14-21

FORMAT, PCO 14-23

HEADER, PC_ 10-23

HOLD_CURSOR, PC_ 10-23, PC_ 10-24, PCO 14-23, PCO D-7

HOST, PCO 14-24

INAME, PC_ 10-25, PCO 14-25

INCLUDE, PC_ 10-25, PCO 14-25

INTYPE, PC_ 10-26

IRECLEN, PCO 14-26

LINES, PC_ 10-27

list, PCO 14-10

list of, PC_ 10-11

LITDELIM, PCO 2-14, PCO 14-27

LNAME, PC_ 10-28, PCO 14-27

LRECLEN, PCO 14-28

LTYPE, PC_ 10-28, PCO 14-28

macro and micro, PCO 14-5

MAXLITERAL, PC_ 2-15, PC_ 10-29, PCO 14-29

MAXOPENCURSORS, PC_ 10-30, PCO 2-28, PCO 14-30, PCO D-7

micro and macro, PC_ 10-5

MODE, PC_ 10-31, PC_ 14-11, PCO 4-32, PCO 8-2, PCO 8-4, PCO 10-12, PCO 14-31

name of the system configuration file, PCO 14-7

NESTED, PCO 14-32, PCO A-3

NLS_CHAR, PC_ 10-32

NLS_LOCAL, PC_ 10-32, PCO 2-17, PCO 14-32

OBJECTS, PC_ 10-33

ONAME, PC_ 10-33, PCO 14-33

ORACA, PC_ 10-34, PCO 8-38, PCO 14-34

ORECLEN, PCO 14-34

PAGELEN, PC_ 10-35, PCO 14-34

PARSE, PC_ 10-35

PICX, PCO 4-32, PCO 14-35, PCO A-8

precedence, PC_ 10-3, PCO 14-4

PREFETCH, PC_ 10-36, PCO 5-20, PCO 14-36, PCO A-2

RELEASE_CURSOR, PC_ 10-36, PCO 14-36, PCO D-7

respecifying, PCO 14-9

scope, PC_ 10-6

scope of, PC_ 10-7, PCO 14-9

SELECT_ERROR, PC_ 10-38, PCO 14-37

specifying, PC_ 10-9, PCO 14-2

SQLCHECK, PC_ 10-38, PC_ 17-21, PCO 14-38, PCO E-2

syntax for, PC_ 10-9, PCO 14-2

SYS_INCLUDE, PC_ 10-39

table of how macro options set micro options, PCO 14-5

THREADS, PC_ 10-40, PC_ 11-8

TYPE_CODE, PC_ 10-41, PC_ 14-11, PCO 10-12, PCO 14-40

UNSAFE_NULL, PC_ 10-41, PCO 14-40

USERID, PC_ 10-42, PCO 14-41

using, PC_ 10-11 to PC_ 10-44

VARCHAR, PC_ 10-42, PCO 14-42

VERSION, PC_ 10-43

XREF, PCO 14-42

precompilers, ADG 10 - 52

anonymous blocks, SCN 16-17

applications, ADG 10 - 4

bind variables, SCN 16-13

compatibility, MIG 8-18

cursors, SCN 16-11

embedded SQL, SCN 16-5

FIPS flagger, SCN 16-6

interoperability, MIG 8-18

PL/SQL backward compatibility, MIG 8-19

SQLLIB calls

relinking, MIG 9-5

stored procedures, SCN 16-18

upgrading applications to Oracle8i, MIG 9-2

precompilers, enhancements, GTK 2-81

predefined exception

list of, PLS 6-4

raising explicitly, PLS 6-11

redeclaring, PLS 6-10

predefined roles, SAD 1-6

predefined symbols, PC_ 2-16

predetermined size fields

SQL*Loader, SUT 5-83

predetermined size LOBs, SUT 5-103

predicate, PLS 5-5

predicates

dynamic

in security policies, SCN 30-23

optimizing view queries, SCN 23-15

partition pruning, SCN 11-4

indexes, SCN 11-36

pushing into a view, SCN 23-18, SCN 23-23

examples, SCN 23-19, SCN 23-21

selectivity, SCN 22-8

histograms, SCN 22-8, SCN 22-10

user-defined, SCN 22-17

Prefer Connection Manager Routing option, NET 7-26

preferred credentials, PSC 5-21

creating an operating system account, PSC 5-22

database, PSC 5-21

nodes, PSC 5-21

SYSDBA or SYSOPER for database, PSC 5-21

preferred Oracle Names servers, NET 2-42

preferred user credentials, described, PSC 5-21

PREFETCH precompiler option, PC_ 10-36, PC_ A-5, PCO 5-20, PCO 14-36

prefetching

during OCIStmtExecute(), OCI 4-6

setting prefetch memory size, OCI 4-15

setting row count, OCI 4-15

prefixed indexes, SCN 11-30, SCN 11-34

prefixes of data dictionary views, SCN 2-5

pre-installation, PSC 2-1 to PSC 2-15

DBCA_RAW_CONFIG, PSC 2-8, PSC 2-13, PSC 4-3

oracle account activities, PSC 2-15

root user activities, PSC 2-14

prepare phase, DDS 3-3

recognizing read-only nodes, DDS 3-17

PREPARE SQL statement, PC_ F-96

PREPARE statement, PC_ 14-21, PCO F-73

effect on data definition statements, PC_ 13-5, PCO 9-6

examples, PC_ F-98, PCO F-74

in dynamic SQL Method 4, PCO 11-29

use in dynamic SQL, PC_ 13-13, PC_ 13-19

use in dynamic SQL method 4, PC_ 15-25

using in dynamic SQL, PCO 9-13, PCO 9-19

prepare/commit phases

abort response, DDS 3-3

effects of failure, DDS 3-20

failures during, DDS 3-19

forcing to fail, DDS 3-33

locked resources, DDS 3-20

pending transaction table, DDS 3-29

prepared response, DDS 3-3

read-only response, DDS 3-3

testing recovery, DDS 3-33

preprocessor

example, PC_ 5-43

EXEC ORACLE directives, PC_ 5-42

preprocessor directives

directives not supported by Pro*C, PC_ 5-30

preprocessor, support of, PC_ 4-2

prerequisites

for creating a database, SAD 2-3

SQL*Loader, SUT 3-15

prerequisites, for Biometric Authentication Service installation, OAS 7-5

PRESENTATION (PRE or PRES) attribute, NET 7-52, NET 7-54, NET 7-57, NET 7-63, NET 9-7

presentation layer

described, NET 2-7

GIOP, NET 2-14, NET 4-13, NET 4-18, NET 7-51, NET 7-52, NET 9-7, NET C-51, NET C-55

oracle.aurora.server.GiopServer, NET 9-7

oracle.aurora.server.SGiopServer, NET 7-52, NET 9-7

TTC, NET 2-11, NET 4-18, NET 9-7, NET C-51, NET C-55

Two-Task Common (TTC), NET 2-11, NET 4-18, NET 9-7, NET C-51, NET C-55

PRESENTATION parameter, NET 4-18, NET 7-55, NET C-55

PRESERVE BLANKS keyword

SQL*Loader, SUT 5-87

PRESERVE SNAPSHOT LOG clause

of TRUNCATE, SQL 7-582

PRESERVE SNAPSHOT LOG option

TRUNCATE TABLE command, REP 7-26

presorting data for a direct path load

example, SUT 4-25

PRESPAWN_DESC parameter, NET C-61

PRESPAWN_LIST parameter, NET C-61

PRESPAWN_MAX parameter, NET 2-24, NET 6-73, NET C-60

role in listener-created server, NET 2-24

prespawned dedicated servers, NET 2-23

configuring, NET 6-73

number of, NET 6-73

prestarted dedicated server process

see prespawned dedicated server process

prestarted dedicated servers

advantages and disadvantages, NET 3-10

recommended for, NET 3-10

primary

key, DDS 4-3

primary databases

preparing for use, SBR B-14

primary disk

recover for UNIX, LEG 5-10, LEG 5-19

PRIMARY KEY clause

of constraint_clause, SQL 7-222

of CREATE TABLE, SQL 7-369

PRIMARY KEY constraint, STU 6-10, STU 27-21

choosing a primary key, ADG 5 - 5

disabling, ADG 5 - 22, SAD 20-19

dropping associated indexes, SAD 16-15

enabling, ADG 5 - 22, SAD 20-19

enabling on creation, SAD 16-8

foreign key references when dropped, SAD 20-20

indexes associated with, SAD 16-8

multiple columns in, ADG 5 - 6

simple subquery snapshots and, REP 3-13

storage of associated indexes, SAD 16-8

UNIQUE key constraint vs., ADG 5 - 6

PRIMARY KEY constraints, SCN 28-11

constraint checking, SCN 28-20

described, SCN 28-11

indexes used to enforce, SCN 28-12

name of, SCN 28-12

maximum number of columns, SCN 28-12

NOT NULL constraints implied by, SCN 28-12

primary key constraints, SQL 7-222

enabling, SQL 7-382

index on, SQL 7-382

primary key OID

example, SUT 4-44

primary key OIDs, SUT 5-96

Primary Key REF Columns, SUT 5-98

primary key REF columns, SUT 5-98

primary key snapshots, REP A-3

primary keys, SCN 1-59, SCN 28-11

advantages of, SCN 28-11

defined, SCN 28-3

generating values for, SQL 7-349

Import, SUT 2-48

missing from replicated tables, REP 2-20

optimization, SCN 23-14

searches, SCN 23-40

upgrading snapshots, REP B-10

primary sites

ownership, REP 6-4

prime number, SPS A-7

principal, in Kerberos, OAS Glossary-5

print script command (RMAN), SBR 11-86

PRIOR collection method, PLS 4-23

PRIOR operator, SQL 3-16

PRIOR row operator, PLS 5-4, PLS 5-6

priority group members

dropping, REP 6-28

dropping by value, REP 6-27

priority groups, REP 6-23

adding members to, SPR 34 - 8, RAR 8-82, REP 6-25

altering members

priorities, SPR 34 - 17, RAR 8-93, REP 6-27

values, SPR 34 - 18, RAR 8-94, REP 6-26

and site priority, RAR 6-12, REP 6-22

creating, SPR 34 - 41, RAR 8-119, REP 6-25

dropping, SPR 34 - 49, RAR 8-129, REP 6-28

dropping members

by priority, REP 6-28

by value, REP 6-27

removing members from, SPR 34 - 49, SPR 34 - 50, RAR 8-128, RAR 8-130

site priority groups

adding members to, SPR 34 - 9, RAR 8-84

using for conflict resolution, REP 6-23

priority level of sites

altering, REP 6-30

priority_groups, REP 6-22

private

rollback segments, SAD 21-8

taking offline, SAD 21-12

synonyms, SAD 15-11

private database links, NET 2-36, NET 6-22

private object, PLS 8-14

private rollback segment

acquisition, SPS 6-8

creating, SPS 14-5

individual parameter file, SPS 18-5

specifying, SPS 6-9

private rollback segments, SCN 4-26

specifying, SRF 1-110

private SQL area

association with cursors, PC_ 2-8, PCO 5-11

definition of, PC_ 2-8

opening, PCO 5-11

opening of, PC_ 2-8

purpose, PCO D-9

purpose of, PC_ C-9

private SQL areas, STU 19-9

cursors and, ADG 8 - 9, SCN 7-9

described, SCN 7-8

how managed, SCN 7-9

persistent areas, SCN 7-8

runtime areas, SCN 7-8

private thread, SPS 14-8

PRIVATE_SGA parameter

of ALTER PROFILE, SQL 7-64

of ALTER RESOURCE COST, SQL 7-69

of CREATE PROFILE, SQL 7-340

PRIVATE_SGA variable, STU 23-6

privilege

ALTER SYSTEM, SPS 21-10

privileges, OAS 9-11, SAD 24-2, SAD 24-3, SUT 2-11

adding datafiles to a tablespace, SAD 10-5

adding redo log groups, SAD 6-11

administrator, SCN 5-3

connections audited, SCN 31-5

OUTLN schema, SCN 22-6

statement execution not audited, SCN 31-5

altering

default storage parameters, SAD 9-8

dispatcher privileges, SAD 4-7

indexes, SAD 16-13

named user limit, SAD 23-6

passwords, SAD 23-16

role authentication, SAD 24-6

rollback segments, SAD 21-9

sequences, SAD 15-10

tables, SAD 14-10

users, SAD 23-15

altering sequences, ADG 3 - 37

altering tables, ADG 3 - 10

analyzing objects, SAD 20-3

application developers and, SAD 22-9

audit object, SAD 25-11

auditing system, SAD 25-10

auditing use of, SAD 25-9, SCN 1-44, SCN 31-7

bringing datafiles offline and online, SAD 10-8

bringing tablespaces online, SAD 9-10

cascading revokes, SAD 24-14

checked when parsing, SCN 16-11

closing a database link, DDS 4-2

cluster creation, ADG 6 - 16, SAD 17-6

coalescing tablespaces, SAD 9-9

column, SAD 24-12

committing in-doubt transactions, DDS 3-31

complete export, SUT 1-44

CREATE SCHEMA command, SAD 20-2

creating

roles, SAD 24-4

rollback segments, SAD 21-7

sequences, SAD 15-10

synonyms, SAD 15-12

tables, SAD 14-9

tablespaces, SAD 9-4

users, SAD 23-11

views, SAD 15-2

creating for Export, SUT 1-9

creating integrity constraints, ADG 5 - 19

creating tables, ADG 3 - 8

creating triggers, ADG 13 - 25

cumulative export, SUT 1-44

database administrator, SAD 1-4

deleting rows from snapshot logs, REP 7-25

disabling automatic archiving, SAD 7-9

dropping

clusters, SAD 17-10

indexes, SAD 16-15

online redo log members, SAD 6-15

redo log groups, SAD 6-14

roles, SAD 24-9

rollback segments, SAD 21-14

sequences, SAD 15-11

synonyms, SAD 15-12

tables, SAD 14-12

views, SAD 15-9

dropping a view, ADG 3 - 27

dropping profiles, SAD 23-21

dropping sequences, ADG 3 - 42

dropping tables, ADG 3 - 11

dropping triggers, ADG 13 - 29

enabling and disabling resource limits, SAD 23-21

enabling and disabling triggers, SAD 20-12

enabling automatic archiving, SAD 7-8

enabling roles and, ADG 12 - 13

Export and, SUT 1-4

for changing session limits, SAD 23-5

forcing a log switch, SAD 6-16

function-based indexes, SCN 10-26, SCN 21-8

granting, ADG 12 - 16, ADG 12 - 17, SCN 1-41, SCN 30-3, SCN 30-4

about, SAD 24-9

examples of, SCN 30-9, SCN 30-10

object privileges, SAD 24-10

required privileges, SAD 24-10

system privileges, SAD 24-9

grouping into roles, SCN 1-41

grouping with roles, SAD 24-4

incremental export, SUT 1-44

index creation, ADG 6 - 5

individual privilege names, SAD 24-2

job queues and, SAD 8-4

listing grants, SAD 24-21

managing, ADG 12 - 10, ADG 12 - 16

managing with procedures, DDS 2-25

managing with synonyms, DDS 2-24

managing with views, DDS 2-22

manually acquiring locks, ADG 8 - 16

manually archiving, SAD 7-10

NetWorker User program, LEG D-1

object, SAD 24-3

on selected columns, ADG 12 - 19, SAD 24-13

operating system

required for database administrator, SAD 1-4

overview of, SCN 1-41, SCN 30-2

partitioned tables and indexes, SCN 11-62

policies for managing, SAD 22-5

procedures, SCN 30-7

creating and altering, SCN 30-9

executing, SCN 18-18, SCN 30-7

in packages, SCN 30-9

recompiling packages, SAD 20-25

recompiling procedures, SAD 20-25

recompiling triggers, ADG 13 - 28

recompiling views, SAD 20-25

remote login, SRF 1-107

renaming

datafiles of a tablespace, SAD 10-9

datafiles of several tablespaces, SAD 10-10

objects, SAD 20-2

redo log members, SAD 6-12

renaming objects, ADG 3 - 48

replacing views, ADG 3 - 25, SAD 15-8

required for SQL*Loader, SUT 3-15

required to create procedures, DCI 5-7

RESTRICTED SESSION, SCN 29-20

RESTRICTED SESSION system privilege, SAD 3-4, SAD 3-8

RESTRICTED_SESSION privilege, SRF 1-54, SRF 1-55

revoked

object dependencies and, SCN 21-6

revoking, ADG 12 - 16, ADG 12 - 18, ADG 12 - 19, SAD 24-13, SCN 30-3, SCN 30-4

ADMIN OPTION, SAD 24-13

GRANT OPTION, SAD 24-13

object privileges, SAD 24-15

system privileges, SAD 24-12

revoking object, SAD 24-13

revoking object privileges, SAD 24-13

roles, SCN 30-16

restrictions on, SCN 30-20

rolling back in-doubt transactions, DDS 3-31

schema object, SCN 30-3

DML and DDL operations, SCN 30-5

granting and revoking, SCN 30-4

overview of, SCN 1-41

packages, SCN 30-9

procedures, SCN 30-7

See also grants, roles

sequence creation, ADG 3 - 37

setting resource costs, SAD 23-20

stored procedure execution, ADG 10 - 53

synonym creation, ADG 3 - 43

system, SAD 24-2, SCN 30-2

granting and revoking, SCN 30-3

overview of, SCN 1-41

user-defined types, SCN 14-13

table-level select privileges, SRF 1-120, SRF 1-121

taking tablespaces offline, SAD 9-10

to start up or shut down a database, SCN 5-3

trigger privileges, SCN 30-8

triggers, ADG 13 - 25

truncating, SAD 20-10

user-defined types

acquired by role, SCN 14-13

ALTER ANY TYPE, SCN 14-13

checked when pinning, SCN 14-16

column level for object tables, SCN 14-16

CREATE ANY TYPE, SCN 14-13

CREATE TYPE, SCN 14-13

DELETE, SCN 14-15, SCN 14-16

DROP ANY TYPE, SCN 14-13

EXECUTE, SCN 14-13, SCN 14-14

EXECUTE ANY TYPE, SCN 14-13, SCN 14-14

EXECUTE ANY TYPE with ADMIN OPTION, SCN 14-14

EXECUTE with GRANT option, SCN 14-14

INSERT, SCN 14-15, SCN 14-16

SELECT, SCN 14-15, SCN 14-16

system privileges, SCN 14-13

UPDATE, SCN 14-15, SCN 14-16

using, SCN 14-13, SCN 14-17

using a view, ADG 3 - 27

using sequences, ADG 3 - 41

view creation, ADG 3 - 24

views, SCN 30-6

creating, SCN 30-6

using, SCN 30-6

privileges. See system privileges or object privileges.

privileges, LSM administrators, LEG 2-27

PRO, SMS 45-1

Pro*Ada

upgrading to SQL*Module for Ada, MIG 8-19

Pro*C/C++, GTK 2-81

applications, ADG 1 - 20

associative access, ADG 19 - 14

connecting with SYSDBA privileges, MIG 8-18

converting between Oracle and C types, ADG 19 - 15

features, ADG 1 - 21

interoperability with Oracle7, MIG 9-5

navigational access, ADG 19 - 14

new features, ADG 1 - 22

processing SQL statements, SCN 16-10

user-defined datatypes, SCN 13-14

with Oracle objects, ADG 19 - 14

Pro*C/C++ Precompiler

common uses for, PC_ 1-3

new database types, PC_ 17-35

new features, PC_ A-1 to PC_ A-6

object support in, PC_ 17-1

runtime context, PC_ 5-46

support for NLS, PC_ 4-49

use of PL/SQL with, PC_ 7-6

using OTT with, PC_ 19-22

Pro*COBOL, GTK 2-82

applications, ADG 1 - 23

connecting with SYSDBA privileges, MIG 8-19

features, ADG 1 - 24

how it works, PCO 1-2

new features, ADG 1 - 25

proactive tuning, STU 2-1

procedural abstraction, PLS 9-2

procedural database extension, PC_ 7-4

Procedural Option

required for migration, MIG 3-9, MIG 4-7

procedural replication, REP 1-14, SCN 34-15

conflicts and, REP 8-3

deleting and, REP 8-28

detecting conflicts, REP 1-15, SCN 34-16

generating support for, REP 8-3

restrictions, REP 8-2

using, REP 8-2

wrapper, REP 1-15, SCN 34-16

Procedural service, DDS 5-2

procedural services, DDS 6-8

Procedure, NET 7-65

procedure, PLS 7-1, PLS 7-3

body, PLS 7-4

calling, PLS 7-5

parameter, PLS 7-3

parts, PLS 7-4

specification, PLS 7-4

syntax, PLS 11-127

procedure calls

remote, DDS 1-12, SCN 33-12

procedure specification

of CREATE TYPE, SQL 7-416

procedures, SCN 16-15, SCN 18-1, SCN 18-6, SCN 21-8

3GL, calling, SQL 7-297

advantages of, SCN 18-7

attributes, OCI 6-8

auditing, SCN 31-8

called by triggers, ADG 13 - 20

calling, SQL 7-210

changing the declaration of, SQL 7-62

changing the definition of, SQL 7-62

contrasted with anonymous blocks, SCN 18-9

contrasted with functions, SCN 1-56, SCN 18-2

creating, SQL 7-333

current user, SCN 18-10

cursors and, SCN 16-18

declaring as a Java method, SQL 7-335

declaring as C functions, SQL 7-335

definer rights, SCN 18-9, SCN 30-7

roles disabled, SCN 30-20

dependency tracking in, SCN 21-6

deterministic functions, SCN 23-9

examples of, SCN 18-6, SCN 30-9, SCN 30-10

executing, SCN 16-16, SCN 18-18, SQL 7-210

external, ADG 11 - 3, SQL 7-333

external procedures, SCN 16-20, SCN 18-11

external reference in, SCN 18-10, SCN 18-19

granting

system privileges on, SQL 7-498

INVALID status, SCN 21-2, SCN 21-6

invalidating local objects dependent on, SQL 7-467

invoker rights, SCN 18-9, SCN 30-8

roles used, SCN 30-20

supplied packages, SCN 30-8

issuing COMMIT or ROLLBACK statements, SQL 7-79

location transparency using, DDS 2-24

naming rules, SQL 2-69

prerequisites for compilation of, SCN 21-5

privileges

create or alter, SCN 30-9

executing, SCN 30-7

executing in packages, SCN 30-9

privileges executed with, SQL 7-415

recompiling, SAD 20-25, SQL 7-62

re-creating, SQL 7-334

remote

error handling, DDS 4-11

remote procedure calls, SCN 33-12

removing from the database, SQL 7-467

schema executed in, SQL 7-415

security enhanced by, SCN 18-7, SCN 30-8

shared pool, SRF 1-49, SRF 1-115, SRF 1-116

shared SQL areas and, SCN 7-10

specifying schema and privileges for, SQL 7-335

stored procedures, SCN 16-15, SCN 16-18, SCN 18-2

storing, SCN 18-17

supplied packages, SCN 18-16

invoker or definer rights, SCN 30-8

synonyms for, SQL 7-355

triggers, SCN 20-2

validity of, SCN 18-18

process

and memory contention in parallel processing, STU 26-10

classes of parallel execution, STU 26-37, STU 26-39, STU 26-72, STU 27-4

dispatcher process configuration, STU 21-9

DSS, STU 27-3

handle attributes, OCI A-49

maximum number, STU 17-6, STU 27-2

maximum number for parallel query, STU 27-2

OLTP, STU 27-3

overhead, STU 27-3

prestarting, STU 22-2

priority, STU 24-2

scheduler, STU 24-2

scheduling, STU 18-4

process architecture for distributed external procedures, DDS 5-6

process failures, SBR 1-12

definition, SBR 1-12

process free list

definition, SPS 11-5

pinging of segment header, SPS 11-6

process global area (PGA), SCN 7-14

See also program global area

process handle, OCI 2-12

process monitor process (PMON)

cleans up timed-out sessions, SCN 29-18

described, SCN 1-19, SCN 8-11

network failure, SCN 32-3

parallel DML process recovery, SCN 26-41

process failure, SCN 32-3

process startup enqueue, SRF B-2

process startup wait event, SRF A-45

processes, SAD 4-1, SCN 8-2

archiver (ARCn), SCN 1-19, SCN 8-12, SCN 32-19

background, SCN 1-18, SCN 8-5

diagrammed, SCN 8-6

block server (BSP), SCN 27-6

checkpoint (CKPT), SCN 1-19, SCN 8-11

checkpoints and, SCN 8-8

database writer (DBWn), SCN 1-18, SCN 8-8

dedicated server, SCN 8-19

derived parameter values, SRF 1-125

dispatcher (Dnnn), SCN 1-20, SCN 8-14

dispatcher process maximum number, SRF 1-75

distributed transaction resolution, SCN 8-12

during recovery, SCN 32-12

failure in, SCN 32-3

job queue (SNPn), SCN 1-20, SCN 8-13

message propagation, SCN 19-10

listener, SCN 6-6, SCN 8-14

shared servers and, SCN 8-16

lock (LCK0), SCN 1-20, SCN 8-13

log writer (LGWR), SCN 1-19, SCN 8-9

maximum shared server processes, SRF 1-75

multiple-process Oracle, SCN 8-2

multi-threaded server, SCN 8-16

artificial deadlocks and, SCN 8-19

client requests and, SCN 8-17

number of server processes, SRF 1-76, SRF 1-103

Oracle, SCN 1-17, SCN 8-5

overview of, SCN 1-17

parallel execution coordinator, SCN 26-6

direct-load INSERT, SCN 25-3

parallel execution servers, SCN 26-6

direct-load INSERT, SCN 25-3, SCN 25-8

NEXT extent size, SCN 25-9

process monitor (PMON), SCN 1-19, SCN 8-11

queue monitor (QMNn), SCN 1-20, SCN 8-13, SCN 19-6

recoverer (RECO), SCN 1-20, SCN 8-12

and in-doubt transactions, SCN 1-36

recovery, SRF 1-104, SRF 1-106

server, SCN 1-18, SCN 1-34, SCN 8-5

dedicated, SCN 8-22

shared, SCN 8-14, SCN 8-19

shadow, SCN 8-22

SNP background processes, SAD 8-2

structure, SCN 8-2

system monitor (SMON), SCN 1-19, SCN 8-11

trace files, SRF 1-126

trace files for, SCN 8-14

user, SCN 1-17, SCN 8-4

allocate PGAs, SCN 7-14

manual archiving by, SCN 32-21

recovery from failure of, SCN 8-11

sharing server processes, SCN 8-14

user processes, SRF 1-103

PROCESSES parameter, PSC 6-10, SPS 18-10, SRF 1-103

calculating non-PCM resources, SPS 16-4

ensuring LM lock capacity, SPS 16-6

setting before database creation, SAD 2-12

Processes setting

Create New Scheduled Link property sheet, REP 2-13

processing

DDL statements, SCN 16-14

distributed, SCN 1-33

DML statements, SCN 16-10

overview, SCN 16-8

parallel SQL, SCN 26-2

queries, SCN 16-12

processing, distributed, STU 3-9

processor affinity

parallel execution, SPS A-15

PRODUCT_COMPONENT_VERSION view, SRF 2-177

productivity, PLS 1-22

products not yet supported, OAS 1-15

PROFILE clause

of ALTER USER. See CREATE USER.

of CREATE USER, SQL 7-427

profiles, SAD 23-17

altering, SAD 23-19

assigning to a user, SQL 7-427

assigning to users, SAD 23-18

composite limit, SAD 23-19

configuring, NET 7-15

creating, SAD 23-18, SQL 7-338

examples, SQL 7-341

deassigning from users, SQL 7-468

default, SAD 23-18

disabling resource limits, SAD 23-21

dropping, SAD 23-21

enabling resource limits, SAD 23-21

granting

system privileges on, SQL 7-498

listing, SAD 23-22

managing, SAD 23-17

modifying, examples, SQL 7-66

overview of, SCN 1-43

password management, SCN 29-7

privileges for dropping, SAD 23-21

privileges to alter, SAD 23-19

privileges to set resource costs, SAD 23-20

PUBLIC_DEFAULT, SAD 23-18

removing from the database, SQL 7-468

resource limits, SRF 1-108, SRF 1-109

setting a limit to null, SAD 23-19

viewing, SAD 23-24

when to use, SCN 29-18

profiles (SQLNET.ORA)

configuration file sample, NET B-2

configuration parameter reference, NET C-7 to NET C-30

configuring, NET 7-15

configuring advanced options, NET 7-23

configuring domains, NET 7-16

configuring preferred Oracle Names servers, NET 7-20

description, NET 6-6

prioritizing naming methods, NET 7-18

routing connection requests, NET 7-26

program global area (PGA), SCN 1-17, SCN 7-14

allocation of, SCN 7-14

contents of, SCN 7-14

effect of MAX_ENABLED_ROLES on, SAD 24-8

multi-threaded servers, SCN 8-19

nonshared and writable, SCN 7-14

size of, SCN 7-15

program interface, SCN 8-25

Oracle side (OPI), SCN 8-25

overview of, SCN 1-20

structure of, SCN 8-25

two-task mode in, SCN 8-23

user side (UPI), SCN 8-25

program interfaces, GTK 2-77 to GTK 2-87

Program Name option, NET 7-69

PROGRAM parameter, NET 6-78, NET 7-66, NET 7-69, NET C-59

program termination, PCO 3-26

normal versus abnormal, PC_ 3-22

program unit, PLS 1-11

program units, SCN 1-25, SCN 16-15, SCN 18-2

prerequisites for compilation of, SCN 21-5

shared pool and, SCN 7-10

program units in PL/SQL, ADG 10 - 2

PROGRAM_ERROR exception, PLS 6-5

programmatic environments

for Oracle objects, ADG 19 - 1

Java, ADG 19 - 19

OCI, ADG 19 - 2

Oracle Objects for OLE, ADG 19 - 16

Pro*C/C++, ADG 19 - 14

programming guidelines, PC_ 2-11, PCO 2-11

programming language support, PCO 1-3

propagating changes

altering propagation method, SPR 34 - 22, RAR 8-98

Propagation, ADQ 1-13

propagation, ADQ 1-10

disabling, SPR 10 - 17, RAR 8-39

minimizing data, REP 6-42

mode of, REP 8-9

altering in a master site, REP 8-10

of changes

altering propagation method, SPR 34 - 14, RAR 8-89

parallel, REP 2-4, REP A-2

removing, MIG 12-32

security context of propagator, REP 8-7

serial, REP 2-4

setting default characteristics, REP 2-9

status of, SPR 10 - 6, RAR 8-25

propagation reduction, REP A-2

propagation scheduling capabilities, SCN 19-10

propagation, exception, PLS 6-12

propagator, REP 2-5

registering, RAR 8-34

propagator accounts

master sites, REP 2-8

property

CHARSETFORM, ADG 11 - 24

CHARSETID, ADG 11 - 24

INDICATOR, ADG 11 - 23

PROPS$ view

NCHAR and NLS, MIG 8-27

NCHAR character set, MIG 3-14

protected write mode, SPS 8-7

PROTOCOL (PRO or PROT) attribute, NET 7-32, NET 7-49, NET 7-54, NET 7-57, NET 9-4

PROTOCOL parameter, NET 6-73, NET 6-78

PROTOCOL, DCE address parameter, OAS 13-2

PROTOCOL_STACK parameter, NET 4-18, NET 7-55, NET C-54

protocol.EXCLUDED_NODES parameter, NET C-81

protocol.INVITED_NODES parameter, NET C-81

PROTOCOL.ORA, NET C-81

DCE address parameters in, OAS 13-10

parameter for CDS, OAS 13-12

protocols

configuration parameter reference, NET C-81

configuring address with, NET 6-76

configuring addresses, NET 6-78

selecting for network layout, NET 3-2

selecting multiple for network layout, NET 3-2

protocol.VALIDNODE_CHECKING parameter, NET C-81

Provides, NET 2-8, NET 2-18

proxy clause

of ALTER USER, SQL 7-180, SQL 7-181

proxy copy

overview, SBR 4-19

requirement, MIG 8-44

proxy only option (RMAN)

backup command, SBR 4-19

proxy option (RMAN)

backup command, SBR 4-19

PROXY_USERS view, SRF 2-177

prtvtoc command, LEG 5-7

pruning

partition, STU 26-51

using DATE columns, STU 26-52

pruning partitions, SCN 11-4, SCN 26-4, SCN 26-48

DATE datatype, SCN 11-22

EXPLAIN PLAN, SCN 11-22

index partitions, SCN 11-4

indexes, SCN 11-36

PRVTPOOL.PLB, STU 10-4

pseudocode, SCN 18-18

triggers, SCN 20-25

pseudocolumn, PLS 5-3

CURRVAL, PLS 5-3

LEVEL, PLS 5-4

NEXTVAL, PLS 5-3

ROWID, PLS 5-4

ROWNUM, PLS 5-5

pseudocolumns, PCO 4-6, SQL 2-51

CHECK constraints prohibit

LEVEL and ROWNUM, SCN 28-18

CURRVAL, PCO 4-6, SQL 2-51

LEVEL, PCO 4-7, SQL 2-53

modifying views, ADG 13 - 8, SCN 20-13

NEXTVAL, PCO 4-7, SQL 2-51

ROWID, SCN 12-15, SQL 2-54

ROWNUM, PCO 4-7, SQL 2-55

cannot use indexes, SCN 23-49

optimizing view queries, SCN 23-16, SCN 23-25

uses for, SQL 2-56

USER, SCN 30-7

pseudoinstruction, PLS 6-8

PSTUBTBL view, SRF 2-178

public

synonyms, SAD 15-11

PUBLIC clause

of CREATE ROLLBACK SEGMENT, SQL 7-345

of CREATE SYNONYM, SQL 7-356

of DROP DATABASE LINK, SQL 7-449

public database link

connected user, DDS 2-11

fixed user, DDS 2-10

public database links, NET 2-36, NET 6-22

dropping, SQL 7-449

public fixed user database link, DDS 2-10

public key infrastructure, SCN 29-5

public object, PLS 8-14

PUBLIC option

thread of redo, SRF 1-123

public rollback segment

bringing online, SPS 14-6

common parameter file, SPS 18-5

creating, SPS 14-6

owner, SPS 14-6

specifying, SPS 14-6

using by default, SPS 14-6

public rollback segments, SCN 4-26, SQL 7-345, SRF 1-110

making available for use, SAD 21-10

taking offline, SAD 21-12

using by default, SRF 1-110

public synonyms, SQL 7-356

dropping, SQL 7-474

PUBLIC thread, SPS 14-8

PUBLIC user group, SCN 29-14, SCN 30-19

granting and revoking privileges to, ADG 12 - 21, SAD 24-15

procedures and, ADG 12 - 22, SAD 24-16

validity of procedures, SCN 18-19

PUBLIC_DEFAULT profile

dropping profiles and, SAD 23-21

using, SAD 23-18

PUBLIC_DEPENDENCY view, SRF 2-178

publication

DDL statements, SCN 20-20

DML statements, SCN 20-20

logon/logoff events, SCN 20-19

system events

server errors, SCN 20-19

startup/shutdown, SCN 20-19

using triggers, SCN 20-18

public-key encryption, OAS Glossary-5

public/private key pairs, definition, OAS Glossary-5

PUBLICSYN view, SRF 2-178

publish-subscribe

_SYSTEM_TRIG_ENABLED parameter, OCI 9-33

advanced queueing, ADG 15 - 3

client notifications, ADG 15 - 3

COMPATIBLE parameter, OCI 9-30

concepts, ADG 15 - 4

database events, ADG 15 - 3

example, OCI 9-33

examples, ADG 15 - 6

functions, OCI 9-30

handle attributes, OCI 9-31, OCI A-37

introduction, ADG 15 - 2

notification callback, OCI 9-31

notification feature, OCI 9-29

subscription handle, OCI 9-31

publish/subscribe

client notification, GTK 2-38

database event publication, GTK 2-39

publishers, GTK 2-38

rules based subscriptions, GTK 2-38

subscribers, GTK 2-38

publish-subscribe functions, OCI 15-4

publish/subscribe support, SCN 19-10

asynchronous notification, SCN 19-11

event publication, SCN 20-18

listen capability, SCN 19-11

message propagation, SCN 19-9

rule-based subscriber, SCN 19-6

triggers, SCN 20-18

publish/subscribe, AQ based, GTK 2-38

purchase order example, ADG 16 - 3

object types, SCN 13-2, SCN 13-4

purge deferred transaction queue, RAR 2-6

PURGE SNAPSHOT LOG clause

of TRUNCATE, SQL 7-582

PURGE SNAPSHOT LOG option

TRUNCATE TABLE command, REP 7-26

PURGE_LOG procedure

DBMS_SNAPSHOT package, REP 7-24

purges

manual, REP 2-18

periodic

scheduling, REP 2-18

purging

deferred transaction queue, REP 2-16

RepCatLog table, SPR 34 - 63, RAR 8-146

snapshot logs, REP 7-24

statistics, SPR 34 - 63, RAR 8-147

purity level, ADG 10 - 61, DCI 5-6

purity rules, PLS 7-7

push deferred transaction queue, RAR 7-8

PUSH_JOIN_PRED hint, SCN 24-12, SQL 2-62, STU 7-65

PUSH_JOIN_PREDICATE parameter, SRF 1-103

PUSH_SUBQ hint, SQL 2-62

pushes

continuous

scheduling, REP 2-14, REP 2-17

periodic

scheduling, REP 2-14

PX local messages recv'd statistic, SRF C-4

PX local messages sent statistic, SRF C-5

PX remote messages recv'd statistic, SRF C-5

PX remote messages sent statistic, SRF C-5

---