P

P code, SCN 60

package bodies

creating, SQL 7-348

recompiling, SQL 7-64

re-creating, SQL 7-349

removing from the database, SQL 7-491

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

PACKAGE clause

of ALTER PACKAGE, SQL 7-65

package overview, SPR 1-2

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

package variables

i_am_a_refresh, SPR 48-4, RAR 8-235

packaged applications

scalability for, PSA 12-4

packaged cursors, PLS 5-12

packaged procedures

dropping, SQL 7-493

packaged subprograms, PLS 1-18, PLS 7-11

calling, PLS 8-7

overloading, PLS 8-15

packages, ADG 1-38, PLS 8-1, PLS 8-2, SCN 46, SCN 54

advantages, PLS 8-5

advantages of, SCN 58

as program units, SCN 1-55

associating statistics with, SQL 7-212

attributes, OCI 6-8

auditing, SCN 336

avoiding run-time compilation, SQL 7-64

bodiless, PLS 8-6

body, PLS 8-2

changing the declaration of, SQL 7-64

corruption, DCI 5-10

creating, ADG 9-15, SPR 1-3, SQL 7-344

DBMS_APPLICATION_INFO, GTK 3-28

DBMS_APPLICATION_INFO package, STU 3-7

DBMS_DDL

used for computing statistics, SAD 19-9

DBMS_DEBUG, GTK 3-80

DBMS_JOB, GTK 3-63, SAD 8-3

DBMS_LOB, GTK 3-34

DBMS_LOGMNR, SAD 7-30, SAD 7-31

DBMS_LOGMNR_D, SAD 7-28, SAD 7-29

DBMS_OLAP, GTK 3-22

DBMS_OUTPUT

example of use, ADG 9-3

DBMS_PROFILER, GTK 3-80

DBMS_REPAIR, GTK 3-40, SAD 20-2 to SAD 20-14

DBMS_RESOURCE_MANAGER, GTK 3-49, SAD 25-5, SAD 25-6, SAD 25-14, SAD 25-15

procedures (table of), SAD 25-3

DBMS_RESOURCE_MANAGER_PRIVS, GTK 3-49, SAD 25-5, SAD 25-14

procedures (table of), SAD 25-4

DBMS_RLS, GTK 3-69

DBMS_SESSION, SAD 25-17

DBMS_SHARED_POOL package, STU 13-4

DBMS_SPACE, SAD 12-15

DBMS_SQL, GTK 3-79

DBMS_STATS, GTK 3-26

used for computing statistics, SAD 19-8

DBMS_TRACE, GTK 3-80

DBMS_TRANSACTION package, STU 17-4

DBMS_UTILITY

used for computing statistics, SAD 19-9

DEBUG_EXTPROC, ADG 10-48

describing, OCI 6-2

disassociating statistics types from, SQL 7-492

DIUTIL package, STU 13-4

dropping, ADG 9-12

dynamic SQL, SCN 28

examples of, SCN 54, SCN 312, SCN 313

executing, SCN 25, SCN 61

for locking, SCN 250

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

initializing, PLS 8-8

internal, REP A-2

invoker rights, SQL 7-345

naming of, ADG 9-16

OUTLN_PKG, GTK 3-37, SCN 129

private, SCN 58

private versus public objects, PLS 8-15

privileges

divided by construct, SCN 312

executing, SCN 309, SCN 312

privileges for execution, ADG 9-52

privileges for recompiling, SAD 19-25

privileges required to create, ADG 9-16

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

product-specific, PLS 8-17

public, SCN 58

queuing, SCN 70

recompiling, SAD 19-25, SQL 7-64

redefining, SQL 7-64, SQL 7-345

referencing, SPR 1-5, PLS 8-7

registering with the database, STU 11-8

removing from the database, SQL 7-491

replication, REP 2-16

scope, PLS 8-6

serially reusable, PLS 5-65

serially reusable packages, ADG 9-70

session state and, ADG 9-17, SCN 112

shared SQL areas and, SCN 7-10

specification, PLS 8-2

specifying schema and privileges of, SQL 7-345

STANDARD package, STU 13-4

storing, SCN 59

supplied packages, SCN 59

invoker or definer rights, SCN 311

synonyms, ADG 9-56

synonyms for, SQL 7-377

syntax, PLS 11-127

UTL_COLL, GTK 3-34

UTL_REF, GTK 3-80

validity of, SCN 61

where documented, ADG 9-17, SPR 1-6

PACKAGES clause

of ASSOCIATE STATISTICS, SQL 7-210, SQL 7-212

packaging deployment templates, RAR 4-11

packed decimal data, SUT 5-16

packets

example of trace data, NET 12-44

types of, NET 12-44

pad character

alternate mappings, NLS 4-10

padding of literal strings

SQL*Loader, SUT 5-46

page table, STU 18-5

PAGELEN

precompiler option, PC_ 10-35

PAGELEN precompiler option, PCO 14-34

pages, SCN 4-2

paging, OID 12-13, DWG 18-37, STU 16-5, STU 18-5

library cache, STU 19-16

rate, DWG 18-18

reducing, STU 19-4

SGA, STU 19-42

subsystem, DWG 18-37

paragraph names

associating with SQL statements, PCO 2-17

coding area for, PCO 2-18

PARALLEL

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

parallel ANALYZE, GTK 4-2

parallel automatic tuning, PSA 2-6

parallel backup operations, SCN 357

parallel backups, PSA 13-16

Parallel Cache Management

examples of, PSC 4-10

locks, minimizing number of, PSA 5-3

parallel cache management, PSC 4-8

parallel cache management lock

sequence, PSC 8-13

parallel cache management locks

acquiring, PSC 4-12

disowning, PSC 4-12

exclusive, PSC 4-12

how they work, PSC 5-31

null, PSC 4-12

owned by instance LCK processes, PSC 5-17

owned by multiple instances, PSC 5-17

periodicity, PSC 5-22

read, PSC 4-12

relative number, PSC 4-13

releasable, PSA 9-3, PSA 9-5

releasing, PSC 4-12

user control, PSC 4-13

PARALLEL clause, DWG 18-59, DWG 18-60

DEGREE keyword, MIG 9-35

INSTANCES keyword removed, MIG 9-35

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

of ALTER DATABASE, SQL 7-15

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

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

of ALTER MATERIALIZED VIEW LOG, SQL 7-59, SQL 7-60

of ALTER TABLE, SQL 7-164

of CREATE CLUSTER, SQL 7-258

of CREATE INDEX, SQL 7-304

of CREATE MATERIALIZED VIEW / SNAPSHOT, SQL 7-319

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

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

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-323

of CREATE TABLE, SQL 7-388, SQL 7-405

parallelization rules, SCN 176

RECOVER statement, STU 24-15

PARALLEL CREATE INDEX statement, DWG 18-22

PARALLEL CREATE TABLE AS SELECT statement

external fragmentation, DWG 18-44

resources required, DWG 18-22

parallel database

availability, PSC 1-3

parallel DDL, SCN 187

extent allocation, SCN 190

functions, SCN 203

parallelism types, SCN 159

parallelization rules, SCN 176

partitioned tables and indexes, SCN 187

building local indexes, SCN 11-29

restrictions

LOBs, SCN 188

object types, SCN 186, SCN 188

parallel DELETE, SCN 177, SCN 178

parallel DML, GTK 3-46, GTK 4-4, SCN 192

applications, SCN 194

bitmap indexes, DWG 6-3, SCN 10-35

degree of parallelism, SCN 176, SCN 179

enabling PARALLEL DML, SCN 195

functions, SCN 203

lock and enqueue resources, SCN 199

parallelism types, SCN 159

parallelization rules, SCN 176

recovery, SCN 197

restrictions, SCN 200

object types, SCN 186, SCN 201

remote transactions, SCN 203

rollback segments, SCN 197

transaction model, SCN 196

parallel execution, SCN 158, STU 3-5

adjusting workloads, DWG 18-40

allocated from large pool, MIG B-10

and scalability, PSA 5-3

avoiding problems with, MIG 8-5

coordinator, SCN 147, SCN 162

direct-load INSERT, SCN 147

cost-based optimization, DWG 18-64

execution processing, PSC 8-12

full table scans, SCN 161

hints, STU 7-25

index creation, DWG 18-57

inter-operator parallelism, SCN 169

intra-operator parallelism, SCN 169

introduction, DWG 5-2

I/O parameters, DWG 18-25

limiting instances for, PSA 2-2

load balancing, PSA 2-5

maximum processes, DWG 18-34

method of, DWG 18-3

of DDL statements, SQL 7-84

of DML statements, SQL 7-84

parallel server, DWG 18-44

partitioned tables and indexes, SCN 160

plans, DWG 18-67

process classification, DWG 4-4

processor affinity, PSC A-17

query servers, STU 21-15

resource parameters, DWG 18-17

rewriting SQL, DWG 18-49

server, SCN 147, SCN 162

index maintenance, SCN 152

temporary segments, SCN 153

servers, SCN 162

direct-load INSERT

index maintenance, SCN 152temporary segments, SCN 153

solving problems, DWG 18-48

space management, DWG 18-43

tuning, DWG 5-1, DWG 18-2

tuning query servers, STU 21-15

understanding performance issues, DWG 18-33

using performance views to examine, PSA 2-6

See also parallel SQL

parallel execution servers, ADG 11-51

direct-load INSERT, SCN 147

PARALLEL hint, DWG 18-48, DWG 18-59, DWG 18-67, SCN 173, SQL 2-67, STU 7-25

parallelization rules, SCN 176

UPDATE and DELETE, SCN 178

parallel index scans, GTK 4-4

parallel joins

and PQ_DISTRIBUTE hint, STU 7-26

PARALLEL keyword

SQL*Loader, SUT 8-27

parallel load

example, DWG 14-15

Oracle Parallel Server, DWG 14-16

using, DWG 14-10

parallel loads, SUT 8-25

allocating extents, SUT 6-6

PARALLEL command-line parameter, SUT 6-6

restrictions on direct path, SUT 8-27

parallel mode

file operation restrictions, PSC A-19, PSC A-21, PSC B-3

instance number, SRF 1-47

recovery restrictions, PSC A-24

sequence restrictions, PSC 8-15, PSC B-3

startup, PSA 1-9

PARALLEL option, PSA 4-2, PSG 3-41, PSG 3-42

PARALLEL parameter

obsolete for 8.0.4, PSC A-7

parallel partition-wise joins

performance considerations, DWG 5-21

parallel processing

definition of, PSC 1-2

hardware for, PSC 2-1

when advantageous, PSC 8-5

parallel processor affinity, PSC A-17

parallel propagation, REP 2-36, REP A-5

dependency

tracking, REP 6-21

implementing, REP 2-37

planning for, REP 7-12

replication environment, REP 7-12

tuning, REP 2-38

parallel query, GTK 4-4, SCN 184

automated tuning, GTK 3-27

bitmap indexes, DWG 6-3, SCN 10-35

functions, SCN 203

idle time, SRF 1-12, SRF 1-96

index-organized tables, SCN 185

maximum number of instances, SRF 1-93

maximum number of servers, SRF 1-94

minimum number of queries, SRF 1-96

object types, SCN 186

restrictions, SCN 186

OPTIMIZER_PERCENT_PARALLEL, SRF 1-86

parallelization rules, SCN 176

restrictions for Oracle objects, ADO 6-38

parallel query option

number of server processes, SAD 4-17

parallelizing index creation, SAD 14-6

parallelizing table creation, SAD 13-4

query servers, SAD 4-17

parallel query, and SYS_CONTEXT, ADG 11-51

parallel recovery, PSA 14-7, PSA 14-14, PSA 14-16, SBR 5-19, SCN 351, SCN 357, STU 24-15

parallel scan operations, DWG 4-3

parallel server, PSC A-5

database configuration, PSC A-5

disk affinities, DWG 18-47

distributed locks, ADG 7-11

installation, PSC A-5

instance affinity for jobs, PSC A-6

listener load balancing, PSC A-5

Oradebug, PSC A-5

parallel execution tuning, DWG 18-44

sequence numbers and, ADG 2-30

Parallel Server Active Users by Instance chart, PSG 8-19

Parallel Server Active Users chart, PSG 8-18

Parallel Server Block Ping chart, PSG 8-7

Parallel Server Block Ping Tablespace Instance chart, PSG 8-8

Parallel Server Block Ping Tablespace Object chart, PSG 8-8

Parallel Server Data Block Ping by Instance chart, PSG 8-10

Parallel Server Data Block Ping chart, PSG 8-8

Parallel Server File I/O Rate by Instance chart, PSG 8-13

Parallel Server File I/O Rate by Object chart, PSG 8-12

Parallel Server File I/O Rate chart, PSG 8-11

Parallel Server Instances folder

in Console Navigator window, PSG 7-5

Parallel Server Instances Logon dialog box, PSG 6-31

Parallel Server Lock Activity chart, PSG 8-14

Parallel Server Manager, Oracle, GTK 3-62

Parallel Server Operation Results dialog box, PSG 7-12

PARALLEL SERVER parameter, SCN 5-7

parallel server processes

configuring for replication environments, REP 2-36

Parallel Server. See Oracle Parallel Server

Parallel Server Sessions chart, PSG 8-15

Parallel Server Shutdown dialog box, PSG 7-10

Parallel Server Shutdown Progress dialog box, PSG 7-11

Parallel Server Started message box, PSG 7-9

Parallel Server Startup dialog box, PSG 7-7

Parallel Server Startup Results dialog box, PSG 7-9

Parallel Server Startup/Shutdown Results dialog box, PSG 7-12

Parallel Server Stopped message box, PSG 7-12

Parallel Server Users Logged On by Instance chart, PSG 8-17

Parallel Server Users Logged On chart, PSG 8-16

parallel SQL, SCN 158

allocating rows to parallel execution servers, SCN 167

coordinator process, SCN 162

direct-load INSERT, SCN 147

degree of parallelism, SCN 172

instance groups, SCN 175

multi-threaded server, SCN 164

number of parallel execution servers, SCN 163

optimizer, SCN 166

Parallel Server and, SCN 157

parallelization rules, SCN 176

server processes, SCN 162

direct-load INSERT, SCN 147, SCN 152, SCN 153

summary or rollup tables, SCN 188

See also parallel execution

parallel transaction recovery

changes for 8.1, PSC A-4

parallel UPDATE, SCN 177, SCN 178

PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, SRF 1-91

PARALLEL_ADAPTIVE_MULTI_USER parameter, DWG 18-6, DWG 18-29

of ALTER SYSTEM, SQL 7-115

PARALLEL_ADAPTIVE_MULTIUSER parameter, PSA 2-6

PARALLEL_AUTOMATIC_TUNING initialization parameter, SRF 1-92

PARALLEL_AUTOMATIC_TUNING parameter, DWG 18-3

PARALLEL_BROADCAST_ENABLE initialization parameter, SRF 1-93

PARALLEL_BROADCAST_ENABLE parameter, DWG 18-21

PARALLEL_BROADCAST_ENABLED initialization parameter, SRF 1-93

PARALLEL_BROADCAST_ENABLED parameter

of ALTER SESSION, SQL 7-92

PARALLEL_DEFAULT_MAX_INSTANCES initialization parameter: obsolete

PARALLEL_DEFAULT_MAX_INSTANCES parameter

obsolete for 8.1, PSC A-6

PARALLEL_DEGREE_LIMIT_ABSOLUTE resource allocation method, SAD 25-10

PARALLEL_ENABLE clause

of CREATE FUNCTION, SQL 7-288

PARALLEL_ENABLE keyword, ADG 9-63

PARALLEL_ENABLE option, PLS 7-6

PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, SRF 1-93

PARALLEL_EXECUTION_MESSAGE_SIZE parameter, DWG 18-20

PARALLEL_INDEX hint, SCN 173, SQL 2-67

PARALLEL_INSTANCE_GROUP initialization parameter, SRF 1-94

PARALLEL_INSTANCE_GROUP parameter, PSA 2-4

of ALTER SESSION, SQL 7-92

of ALTER SYSTEM, SQL 7-115

PARALLEL_MAX_SERVERS initialization parameter, REP 2-37, REP 7-6, SAD 4-18, SRF 1-94, STU 24-15

PARALLEL_MAX_SERVERS parameter, DWG 14-27, DWG 18-8, DWG 18-9, DWG 18-38, PSA 14-14, PSA 14-16, SCN 164, STU 24-15

and parallel execution, DWG 18-8

ensuring LM lock capacity, PSA 10-3

PARALLEL_MIN_MESSAGE_POOL initialization parameter: obsolete

PARALLEL_MIN_PERCENT initialization parameter, SRF 1-95

PARALLEL_MIN_PERCENT parameter, DWG 18-9, DWG 18-16, SCN 175

of ALTER SESSION parameter, SQL 7-92

PARALLEL_MIN_SERVERS initialization parameter, REP 2-37, REP 7-6, SAD 4-18, SRF 1-96

PARALLEL_MIN_SERVERS parameter, DWG 18-10, SCN 163, SCN 165

PARALLEL_SERVER initialization parameter, SRF 1-96

PARALLEL_SERVER parameter, PSA 1-11, PSA 4-2

new for 8.0., PSC A-7

PARALLEL_SERVER_ INSTANCES parameter, PSA 1-12

PARALLEL_SERVER_IDLE_TIME initialization parameter, SAD 4-18, SRF 1-12, SRF 1-96

PARALLEL_SERVER_IDLE_TIME initialization parameter: obsolete

PARALLEL_SERVER_INSTANCES initialization parameter, SRF 1-96

PARALLEL_SERVER_INSTANCES parameter, PSA 1-8

and parallel execution, DWG 18-17

PARALLEL_THREADS_PER_CPU initialization parameter, SRF 1-97

PARALLEL_THREADS_PER_CPU parameter, DWG 18-3, DWG 18-7

of ALTER SYSTEM, SQL 7-116

PARALLEL_TRANSACTION_RECOVERY parameter

changes for 8.1, PSC A-4

PARALLEL_TRANSACTION_RESOURCE_TIMEOUT initialization parameter: obsolete

parallelism

degree, SCN 171

degree, overriding, DWG 18-48

enabing for tables and queries, DWG 18-6

OPTIMIZER_PERCENT_PARALLEL, SRF 1-86

parallelism attribute, server resource, LEG 2-26

parallelization

channels, RMN 1-31

factors affecting degree of, RMN 1-31

of backups using RMAN, RMN 1-45, RMN 5-24

RMAN backups, RMN 1-45, RMN 5-24

parallelization of aggregate distinct queries, GTK 3-25

parameter

database creation, PSA 3-3

obsolete, PSC A-23

parameter aliasing, PLS 7-22

parameter descriptor, OCI 2-16

attributes, OCI 6-5, OCI A-25

parameter descriptor object, OCI 11-23

parameter file

comments, SUT 1-13, SUT 2-27

Export, SUT 1-12, SUT 1-22

Import, SUT 2-9, SUT 2-25

maximum size

Export, SUT 1-13

parameter files, STU 11-4

See also initialization parameter files.

backing up, PSA 13-1

common file, PSA 1-5

duplicate values, PSA 1-3

identical parameters, PSA 1-9

IFILE parameter, PSA 1-4

include file parameter, PSA 1-4

initialization, PSA 1-2

instance specific, PSA 1-2

instance specific, conditions requiring, PSA 1-3

instance-specific, PSA 1-3 to PSA 1-4

location, PSA 1-3

naming conventions for, PSA 1-2

non-default, PSA 1-2

PFILE, PSA 1-4, PSA 1-5

remote instance, PSA 1-4, PSA 1-5

remote instances, PSA 4-4

parameter mode, PCO 6-5

parameter modes, PC_ 7-3

parameter passing

by reference, PLS 7-22

by value, PLS 7-22

in dynamic SQL, PLS 10-6

parameters, NET B-3

actual versus formal, PLS 7-12

ANALYZE, SUT 2-18

attributes, OCI 6-5

authentication, OAS B-1

CyberSafe, OAS B-2

Identix, OAS B-2

Kerberos, OAS B-5

RADIUS, OAS B-6

SSL, OAS B-11

BUFFER

Export, SUT 1-16

buffer lengths, OCI 15-3

calendar, NLS 2-17

cman.ora configuration reference, NET C-70 to NET C-76

collation, NLS 2-27

COMMIT

Import, SUT 2-19

COMPATIBLE, DWG 14-13, DWG 19-5

COMPRESS, SUT 1-17

configuration for JDBC, OAS 3-5

conflicts between export parameters, SUT 1-28

CONSTRAINTS

Export, SUT 1-19

cursor, PLS 5-8

database creation, PSA 3-3, PSC 7-21

date, NLS 2-13

DB_BLOCK_SIZE, DWG 18-25

DB_FILE_MULTIBLOCK_READ_COUNT, DWG 18-26

default values, ADG 9-9, PLS 7-20

with stored functions, ADG 9-59

deployment templates, RAR 4-7

DESTROY

Import, SUT 2-20

DIRECT

Export, SUT 1-19

DISK_ASYNCH_IO, DWG 18-26

DML_LOCKS, DWG 18-23, DWG 18-25

embedded parameter files, SRF 1-4

encryption and checksumming, OAS 2-11

ENQUEUE_RESOURCES, DWG 18-23, DWG 18-25

Export, SUT 1-13

FAST_START_PARALLEL_ROLLBACK, DWG 18-23

FEEDBACK

Export, SUT 1-19

Import, SUT 2-20

FILE

Export, SUT 1-19

Import, SUT 2-20

for Migration utility. See command-line options

FREELISTS, DWG 18-56

FROMUSER

Import, SUT 2-21

FULL

Export, SUT 1-21

GC_FILES_TO_LOCKS, DWG 18-44

GC_ROLLBACK_LOCKS, DWG 18-45

GC_ROLLBACK_SEGMENTS, DWG 18-45

GRANTS

Export, SUT 1-21

Import, SUT 2-22

HASH_AREA_SIZE, DWG 18-18, DWG 18-38, DWG 18-39

HASH_MULTIBLOCK_IO_COUNT, DWG 18-26

HELP

Export, SUT 1-21

Import, SUT 2-22

IGNORE

Import, SUT 2-22

in syntax diagrams, RMN 10-3, SQL xi

INCTYPE

Export, SUT 1-21

Import, SUT 2-23

INDEXES

Export, SUT 1-22

Import, SUT 2-24

INDEXFILE

Import, SUT 2-24

initialization, PSA 1-1, SCN 5-4

locking behavior, SCN 229

See also initialization parameters

JOB_QUEUE_INTERVAL, DWG 14-19

JOB_QUEUE_PROCESSES, DWG 14-19

LARGE_POOL_SIZE, DWG 18-10

ldap.ora configuration reference, NET C-78

listener.ora configuration reference, NET C-48 to NET C-58

LOG, SUT 1-40

Export, SUT 1-22

Import, SUT 2-25

LOG_BUFFER, DWG 18-23

modes, ADG 9-6, DCI 13-2, OCI 15-2, OCI 18-2, PLS 7-14

monetary, NLS 2-22

MULTIBLOCK_READ_COUNT, DWG 14-13

names.ora configuration reference, NET C-59 to NET C-69

National Language Support, SCN 5-5

NLS default values, NLS A-25

NLS_CALENDAR, NLS 2-20

NLS_COMP, NLS 2-32

NLS_CREDIT, NLS 2-23, NLS 2-27

NLS_CURRENCY, NLS 2-23

NLS_DATE_FORMAT, NLS 2-14

NLS_DATE_LANGUAGE, NLS 2-16

NLS_DEBIT, NLS 2-27

NLS_DUAL_CURRENCY, NLS 2-25

NLS_ISO_CURRENCY, NLS 2-24

NLS_LANGUAGE, NLS 2-8

NLS_LIST_SEPARATOR, NLS 2-33

NLS_MONETARY_CHARACTERS, NLS 2-26

NLS_NCHAR, NLS 2-34

NLS_NUMERIC_CHARACTERS, NLS 2-21

NLS_SORT, NLS 2-32, NLS 2-33

NLS_TERRITORY, NLS 2-10

numeric, NLS 2-21

obsolete for release 8.1, NET C-80

OPTIMIZED_PERCENT_PARALLEL, DWG 18-67

OPTIMIZER_MODE, DWG 14-28, DWG 18-64, DWG 19-5

OPTIMIZER_PERCENT_PARALLEL, DWG 14-28, DWG 18-21

optional, SQL A-2

Oracle protocols, NET B-3

OWNER

Export, SUT 1-22

PARALLEL_ADAPTIVE_MULTI_USER, DWG 18-29

PARALLEL_AUTOMATIC_TUNING, DWG 18-3

PARALLEL_BROADCAST_ENABLE, DWG 18-21

PARALLEL_EXECUTION_MESSAGE_SIZE, DWG 18-20

PARALLEL_MAX_SERVERS, DWG 14-27, DWG 18-8, DWG 18-9, DWG 18-38

PARALLEL_MIN_PERCENT, DWG 18-9, DWG 18-16

PARALLEL_MIN_SERVERS, DWG 18-10

PARALLEL_SERVER_INSTANCES, DWG 18-17

PARALLEL_THREADS_PER_CPU, DWG 18-3

PARFILE

Export, SUT 1-9, SUT 1-22

passing by reference, GTK 3-80

passing strings, OCI 2-31

protocol.ora configuration reference, NET C-77

QUERY_REWRITE_ENABLED, DWG 19-5

RECORD

Export, SUT 1-23

RECORDLENGTH

Export, SUT 1-24

Import, SUT 2-26

required, SQL A-1

ROLLBACK_SEGMENTS, DWG 18-22

ROWS

Export, SUT 1-24

Import, SUT 2-26

SecurID, OAS B-5

SELF, PLS 9-9

setting, NLS 2-2

setting for multiple instances, PSA 1-7

SHARED_POOL_SIZE, DWG 18-10, DWG 18-16

SHOW

Import, SUT 2-26

SKIP_INDEX_MAINTENANCE, SUT 6-9, SUT 8-20

SKIP_UNUSABLE_INDEXES, SUT 6-10, SUT 8-20

Import, SUT 2-26

SORT_AREA_SIZE, DWG 14-28, DWG 18-19

SORT_MULTIBLOCK_READ_COUNT, DWG 18-26

sqlnet.ora configuration reference, NET C-5 to NET C-30

STAR_TRANSFORMATION_ENABLED, DWG 16-4

STATISTICS

Export, SUT 1-24

storage, PSA 8-4, PSA 8-6, PSA 8-9, PSC 7-7, SCN 4-5, SCN 4-12

string length, OCI 15-3

TABLES

Export, SUT 1-25

Import, SUT 2-27

TABLESPACES, SUT 2-28

TAPE_ASYNCH_IO, DWG 18-26

that must be identical on all instances, PSA 1-8

that must be unique on all instances, PSA 1-8

time, NLS 2-13

tnsnames.ora configuration reference, NET C-31 to NET C-48

TOID_NOVALIDATE, SUT 2-28

TOUSER

Import, SUT 2-29

TRANSACTIONS, DWG 18-22

user values, RAR 4-9

USERID

Export, SUT 1-27

Import, SUT 2-30

UTL_FILE_DIR, DWG 14-19

PARAMETERS clause

of CREATE INDEX, SQL 7-304

PARAMETERS clause with external procedure, DCI 4-9

Parameters tab

from Create Job property sheet, PSG 7-23

PARENT_ID column

PLAN_TABLE table, STU 5-5

parentheses, PLS 2-43

parentheses, use of in method calls, ADO 2-8

PARFILE

Export command-line option, SUT 1-9, SUT 1-12, SUT 1-22

Import command-line option, SUT 2-9, SUT 2-25

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

PARSE

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

parse

definition of, PC_ 13-4

Parse Elapsed Time data view, STU 14-11

parse error offset, PCO 8-9

how to interpret, PC_ 9-15

use in error reporting, PC_ 9-15

PARSE procedure, DDS 9-3

Parse Statistics drilldown data view, STU 14-19

parse tree, ADG 13-28

parse trees, SCN 60

construction of, SCN 16

in shared SQL area, SCN 7-8

stored in database, SCN 60

parse(InputSource) - oracle.xml.parser.v2.XMLParser.parse(org.xml.sax.InputSource), JPR 4-123

parse(InputStream) - oracle.xml.parser.v2.XMLParser.parse(java.io.InputStream), JPR 4-123

parse(Reader) - oracle.xml.parser.v2.XMLParser.parse(java.io.Reader), JPR 4-123

parse(String) - oracle.xml.parser.v2.XMLParser.parse(java.lang.String), JPR 4-124

parse(URL) - oracle.xml.parser.v2.XMLParser.parse(java.net.URL), JPR 4-124

PARSED_PIECES view, SRF 2-155

PARSED_SIZE view, SRF 2-155

parseDocument() - oracle.xml.parser.v2.XMLTokenizer.parseDocument(), JPR 4-142

parseDTD(InputSource, String) - oracle.xml.parser.v2.DOMParser.parseDTD(org.xml.sax.InputSource, java.lang.String), JPR 4-17

parseDTD(InputStream, String) - oracle.xml.parser.v2.DOMParser.parseDTD(java.io.InputStream, java.lang.String), JPR 4-18

parseDTD(Reader, String) - oracle.xml.parser.v2.DOMParser.parseDTD(java.io.Reader, java.lang.String), JPR 4-18

parseDTD(String, String) - oracle.xml.parser.v2.DOMParser.parseDTD(java.lang.String, java.lang.String), JPR 4-19

parseDTD(URL, String) - oracle.xml.parser.v2.DOMParser.parseDTD(java.net.URL, java.lang.String), JPR 4-19

Parse/Execution Ratio data view, STU 14-10

parsing, SCN 20

DBMS_SQL package, SCN 28

embedded SQL, SCN 14

Oracle Forms, STU 19-11

Oracle precompilers, STU 19-10

parse calls, SCN 16

parse locks, SCN 20, SCN 240

performed, SCN 16

reducing unnecessary calls, STU 19-10

SQL statements, SCN 20, SCN 28

parsing dynamic statements

PREPARE statement, PC_ F-95, PCO F-74

PART statement in DB2

not allowed by SQL*Loader, SUT B-4

partial backups, SCN 366

partial partition-wise joins, DWG 5-17

partially dropped columns

dropping, MIG 13-15

PARTITION ... LOB storage clause

of ALTER TABLE, SQL 7-142

PARTITION BY HASH clause, SAD 15-10

of CREATE TABLE, SQL 7-402

PARTITION BY RANGE clause, SAD 15-8, SAD 15-11

of CREATE TABLE, SQL 7-386, SQL 7-403

PARTITION clause, SAD 15-8, SAD 15-10, SAD 15-11, SCN 11-63

of ANALYZE, SQL 7-203

of CREATE INDEX, SQL 7-302

of CREATE TABLE, SQL 7-403

of DELETE, SQL 7-466

of INSERT, SQL 7-542

of LOCK TABLE, SQL 7-548

of SELECT, SQL 7-575

of UPDATE, SQL 7-618

partition granules, DWG 5-4

partition views, GTK 7-6, SCN 11-11, STU 9-35

converting to partitioned table, SAD 15-34

migrate to partition tables, MIG 8-12

PARTITION_ID column

PLAN_TABLE table, STU 5-6

PARTITION_START column

PLAN_TABLE table, STU 5-6

PARTITION_STOP column

PLAN_TABLE table, STU 5-6

PARTITION_VIEW_ENABLED initialization parameter, SRF 1-97

PARTITION_VIEW_ENABLED parameter, STU 9-36

of ALTER SESSION, SQL 7-93

partitioned

indexes, NLS 4-9

tables, NLS 4-9

partitioned directories, OID 2-11

partitioned indexes, SAD 15-1 to SAD 15-35, SQL 2-70, SQL 7-295, SQL 7-302

adding partitions, SAD 15-15

creating local index on composite partitioned table, SAD 15-11

creating local index on hash partitioned table, SAD 15-10

creating range partitions, SAD 15-9

description, SAD 15-2

dropping partitions, SAD 15-18

global, SAD 15-3

local, SAD 15-3

maintenance operations, SAD 15-12 to SAD 15-32

table of, SAD 15-12

modifying partition default attributes, SAD 15-23

modifying real attributes of partitions, SAD 15-25

moving partitions, SAD 15-26

rebuilding index partitions, SAD 15-27

renaming index partitions/subpartitions, SAD 15-28

secondary indexes on index-organized tables, SAD 15-9

splitting partitions, SAD 15-30

user-defined, SQL 7-302

partitioned loads

concurrent conventional path loads, SUT 8-25

SQL*Loader, SUT 8-25

partitioned objects

and EXPLAIN PLAN statement, STU 5-14

partitioned tables, SAD 15-1 to SAD 15-35, SQL 2-70

adding partitions, SAD 15-14

adding subpartitions, SAD 15-15

and dropped partitions, SBR 7-18

and split partitions, SBR 7-23

coalescing partitions, SAD 15-16

converting partition views, SAD 15-34

creating composite partitions and subpartitions, SAD 15-11

creating hash partitions, SAD 15-10

creating range partitions, SAD 15-8, SAD 15-9

data warehouses, DWG 5-6

description, SAD 15-2

DISABLE ROW MOVEMENT, SAD 15-8

dropping partitions, SAD 15-16

ENABLE ROW MOVEMENT, SAD 15-8

example, DWG 14-13, SUT 4-34

exchanging partitions, SAD 15-19

exchanging subpartitions, SAD 15-20

export consistency and, SUT 1-17

exporting, SUT 1-8

global indexes on, SAD 15-3

importing, SUT 2-5, SUT 2-33

in DB2

no Oracle equivalent, SUT B-4

indexes and, REP A-8

index-organized tables, SAD 15-9

loading, SUT 8-6

local indexes on, SAD 15-3

maintenance operations, SAD 15-12 to SAD 15-32

table of, SAD 15-12

marking indexes UNUSABLE, SAD 15-14, SAD 15-16, SAD 15-17, SAD 15-19, SAD 15-21, SAD 15-24, SAD 15-25, SAD 15-26, SAD 15-29, SAD 15-31

merging partitions, SAD 15-21

modifying partition default attributes, SAD 15-23

modifying real attributes of partitions, SAD 15-24

modifying real attributes of subpartitions, SAD 15-25

modifying subpartition default attributes, SAD 15-23

moving partitions, SAD 15-25

moving subpartitions, SAD 15-26

performing partial TSPITR, SBR 7-15

rebuilding index partitions, SAD 15-27

renaming partitions, SAD 15-28

renaming subpartitions, SAD 15-28

splitting partitions, SAD 15-29

truncating partitions, SAD 15-30

truncating subpartitions, SAD 15-32

partition-extended table names, SQL 2-70

in DML statements, SQL 2-71

restrictions on, SQL 2-71

syntax, SQL 2-71

partitioning, OID 2-18, DWG 11-7, GTK 2-11, GTK 4-2

"rolling window", GTK 2-11

and scalability, PSA 5-16

applications, PSA 5-7

batch processing issues, PSA 5-17

by range, SQL 7-386

clauses

of ALTER INDEX, SQL 7-32

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

of ALTER MATERIALIZED VIEW LOG, SQL 7-59, SQL 7-60

of ALTER TABLE, SQL 7-155

of CREATE MATERIALIZED VIEW / SNAPSHOT, SQL 7-319

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

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

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-323

columns, SCN 11-13

compatibility, MIG 9-10

composite, DWG 5-6, PSA 5-14, PSA 5-15, SAD 15-6

creating partitions, SAD 15-7 to SAD 15-11

data, DWG 5-4

data among instances, PSA 7-14

departmental, PSA 5-13

distribution value, STU 5-8

downgrading, MIG 13-22

examples of, STU 5-14

examples of composite, STU 5-16

hash, DWG 5-5, PSA 5-14, PSA 5-15, SAD 15-5, STU 5-14

indexes, DWG 5-6, SAD 15-2

See also partitioned indexes

index-organized tables, SAD 15-9

LOBs

DML locks, SCN 11-45

maintenance operations, SCN 11-56

maintaining partitions, SAD 15-12 to SAD 15-32

materialized views, DWG 8-31

method, selecting, PSA 5-6

methodology, PSA 5-8

methods, SAD 15-3

methods, table, PSA 5-14

new partitioning methods

composite, GTK 3-46

hash, GTK 3-46

local indexes, GTK 3-46

queries, DML, and DDL for, GTK 3-46

of index-organized tables, GTK 3-47

of object tables, GTK 3-37

of tables containing user defined types, GTK 3-37

of tables with LOBs, GTK 3-47

physical table, PSA 5-15

prebuilt tables, DWG 8-33

range, DWG 5-5, PSA 5-14, SAD 15-3, STU 5-14

range partitioning enhancements

merging partitions, GTK 3-45

updatable partition keys, GTK 3-46

removing LOBs, MIG 13-28

start and stop columns, STU 5-15

strategy, based on data, PSA 5-6

strategy, considerations for, PSA 6-15

tables, SAD 15-2

See also partitioned tables

tables containing Oracle objects, ADO 7-14

tables with LOB columns, SCN 11-37

transaction, PSA 5-15

transactions, PSA 5-15

user, PSA 5-13

users, PSA 5-13

partitioning data

data files, PSA 8-11, PSC 7-2

free list, PSA 1-6

free lists, PSA 8-9, PSC 7-10, PSC 7-21

index data, PSA 7-14

PCM locks, PSA 7-14, PSA 8-9, PSC 7-21

rollback segments, PSC 7-6, PSC 7-7

table data, PSA 7-14, PSA 8-9, PSC 7-21

partition-level Export, SUT 1-8

examples, SUT 1-34

partition-level Import, SUT 2-5, SUT 2-31

guidelines, SUT 2-31

specifying, SUT 1-25

partitions, SCN 11-2, SCN 11-11

See also partitioned tables.

adding rows to, SQL 7-540

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

affinity, SCN 205

allocating extents for, SQL 7-150

basic partitioning model, SCN 11-11

bitmap indexes, DWG 6-6, SCN 10-39

composite, SQL 2-70

specifying, SQL 7-403

concurrent maintenance operations, SCN 11-49

converting into nonpartitioned tables, SQL 7-162

DATE datatype, SCN 11-12, SCN 11-21

deallocating unused space from, SQL 7-150

DML partition locks, SCN 11-45

dropping, SQL 7-160

dynamic partitioning, SCN 162

elimination, GTK 3-47, STU 9-35

equipartitioning, SCN 11-23

examples, SCN 11-24, SCN 11-30, SCN 11-31

LOB columns, SCN 11-37

local indexes, SCN 11-29

on one dimension, SCN 11-23

overflow of index-organized tables, SCN 11-41, SCN 11-43

range partitioning, SCN 11-24

EXCHANGE PARTITION, SCN 11-11

execution plan, SCN 11-13

extents

allocating new, SQL 7-35

global indexes, SCN 11-31, SCN 11-60

hash, SQL 2-70

adding, SQL 7-160

coalescing, SQL 7-160

specifying, SQL 7-402

hash partitioning, SCN 11-15

inserting rows into, SQL 7-542

LOB storage characteristics of, SQL 7-142

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

building in parallel, SCN 11-29

locking, SQL 7-547

logging attribute of, SQL 7-395

logging insert operations, SQL 7-152

LONG and LONG RAW restriction, SCN 11-12

maintenance operations, SCN 11-47

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

merging, SCN 11-14, SQL 7-162

modifying, SQL 7-156

moving to a different segment, SQL 7-157

multi-column keys, SCN 11-22

no-logging mode, SCN 151

nonprefixed indexes, SCN 11-30, SCN 11-34

OLTP databases, SCN 11-7

parallel DDL, SCN 187

parallel queries, SCN 160

partition bounds, SCN 11-19

partition elimination, SCN 11-4

partition names, SCN 11-18

partition pruning, SCN 11-4

DATE datatype, SCN 11-21

disk striping and, SCN 205

indexes, SCN 11-35

parallelizing by block range, SCN 160

partition transparency, SCN 11-11

partition-extended table names, SCN 11-63

partitioning indexes, SCN 11-28, SCN 11-35

partitioning keys, SCN 11-13, SCN 11-18

partitioning tables, SCN 11-26

partition-wise joins, SCN 11-5

physical attributes, SCN 11-26, SCN 11-36

changing, SQL 7-145

prefixed indexes, SCN 11-30

pruning, DWG 5-10

range, SQL 2-70

adding, SQL 7-158

specifying, SQL 7-403

range partitioning, SCN 11-13

disk striping and, SCN 205

raw, SRF 1-55

rebuild partition, SCN 11-60

referencing a partition, SCN 11-18

removing rows from, SQL 7-160, SQL 7-466

renaming, SQL 7-157

restrictions

bitmap indexes, SCN 11-13

datatypes, SCN 11-12, SCN 11-21

partition-extended table names, SCN 11-64

revising values in, SQL 7-618

rules of parallelism, SCN 181, SCN 183

segments, SCN 4-18, SCN 4-19

splitting, SQL 7-161

statistics, SCN 11-13, SCN 134, STU 8-4

storage characteristics, SQL 7-394

tablespace for

defining, SQL 7-394

VLDB, SCN 11-5

See also partitioned indexes.

PARTITIONS clause, SAD 15-10

partitions, creating, LEG 5-7

partition-wise joins, DWG 5-12

benefits of, DWG 5-20

full, STU 5-20

full, and EXPLAIN PLAN output, STU 5-20

partial, and EXPLAIN PLAN output, STU 5-19

PARTNER_LU_LOCAL_ALIAS parameter, NET B-3

PARTNER_LU_NAME parameter, NET B-3

Pascal Calling Standard, ADG 10-8

pass-through SQL, DDS 9-2

avoiding SQL interpretation, DDS 9-2

executing statements, DDS 9-3

non-queries, DDS 9-4

queries, DDS 9-7

with bind variables, DDS 9-4

with IN bind variables, DDS 9-5

with IN OUT bind variables, DDS 9-6

with OUT bind variables, DDS 9-6

implications of using, DDS 9-3

overview, DDS 9-2

restrictions, DDS 9-3

password

defining, PC_ 3-2

for LSNRCTL access, NET A-3

for NAMESCTL access, NET A-26

PASSWORD command, NET A-40

PASSWORD EXPIRE clause

of ALTER USER. See CREATE USER

of CREATE USER, SQL 7-453

password file

migration

exclusive setting, MIG A-17

password files, PSG 3-37

connecting to Recovery Manager with, RMN 2-10, RMN 2-11

connecting to Recovery Manager without, RMN 2-11

Recovery Manager, RMN 2-2

password management, OCI 8-12, OCI 8-13

application changes required for Oracle8i, MIG 9-37

interoperability, MIG 9-38

password expiration, MIG 9-38

password, changing, PCO A-8

PASSWORD_GRACE_TIME parameter

of ALTER PROFILE, SQL 7-70

of CREATE PROFILE, SQL 7-362

PASSWORD_LIFE_TIME parameter

of ALTER PROFILE, SQL 7-70

of CREATE PROFILE, SQL 7-362

PASSWORD_LOCK_TIME parameter

of ALTER PROFILE, SQL 7-70

of CREATE PROFILE, SQL 7-362

PASSWORD_REUSE_MAX parameter

of ALTER PROFILE, SQL 7-70

of CREATE PROFILE, SQL 7-362

PASSWORD_REUSE_TIME parameter

of ALTER PROFILE, SQL 7-70

of CREATE PROFILE, SQL 7-362

PASSWORD_VERIFY_FUNCTION parameter

of ALTER PROFILE, SQL 7-70

of CREATE PROFILE, SQL 7-362

password-based authentication, OID 1-5, OID 2-21, OID 4-4

passwords

account locking, SCN 285

administrator privileges, SCN 5-3

authenticating, SRF 1-90, SRF 1-103

authentication file for, SAD 1-9

changing at runtime, PC_ A-2

changing at runtime with ALTER AUTHORIZATION, PCO 3-10

changing for roles, SAD 23-7

complexity verification, SCN 286

connecting with, SCN 8-4

connecting without, SCN 282

database links

viewing, DDS 2-22

database user authentication, SCN 285

defining, PCO 3-2

encrypted

database, SAD 21-5

encrypting, OID 5-16

encryption, SAD 22-8, SCN 285

expiration, SCN 286

expiration of, SQL 7-453

for shell tools, OID 4-15, OID 7-28

for SSL wallets, OID 4-6

modifying, OID 5-10, OID F-6

setting, OID F-6

for using bulk tools, OID 4-15

hardcoding, PCO 3-2

hiding, SUT 2-7

hiding in RMAN, RMN 2-13

initial for SYS and SYSTEM, SAD 1-5

parameters

of ALTER PROFILE, SQL 7-363

of CREATE PROFILE, SQL 7-360

password file, SAD 1-12

creating, SAD 1-9

OS authentication, SAD 1-7

removing, SAD 1-16

state of, SAD 1-16

password files, SCN 292

password reuse, SCN 286

privileges for changing for roles, SAD 23-7

privileges to alter, SAD 22-18

REMOTE_LOGIN_PASSWORDFILE initialization parameter, SRF 1-102

role, ADG 11-18, ADG 11-25

roles, SAD 23-8

security policy for users, SAD 21-5

setting REMOTE_LOGIN_PASSWORD parameter, SAD 1-11

to a directory, changing, OID 5-19

to Oracle data servers, OID 4-16

changing, OID 5-30

used in roles, SCN 1-41

user authentication, SAD 22-8

PASSWORDS_listener_name parameter, NET C-55

pattern

check if it exists in BFILE using instr, ADL 11-126

see if it exists IN LOB using (instr)

internal persistent LOBs, ADL 9-128

temporary LOBs

checking if it exists, ADL 10-82

pattern matching, PLS 2-46

Payload factory can only be specified for destinations with ADT payloads - error, ADQ D-7

Payload factory must be specified for destinations with ADT payloads - error, ADQ D-7

Payload factory or Sql_data_class must be specified - error, ADQ D-11

Payload, Structured, ADQ 8-7

PCB, SMS 38-1

PCF, SMS 39-1

PCM

1 to 1 lock usage, PSC 5-32

1 to 1 locks, PSC 5-5

1 to n locks, PSC 5-5

hashed lock usage, PSC 5-32

PCM lock, DWG 18-44

mapping blocks to, SRF 1-40

PCM locks, PSA 7-14

adding data files, PSA 9-8

allocating, PSA 7-2

checking for valid number, PSA 9-6, PSA 9-8

contention, PSA 7-14, PSA 8-9, PSC 7-21

conversion time, PSA 9-12

estimating number needed, PSA 7-3

exclusive, PSA 7-8

fixed 1

n, PSC 5-4

index data, PSA 7-14

mapping blocks to, PSA 8-9, PSC 5-20, PSC 7-21

planning, PSA 7-2

releasable, PSA 9-3, PSA 9-5, PSC 5-4

sessions waiting, PSA 9-12

set of files, PSC 5-21

shared, PSA 7-8, PSA 7-14

specifying total number, PSA 3-9

valid lock assignments, PSA 9-7

worksheets, PSA 7-12

pcode

when generated for triggers, ADG 13-28

PCS, SMS 40-1

PCTFREE, PSC 7-12

value for complex snapshots, REP 3-28

PCTFREE parameter, STU 2-12, STU 20-31

altering, SAD 13-12

block overhead and, SAD 12-6

clustered tables, SAD 12-4

clusters, used in, SAD 16-5

examples of use, SAD 12-6

guidelines for setting, SAD 12-3

indexes, SAD 12-4

non-clustered tables, SAD 12-4

of ALTER CLUSTER, SQL 7-4

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

of ALTER MATERIALIZED VIEW, SQL 7-49

of ALTER MATERIALIZED VIEW LOG, SQL 7-58

of CREATE CLUSTER, SQL 7-256

of CREATE INDEX, SQL 7-300

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

of CREATE MATERIALIZED VIEW/SNAPSHOT. See CREATE TABLE.

of CREATE TABLE, SQL 7-393

PCTUSED, use with, SAD 12-6

usage, SAD 12-2

PCTFREE storage parameter, ADG 2-4 to ADG 2-9

how it works, SCN 4-6

PCTUSED and, SCN 4-8

PCTINCREASE parameter, STU 20-37

and SQL.BSQ file, STU 20-34

of STORAGE clause, SQL 7-607

table extents, PSA 8-9

PCTINCREASE storage parameter

altering, SAD 12-13

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

setting for the data dictionary, SAD 19-27

PCTINCREASEstorage parameter

description, SAD 12-9

PCTTHRESHOLD parameter

of ALTER TABLE, SQL 7-154

of CREATE TABLE, SQL 7-397

PCTUSED, PSC 7-12

value for complex snapshots, REP 3-28

PCTUSED parameter, STU 2-12, STU 20-32

altering, SAD 13-12

block overhead and, SAD 12-6

clusters, used in, SAD 16-5

examples of use, SAD 12-6

guidelines for setting, SAD 12-5

of ALTER CLUSTER, SQL 7-4

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

of ALTER MATERIALIZED VIEW, SQL 7-49

of ALTER MATERIALIZED VIEW LOG, SQL 7-58

of CREATE CLUSTER, SQL 7-256

of CREATE INDEX. See CREATE TABLE

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

of CREATE MATERIALIZED VIEW/SNAPSHOT. See CREATE TABLE.

of CREATE TABLE, SQL 7-393

PCTFREE, use with, SAD 12-6

usage, SAD 12-4

PCTUSED storage parameter, ADG 2-6 to ADG 2-9

guidelines for setting, ADG 2-6

how it works, SCN 4-7

PCTFREE and, SCN 4-8

PCTVERSION, ADL 7-7

PCTVERSION parameter

of CREATE TABLE, SQL 7-399

of LOB storage clause, SQL 7-142

PDO. See parameter descriptor object

peer-to-peer replication. See multimaster replication

pending area for Database Resource Manager plans, SAD 25-7 to SAD 25-10

validating plan schema changes, SAD 25-8

Pending Messages Window

recovery waiting for tape_volume_name, LEG 3-21

waiting for writable backup tape, LEG 3-21

pending transaction tables, DDS 5-25

percent sign

alternate mappings, NLS 4-10

PERCENT_RANK function, DWG 17-33, SQL 4-66

Performance, ADQ 5-2

performance, PLS 1-21, SRF 1-11

add/modify, OID 13-12

and lock mastering, PSC 3-5

application, PSC 7-19

assigning multiple locators to same temporary LOB, impacts, ADL 10-10

caching sequences, PSC 8-14

causes of poor, PCO D-2

client/server applications, STU 3-11

clusters, ADG 5-15

clusters and, SCN 10-52

constraint effects on, SCN 257

decision support applications, STU 3-4

different types of applications, STU 3-2

direct path Export, SUT 1-42, SUT 1-44

distributed databases, STU 3-8

DSS database, SCN 11-9, SCN 194

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

eliminating extra parsing to improve, PC_ C-7

evaluating, STU 1-10

group commits, SCN 8-10

Import, SUT 2-19

improving, PCO D-3, PLS 5-61

index build, SCN 10-24

index column order, ADG 5-4

inserts and updates, PSC 7-19

I/O, SCN 11-9

key factors, STU 16-3

location of datafiles and, SAD 10-4

mainframe, STU 23-6

metrics, OID 13-2

monitoring registered applications, STU 11-8

native dynamic SQL, ADG 8-15

NT, STU 23-6

OCI and temporary LOBs, ADL 10-12

OLTP applications, STU 3-2

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

optimizing SQL statements to improve, PC_ C-5

Oracle Parallel Server, STU 3-10

Oracle Parallel Server and DML locks, SCN 11-46

Oracle8 features, PSC 1-4

packages, SCN 58

parallel recovery and, SCN 351

partitioned load

SQL*Loader, SUT 8-25

partitions, SCN 11-9

prefixed and nonprefixed indexes, SCN 11-34

problems, diagnosing, PSA 11-18

problems, identifying, PSA 12-31

reasons for poor, PC_ C-2

recovery, SCN 354

replication, REP 2-36

replication and, OID 2-12

resource limits and, SCN 295

rollback segments, PSC 7-7

rule-based optimization, SRF 1-86

search, OID 13-12

sequence numbers, PSC 8-14

SGA size and, SCN 7-13

shared pool, SRF 1-45, SRF 1-110, SRF 1-111

sort operations, SCN 3-12

sort performance, SRF 1-113

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

troubleshooting, OID 13-12

tuning archiving, SAD 7-19

UNIX-based systems, STU 23-6

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 multiple threads, OID A-9

using orclEntryLevelACI, OID 9-3

using RELEASE_CURSOR to improve, PC_ C-12

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

viewing execution plans, SCN 127, STU 4-3

views, using to examine parallel execution, PSA 2-6

performance enhancements, REP A-2, REP A-5

performance improvement

conventional path for small loads, SUT 8-22

performance issues

direct path loads, SUT 8-16

Performance Manager, STU 11-11

Performance Manager Login dialog box, PSG 6-28

Performance Monitor

NT, STU 18-5

performance of SSL compared to Net8, OAS 10-10

performing backups after unrecoverable operations, SBR 3-8

periodic purges

scheduling, REP 7-12

periodic pushes

scheduling, REP 7-10

PERMANENT clause

of ALTER TABLESPACE, SQL 7-181

of CREATE TABLESPACE, SQL 7-422

permissions, OID 2-20, OID 2-25

granting

by using command line tools, OID 9-47

by using Oracle Directory Manager, OID 9-16

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 67

persistent resource, PSC 3-6

PFILE

Migration utility option, MIG 4-17

PFILE option, PSA 1-4, PSA 1-5

starting a database, SAD 3-3

PG2, SMS 41-1

PGA, SCN 1-15, SCN 7-15

multi-threaded server, SCN 8-20

PGO, SMS 42-1

phantom reads, SCN 213, SCN 221

PHYRDS column

V$FILESTAT table, STU 20-17

physical attributes clause

of a constraint, SQL 7-236

of ALTER CLUSTER, SQL 7-2

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

of ALTER MATERIALIZED VIEW, SQL 7-49

of ALTER MATERIALIZED VIEW LOG, SQL 7-58

of ALTER TABLE, SQL 7-145

of CREATE CLUSTER, SQL 7-254

of CREATE MATERIALIZED VIEW / SNAPSHOT, SQL 7-319

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

of CREATE TABLE, SQL 7-384, SQL 7-393

physical database layouts, DWG 5-3

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

control files, SCN 1-10, SCN 362

datafiles, SCN 1-8, SCN 3-16

redo log files, SCN 1-9, SCN 347

physical guesses in logical rowids, SCN 12-21

staleness, SCN 12-22

statistics for, SCN 12-22

physical layer, described, NET 3-4

physical layouts

design of, PSA 6-15

suggestions for, PSA 6-15

physical memory, OID 12-13

physical partitioning strategy

considerations for, PSA 6-15

physical reads statistic, STU 19-28

physical rowids, PLS 2-17

physical structure of a database, SAD 1-19

physical table partitioning, PSA 5-15

PHYWRTS column

V$FILESTAT table, STU 20-17

PI - oracle.xml.parser.v2.XMLToken.PI, JPR 4-138

PIC G for NLS characters, PCO B-3

PIC N for NLS characters, PCO B-3

PICX precompiler option, PCO 4-29, PCO 14-34

PIECED keyword

SQL*Loader, SUT 8-15

piecewise fetch, OCI 5-41

piecewise operations, OCI 5-39

fetch, OCI 5-37, OCI 5-42

in PL/SQL, OCI 5-41

insert, OCI 5-37

update, OCI 5-37

valid datatypes, OCI 5-38

pin count, OCI 10-28

pin duration

example, OCI 13-14

of objects, OCI 13-14

PIN_COUNT initialization parameter: obsolete

ping UNIX command, STU 11-3

PING utility, NET 11-13, NET A-41

testing Oracle Names servers with, NET 11-13

ping, host table testing, LEG B-3

pinging, PSA 9-10, PSA 9-12, PSC 5-22, PSC 5-24, STU 2-13

definition, PSC 5-2

false, PSC 5-31

identifying by block class, PSA 12-26

rate, PSA 9-11

pinning, OCI 13-7

pinning objects, OCI 13-7

PINPAD cards

using SecurID, OAS 7-11

pins

on KGL objects, SRF 2-113

PINS column

V$LIBRARYCACHE table, STU 19-15

pipe, PLS 8-18

PIPE parameter, NET B-3

PITarget - oracle.xml.parser.v2.XMLToken.PITarget, JPR 4-138

pivoting, DWG 13-7

PKI, OAS 1-8, SCN 283

PKI authentication, OID 2-21

pkREFs, ADO 7-2

placeholders, PLS 10-2

duplicate, PC_ 13-14, PC_ 13-30, PCO 9-30, PLS 10-12

naming, PC_ 13-14

proper order of, PC_ 13-14

use in dynamic SQL statements, PC_ 13-3

plan

accessing views, STU 4-80, STU 4-82, STU 4-84

complex statements, STU 4-75

compound queries, STU 4-91, STU 4-92, STU 4-93

joining views, STU 4-89

joins, STU 4-49, STU 4-58

OR operators, STU 4-73

SQL execution, SCN 12, SCN 20

plan schemas for Database Resource Manager, SAD 25-7, SAD 25-11, SAD 25-13, SAD 25-18, SAD 25-22

examples, SAD 25-18

validating plan changes, SAD 25-8

plan stability, SPR 58-1, SQL 7-342, STU 10-2

compatibility, MIG 9-13

downgrading, MIG 13-44

limitations of, STU 10-2

preserving execution plans, STU 10-2

procedures for the cost-based optimizer, STU 10-8

use of hints, STU 10-2

plan stability for optimization, SCN 129

plan stability for optimizer, GTK 3-37

plan, execution, PCO D-4

PLAN_TABLE execution plan table, SRF 2-156

PLAN_TABLE sample table, SQL 7-512

PLAN_TABLE table

BYTES column, STU 5-5

CARDINALITY column, STU 5-5

COST column, STU 5-5

DISTRIBUTION column, STU 5-6

ID column, STU 5-5

OBJECT_INSTANCE column, STU 5-5

OBJECT_NAME column, STU 5-5

OBJECT_NODE column, STU 5-4

OBJECT_OWNER column, STU 5-5

OBJECT_TYPE column, STU 5-5

OPERATION column, STU 5-4

OPTIMIZER column, STU 5-5

OPTIONS column, STU 5-4

OTHER column, STU 5-6

OTHER_TAG column, STU 5-5

PARENT_ID column, STU 5-5

PARTITION_ID column, STU 5-6

PARTITION_START column, STU 5-6

PARTITION_STOP column, STU 5-6

POSITION column, STU 5-5

REMARKS column, STU 5-4

SEARCH_COLUMNS column, STU 5-5

STATEMENT_ID column, STU 5-4

structure, STU 5-3

TIMESTAMP column, STU 5-4

planned downtime, PSC 9-3

planning

capacity, PSC 9-4

database creation, SAD 2-2

redundancy, PSC 9-4

relational design, SAD 1-19

the database, SAD 1-19

planning overview, NET 5-2

plans

star transformations, DWG 16-8

PLS, SMS 21-1

PLS_INTEGER datatype, PLS 2-14

PL/SQL, ADG 9-2, ADL 3-2, OCI 1-9, PC_ 1-4, GTK 3-78, SCN 24, SQL v, ADQ 3-2

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

anonymous block

used to open a cursor variable, PC_ 4-28

anonymous blocks, ADG 9-2, ADG 11-10, SCN 24, SCN 53

architecture, PLS 1-17

assigning one LOB to another, ADL 10-110

auditing of statements within, SCN 332

autonomous blocks, GTK 3-78

backward compatibility, MIG 9-21

bind variables

user-defined types, ADO 3-2, SCN 13-14

binding and defining nested tables, OCI 5-35

binding and defining ref cursors, OCI 5-35

binding placeholders, OCI 2-39

block structure, PLS 1-2

blocks

syntax of, SQL xiii

bulk binds, GTK 3-79

downgrading, MIG 13-34

calling remote stored procedures, ADG 9-54

compatibility, MIG 9-13, MIG 9-21

compatibility with earlier releases, SQL 7-93, SQL 7-116

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

cursor variables, ADG 9-38

database triggers, SCN 81

datatype equivalents, PCO 11-18

datatypes, SPR 12-6, SCN 12-2

numeric codes for, SPR 12-9

DBMS_LOB package compared with OCI, DCI 6-7

debugging, DCI 5-8

defining output variables, OCI 5-21

demo directory, DCI 4-10

dependencies among library units, ADG 9-28

description of, PC_ 1-4

deterministic functions, STU 4-70

development environment, DDS 9-2

difference from SQL, PC_ 1-4

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

dynamic SQL, SCN 28

DBMS_SQL package, GTK 3-79

dynamically modifying SQL statements, ADG 11-14

embedded, PCO 6-2

errors

ORA-06510, DDS 3-13

exception, PCO 6-13

exception handlers, ADG 9-2

exception handling, SCN 27

executing, SCN 24, SCN 61, SCN 62

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

execution environments, PLS 1-17

external procedures, SCN 29, SCN 54

features, ADG 1-3

functions

arguments, ADG 9-59

desupported in Oracle8i, MIG 9-30

overloading, ADG 9-70

parameter default values, ADG 9-59

purity level, ADG 9-69

RESTRICT_REFERENCES pragma, ADG 9-66

using, ADG 9-56

gateway, SCN 29

hiding source code, ADG 9-28

increased package body size, GTK 3-81

integration with database server, PC_ 7-2

integration with server, PCO 6-3

interoperability, MIG 9-21

invoker rights, GTK 3-79

invoking with dynamic SQL, ADG 8-7

language constructs, SCN 26

limitations, PLS E-1

main advantage of, PC_ 1-4

modules

recompiling, MIG 7-38

monitoring and analysis of program execution

DBMS_DEBUG, GTK 3-80

DBMS_PROFILER, GTK 3-80

DBMS_TRACE, GTK 3-80

NOCOPY parameter passing mode, GTK 3-80

object views, ADO 5-4, SCN 14-4

objects, ADG 1-5

opening a cursor variable

anonymous block, PCO 6-33

stored procedure, PCO 6-32

overview of, SCN 1-55, SCN 24

package, PCO 6-5, STU 11-7

packages, ADG 9-12, DCI 5-5, PC_ 7-4, SCN 46, SCN 54

parameter passing by reference, GTK 3-80

parse locks, SCN 240

parsing DDL statements, SCN 28

partition-extended table names, SCN 11-65

performance, PLS 1-21

performance when reassigning locators in temporary LOBs, ADL 10-12

piecewise operations, OCI 5-41

PL/SQL engine, SCN 24, SCN 44

compiler, SCN 59

executing a procedure, SCN 62

products containing, SCN 25

PL/SQL tables, PC_ 7-5

PLSQL_V2_COMPATIBILITY initialization parameter, MIG 9-21

portability, PLS 1-23

procedural aspects, PLS 1-2

procedures and functions, PC_ 7-3

procedures for supporting REF-based operations

UTL_REF package, GTK 3-80

program body

of CREATE FUNCTION, SQL 7-289

program units, ADG 9-2, SCN 1-24, SCN 7-10, SCN 24, SCN 44

compiled, SCN 25, SCN 53, SCN 59

dropped tables and, ADG 2-10, SAD 13-16

replaced views and, ADG 2-18, SAD 18-12

shared SQL areas and, SCN 7-10

purity rules relaxed, GTK 3-81

RAISE statement, ADG 9-44

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 13-33

reparsing, ADG 11-45, ADG 11-46

reserved words, PLS F-1

roles in procedures, SCN 322

sample code, ADG 1-2

sample programs, PLS A-1

serially reusable packages, ADG 9-70

server pages, ADG 12-2 to ADG 12-12

Server Pages (PSPs), PLS 7-45

setting context, ADG 11-49

setting SQLCA, PC_ 9-22

stored procedures, SCN 1-24, SCN 24, SCN 44, SCN 48

subprogram, PCO 6-4

support for SQL, PLS 1-20

syntax, PLS 11-1

tables, ADG 9-9

of records, ADG 9-9

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

tuning PL/SQL areas, STU 19-8

user locks, SCN 250

user-defined datatypes, ADO 3-2, SCN 13-13

user-defined errors, ADG 9-44

user-defined exceptions, DDS 3-12

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 9-28

vs Java, ADG 1-39

web toolkit, ADG 12-2

wrapper to hide code, ADG 9-28

see also external procedures (routines)

PL/SQL block execution

effect on SQLCA components, PCO 8-13

PL/SQL blocks

anonymous, PLS 1-2, PLS 7-2

embedded in Oracle7 precompiler programs, PCO F-39

embedded in precompiler programs, PC_ F-51

syntax, PLS 11-10

PL/SQL compiler

how calls are resolved, PLS 7-27

PL/SQL engine, PLS 1-17

in Oracle server, PLS 1-18

in Oracle tools, PLS 1-19

PL/SQL procedures

client-side cannot call DBMS_LOB, ADL 4-16

PL/SQL Server Pages, GTK 2-6, SCN 29

PL/SQL subprogram

calling from Pro*COBOL, PCO 6-21

PL/SQL table, PCO 6-6

supported datatype conversions, PCO 6-16

PLSQL_V2_COMPATIBILITY flag, PLS 5-69

PLSQL_V2_COMPATIBILITY initialization parameter, SRF 1-98

PLSQL_V2_COMPATIBILITY parameter

of ALTER SESSION, SQL 7-93

of ALTER SYSTEM, SQL 7-116

PLU parameter, NET B-3

PLU_LA parameter, NET B-3

PLUGGABLE_SET_CHECK view, SRF 2-157

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

PM (P.M.) date format element, SQL 2-46, SQL 2-48

PMON background process, SCN 8-12

See also process monitor process

PMON process, NET 2-22

point events in Oracle Trace, STU 14-5

pointer

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

pointers, PLS 5-16

point-in-time recovery

clone database, SCN 5-8

tablespace, RMN 8-2 to RMN 8-15, SBR 7-1 to SBR 7-26

point-to-point model, SCN 68

policy

browse, LEG 2-6

retention, LEG 2-6

polling, ADL 9-65, ADL 9-76, ADL 9-103, ADL 9-192, ADL 10-152

POOL attribute, NET 9-6, STU 21-8

POOL_SIZE parameter, NET 2-17, NET 7-17

pooling, connection, OID 1-4

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, OID 4-4

default, OID 3-5, OID 3-8, OID 4-3

port 1024, NET B-5

port 1521, NET B-4

if not using, NET 7-10

port 1575, NET 4-24, NET 6-55, NET B-4, NET C-59

port 1610, MIG F-16

port 1630, MIG F-16, NET 4-5, NET 8-28, NET 8-32, NET 8-35, NET B-4

port 1646, NET C-23

port 1830, MIG F-16, NET 8-28, NET 8-32, NET B-4, NET C-85

port 2481, NET B-4

port 2482, NET B-4

port 389, OID 3-5, OID 3-8, OID F-5

port 636, OID 3-5, OID 3-8, OID F-5

port numbers, allowed, NET B-5

PORT parameter, NET B-4

portability, PLS 1-23, SCN 1-3

portmapper, testing with rpcinfo, LEG B-4

POSITION column

PLAN_TABLE table, STU 5-5

POSITION keyword

specification of field position, SUT 5-15

tabs, SUT 5-49

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

positional notation, PLS 7-13

positioned, OCI 2-34

deletes, OCI 2-34

POSITIVE subtype, PLS 2-13

POSITIVEN subtype, PLS 2-13

power demand cartridge example, DCI 11-1

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

POWER function, SQL 4-67

PPE, SMS 43-1

PQ_DISTRIBUTE hint, SQL 2-67, STU 7-26

PR number format element, SQL 2-41

PR2, SMS 44-1

pragma, ADG 7-32, ADG 7-40

RESTRICT_REFERENCES pragma, ADG 9-66

SERIALLY_REUSABLE pragma, ADG 9-70, ADG 9-71

PRAGMA clause

of ALTER TYPE, SQL 7-189

of CREATE TYPE, SQL 7-438, SQL 7-442

PRAGMA RESTRICT_REFERENCES, SQL 7-189, SQL 7-442

pragma RESTRICT_REFERENCES, ADO 9-20, DCI 5-6

PRAGMA_EXCEPTION_INIT procedure

assigning exception names, DDS 3-12

pragmas, PLS 6-8

AUTONOMOUS_TRANSACTION, PLS 5-53

EXCEPTION_INIT, PLS 6-8

RESTRICT_REFERENCES, PLS 5-60, PLS 7-9, PLS 10-15

SERIALLY_REUSABLE, PLS 5-65

PRE_PAGE_SGA initialization parameter, SRF 1-98

PRE_PAGE_SGA parameter, STU 19-5

pre-allocating extents, PSC 7-25

prebuilt materialized views, DWG 8-16

PREBUILT TABLE clause

materialized views and downgrading, MIG 13-17

precedence

of operators, SQL 3-2

precedence of precompiler options, PC_ 10-4

precedence rules

ACL evaluation, OID 9-11

in conflicting access policies, OID 9-3

precedence, operator, PLS 2-43

precision

definition of, PC_ 15-16

number of digits of, SQL 2-4

of NUMBER datatype, SQL 2-17

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

precompilation

conditional, PC_ 2-15, PCO 2-25

generated code, PCO 14-3

separate, PC_ 2-16, PCO 2-26

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-10, 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-3

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-20, PCO 14-17

DEF_SQLCODE, PC_ 10-17

DEFINE, PC_ 10-18, PCO 14-18

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

END_OF_FETCH, PCO 14-19

entering, PC_ 10-9, PCO 14-6

entering inline, PCO 14-7

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

ERRORS, PC_ 10-20, PCO 14-20

ERRTYPE, PC_ 10-21

FIPS, PC_ 10-21, PCO 14-20

FORMAT, PCO 14-22

HEADER, PC_ 10-23

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

HOST, PCO 14-23

INAME, PC_ 10-24, PCO 14-24

INCLUDE, PC_ 10-25, PCO 14-24

INTYPE, PC_ 10-26

IRECLEN, PCO 14-25

LINES, PC_ 10-27

list, PCO 14-10

list of, PC_ 10-11

LITDELIM, PCO 2-14, PCO 14-26

LNAME, PC_ 10-28, PCO 14-26

LRECLEN, PCO 14-27

LTYPE, PC_ 10-28, PCO 14-27

macro and micro, PCO 14-5

MAXLITERAL, PC_ 2-13, PC_ 10-29, PCO 14-28

MAXOPENCURSORS, PC_ 10-30, PCO 2-27, PCO 14-29, PCO D-7

micro and macro, PC_ 10-5

MODE, PC_ 10-31, PC_ 14-11, PCO 4-29, PCO 8-3, PCO 10-12, PCO 14-30

name of the system configuration file, PCO 14-9

NESTED, PCO 14-31, PCO A-3

NLS_CHAR, PC_ 10-32

NLS_LOCAL, PC_ 10-32, PCO 14-31

OBJECTS, PC_ 10-33

ONAME, PC_ 10-33, PCO 14-32

ORACA, PC_ 10-34, PCO 8-25, PCO 14-33

ORECLEN, PCO 14-33

PAGELEN, PC_ 10-35, PCO 14-34

PARSE, PC_ 10-35

PICX, PCO 4-29, PCO 14-34, PCO A-8

precedence, PC_ 10-4, PCO 14-4

PREFETCH, PC_ 10-36, PCO 5-18, PCO 14-35, PCO A-2

RELEASE_CURSOR, PC_ 10-36, PCO 14-35, 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-37, 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-7, PCO 12-7, PCO 14-39

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

VERSION, PC_ 10-43

XREF, PCO 14-42

precompilers, ADG 9-51

advantages, PCO 1-3

anonymous blocks, SCN 26

applications, ADG 9-4

changing to use Oracle8i, MIG 10-10

upgrading dynamically linked, MIG 10-7

upgrading options, MIG 10-8

bind variables, SCN 22

calling stored procedures and packages, ADG 9-51

compatibility, MIG 9-20

control of parsing and private SQL areas, STU 19-10

cursors, SCN 20

embedded SQL, SCN 14

enhancements, GTK 3-81

FIPS flagger, SCN 14

interoperability, MIG 9-20

language support, PCO 1-3

NLS support, PCO 4-36

Oracle, SQL 1-4

PL/SQL backward compatibility, MIG 9-21

running, PCO 14-1

stored procedures, SCN 27

upgrading applications to Oracle8i, MIG 10-3

using PL/SQL, PCO 6-7

precompilers vs OCI, ADG 1-37

predefined exceptions

list of, PLS 6-4

raising explicitly, PLS 6-11

redeclaring, PLS 6-10

predefined roles, SAD 1-6

predefined symbols, PC_ 2-15

predetermined size fields

SQL*Loader, SUT 5-83

predetermined size LOBs, SUT 5-102

predicates, PLS 5-5

dynamic

in security policies, SCN 326

optimizing view queries, STU 4-76

partition pruning, SCN 11-4

indexes, SCN 11-35

pushing into a view, STU 4-79, STU 4-84

examples, STU 4-80, STU 4-82

selectivity, SCN 131, STU 8-2

histograms, SCN 132, SCN 133, STU 8-17

user-defined, SCN 141, STU 4-33

preface

conventions table sample, SPR xcix

Prefer Connection Manager Routing option in Net8 Assistant, NET 8-21

preferred credentials, PSG 6-19

creating an operating system account, PSG 6-20

database, PSG 6-19

nodes, PSG 6-19

SYSDBA or SYSOPER for database, PSG 6-19

preferred Oracle Names servers, NET 4-21

preferred user credentials, described, PSG 6-19

PREFETCH precompiler option, PC_ 6-15, PC_ 10-36, PC_ A-5, PCO 5-18, PCO 14-35

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

prefixes of data dictionary views, SCN 2-5

pre-installation, PSG 2-1 to PSG 2-12

DBCA_RAW_CONFIG, PSG 2-9

oracle account activities, PSG 2-11

raw device creation, PSG 2-5 to PSG 2-10

root user activities, PSG 2-11

preparation

standby database, SBY 2-2

prepare multiple branches in a single message, OCI 8-8

prepare phase, DDS 4-12

recognizing read-only nodes, DDS 4-13

two-phase commit, DDS 4-11, DDS 4-12

PREPARE SQL statement, PC_ F-95

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

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

examples, PC_ F-97, PCO F-75

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 4-12

effects of failure, DDS 5-4

failures during, DDS 5-11

forcing to fail, DDS 5-26

locked resources, DDS 5-4

pending transaction table, DDS 5-25

prepared response, DDS 4-12

read-only response, DDS 4-12

testing recovery, DDS 5-26

prepared response

two-phase commit, DDS 4-12

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

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

prescriptive access control, OID 1-5, OID 9-3

Present filter, Oracle Directory Manager, OID 7-7

presentation layer

described, NET 3-4

General Inter-Orb Protocol, NET 3-16

GIOP, NET 3-16

PRESERVE BLANKS keyword

SQL*Loader, SUT 5-87

PRESERVE SNAPSHOT LOG clause

of TRUNCATE, SQL 7-613

PRESERVE SNAPSHOT LOG option

TRUNCATE TABLE statement, RAR 7-21

presorting data for a direct path load

example, SUT 4-25

PRESPAWN_DESC parameter, NET C-54

PRESPAWN_LIST parameter, NET C-53

PRESPAWN_MAX parameter, NET 2-17, NET 7-16, NET C-53

pre-spawned dedicated processes, SCN 8-27

prespawned dedicated servers, MIG F-16, NET 2-16

advantages and disadvantages, NET 5-5

configuring, NET 7-16

number of, NET 7-17

POOL_SIZE parameter, NET 2-17

PRESPAWN_MAX parameter, NET 2-17

recommended for, NET 5-5

TIMEOUT parameter, NET 2-17

prestarted dedicated server process

see prespawned dedicated server process

PRGRMANC.SQL script, RMN 3-19

primary and secondary instances

client configuration, PSG 5-8

connecting to secondary instances, PSG 5-9

initdb_name.ora file configuration, PSG 5-7

listener configuration, PSG 5-9

overview, PSG 5-6

primary databases

preparing for use, SBR 7-14

primary disk

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

PRIMARY KEY

constraints

effect on direct path load, SUT 8-29

PRIMARY KEY clause

of constraint_clause, SQL 7-239

of CREATE TABLE, SQL 7-393

PRIMARY KEY constraint, STU 12-10

choosing a primary key, ADG 4-6

disabling, ADG 4-20

dropping associated indexes, SAD 14-17

enabling, ADG 4-20

enabling on creation, SAD 14-9

foreign key references when dropped, SAD 19-19

indexes associated with, SAD 14-9

multiple columns in, ADG 4-7

simple subquery snapshots and, REP 3-15

storage of associated indexes, SAD 14-10

UNIQUE key constraint vs., ADG 4-7

PRIMARY KEY constraints, DWG 18-58, SCN 261

constraint checking, SCN 273

described, SCN 261

indexes used to enforce, SCN 262

name of, SCN 262

maximum number of columns, SCN 262

NOT NULL constraints implied by, SCN 262

primary key constraints, SQL 7-239

enabling, SQL 7-407

index on, SQL 7-407

primary key OIDs

example, SUT 4-44, SUT 5-95

primary key REF columns, SUT 5-97

primary key snapshots, REP 3-5, REP A-7

primary keys, SCN 1-58, SCN 261

advantages of, SCN 261

defined, SCN 253

generating values for, SQL 7-371

Import, SUT 2-45

optimization, STU 4-75

replicated tables, RAR 3-6, REP 7-2

searches, STU 4-37

upgrading snapshots, MIG G-11

primary sites

ownership, REP 5-7

primary-key-based REFs, ADO 7-2

Primary/Secondary Instance

definition of, PSC 9-18

prime number, PSC A-8

print script command (RMAN), RMN 10-94

print(OutputStream) - oracle.xml.parser.v2.XMLDocument.print(java.io.OutputStream), JPR 4-78

print(OutputStream) - oracle.xml.parser.v2.XMLNode.print(java.io.OutputStream), JPR 4-112

print(OutputStream, String) - oracle.xml.parser.v2.XMLDocument.print(java.io.OutputStream, java.lang.String), JPR 4-78

print(OutputStream, String) - oracle.xml.parser.v2.XMLNode.print(java.io.OutputStream, java.lang.String), JPR 4-112

print(PrintWriter) - oracle.xml.parser.v2.XMLDocument.print(java.io.PrintWriter), JPR 4-78

print(PrintWriter) - oracle.xml.parser.v2.XMLNode.print(java.io.PrintWriter), JPR 4-112

printExternalDTD(OutputStream) - oracle.xml.parser.v2.DTD.printExternalDTD(java.io.OutputStream), JPR 4-28

printExternalDTD(OutputStream) - oracle.xml.parser.v2.XMLDocument.printExternalDTD(java.io.OutputStream), JPR 4-79

printExternalDTD(OutputStream, String) - oracle.xml.parser.v2.DTD.printExternalDTD(java.io.OutputStream, java.lang.String), JPR 4-28

printExternalDTD(OutputStream, String) - oracle.xml.parser.v2.XMLDocument.printExternalDTD(java.io.OutputStream, java.lang.String), JPR 4-79

printExternalDTD(PrintWriter) - oracle.xml.parser.v2.DTD.printExternalDTD(java.io.PrintWriter), JPR 4-29

printExternalDTD(PrintWriter) - oracle.xml.parser.v2.XMLDocument.printExternalDTD(java.io.PrintWriter), JPR 4-79

PRIOR collection method, PLS 4-23

PRIOR operator, SQL 3-16

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

Priority and Ordering of Messages, ADQ 8-38, ADQ 12-58

priority groups

adding members to, SPR 37-9, RAR 8-75

altering members

priorities, SPR 37-19, RAR 8-85

values, SPR 37-20, RAR 8-86

creating, SPR 37-45, RAR 8-111

dropping, SPR 37-54, RAR 8-120

removing members from, SPR 37-53, SPR 37-55, RAR 8-119, RAR 8-121

site priority groups

adding members to, SPR 37-10, RAR 8-76

priority groups conflict resolution method, REP 5-21

private database links, DDS 1-16, NET 4-15

private key, OID 2-23

private objects, PLS 8-15

private rollback segments, PSA 1-9, PSA 3-5, SAD 11-3, SAD 11-7, SCN 4-27

acquisition, PSC 7-6

creating, PSA 3-4

specifying, PSC 7-8, SRF 1-105

taking offline, SAD 11-12

private SQL area

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

definition of, PC_ 2-7

opening, PCO 5-11

opening of, PC_ 2-7

purpose, PCO D-9

purpose of, PC_ C-9

private SQL areas, STU 19-10

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

described, SCN 7-8

how managed, SCN 7-9

persistent areas, SCN 7-8

runtime areas, SCN 7-9

private synonyms, SAD 18-14

private thread, PSA 3-7

PRIVATE_SGA parameter

of ALTER PROFILE, SQL 7-69

of ALTER RESOURCE COST, SQL 7-74

of CREATE PROFILE, SQL 7-362

PRIVATE_SGA variable, STU 19-24

privilege groups, OID 9-4

granting privileges and roles

specifying ALL, SAD 23-4

revoking privileges and roles

specifying ALL, SAD 23-4

privileges, OID 2-20, OID 2-22, OID 2-25, SAD 23-2, SUT 2-10

See also system privileges.

adding datafiles to a tablespace, SAD 10-5

adding redo log groups, SAD 6-11

administrator, SCN 5-3

connections audited, SCN 333

OUTLN schema, SCN 129

statement execution not audited, SCN 332

ALTER SYSTEM, PSA 13-14, PSA 13-15

altering

indexes, SAD 14-15

named user limit, SAD 22-6

passwords, SAD 22-19

role authentication, SAD 23-7

sequences, SAD 18-12

tables, SAD 13-11

users, SAD 22-18

altering sequences, ADG 2-30

altering tables, ADG 2-10

analyzing objects, SAD 19-4

application developers and, SAD 21-10

audit object, SAD 24-11

auditing system, SAD 24-10

auditing use of, SAD 24-8, SCN 1-43, SCN 335

bringing datafiles offline and online, SAD 10-8

cascading revokes, SAD 23-15

checked when parsing, SCN 20

closing a database link, DDS 3-2

cluster creation, ADG 5-16

column, SAD 23-12

complete export, SUT 1-45

creating

roles, SAD 23-6

sequences, SAD 18-12

synonyms, SAD 18-14

tables, SAD 13-9

tablespaces, SAD 9-4

views, SAD 18-2

creating database links, DDS 2-8

creating for Export, SUT 1-9

creating integrity constraints, ADG 4-18

creating rollback segments, SAD 11-6

creating tables, ADG 2-8

creating triggers, ADG 13-26

creating users, SAD 22-15

cumulative export, SUT 1-45

database administrator, SAD 1-4

disabling automatic archiving, SAD 7-8

dropping

indexes, SAD 14-16

online redo log members, SAD 6-15

redo log groups, SAD 6-14

roles, SAD 23-10

sequences, SAD 18-13

synonyms, SAD 18-14

tables, SAD 13-15

views, SAD 18-11

dropping a view, ADG 2-20

dropping profiles, SAD 22-25

dropping rollback segments, SAD 11-13

dropping sequences, ADG 2-35

dropping tables, ADG 2-11

dropping triggers, ADG 13-30

enabling and disabling resource limits, SAD 22-21

enabling and disabling triggers, SAD 19-13

enabling automatic archiving, SAD 7-7

encapsulating in stored procedures, ADG 11-17

Export and, SUT 1-3

for changing session limits, SAD 22-5

forcing a log switch, SAD 6-16

function-based indexes, SCN 10-28, SCN 114

granting, ADG 11-28, ADG 11-30, SCN 1-40, SCN 305, SCN 306

about, SAD 23-10

examples of, SCN 312, SCN 313

object privileges, SAD 23-11

required privileges, SAD 23-11

system privileges, SAD 23-10

granting to PUBLIC, ADG 11-34

grouping into roles, SCN 1-40

grouping with roles, SAD 23-4

incremental export, SUT 1-45

index creation, ADG 5-5

individual privilege names, SAD 23-2

listing grants, SAD 23-23

managing, ADG 11-8, ADG 11-21

managing with procedures, DDS 2-32

managing with synonyms, DDS 2-30

managing with views, DDS 2-28

manually acquiring locks, ADG 7-16

manually archiving, SAD 7-9

middle tier, ADG 11-70

NetWorker User program, LEG D-1

n-tier systems, ADG 11-66

object, ADG 11-22, SAD 23-4

on selected columns, ADG 11-31, SAD 23-14

overview of, SCN 1-40, SCN 304

partitioned tables and indexes, SCN 11-62

policies for managing, SAD 21-6

procedures, SCN 309

creating and altering, SCN 311

executing, SCN 61, SCN 309

in packages, SCN 312

recompiling packages, SAD 19-25

recompiling procedures, SAD 19-25

recompiling triggers, ADG 13-29

recompiling views, SAD 19-24

remote login, SRF 1-102

renaming

datafiles of a tablespace, SAD 10-9

datafiles of several tablespaces, SAD 10-12

objects, SAD 19-3

redo log members, SAD 6-12

renaming objects, ADG 2-40

replacing views, ADG 2-18, SAD 18-11

required for SQL*Loader, SUT 3-14

required to create procedures, DCI 5-7

RESTRICTED SESSION, SCN 300

RESTRICTED SESSION system privilege, SAD 3-6

RESTRICTED_SESSION privilege, SRF 1-51, SRF 1-52

revoked

object dependencies and, SCN 112

revoking, ADG 11-29, ADG 11-31, SAD 23-14, SCN 305, SCN 306

GRANT OPTION, SAD 23-14

object privileges, SAD 23-16

system privileges, SAD 23-13

revoking object, SAD 23-14

revoking object privileges, SAD 23-14

roles, SCN 319

restrictions on, SCN 323

schema object, SCN 305

DML and DDL operations, SCN 307

granting and revoking, SCN 306

overview of, SCN 1-40

packages, SCN 312

procedures, SCN 309

sequence creation, ADG 2-30

setting resource costs, SAD 22-24

SQL statements permitted, ADG 11-22

stored procedure execution, ADG 9-52

synonym creation, ADG 2-35

system, SAD 23-2, SCN 304

granting and revoking, SCN 305

overview of, SCN 1-40

user-defined types, ADO 2-10

table-level select privileges, SRF 1-114, SRF 1-115, SRF 1-116

taking tablespaces offline, SAD 9-15

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

trigger privileges, SCN 310

triggers, ADG 13-26

truncating, SAD 19-11

user-defined types

acquired by role, ADO 2-11

ALTER ANY TYPE, ADO 2-10

checked when pinning, ADO 2-13

column level for object tables, ADO 2-14

CREATE ANY TYPE, ADO 2-10

CREATE TYPE, ADO 2-10

DELETE, ADO 2-12, ADO 2-13

DROP ANY TYPE, ADO 2-11

EXECUTE, ADO 2-11

EXECUTE ANY TYPE, ADO 2-11

EXECUTE ANY TYPE with ADMIN OPTION, ADO 2-11

EXECUTE with GRANT option, ADO 2-11

INSERT, ADO 2-12, ADO 2-13

SELECT, ADO 2-12, ADO 2-13

system privileges, ADO 2-10

UPDATE, ADO 2-12, ADO 2-13

using, ADO 2-11, ADO 2-15

using a view, ADG 2-20

using sequences, ADG 2-34

view creation, ADG 2-17

views, SCN 308

creating, SCN 308

using, SCN 308

See also system privileges.

privileges event attribute, ADG 14-4

privileges. See system privileges or object privileges

privileges, LSM administrators, LEG 2-29

PRO, SMS 45-1

Pro*Ada

upgrading to SQL*Module for Ada, MIG 9-20

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

associative access, ADO 3-6

connecting with SYSDBA privileges, MIG 9-20

converting between Oracle and C types, ADO 3-7

navigational access, ADO 3-6

overview of application development, ADG 1-20 to ADG 1-22

processing SQL statements, SCN 19

user-defined datatypes, ADO 3-2, SCN 13-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*C/C++ precompiler

available LOB functions, ADL 3-3

LOB buffering, ADL 3-25

locators, ADL 3-24

modifying internal LOB values, ADL 3-23

opening and closing internal LOBs and external LOBs (BFILEs), ADL 3-25

providing an allocated input locator pointer, ADL 3-22

reading or examining internal and external LOB values, ADL 3-23

statements for BFILEs, ADL 3-24

statements for temporary LOBs, ADL 3-24

Pro*COBOL, GTK 3-82

connecting with SYSDBA privileges, MIG 9-20

how it works, PCO 1-2

overview of application development, ADG 1-23 to ADG 1-25

Pro*COBOL precompiler

available LOB functions, ADL 3-3

LOB buffering, ADL 3-29

locators, ADL 3-28

modifying internal LOB values, ADL 3-27

opening/closing internal LOBs and external LOBs (BFILEs), ADL 3-29

providing an allocated input locator, ADL 3-26

reading or examining internal and external LOBs, ADL 3-28

statements for BFILEs, ADL 3-28

temporary LOBs, ADL 3-28

proactive tuning, STU 2-2

procedural abstraction, PLS 9-2

procedural database extension, PC_ 7-4

Procedural Option

required for migration, MIG 4-9, MIG 5-8

procedural replication, REP 1-16, SCN 436

conflicts and, REP 6-3

detecting conflicts, REP 1-17, SCN 437

generating support for, REP 6-4

restrictions, REP 2-16, REP 6-2

serialization of transactions, REP 6-3

using, REP 6-2

wrapper, REP 1-16, SCN 436

procedures, PLS 7-1, PLS 7-3, SCN 24, SCN 43, SCN 48, SCN 114

3GL, calling, SQL 7-316

advantages of, SCN 50

attributes, OCI 6-8

auditing, SCN 336

body, PLS 7-4

called by triggers, ADG 13-20

calling, PLS 7-5, SQL 7-226

changing the declaration of, SQL 7-67

changing the definition of, SQL 7-67

contrasted with anonymous blocks, SCN 53

contrasted with functions, SCN 1-55, SCN 44

creating, SQL 7-354

cursors and, SCN 27

declaring

as a Java method, SQL 7-357

as C functions, SQL 7-357

definer rights, SCN 49, SCN 310

roles disabled, SCN 322

dependency tracking in, SCN 112

deterministic functions, STU 4-70

examples of, SCN 48, SCN 312, SCN 313

executing, SCN 25, SCN 61, SQL 7-226

external, ADG 10-2, SQL 7-354

external procedures, SCN 29, SCN 54

external reference in, SCN 50, SCN 62

granting

system privileges on, SQL 7-524

INVALID status, SCN 109, SCN 112

invalidating local objects dependent on, SQL 7-493

invoker rights, SCN 49, SCN 310

roles used, SCN 323

supplied packages, SCN 311

issuing COMMIT or ROLLBACK statements, SQL 7-84

location transparency using, DDS 2-30, DDS 2-31, DDS 2-32

naming rules, SQL 2-74

parameter, PLS 7-3

parts, PLS 7-4

prerequisites for compilation of, SCN 111

privileges

create or alter, SCN 311

executing, SCN 309

executing in packages, SCN 312

privileges executed with, SQL 7-188, SQL 7-441

recompiling, SAD 19-25, SQL 7-67

re-creating, SQL 7-356

remote calls, DDS 1-46, SCN 416

removing from the database, SQL 7-493

replicating, REP 2-17

schema executed in, SQL 7-188, SQL 7-441

security enhanced by, SCN 50, SCN 310

shared pool, SRF 1-45, SRF 1-110, SRF 1-111

shared SQL areas and, SCN 7-10

specification, PLS 7-4

specification of

in CREATE TYPE, SQL 7-442

specifying schema and privileges for, SQL 7-357

stored procedures, SCN 24, SCN 27, SCN 44

storing, SCN 59

supplied packages, SCN 59

invoker or definer rights, SCN 311

synonyms for, SQL 7-377

syntax, PLS 11-133

triggers, SCN 82

validity of, SCN 61

process

dispatcher process configuration, STU 21-8

handle attributes, OCI A-50

maximum number, STU 16-7

prestarting, STU 22-6

priority, STU 23-3

scheduler, STU 23-3

scheduling, STU 18-6

process architecture for distributed external procedures, DDS 6-6

process failures, SBR 1-12

definition, SBR 1-12

process free lists

pinging of segment header, PSC 7-14

process global area (PGA), SCN 7-15

See also program global area

process handle, OCI 2-13

process instance location, OID 5-17

process monitor, SAD 4-12

process monitor process (PMON)

cleans up timed-out sessions, SCN 297

described, SCN 1-18, SCN 8-12

network failure, SCN 343

parallel DML process recovery, SCN 198

process failure, SCN 343

processes, OID 2-30, SCN 8-2

See also server processes

and memory contention in parallel processing, DWG 18-9

archiver (ARCn), SCN 1-18, SCN 8-12, SCN 360

background, SCN 1-16, SCN 8-5

diagrammed, SCN 8-6

block server (BSP), SCN 217

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

checkpoints and, SCN 8-8

classes of parallel execution, DWG 4-4

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

dedicated server, SCN 8-20

derived parameter values, SRF 1-119

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

dispatcher process maximum number, SRF 1-71

distributed transaction resolution, SCN 8-12

DSS, DWG 18-35

during recovery, SCN 352

failure in, SCN 343

for Oracle Parallel Server, PSC 6-2

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

message propagation, SCN 76

listener, SCN 6-6, SCN 8-14

shared servers and, SCN 8-16

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

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

maximum number, DWG 18-34

maximum number for parallel query, DWG 18-34

maximum shared server processes, SRF 1-72

multiple-process Oracle, SCN 8-2

multi-threaded server, SCN 8-16

artificial deadlocks and, SCN 8-20

client requests and, SCN 8-17

number of server processes, SRF 1-48, SRF 1-49, SRF 1-72, SRF 1-73, SRF 1-99

OLTP, DWG 18-35

Oracle, SCN 1-16, SCN 8-5

Oracle background, OID 13-11

Oracle foreground

restricting, OID 13-7

overview of, SCN 1-15

parallel execution coordinator, SCN 162

direct-load INSERT, SCN 147

parallel execution servers, SCN 162

direct-load INSERT, SCN 147, SCN 152, SCN 153

pre-spawned, SCN 8-27

process monitor (PMON), SCN 1-18, SCN 8-12

queue monitor (QMNn), SCN 1-19, SCN 8-14, SCN 72

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

and in-doubt transactions, SCN 1-35

recovery, SRF 1-100, SRF 1-101

server, SCN 1-16, SCN 1-33, SCN 8-5

dedicated, SCN 8-23

shared, SCN 8-14, SCN 8-15, SCN 8-20

shadow, SCN 8-23

SNP background processes, SAD 8-2

starting, OID 5-1

structure, SCN 8-2

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

trace files, SRF 1-121

trace files for, SCN 8-15

user, SCN 1-15, SCN 8-4

allocate PGAs, SCN 7-15

manual archiving by, SCN 362

recovery from failure of, SCN 8-12

sharing server processes, SCN 8-14, SCN 8-15

user processes, SRF 1-99

PROCESSES initialization parameter, REP 7-7, SRF 1-99

setting before database creation, SAD 2-23

PROCESSES parameter, PSA 1-12

ensuring LM lock capacity, PSA 10-3

processing

DDL statements, SCN 23

distributed, SCN 1-32

DML statements, SCN 19

overview, SCN 17

parallel SQL, SCN 158

queries, SCN 21

processing power of CPU, OID 12-15

processing, distributed, STU 3-11

processor affinity

parallel execution, PSC A-17

processor affinity, on SMP systems, OID 13-6

processXSL(XSLStylesheet, InputStream, URL) - oracle.xml.parser.v2.XSLProcessor.processXSL(oracle.xml.parser.v2.XSLStylesheet, java.io.InputStream, java.net.URL), JPR 4-148

processXSL(XSLStylesheet, Reader, URL) - oracle.xml.parser.v2.XSLProcessor.processXSL(oracle.xml.parser.v2.XSLStylesheet, java.io.Reader, java.net.URL), JPR 4-149

processXSL(XSLStylesheet, URL, URL) - oracle.xml.parser.v2.XSLProcessor.processXSL(oracle.xml.parser.v2.XSLStylesheet, java.net.URL, java.net.URL), JPR 4-149

processXSL(XSLStylesheet, XMLDocument) - oracle.xml.parser.v2.XSLProcessor.processXSL(oracle.xml.parser.v2.XSLStylesheet, oracle.xml.parser.v2.XMLDocument), JPR 4-150

processXSL(XSLStylesheet, XMLDocument, OutputStream) - oracle.xml.parser.v2.XSLProcessor.processXSL(oracle.xml.parser.v2.XSLStylesheet, oracle.xml.parser.v2.XMLDocument, java.io.OutputStream), JPR 4-151

processXSL(XSLStylesheet, XMLDocument, PrintWriter) - oracle.xml.parser.v2.XSLProcessor.processXSL(oracle.xml.parser.v2.XSLStylesheet, oracle.xml.parser.v2.XMLDocument, java.io.PrintWriter), JPR 4-151

processXSL(XSLStylesheet, XMLDocumentFragment) - oracle.xml.parser.v2.XSLProcessor.processXSL(oracle.xml.parser.v2.XSLStylesheet, oracle.xml.parser.v2.XMLDocumentFragment), JPR 4-150

processXSL(XSLStylesheet, XMLDocumentFragment, OutputStream) - oracle.xml.parser.v2.XSLProcessor.processXSL(oracle.xml.parser.v2.XSLStylesheet, oracle.xml.parser.v2.XMLDocumentFragment, java.io.OutputStream), JPR 4-150

processXSL(XSLStylesheet, XMLDocumentFragment, PrintWriter) - oracle.xml.parser.v2.XSLProcessor.processXSL(oracle.xml.parser.v2.XSLStylesheet, oracle.xml.parser.v2.XMLDocumentFragment, java.io.PrintWriter), JPR 4-151

Producer is closed - error, ADQ D-7

Producers, ADQ 7-3

PRODUCT_COMPONENT_VERSION view, SAD 1-22, SRF 2-158

PRODUCT_USER_PROFILE table, ADG 11-13, ADG 11-14, ADG 11-17

productivity, PLS 1-22

PROFILE clause

of ALTER USER. See CREATE USER

of CREATE USER, SQL 7-453

profiles, SAD 22-21

altering, SAD 22-23

assigning to a user, SQL 7-453

assigning to users, SAD 22-23

creating, SAD 22-22, SQL 7-360

examples, SQL 7-363

deassigning from users, SQL 7-494

default, SAD 22-22

disabling resource limits, SAD 22-21

dropping, SAD 22-25

enabling resource limits, SAD 22-21

granting

system privileges on, SQL 7-524

listing, SAD 22-25

managing, SAD 22-21

modifying, examples, SQL 7-71

overview of, SCN 1-42

password management, SCN 286

privileges for dropping, SAD 22-25

privileges to alter, SAD 22-23

privileges to set resource costs, SAD 22-24

PUBLIC_DEFAULT, SAD 22-22

removing from the database, SQL 7-494

resource limits, SRF 1-104, SRF 1-105

setting a limit to null, SAD 22-23

viewing, SAD 22-28

when to use, SCN 298

profiles (sqlnet.ora)

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

configuring

advanced options, NET 8-23

default domains, NET 8-17

configuring preferred Oracle Names servers, NET 8-26

naming methods, specifying, NET 8-19

prioritizing naming methods, NET 8-19

routing connection requests, NET 8-21

program global area (PGA), SCN 1-15, SCN 7-15

allocation of, SCN 7-15

contents of, SCN 7-15

effect of MAX_ENABLED_ROLES on, SAD 23-18

multi-threaded servers, SCN 8-20

nonshared and writable, SCN 7-15

size of, SCN 7-16

program interface, SCN 8-27

Oracle side (OPI), SCN 8-28

overview of, SCN 1-19

structure of, SCN 8-27

two-task mode in, SCN 8-25

user side (UPI), SCN 8-27

program interfaces, GTK 3-78 to GTK 3-87

Program Name field in Net8 Assistant, NET 8-47, NET 8-49

PROGRAM parameter, NET 8-47, NET 8-49, NET B-3, NET C-51

program termination, PCO 3-20

normal versus abnormal, PC_ 3-23

program units, PLS 1-11, SCN 1-24, SCN 24, SCN 44

prerequisites for compilation of, SCN 111

shared pool and, SCN 7-10

program units in PL/SQL, ADG 9-2

PROGRAM_ERROR exception, PLS 6-5

programmatic environments, ADL 3-2, ADQ 3-2

available functions, ADL 3-3

compared, ADL 3-3

for Oracle objects, ADO 3-1 to ADO 3-12

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

programming language support, PCO 1-3

Propagation, ADQ 1-15, ADQ 8-103, ADQ 12-90

propagation, REP 2-29, ADQ 1-12

altering method, SPR 37-24, RAR 8-90

disabling, SPR 11-21, RAR 8-36

initiating, REP 2-35

modes, REP 2-33

of changes

propagation

altering method, SPR 37-16, RAR 8-82

parallel, REP 2-36

implementing, REP 2-37

tuning, REP 2-38

reduction, REP A-6

removing, MIG 13-40

security context of propagator, REP 2-32

status of, SPR 11-7, RAR 8-22

Propagation Failures, ADQ 5-4

Propagation Features, ADQ 8-102

Propagation Issues, ADQ 5-3

Propagation of Messages with LOB Attributes, ADQ 8-108

Propagation Schedule, Altering, ADQ 9-75

Propagation Schedule, Disabling, ADQ 9-82

Propagation Schedule, Enabling, ADQ 9-79

Propagation Schedules in User Schema, Selecting, ADQ 10-30

Propagation Scheduling, ADQ 1-15, ADQ 8-104, ADQ 12-96

propagation scheduling capabilities, SCN 76

propagation, exception, PLS 6-12

Propagation, Exception Handling During, ADQ 12-100

Propagation, Message, ADQ 4-7

propagator

registering, SPR 11-16, RAR 2-5, RAR 8-31

replication, REP 2-12

property

CHARSETFORM, ADG 10-24

CHARSETID, ADG 10-24

INDICATOR, ADG 10-23

Property {0} not writeable - error, ADQ D-3

Property name must be specified - error, ADQ D-7

Property name size exceeded - error, ADQ D-8

Property not supported - error, ADQ D-8

propertyExists(String) - oracle.jms.AQjmsAdtMessage.propertyExists(java.lang.String), JPR 2-16

propertyExists(String) - oracle.jms.AQjmsMessage.propertyExists(java.lang.String), JPR 2-113

PROPS$ view

NCHAR and NLS, MIG 9-28

NCHAR character set, MIG 4-17

protected write mode, PSC 5-9

PROTOCOL

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

PROTOCOL (PRO or PROT) attribute, NET 8-29, NET 9-4, PSG 4-8

PROTOCOL parameter, NET 7-16, NET B-3

protocol.EXCLUDED_NODES parameter, NET C-77

protocol.INVITED_NODES parameter, NET C-77

protocol.ora file, NET C-78

configuration parameter reference, NET C-77

controlling access to database, NET C-77

DCE address parameters in, OAS 14-12

DCE.AUTHENTICATION parameter, OAS 14-12

DCE.LOCAL_CELL_USERNAMES parameter, OAS 14-12

DCE.PROTECTION parameter, OAS 14-12

DCE.TNS_ADDRESS_OID parameter, OAS 14-12

parameter for CDS, OAS 14-14

protocol.EXCLUDED_NODES parameter, NET C-77

protocol.INVITED_NODES parameter, NET C-77

protocol.VALIDNODE_CHECKING parameter, NET C-77

TCP.NODELAY parameter, NET C-77

protocols, OAS 1-12, NET B-3

Bequeath, NET 4-4, NET B-3

configuration parameter reference, NET C-77, NET C-78

configuring address with, NET B-1

configuring addresses, NET B-3

IPC, NET B-3

LU6.2, NET 4-4

Named Pipes, NET 4-3, NET B-3

selecting for network layout, NET 5-2

selecting multiple for network layout, NET 5-2

SPX, NET 4-3, NET B-4

TCP/IP, NET 4-2, NET B-4

TCP/IP with SSL, NET 4-2, NET B-4

protocol.VALIDNODE_CHECKING parameter, NET C-77

proxies, SCN 287

auditing clients of, SAD 24-11

multi-tier authentication and authorization, SAD 22-13

proxy clause

of ALTER USER, SQL 7-194, SQL 7-195

proxy copy

overview, RMN 1-22

requirement, MIG 9-44

proxy only option (RMAN)

backup command, RMN 1-22

proxy option (RMAN)

backup command, RMN 1-22

proxy servers

auditing clients, SAD 24-11

proxy snapshot administrator

creating, RAR 2-6

proxy user, managing user name and password, OID 5-19

PROXY_USER attribute, ADG 11-42, ADG 11-44

PROXY_USERS view, SAD 22-14, SRF 2-158

prtvtoc command, LEG 5-7

pruning

partitions, DWG 5-10

using DATE columns, DWG 5-11

pruning partitions, SCN 11-4, SCN 160, SCN 205

DATE datatype, SCN 11-21

EXPLAIN PLAN, SCN 11-22

index partitions, SCN 11-4

indexes, SCN 11-35

pseudocode, SCN 60

triggers, SCN 106

pseudocolumns, PCO 4-11, PLS 5-3, SQL 2-56

CHECK constraints prohibit

LEVEL and ROWNUM, SCN 271

CURRVAL, PCO 4-12, PLS 5-3, SQL 2-56

LEVEL, PCO 4-12, PLS 5-4, SQL 2-58

modifying views, ADG 13-8, SCN 94

NEXTVAL, PCO 4-12, PLS 5-3, SQL 2-56

ROWID, PLS 5-4, SCN 12-16, SQL 2-59

ROWNUM, PCO 4-12, PLS 5-5, SQL 2-60

cannot use indexes, STU 4-46

optimizing view queries, STU 4-77, STU 4-88

uses for, SQL 2-61

USER, SCN 309

pseudoinstruction, PLS 6-8

PSP

See PL/SQL server pages, ADG 12-2 to ??

.psp files, ADG 12-4

PSP. See PL/SQL Server Pages

PSTUBTBL view, SRF 2-159

PUBLIC clause

of ALTER DATABASE

thread of redo, SRF 1-117

of CREATE ROLLBACK SEGMENT, SQL 7-367

of CREATE SYNONYM, SQL 7-378

of DROP DATABASE LINK, SQL 7-475

public database links, NET 4-15

connected user, DDS 2-36

dropping, SQL 7-475

fixed user, DDS 2-34

public fixed user database links, DDS 2-34

public key, OID 2-22

public key infrastructure, OAS 1-8, OID 2-21, SCN 283

public objects, PLS 8-15

public rollback segments, PSA 3-5, SAD 11-3, SAD 11-7, SCN 4-27, SQL 7-367, SRF 1-105

bringing online, PSA 3-5

creating, PSA 3-5

owner, PSA 3-5

specifying, PSA 3-5

taking offline, SAD 11-12

using by default, PSA 3-5, SRF 1-105

public synonyms, SAD 18-14, SQL 7-378

dropping, SQL 7-500

PUBLIC thread, PSA 3-7

PUBLIC user group, ADG 11-34, SCN 294, SCN 322

granting and revoking privileges to, SAD 23-16

procedures and, SAD 23-17

validity of procedures, SCN 61

PUBLIC_DEFAULT profile

dropping profiles and, SAD 22-25

using, SAD 22-22

PUBLIC_DEPENDENCY view, SRF 2-159

publication

DDL statements, SCN 101

DML statements, SCN 101

logon/logoff events, SCN 100

system events

server errors, SCN 100

startup/shutdown, SCN 100

using triggers, SCN 99

PUBLICSYN view, SRF 2-159

publish(Message) - oracle.jms.AQjmsProducer.publish(javax.jms.Message), JPR 2-137

publish(Message, AQjmsAgent[]) - oracle.jms.AQjmsProducer.publish(javax.jms.Message, oracle.jms.AQjmsAgent[]), JPR 2-137

publish(Message, AQjmsAgent[]) - oracle.jms.AQjmsTopicPublisher.publish(javax.jms.Message, oracle.jms.AQjmsAgent[]), JPR 2-205

publish(Message, AQjmsAgent[], int, int, long) - oracle.jms.AQjmsProducer.publish(javax.jms.Message, oracle.jms.AQjmsAgent[], int, int, long), JPR 2-137

publish(Message, AQjmsAgent[], int, int, long) - oracle.jms.AQjmsTopicPublisher.publish(javax.jms.Message, oracle.jms.AQjmsAgent[], int, int, long), JPR 2-205

publish(Message, int, int, long) - oracle.jms.AQjmsProducer.publish(javax.jms.Message, int, int, long), JPR 2-138

publish(Topic, Message) - oracle.jms.AQjmsProducer.publish(javax.jms.Topic, javax.jms.Message), JPR 2-139

publish(Topic, Message, AQjmsAgent[]) - oracle.jms.AQjmsProducer.publish(javax.jms.Topic, javax.jms.Message, oracle.jms.AQjmsAgent[]), JPR 2-139

publish(Topic, Message, AQjmsAgent[]) - oracle.jms.AQjmsTopicPublisher.publish(javax.jms.Topic, javax.jms.Message, oracle.jms.AQjmsAgent[]), JPR 2-206

publish(Topic, Message, AQjmsAgent[], int, int, long) - oracle.jms.AQjmsProducer.publish(javax.jms.Topic, javax.jms.Message, oracle.jms.AQjmsAgent[], int, int, long), JPR 2-140

publish(Topic, Message, AQjmsAgent[], int, int, long) - oracle.jms.AQjmsTopicPublisher.publish(javax.jms.Topic, javax.jms.Message, oracle.jms.AQjmsAgent[], int, int, long), JPR 2-206

publish(Topic, Message, int, int, long) - oracle.jms.AQjmsProducer.publish(javax.jms.Topic, javax.jms.Message, int, int, long), JPR 2-140

publish-subscribe, ADG 15-2 to ADG 15-6

_SYSTEM_TRIG_ENABLED parameter, OCI 9-35

COMPATIBLE parameter, OCI 9-32

example, OCI 9-35

functions, OCI 9-32

handle attributes, OCI 9-33, OCI A-38

notification callback, OCI 9-33

notification feature, OCI 9-31

subscription handle, OCI 9-33

publish/subscribe

client notification, GTK 3-38

database event publication, GTK 3-39

publishers, GTK 3-38

rules-based subscriptions, GTK 3-38

subscribers, GTK 3-38

publish-subscribe functions, OCI 15-4

publish-subscribe model, SCN 69

Publish/Subscribe Support, ADQ 8-26

publish-subscribe support, SCN 77

event publication, SCN 99

listen capability, SCN 78

message propagation, SCN 76

rule-based subscriber, SCN 72

triggers, SCN 99

Publish/Subscribe using AQ, ADQ 7-12

publish/subscribe, AQ based, GTK 3-38

purchase order example

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

purge deferred transaction queue

master sites, RAR 2-6

snapshot sites, RAR 2-18

purge schedule, setting using Oracle Directory Manager, OID 10-12

PURGE SNAPSHOT LOG clause

of TRUNCATE, SQL 7-613

PURGE SNAPSHOT LOG option

TRUNCATE TABLE statement, RAR 7-21

PURGE_LOST_DB_ENTRY procedure

DBMS_TRANSACTION package, DDS 5-16

purges

periodic

scheduling, REP 7-12

purging

DBA_REPCATLOG table, SPR 37-69, RAR 8-135

deferred transaction queue, RAR 7-25

purging data, DWG 14-7

purging pending rows

from data dictionary, DDS 5-15

when necessary, DDS 5-16

purging recovery catalog

obsolete records, RMN 3-19

records with DELETED status, RMN 3-19

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

purity rules, PLS 7-9

push

deferred transactions, RAR 7-24

snapshot sites, RAR 2-19

PUSH_JOIN_PRED hint, SQL 2-67, STU 4-87

PUSH_JOIN_PREDICATE initialization parameter: obsolete

PUSH_PRED hint, STU 7-34

PUSH_SUBQ hint, SQL 2-67

pushes

continuous

scheduling, REP 7-11, REP 7-12

periodic

scheduling, REP 7-10

pushing deferred transactions, RAR 7-24

putValue(String, Object) - oracle.security.ssl.OracleSSLSession.putValue(java.lang.String, java.lang.Object), OAS F-39

putValue(String, Object) - oracle.security.ssl.SSLSocketSession.putValue(java.lang.String, java.lang.Object), OAS F-51

pwdsid.ora file, PSG 3-37