Home

Help

Contact Us

Oracle Database Master Index: P
10g Release 2 (10.2)

Shortcuts to Letters

Symbols

Numerals

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

Index Entries

p option (-props) (JPublisher User's Guide)

P prefix (sqlj -P-x) (SQLJ Developer's Guide and Reference)

P.M. datetime format element (SQL Reference)

     [entry #2] (SQL Reference)

PACKAGE

with SQL CREATE statement (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

package

DBMS_EXPFIL (PL/SQL Packages and Types Reference)

DBMS_ODCI (PL/SQL Packages and Types Reference)

DBMS_RLMGR (PL/SQL Packages and Types Reference)

DBMS_XDB (PL/SQL Packages and Types Reference)

DBMS_XMLDOM (PL/SQL Packages and Types Reference)

DBMS_XMLGEN (PL/SQL Packages and Types Reference)

DBMS_XMLPARSER (PL/SQL Packages and Types Reference)

DBMS_XMLQUERY (PL/SQL Packages and Types Reference)

DBMS_XMLSAVE (PL/SQL Packages and Types Reference)

DBMS_XMLSCHEMA (PL/SQL Packages and Types Reference)

definition (Application Developer's Guide - Fundamentals)

UriFactory (PL/SQL Packages and Types Reference)

Package - UriFactory (PL/SQL Packages and Types Reference)

package bodies

compile (2 Day DBA)

create (2 Day DBA)

creating (SQL Reference)

definition (2 Day DBA)

delete (2 Day DBA)

modify (2 Day DBA)

re-creating (SQL Reference)

removing from the database (SQL Reference)

PACKAGE BODY

with SQL CREATE statement (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

package body (Application Developer's Guide - Fundamentals)

     [entry #2] (Data Cartridge Developer's Guide)

package DBMS_JAVA (Java Developer's Guide)

     [entry #2] (Java Developer's Guide)

package declaration

syntax (PL/SQL User's Guide and Reference)

package overview (PL/SQL Packages and Types Reference)

package specification (Application Developer's Guide - Fundamentals)

     [entry #2] (Data Cartridge Developer's Guide)

package variables

i_am_a_refresh (PL/SQL Packages and Types Reference)

packaged call specifications, writing (Java Developer's Guide)

packaged cursors (PL/SQL User's Guide and Reference)

packaged procedures

dropping (SQL Reference)

packaged subprograms (PL/SQL User's Guide and Reference)

packages

     [entry #2] (Application Developer's Guide - Fundamentals)

     [entry #3] (Concepts)

     [entry #4] (SQL*Module for Ada Programmer's Guide)

advantages (PL/SQL User's Guide and Reference)

advantages of (Concepts)

as program units, definition (Concepts)

associating statistics with (SQL Reference)

     [subentry #2] (SQL Reference)

attributes (Oracle Call Interface Programmer's Guide)

auditing (Security Guide)

avoiding run-time compilation (SQL Reference)

bodiless (PL/SQL User's Guide and Reference)

body (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

     [subentry #3] (PL/SQL User's Guide and Reference)

call specification (PL/SQL User's Guide and Reference)

Callback for C (XML C API Reference)

calling subprograms (PL/SQL User's Guide and Reference)

compile (2 Day DBA)

contents of (PL/SQL User's Guide and Reference)

corruption (Data Cartridge Developer's Guide)

creating (Application Developer's Guide - Fundamentals)

     [subentry #2] (PL/SQL Packages and Types Reference)

     [subentry #3] (PL/SQL User's Guide and Reference)

     [subentry #4] (PL/SQL User's Guide and Reference)

     [subentry #5] (SQL Reference)

Ctx for C++ (XML C++ API Reference)

cursor specifications (PL/SQL User's Guide and Reference)

cursors (PL/SQL User's Guide and Reference)

DBMS_ADVISOR (Data Warehousing Guide)

     [subentry #2] (Performance Tuning Guide)

DBMS_CDC_PUBLISH (Data Warehousing Guide)

DBMS_CDC_SUBSCRIBE (Data Warehousing Guide)

DBMS_DIMENSION (Data Warehousing Guide)

DBMS_ERROR (Data Warehousing Guide)

DBMS_ERRORLOG (Data Warehousing Guide)

     [subentry #2] (Data Warehousing Guide)

DBMS_FILE_TRANSFER (Administrator's Guide)

DBMS_METADATA (Administrator's Guide)

DBMS_MVIEW (Data Warehousing Guide)

     [subentry #2] (Data Warehousing Guide)

DBMS_PIPE (Backup and Recovery Advanced User's Guide)

     [subentry #2] (Backup and Recovery Advanced User's Guide)

DBMS_REDEFINITION (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

DBMS_REPAIR (Administrator's Guide)

DBMS_RESOURCE_MANAGER (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

     [subentry #3] (Administrator's Guide)

     [subentry #4] (Administrator's Guide)

     [subentry #5] (Administrator's Guide)

DBMS_RESOURCE_MANAGER_PRIVS (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

     [subentry #3] (Administrator's Guide)

DBMS_RESUMABLE (Administrator's Guide)

DBMS_SESSION (Administrator's Guide)

DBMS_SPACE (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

DBMS_STATS (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

     [subentry #3] (Data Warehousing Guide)

     [subentry #4] (Performance Tuning Guide)

DBMS_STORAGE_MAP (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

DEBUG_EXTPROC (Application Developer's Guide - Fundamentals)

declaration (PL/SQL User's Guide and Reference)

definition (2 Day DBA)

     [subentry #2] (2 Day DBA)

describing (Oracle Call Interface Programmer's Guide)

disassociating statistics types from (SQL Reference)

DOM for C (XML C API Reference)

Dom for C++ (XML C++ API Reference)

dot notation (PL/SQL User's Guide and Reference)

dropping (Application Developer's Guide - Fundamentals)

dynamic SQL (Concepts)

examples of (Security Guide)

     [subentry #2] (Security Guide)

examples of features (PL/SQL User's Guide and Reference)

executing (Concepts)

for locking (Concepts)

global variables (PL/SQL User's Guide and Reference)

guidelines for writing (PL/SQL User's Guide and Reference)

hidden declarations (PL/SQL User's Guide and Reference)

in PL/SQL (Application Developer's Guide - Fundamentals)

     [subentry #2] (Data Cartridge Developer's Guide)

initializing (PL/SQL User's Guide and Reference)

invoker rights (SQL Reference)

IO for C++ (XML C++ API Reference)

links to examples (PL/SQL User's Guide and Reference)

modify (2 Day DBA)

modularity (PL/SQL User's Guide and Reference)

naming of (Application Developer's Guide - Fundamentals)

Oracle Database (Application Developer's Guide - Fundamentals)

Oracle Label Security (Label Security Administrator's Guide)

OracleXml for C++ (XML C++ API Reference)

ORDPLUGINS.ORDX_DEFAULT_AUDIO (interMedia User's Guide)

ORDPLUGINS.ORDX_DEFAULT_DOC (interMedia User's Guide)

ORDPLUGINS.ORDX_DEFAULT_VIDEO (interMedia User's Guide)

ORDPLUGINS.ORDX_FILE_SOURCE (interMedia User's Guide)

ORDPLUGINS.ORDX_HTTP_SOURCE (interMedia User's Guide)

overloading subprograms (PL/SQL User's Guide and Reference)

overview (PL/SQL User's Guide and Reference)

overview of Oracle supplied (PL/SQL User's Guide and Reference)

Parser for C++ (XML C++ API Reference)

private (Concepts)

private versus public objects (PL/SQL User's Guide and Reference)

privileges

divided by construct (Security Guide)

executing (Security Guide)

executing (Security Guide)

privileges for execution (Application Developer's Guide - Fundamentals)

privileges for recompiling (Administrator's Guide)

privileges required to create (Application Developer's Guide - Fundamentals)

privileges required to create procedures in (Application Developer's Guide - Fundamentals)

     [subentry #2] (Data Cartridge Developer's Guide)

product-specific (PL/SQL User's Guide and Reference)

product-specific for use with PL/SQL (PL/SQL User's Guide and Reference)

public (Concepts)

Range for C (XML C API Reference)

recompiling (Administrator's Guide)

recompiling explicitly (SQL Reference)

redefining (SQL Reference)

referencing (PL/SQL Packages and Types Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

removing from the database (SQL Reference)

replication (Advanced Replication)

restrictions on referencing (PL/SQL User's Guide and Reference)

SAX for C (XML C API Reference)

Schema for C (XML C API Reference)

scope (PL/SQL User's Guide and Reference)

serially reusable (PL/SQL User's Guide and Reference)

serially reusable packages (Application Developer's Guide - Fundamentals)

session state and (Application Developer's Guide - Fundamentals)

     [subentry #2] (Concepts)

shared SQL areas and (Concepts)

SOAP for C (XML C API Reference)

SOAP for C++ (XML C++ API Reference)

specification (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

specifications (PL/SQL User's Guide and Reference)

specifying schema and privileges of (SQL Reference)

STANDARD package (PL/SQL User's Guide and Reference)

synonyms (Application Developer's Guide - Fundamentals)

synonyms for (SQL Reference)

Tools for C++ (XML C++ API Reference)

Traversal for C (XML C API Reference)

trusted stored program units (Label Security Administrator's Guide)

understanding (PL/SQL User's Guide and Reference)

UTL_TCP (Application Developer's Guide - Fundamentals)

visibility of contents (PL/SQL User's Guide and Reference)

where documented (Application Developer's Guide - Fundamentals)

     [subentry #2] (PL/SQL Packages and Types Reference)

XML for C (XML C API Reference)

XPath for C (XML C API Reference)

XPath for C++ (XML C++ API Reference)

XPointer for C (XML C API Reference)

XPointer for C++ (XML C++ API Reference)

Xsl for C++ (XML C++ API Reference)

XSLT for C (XML C API Reference)

XSLTVM for C (XML C API Reference)

packages or PL/SQL plug-ins (interMedia User's Guide)

packages, Java

-package option (JPublisher User's Guide)

naming rules in INPUT file (JPublisher User's Guide)

packages, PL/SQL

generated classes for (JPublisher User's Guide)

option for package name (JPublisher User's Guide)

publishing (introduction) (JPublisher User's Guide)

packaging

deployment templates (Advanced Replication Management API Reference)

packaging deployment templates (Advanced Replication)

PACKBITS image compression format (interMedia Reference)

packets

examining trace data (Net Services Administrator's Guide)

     [subentry #2] (Net Services Administrator's Guide)

types of (Net Services Administrator's Guide)

PACK_MESSAGE procedures (PL/SQL Packages and Types Reference)

PACK_STGTAB_SQLPROF Procedure (PL/SQL Packages and Types Reference)

PACK_STGTAB_SQLSET Procedure (PL/SQL Packages and Types Reference)

padding (Spatial GeoRaster)

padding expressions (OLAP DML Reference)

     [entry #2] (OLAP DML Reference)

Padding forms (Security Guide)

padding of literal strings

SQL*Loader (Utilities)

page

about (HTML DB User's Guide)

adding (HTML DB User's Guide)

calling from a button (HTML DB User's Guide)

calling with an alias (HTML DB User's Guide)

creating from Application Builder (HTML DB User's Guide)

creating from Developer toolbar (HTML DB User's Guide)

creating from Page Definition (HTML DB User's Guide)

creating groups (HTML DB User's Guide)

deleting (HTML DB User's Guide)

enabling user customization (HTML DB User's Guide)

exporting (HTML DB User's Guide)

linking with f?p syntax (HTML DB User's Guide)

locking (HTML DB User's Guide)

optimizing for Printing (HTML DB User's Guide)

preventing conflicts (HTML DB User's Guide)

resource use (HTML DB User's Guide)

running (HTML DB User's Guide)

understanding layout (HTML DB User's Guide)

unlocking (HTML DB User's Guide)

zero (HTML DB User's Guide)

page attributes

Comments (HTML DB User's Guide)

Configuration Management (HTML DB User's Guide)

Duplicate Page Submission Checks (HTML DB User's Guide)

editing (HTML DB User's Guide)

HTML Header (HTML DB User's Guide)

On Error Text (HTML DB User's Guide)

On Load JavaScript (HTML DB User's Guide)

Page Header, Footer and Text Attributes (HTML DB User's Guide)

Page Help Text (HTML DB User's Guide)

Page Identification (HTML DB User's Guide)

Primary Display Attributes (HTML DB User's Guide)

Security (HTML DB User's Guide)

PAGE clause, 12 (SQL*Plus User's Guide and Reference)

PAGE command (OLAP DML Reference)

page components

summary view (HTML DB User's Guide)

page computation

defining computation point (HTML DB User's Guide)

defining computation source (HTML DB User's Guide)

editing computation attributes (HTML DB User's Guide)

making a computation conditional (HTML DB User's Guide)

page controls

summary view (HTML DB User's Guide)

Page Definition

about (HTML DB User's Guide)

accessing (HTML DB User's Guide)

Copy button (HTML DB User's Guide)

Copy icon (HTML DB User's Guide)

Create button (HTML DB User's Guide)

Create icon (HTML DB User's Guide)

creating a page (HTML DB User's Guide)

creating new controls and components (HTML DB User's Guide)

Delete button (HTML DB User's Guide)

Edit Attributes button (HTML DB User's Guide)

editing (HTML DB User's Guide)

Event View (HTML DB User's Guide)

Export (HTML DB User's Guide)

History (HTML DB User's Guide)

Object References (HTML DB User's Guide)

Page field (HTML DB User's Guide)

Page Processing (HTML DB User's Guide)

Page Rendering (HTML DB User's Guide)

Shared Components (HTML DB User's Guide)

summary view (HTML DB User's Guide)

viewing (HTML DB User's Guide)

Page field (HTML DB User's Guide)

page group

assigning pages (HTML DB User's Guide)

creating (HTML DB User's Guide)

managing (HTML DB User's Guide)

report (HTML DB User's Guide)

Page Header, Footer and Text Attributes (HTML DB User's Guide)

Body Header (HTML DB User's Guide)

Footer (HTML DB User's Guide)

Header Text (HTML DB User's Guide)

page help (HTML DB User's Guide)

creating (HTML DB User's Guide)

Page Help Text attribute (HTML DB User's Guide)

Page Identification (HTML DB User's Guide)

Groups (HTML DB User's Guide)

Name (HTML DB User's Guide)

Page Alias (HTML DB User's Guide)

page layout

affect of region attributes (HTML DB User's Guide)

page level template (HTML DB User's Guide)

page locks

managing (HTML DB User's Guide)

page number (HTML DB User's Guide)

page number, including in titles, 6.2.4 (SQL*Plus User's Guide and Reference)

page number, including in titles, 6.3.2 (SQL*Plus User's Guide and Reference)

page operator (interMedia Reference)

     [entry #2] (interMedia Reference)

page pool

performance statistics (OLAP Reference)

page processes

about (HTML DB User's Guide)

changing processing points (HTML DB User's Guide)

changing source (HTML DB User's Guide)

creating (HTML DB User's Guide)

editing attributes (HTML DB User's Guide)

making conditional (HTML DB User's Guide)

page processing (HTML DB User's Guide)

understanding (HTML DB User's Guide)

page processing controls (HTML DB User's Guide)

     [entry #2] (HTML DB User's Guide)

branching (HTML DB User's Guide)

computations (HTML DB User's Guide)

processes (HTML DB User's Guide)

validations (HTML DB User's Guide)

page rendering (HTML DB User's Guide)

Regions (HTML DB User's Guide)

understanding (HTML DB User's Guide)

page rendering controls (HTML DB User's Guide)

buttons (HTML DB User's Guide)

computations (HTML DB User's Guide)

items (HTML DB User's Guide)

managing (HTML DB User's Guide)

processes (HTML DB User's Guide)

regions (HTML DB User's Guide)

page reports

database object dependencies (HTML DB User's Guide)

object references (HTML DB User's Guide)

viewing (HTML DB User's Guide)

page table (Performance Tuning Guide)

page template

Configuration Management (HTML DB User's Guide)

editing (HTML DB User's Guide)

Error Page Template Control (HTML DB User's Guide)

Header / Body / Footer Definitions (HTML DB User's Guide)

Image Based Tab Attributes (HTML DB User's Guide)

Multi Column Region Table Attribute (HTML DB User's Guide)

Parent Tab Attributes (HTML DB User's Guide)

Standard Tab Attributes (HTML DB User's Guide)

substitution strings (HTML DB User's Guide)

Subtemplate Definitions (HTML DB User's Guide)

Template Identification attribute (HTML DB User's Guide)

Template Subscription (HTML DB User's Guide)

page template substitution strings (HTML DB User's Guide)

#APP_VERSION# (HTML DB User's Guide)

#BOX_BODY# (HTML DB User's Guide)

#CUSTOMIZE# (HTML DB User's Guide)

#FORM_CLOSE# (HTML DB User's Guide)

#FORM_OPEN# (HTML DB User's Guide)

#GLOBAL_NOTIFICATION# (HTML DB User's Guide)

#HEAD# (HTML DB User's Guide)

#LOGO# (HTML DB User's Guide)

#NAVIGATION_BAR# (HTML DB User's Guide)

#NOTIFICATION_MESSAGE# (HTML DB User's Guide)

#ONLOAD# (HTML DB User's Guide)

#PARENT_TAB_CELLS# (HTML DB User's Guide)

#REGION_POSITION_NN# (HTML DB User's Guide)

#SUCCESS_MESSAGE# (HTML DB User's Guide)

#TAB_CELLS# (HTML DB User's Guide)

#TITLE# (HTML DB User's Guide)

Page View Activity logs

truncating (HTML DB User's Guide)

page zero (HTML DB User's Guide)

page-charset (Globalization Support Guide)

page-out activity, 8.3.2 (Administrator's Reference for UNIX-Based Operating Systems)

PAGELEN

PAGELEN option (Programmer's Guide to the Oracle Precompilers)

PAGELEN precompiler option (Pro*COBOL Programmer's Guide)

PAGENUM option (OLAP DML Reference)

pageout considerations (Data Guard Concepts and Administration)

pageouts

SQL Apply (Data Guard Concepts and Administration)

PAGEPRG option (OLAP DML Reference)

pages (Concepts)

assigning to groups (HTML DB User's Guide)

PAGESIZE (OLAP DML Reference)

PAGESIZE clause

PAGESIZE variable, 12 (SQL*Plus User's Guide and Reference)

     [entry #2] (SQL*Plus User's Guide and Reference)

PAGESIZE variable, 4.4 (SQL*Plus User's Guide and Reference)

PAGESIZE variable, 6.3.6 (SQL*Plus User's Guide and Reference)

PAGESIZE variable, 8.5.8 (SQL*Plus User's Guide and Reference)

pagination

reports (HTML DB User's Guide)

     [subentry #2] (HTML DB User's Guide)

     [subentry #3] (HTML DB User's Guide)

     [subentry #4] (HTML DB User's Guide)

Pagination Subtemplate

Next Page Template (HTML DB User's Guide)

     [subentry #2] (HTML DB User's Guide)

Next Set Template (HTML DB User's Guide)

     [subentry #2] (HTML DB User's Guide)

Pagination Template (HTML DB User's Guide)

     [subentry #2] (HTML DB User's Guide)

Previous Page Template (HTML DB User's Guide)

     [subentry #2] (HTML DB User's Guide)

Previous Set Template (HTML DB User's Guide)

     [subentry #2] (HTML DB User's Guide)

paging

     [entry #2] (OLAP Application Developer's Guide)

     [entry #3] (Performance Tuning Guide)

reducing (Performance Tuning Guide)

paging in reports (OLAP DML Reference)

forcing a page break (OLAP DML Reference)

line number on current page (OLAP DML Reference)

lines for bottom margin (OLAP DML Reference)

lines for top margin (OLAP DML Reference)

lines left on page (OLAP DML Reference)

lines on a page (OLAP DML Reference)

page number (OLAP DML Reference)

producing a custom heading (OLAP DML Reference)

producing a standard heading (OLAP DML Reference)

turning on (OLAP DML Reference)

PAGING option (OLAP DML Reference)

paging space, 8.3 (Administrator's Reference for UNIX-Based Operating Systems)

paging, controlling, 8.3.2 (Administrator's Reference for UNIX-Based Operating Systems)

palette table (Spatial GeoRaster)

PARA function

of HTF package (PL/SQL Packages and Types Reference)

PARA procedure

of HTP package (PL/SQL Packages and Types Reference)

PARAGRAPH function

of HTF package (PL/SQL Packages and Types Reference)

PARAGRAPH keyword (Text Reference)

paragraph names

associating with SQL statements (Pro*COBOL Programmer's Guide)

coding area for (Pro*COBOL Programmer's Guide)

PARAGRAPH procedure

of HTP package (PL/SQL Packages and Types Reference)

paragraph section

defining (Text Reference)

querying (Text Reference)

paragraph tags

GT GlossaryTitle (Advanced Security Administrator's Guide)

     [subentry #2] (Data Warehousing Guide)

     [subentry #3] (Enterprise User Administrator's Guide)

parallel access

to external tables (Concepts)

parallel aggregation and external context (Data Cartridge Developer's Guide)

parallel apply

and log apply services (Data Guard Broker)

managing in a physical standby database (Data Guard Broker)

PARALLEL clause (Data Warehousing Guide)

     [entry #2] (Data Warehousing Guide)

CREATE INDEX statement (Performance Tuning Guide)

of ALTER CLUSTER (SQL Reference)

     [subentry #2] (SQL Reference)

of ALTER INDEX (SQL Reference)

of ALTER MATERIALIZED VIEW (SQL Reference)

     [subentry #2] (SQL Reference)

of ALTER MATERIALIZED VIEW LOG (SQL Reference)

     [subentry #2] (SQL Reference)

of ALTER TABLE (SQL Reference)

of CREATE CLUSTER (SQL Reference)

of CREATE INDEX (SQL Reference)

of CREATE MATERIALIZED VIEW (SQL Reference)

     [subentry #2] (SQL Reference)

of CREATE MATERIALIZED VIEW LOG (SQL Reference)

     [subentry #2] (SQL Reference)

of CREATE TABLE (SQL Reference)

     [subentry #2] (SQL Reference)

parallelization rules (Data Warehousing Guide)

PARALLEL CREATE INDEX statement (Data Warehousing Guide)

PARALLEL CREATE TABLE AS SELECT statement

resources required (Data Warehousing Guide)

parallel DDL (Data Warehousing Guide)

extent allocation (Data Warehousing Guide)

parallelization rules (Data Warehousing Guide)

partitioned tables and indexes (Data Warehousing Guide)

restrictions

LOBs (Data Warehousing Guide)

LOBs (Data Warehousing Guide)

object types (Data Warehousing Guide)

object types (Data Warehousing Guide)

object types (Data Warehousing Guide)

Parallel DDL (PDDL) transactions

SQL Apply (Data Guard Concepts and Administration)

parallel delete (Data Warehousing Guide)

parallel DELETE statement (Data Warehousing Guide)

parallel DML

     [entry #2] (Data Warehousing Guide)

applications (Data Warehousing Guide)

bitmap indexes (Concepts)

     [subentry #2] (Concepts)

     [subentry #3] (Data Warehousing Guide)

degree of parallelism (Data Warehousing Guide)

     [subentry #2] (Data Warehousing Guide)

enabling PARALLEL DML (Data Warehousing Guide)

lock and enqueue resources (Data Warehousing Guide)

parallelization rules (Data Warehousing Guide)

recovery (Data Warehousing Guide)

restrictions (Data Warehousing Guide)

object types (Data Warehousing Guide)

object types (Data Warehousing Guide)

object types (Data Warehousing Guide)

object types (Data Warehousing Guide)

object types (Data Warehousing Guide)

remote transactions (Data Warehousing Guide)

transaction model (Data Warehousing Guide)

parallel DML (PDML) transactions

SQL Apply (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

parallel DML support (Application Developer's Guide - Large Objects)

Parallel evaluation of user-defined aggregates (Data Cartridge Developer's Guide)

parallel execution

     [entry #2] (Concepts)

     [entry #3] (Concepts)

coordinator (Concepts)

full table scans (Data Warehousing Guide)

hints (SQL Reference)

I/O parameters (Data Warehousing Guide)

index creation (Data Warehousing Guide)

interoperator parallelism (Data Warehousing Guide)

intraoperator parallelism (Data Warehousing Guide)

managing (Administrator's Guide)

of DDL statements (SQL Reference)

of DML statements (SQL Reference)

of table functions (Concepts)

parallel hints (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

parallelizing index creation (Administrator's Guide)

plans (Data Warehousing Guide)

process classification (Concepts)

     [subentry #2] (Concepts)

query optimization (Data Warehousing Guide)

resource parameters (Data Warehousing Guide)

resumable space allocation (Administrator's Guide)

rewriting SQL (Data Warehousing Guide)

server (Concepts)

servers (Concepts)

solving problems (Data Warehousing Guide)

tuning (Concepts)

     [subentry #2] (Concepts)

     [subentry #3] (Data Warehousing Guide)

parallel execution for index creation and rebuilding (Spatial User's Guide and Reference)

     [entry #2] (Spatial User's Guide and Reference)

     [entry #3] (Spatial User's Guide and Reference)

parallel execution processes

logical standby databases (Data Guard Concepts and Administration)

physical standby databases (Data Guard Concepts and Administration)

tuning the log apply rate (Data Guard Concepts and Administration)

specifying

PARALLEL_MAX_SERVERS initialization parameter (Data Guard Concepts and Administration)

PARALLEL_MAX_SERVERS initialization parameter (Data Guard Concepts and Administration)

parallel execution servers (Security Guide)

PARALLEL hint (Data Warehousing Guide)

     [entry #2] (Data Warehousing Guide)

     [entry #3] (Data Warehousing Guide)

     [entry #4] (SQL Reference)

parallelization rules (Data Warehousing Guide)

UPDATE and DELETE (Data Warehousing Guide)

parallel hints (Administrator's Guide)

     [entry #2] (Administrator's Guide)

parallel index creation (Text Reference)

parallel indexing (Text Application Developer's Guide)

     [entry #2] (Text Application Developer's Guide)

     [entry #3] (Text Reference)

     [entry #4] (Text Reference)

     [entry #5] (Text Reference)

DBMS_PCLUTIL.BUILD_PART_INDEX (Text Reference)

example (Text Reference)

local partitioned index (Text Reference)

partitioned table (Text Application Developer's Guide)

parallel instance groups, 14.3.3 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

parallel join bitmap filtering (New Features Guide)

parallel loads (Utilities)

restrictions on direct path (Utilities)

parallel LONG-to-LOB migration (Application Developer's Guide - Large Objects)

PARALLEL option

tuning the log apply rate for Redo Apply (Data Guard Concepts and Administration)

PARALLEL parameter

Data Pump Export utility

command-line interface (Utilities)

interactive-command mode (Utilities)

Data Pump Import utility

command-line mode (Utilities)

interactive-command mode (Utilities)

SQL*Loader command line (Utilities)

parallel partition-wise joins

performance considerations (Data Warehousing Guide)

parallel propagation (Advanced Replication)

configuring for replication environments (Advanced Replication)

dependency

tracking (Advanced Replication)

implementing (Advanced Replication)

monitoring (Advanced Replication Management API Reference)

     [subentry #2] (Advanced Replication Management API Reference)

planning for (Advanced Replication)

replication environment (Advanced Replication)

row level SCN (Advanced Replication)

tuning (Advanced Replication)

parallel queries (Text Application Developer's Guide)

     [entry #2] (Text Application Developer's Guide)

parallel query

     [entry #2] (Data Warehousing Guide)

and SYS_CONTEXT (Security Guide)

application context (Security Guide)

bitmap indexes (Concepts)

     [subentry #2] (Concepts)

     [subentry #3] (Data Warehousing Guide)

index-organized tables (Data Warehousing Guide)

maximum number of instances (Reference)

maximum number of servers (Reference)

minimum number of queries (Reference)

object types (Data Warehousing Guide)

restrictions (Data Warehousing Guide)

objects (Application Developer's Guide - Object-Relational Features)

parallelization rules (Data Warehousing Guide)

restrictions for Oracle objects (Application Developer's Guide - Object-Relational Features)

view objects (Application Developer's Guide - Object-Relational Features)

parallel query, and SYS_CONTEXT (Security Guide)

parallel recovery (Backup and Recovery Advanced User's Guide)

parallel recovery processes

initiated for Redo Apply (Data Guard Concepts and Administration)

parallel recovery, 8.7.2.1 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

parallel server

distributed locks (Application Developer's Guide - Fundamentals)

parallel SQL (Concepts)

     [entry #2] (Concepts)

allocating rows to parallel execution servers (Data Warehousing Guide)

coordinator process (Concepts)

degree of parallelism (Data Warehousing Guide)

instance groups (Data Warehousing Guide)

number of parallel execution servers (Data Warehousing Guide)

optimizer (Data Warehousing Guide)

parallelization rules (Data Warehousing Guide)

server processes (Concepts)

shared server (Data Warehousing Guide)

parallel update (Data Warehousing Guide)

parallel UPDATE statement (Data Warehousing Guide)

parallelism

     [entry #2] (Data Warehousing Guide)

backups (Backup and Recovery Advanced User's Guide)

configuring RMAN (Backup and Recovery Advanced User's Guide)

     [subentry #2] (Backup and Recovery Advanced User's Guide)

degree (Data Warehousing Guide)

     [subentry #2] (Data Warehousing Guide)

degree, overriding (Data Warehousing Guide)

enabling for tables and queries (Data Warehousing Guide)

interoperator (Data Warehousing Guide)

intraoperator (Data Warehousing Guide)

manually allocated RMAN channels (Backup and Recovery Advanced User's Guide)

parallelizing table creation (Administrator's Guide)

     [entry #2] (Administrator's Guide)

PARALLEL_ADAPTIVE_MULTI_USER initialization parameter (Data Warehousing Guide)

     [entry #2] (Reference)

setting with ALTER SYSTEM (SQL Reference)

PARALLEL_AUTOMATIC_TUNING initialization parameter (Reference)

PARALLEL_DEGREE_LIMIT_ABSOLUTE resource allocation method (Administrator's Guide)

PARALLEL_ENABLE clause

of CREATE FUNCTION (SQL Reference)

PARALLEL_ENABLE keyword (Application Developer's Guide - Fundamentals)

PARALLEL_ENABLE option (Java Developer's Guide)

use with functions (PL/SQL User's Guide and Reference)

PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter (Data Warehousing Guide)

     [entry #2] (Data Warehousing Guide)

     [entry #3] (Reference)

setting with ALTER SYSTEM (SQL Reference)

PARALLEL_INDEX hint (Data Warehousing Guide)

     [entry #2] (SQL Reference)

PARALLEL_INSTANCE_GROUP initialization parameter (Reference)

setting with ALTER SYSTEM (SQL Reference)

PARALLEL_MAX_SERVERS initialization parameter (Advanced Replication)

     [entry #2] (Advanced Replication)

     [entry #3] (Data Warehousing Guide)

     [entry #4] (Data Warehousing Guide)

     [entry #5] (Data Warehousing Guide)

     [entry #6] (Reference)

     [entry #7] (Streams Concepts and Administration)

and parallel execution (Data Warehousing Guide)

setting with ALTER SYSTEM (SQL Reference)

specifying

creating a logical standby database (Data Guard Concepts and Administration)

creating a logical standby database (Data Guard Concepts and Administration)

PARALLEL_MAX_SERVERS parameter, 8.7.2.1 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

PARALLEL_MIN_PERCENT initialization parameter (Data Warehousing Guide)

     [entry #2] (Data Warehousing Guide)

     [entry #3] (Data Warehousing Guide)

     [entry #4] (Reference)

setting with ALTER SYSTEM (SQL Reference)

PARALLEL_MIN_SERVERS initialization parameter (Advanced Replication)

     [entry #2] (Advanced Replication)

     [entry #3] (Data Warehousing Guide)

     [entry #4] (Data Warehousing Guide)

     [entry #5] (Data Warehousing Guide)

     [entry #6] (Reference)

setting with ALTER SYSTEM (SQL Reference)

PARALLEL_THREADS_PER_CPU initialization parameter (Data Warehousing Guide)

     [entry #2] (Reference)

setting with ALTER SYSTEM (SQL Reference)

PARALLE_ENABLE option

FUNCTION (PL/SQL User's Guide and Reference)

PARAM function

of HTF package (PL/SQL Packages and Types Reference)

PARAM procedure

of HTP package (PL/SQL Packages and Types Reference)

parameter

server (Concepts)

transactional (Text Reference)

     [subentry #2] (Text Reference)

parameter definitions (sizes)

general information (SQLJ Developer's Guide and Reference)

Oracle customizer optparamdefaults option (SQLJ Developer's Guide and Reference)

Oracle customizer optparams option (SQLJ Developer's Guide and Reference)

SQLJ -optparamdefaults option (SQLJ Developer's Guide and Reference)

SQLJ -optparams option (SQLJ Developer's Guide and Reference)

parameter descriptor (Oracle Call Interface Programmer's Guide)

attributes (Oracle Call Interface Programmer's Guide)

     [subentry #2] (Oracle Call Interface Programmer's Guide)

parameter descriptor object (Oracle Call Interface Programmer's Guide)

parameter file (OLAP Application Developer's Guide)

parameter files

creating (SQL Reference)

definition (Concepts)

Export (Utilities)

Export and Import

comments in (Utilities)

maximum size (Utilities)

Import (Utilities)

See also initialization parameter file.

SQL*Loader (Utilities)

parameter files (INIT.ORA files)

parameter list (SQL*Module for Ada Programmer's Guide)

parameter mode (Pro*COBOL Programmer's Guide)

parameter modes

     [entry #2] (Java Developer's Guide)

     [entry #3] (Programmer's Guide to the Oracle Precompilers)

IN (JDBC Developer's Guide and Reference)

IN OUT (JDBC Developer's Guide and Reference)

OUT (JDBC Developer's Guide and Reference)

     [subentry #2] (JDBC Developer's Guide and Reference)

     [subentry #3] (JDBC Developer's Guide and Reference)

parameter modes, 7.1.4 (Pro*C/C++ Precompiler Programmer's Guide)

Parameter objects

compared to CursorInput objects (OLAP Developer's Guide to the OLAP API)

     [subentry #2] (OLAP Developer's Guide to the OLAP API)

description (OLAP Developer's Guide to the OLAP API)

example of (OLAP Developer's Guide to the OLAP API)

     [subentry #2] (OLAP Developer's Guide to the OLAP API)

     [subentry #3] (OLAP Developer's Guide to the OLAP API)

parameter passing

by reference (PL/SQL User's Guide and Reference)

by value (PL/SQL User's Guide and Reference)

in dynamic SQL (PL/SQL User's Guide and Reference)

parameter, 12 (SQL*Plus User's Guide and Reference)

     [entry #2] (SQL*Plus User's Guide and Reference)

     [entry #3] (SQL*Plus User's Guide and Reference)

parameter, 5.11 (SQL*Plus User's Guide and Reference)

parameterized Source objects

definition (OLAP Developer's Guide to the OLAP API)

description (OLAP Developer's Guide to the OLAP API)

example of (OLAP Developer's Guide to the OLAP API)

     [subentry #2] (OLAP Developer's Guide to the OLAP API)

     [subentry #3] (OLAP Developer's Guide to the OLAP API)

parameterized statements (Oracle C++ Call Interface Programmer's Guide)

parameters

actual (PL/SQL User's Guide and Reference)

actual versus formal (PL/SQL User's Guide and Reference)

admin_option (Streams Advanced Queuing User's Guide and Reference)

agent_list (Streams Advanced Queuing User's Guide and Reference)

agent_name (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

alias (Streams Advanced Queuing User's Guide and Reference)

aliasing (PL/SQL User's Guide and Reference)

AQ_TM_PROCESSES (Streams Advanced Queuing User's Guide and Reference)

array_size (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

attempts (Streams Advanced Queuing User's Guide and Reference)

attributes (Oracle Call Interface Programmer's Guide)

attribute_number (Streams Advanced Queuing User's Guide and Reference)

authentication

Kerberos (Advanced Security Administrator's Guide)

RADIUS (Advanced Security Administrator's Guide)

Secure Sockets Layer (SSL) (Advanced Security Administrator's Guide)

autocommit (Streams Advanced Queuing User's Guide and Reference)

BLANK_TRIMMING (Globalization Support Guide)

buffer lengths (Oracle Call Interface Programmer's Guide)

     [subentry #2] (Oracle Call Interface Programmer's Guide)

calendar (Globalization Support Guide)

certificate (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

certificate_location (Streams Advanced Queuing User's Guide and Reference)

character set conversion (Globalization Support Guide)

comment (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

compatibility (Streams Advanced Queuing User's Guide and Reference)

compatible (Streams Advanced Queuing User's Guide and Reference)

configuration for JDBC (Advanced Security Administrator's Guide)

consumer_name (Streams Advanced Queuing User's Guide and Reference)

correlation (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

cursor (PL/SQL User's Guide and Reference)

db_username (Streams Advanced Queuing User's Guide and Reference)

default values (Application Developer's Guide - Fundamentals)

     [subentry #2] (PL/SQL User's Guide and Reference)

with stored functions (Application Developer's Guide - Fundamentals)

delay (Streams Advanced Queuing User's Guide and Reference)

delivery_mode (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

     [subentry #3] (Streams Advanced Queuing User's Guide and Reference)

     [subentry #4] (Streams Advanced Queuing User's Guide and Reference)

deployment templates (Advanced Replication)

     [subentry #2] (Advanced Replication Management API Reference)

dequeue (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

dequeue_mode (Streams Advanced Queuing User's Guide and Reference)

dequeue_options (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

deq_condition (Streams Advanced Queuing User's Guide and Reference)

destination (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

destination_queue (Streams Advanced Queuing User's Guide and Reference)

dest_queue_name (Streams Advanced Queuing User's Guide and Reference)

duration (Streams Advanced Queuing User's Guide and Reference)

enable_anyp (Streams Advanced Queuing User's Guide and Reference)

enable_http (Streams Advanced Queuing User's Guide and Reference)

encryption and checksumming (Advanced Security Administrator's Guide)

enqueue (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

enqueue_options (Streams Advanced Queuing User's Guide and Reference)

enqueue_time (Streams Advanced Queuing User's Guide and Reference)

exception_queue (Streams Advanced Queuing User's Guide and Reference)

expiration (Streams Advanced Queuing User's Guide and Reference)

formal (PL/SQL User's Guide and Reference)

FREELISTS (Data Warehousing Guide)

from_schema (Streams Advanced Queuing User's Guide and Reference)

from_type (Streams Advanced Queuing User's Guide and Reference)

grantee (Streams Advanced Queuing User's Guide and Reference)

grant_option (Streams Advanced Queuing User's Guide and Reference)

IN mode (PL/SQL User's Guide and Reference)

IN OUT mode (PL/SQL User's Guide and Reference)

in PL/SQL subprograms (PL/SQL User's Guide and Reference)

in syntax

optional (SQL Reference)

required (SQL Reference)

in syntax diagrams (Recovery Manager Reference)

initialization (Concepts)

locking behavior (Concepts)

JOB_QUEUE_PROCESSES (Streams Advanced Queuing User's Guide and Reference)

latency (Streams Advanced Queuing User's Guide and Reference)

linguistic sorts (Globalization Support Guide)

listen_delivery_mode (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

     [subentry #3] (Streams Advanced Queuing User's Guide and Reference)

log_directory (Streams Advanced Queuing User's Guide and Reference)

log_level (Streams Advanced Queuing User's Guide and Reference)

max_retries (Streams Advanced Queuing User's Guide and Reference)

message_grouping (Streams Advanced Queuing User's Guide and Reference)

message_properties (Streams Advanced Queuing User's Guide and Reference)

message_properties_array (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

methods of setting (Globalization Support Guide)

modes (Application Developer's Guide - Fundamentals)

     [subentry #2] (Oracle Call Interface Programmer's Guide)

     [subentry #3] (Oracle Call Interface Programmer's Guide)

     [subentry #4] (PL/SQL User's Guide and Reference)

monetary (Globalization Support Guide)

msgid (Streams Advanced Queuing User's Guide and Reference)

MSG_STATE (Streams Advanced Queuing User's Guide and Reference)

multiple_consumers (Streams Advanced Queuing User's Guide and Reference)

name (Streams Advanced Queuing User's Guide and Reference)

namespace (Streams Advanced Queuing User's Guide and Reference)

navigation (Streams Advanced Queuing User's Guide and Reference)

next_time (Streams Advanced Queuing User's Guide and Reference)

NLS_CALENDAR (Globalization Support Guide)

NLS_COMP (Globalization Support Guide)

NLS_CREDIT (Globalization Support Guide)

NLS_CURRENCY (Globalization Support Guide)

NLS_DATE_FORMAT (Globalization Support Guide)

NLS_DATE_LANGUAGE (Globalization Support Guide)

NLS_DEBIT (Globalization Support Guide)

NLS_DUAL_CURRENCY (Globalization Support Guide)

NLS_ISO_CURRENCY (Globalization Support Guide)

NLS_LANG (Globalization Support Guide)

NLS_LANGUAGE (Globalization Support Guide)

NLS_LIST_SEPARATOR (Globalization Support Guide)

NLS_MONETARY_CHARACTERS (Globalization Support Guide)

NLS_NCHAR_CONV_EXCP (Globalization Support Guide)

NLS_NUMERIC_CHARACTERS (Globalization Support Guide)

NLS_SORT (Globalization Support Guide)

NLS_TERRITORY (Globalization Support Guide)

numeric (Globalization Support Guide)

obj_location (Streams Advanced Queuing User's Guide and Reference)

original_msgid (Streams Advanced Queuing User's Guide and Reference)

OUT mode (PL/SQL User's Guide and Reference)

OWNER_INSTANCE (Streams Advanced Queuing User's Guide and Reference)

passing strings (Oracle Call Interface Programmer's Guide)

payload (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

payload_array (Streams Advanced Queuing User's Guide and Reference)

post_count (Streams Advanced Queuing User's Guide and Reference)

post_list (Streams Advanced Queuing User's Guide and Reference)

primary_instance (Streams Advanced Queuing User's Guide and Reference)

priority (Streams Advanced Queuing User's Guide and Reference)

protocol.ora (Security Guide)

purge_condition (Streams Advanced Queuing User's Guide and Reference)

purge_options (Streams Advanced Queuing User's Guide and Reference)

queue_name (Streams Advanced Queuing User's Guide and Reference)

queue_payload_type (Streams Advanced Queuing User's Guide and Reference)

queue_table (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

queue_to_queue (Streams Advanced Queuing User's Guide and Reference)

queue_type (Streams Advanced Queuing User's Guide and Reference)

recipient_list (Streams Advanced Queuing User's Guide and Reference)

reg_count (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

reg_list (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

relative_msgid (Streams Advanced Queuing User's Guide and Reference)

REMOTE_LISTENER (Streams Advanced Queuing User's Guide and Reference)

retention_time (Streams Advanced Queuing User's Guide and Reference)

retry_delay (Streams Advanced Queuing User's Guide and Reference)

rule (Streams Advanced Queuing User's Guide and Reference)

secondary_instance (Streams Advanced Queuing User's Guide and Reference)

secure (Streams Advanced Queuing User's Guide and Reference)

sender_id (Streams Advanced Queuing User's Guide and Reference)

sequence_deviation (Streams Advanced Queuing User's Guide and Reference)

setting (Globalization Support Guide)

     [subentry #2] (Text Reference)

sort_list (Streams Advanced Queuing User's Guide and Reference)

src_queue_name (Streams Advanced Queuing User's Guide and Reference)

start_time (Streams Advanced Queuing User's Guide and Reference)

state (Streams Advanced Queuing User's Guide and Reference)

storage (Concepts)

     [subentry #2] (Concepts)

storage_clause (Streams Advanced Queuing User's Guide and Reference)

streams_pool_size (Streams Advanced Queuing User's Guide and Reference)

string length (Oracle Call Interface Programmer's Guide)

     [subentry #2] (Oracle Call Interface Programmer's Guide)

summary of modes (PL/SQL User's Guide and Reference)

time and date (Globalization Support Guide)

time zone (Globalization Support Guide)

     [subentry #2] (Globalization Support Guide)

to_schema (Streams Advanced Queuing User's Guide and Reference)

to_type (Streams Advanced Queuing User's Guide and Reference)

transaction_group (Streams Advanced Queuing User's Guide and Reference)

transformation (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

     [subentry #3] (Streams Advanced Queuing User's Guide and Reference)

user values (Advanced Replication Management API Reference)

user_property (Streams Advanced Queuing User's Guide and Reference)

viewing system-defined (Text Reference)

visibility (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

wait (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

PARAMETERS clause

of CREATE INDEX (SQL Reference)

PARAMETERS clause with external procedure (Data Cartridge Developer's Guide)

PARAMETERS clause, 12 (SQL*Plus User's Guide and Reference)

PARAMETER_LIST networking parameter (Net Services Administrator's Guide)

     [entry #2] (Net Services Reference)

paramstring for CREATE INDEX (Text Application Developer's Guide)

PARENS option (OLAP DML Reference)

parent attribute

example of getting (OLAP Developer's Guide to the OLAP API)

method for getting (OLAP Developer's Guide to the OLAP API)

parent cursor (Programmer's Guide to the Oracle Precompilers)

parent element, definition (XML Developer's Kit Programmer's Guide)

Parent ET Key (OLAP Reference)

     [entry #2] (OLAP Reference)

Parent Grouping ID (OLAP Reference)

     [entry #2] (OLAP Reference)

parent layer (Spatial Topology and Network Data Models)

parent link

getting (Spatial Topology and Network Data Models)

setting (Spatial Topology and Network Data Models)

parent Model objects

of a CustomModel (OLAP Developer's Guide to the OLAP API)

of a Model (OLAP Developer's Guide to the OLAP API)

parent node (Spatial Topology and Network Data Models)

getting ID (Spatial Topology and Network Data Models)

setting for a node (Spatial Topology and Network Data Models)

Parent Tab Attributes (HTML DB User's Guide)

parent tabs

creating (HTML DB User's Guide)

parent workspace (Application Developer's Guide - Workspace Manager)

conflicts with (Application Developer's Guide - Workspace Manager)

parent-child relations

described (OLAP Application Developer's Guide)

parent-child relationships

in hierarchies (OLAP Developer's Guide to the OLAP API)

     [subentry #2] (OLAP Developer's Guide to the OLAP API)

in levels (OLAP Developer's Guide to the OLAP API)

parentheses (PL/SQL User's Guide and Reference)

altering precedence (Text Reference)

     [subentry #2] (Text Reference)

grouping character (Text Reference)

parentNode() (XML C++ API Reference)

PARENTREL relation (OLAP Application Developer's Guide)

PARENT_ID column

PLAN_TABLE table (Performance Tuning Guide)

PARFILE parameter

Data Pump Export utility (Utilities)

Data Pump Import utility (Utilities)

Export command line (Utilities)

Import command line (Utilities)

SQL*Loader command line (Utilities)

PARSE

parse (Programmer's Guide to the Oracle Precompilers)

PARSE command (OLAP DML Reference)

     [entry #2] (OLAP DML Reference)

     [entry #3] (OLAP DML Reference)

parse error offset

     [entry #2] (Pro*COBOL Programmer's Guide)

     [entry #3] (Programmer's Guide to the Oracle Precompilers)

how to interpret (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

use in error reporting (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

parse option (sqlj -parse) (SQLJ Developer's Guide and Reference)

PARSE Procedure (PL/SQL Packages and Types Reference)

PARSE procedure (Heterogeneous Connectivity Administrator's Guide)

     [entry #2] (PL/SQL Packages and Types Reference)

     [entry #3] (PL/SQL Packages and Types Reference)

parse tree (Application Developer's Guide - Fundamentals)

parse trees

construction of (Concepts)

in shared SQL area (Concepts)

parse() (XML C++ API Reference)

     [entry #2] (XML C++ API Reference)

PARSEBUFFER procedure (PL/SQL Packages and Types Reference)

PARSECLOB procedure (PL/SQL Packages and Types Reference)

parsedEntityDecl() (XML C++ API Reference)

PARSEDTD procedure (PL/SQL Packages and Types Reference)

parseDTD() (XML C++ API Reference)

     [entry #2] (XML C++ API Reference)

parseDTD() method (XML Developer's Kit Programmer's Guide)

PARSEDTDBUFFER procedure (PL/SQL Packages and Types Reference)

PARSEDTDCLOB procedure (PL/SQL Packages and Types Reference)

Parser Datatypes (XML C++ API Reference)

DOMParserIdType (XML C++ API Reference)

ParserExceptionCode (XML C++ API Reference)

SAXParserIdType (XML C++ API Reference)

SchValidatorIdType (XML C++ API Reference)

Parser for Java (XML Developer's Kit Programmer's Guide)

constructor extension functions (XML Developer's Kit Programmer's Guide)

oraxsl (XML Developer's Kit Programmer's Guide)

return value extension function (XML Developer's Kit Programmer's Guide)

supported database (XML Developer's Kit Programmer's Guide)

using DTDs (XML Developer's Kit Programmer's Guide)

Parser for Java, overview (XML Developer's Kit Programmer's Guide)

Parser package for C++ (XML C++ API Reference)

ParserException Interface

getCode() (XML C++ API Reference)

getMesLang() (XML C++ API Reference)

getMessage() (XML C++ API Reference)

getParserCode() (XML C++ API Reference)

Parser package (XML C++ API Reference)

ParserExceptionCode datatype, Parser package (XML C++ API Reference)

parseSchVal() (XML C++ API Reference)

parsing (Concepts)

DBMS_SQL package (Concepts)

embedded SQL (Concepts)

hard (Performance Tuning Guide)

Oracle Forms (Performance Tuning Guide)

Oracle precompilers (Performance Tuning Guide)

parse calls (Concepts)

parse locks (Concepts)

     [subentry #2] (Concepts)

performed (Concepts)

reducing unnecessary calls (Performance Tuning Guide)

soft (Performance Tuning Guide)

SQL statements (Concepts)

     [subentry #2] (Concepts)

parsing dynamic statements

PREPARE statement (Pro*COBOL Programmer's Guide)

parsing dynamic statements, PREPARE command (Programmer's Guide to the Oracle Precompilers)

parsing expressions (OLAP DML Reference)

     [entry #2] (OLAP DML Reference)

partial archived redo log files

registering (Data Guard Concepts and Administration)

partial update of XML data

definition (XML DB Developer's Guide)

partition

default (Data Warehousing Guide)

PARTITION ... LOB storage clause

of ALTER TABLE (SQL Reference)

PARTITION BY HASH clause (Administrator's Guide)

of CREATE TABLE (SQL Reference)

PARTITION BY LIST clause (Administrator's Guide)

of CREATE TABLE (SQL Reference)

PARTITION BY RANGE clause (Administrator's Guide)

for composite-partitioned tables (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

of CREATE TABLE (SQL Reference)

     [subentry #2] (SQL Reference)

Partition Change Tracking (PCT) (Data Warehousing Guide)

     [entry #2] (Data Warehousing Guide)

     [entry #3] (Data Warehousing Guide)

with Pmarkers (Data Warehousing Guide)

Partition Change Tracking Refresh (PCT) (New Features Guide)

PARTITION clause

for composite-partitioned tables (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

for hash partitions (Administrator's Guide)

for list partitions (Administrator's Guide)

for range partitions (Administrator's Guide)

of ANALYZE (SQL Reference)

of CREATE INDEX (SQL Reference)

of CREATE TABLE (SQL Reference)

of DELETE (SQL Reference)

of INSERT (SQL Reference)

of LOCK TABLE (SQL Reference)

of UPDATE (SQL Reference)

partition pruning (Data Warehousing Guide)

     [entry #2] (New Features Guide)

dynamic (Data Warehousing Guide)

static (Data Warehousing Guide)

techniques (Data Warehousing Guide)

PARTITION table

routing engine use of (Spatial User's Guide and Reference)

partition templates (OLAP DML Reference)

     [entry #2] (OLAP DML Reference)

defining (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

deleting (OLAP DML Reference)

maintaining (OLAP DML Reference)

retrieving partition names (OLAP DML Reference)

retrieving partitioning method (OLAP DML Reference)

partition-extended table names

in DML statements (SQL Reference)

restrictions on (SQL Reference)

syntax (SQL Reference)

partition-level Export (Utilities)

example session (Utilities)

partition-level Import (Utilities)

specifying (Utilities)

partition-wise joins (Data Warehousing Guide)

benefits of (Data Warehousing Guide)

full (Data Warehousing Guide)

     [subentry #2] (Performance Tuning Guide)

full, and EXPLAIN PLAN output (Performance Tuning Guide)

partial (Data Warehousing Guide)

partial, and EXPLAIN PLAN output (Performance Tuning Guide)

PARTITIONCHECK function (OLAP DML Reference)

partitioned

indexes (Globalization Support Guide)

tables (Globalization Support Guide)

partitioned index

     [entry #2] (Text Application Developer's Guide)

cannot be created or dropped on version-enabled table (Application Developer's Guide - Workspace Manager)

creating local in parallel (Text Reference)

example (Text Reference)

improved response time (Text Application Developer's Guide)

local (Text Reference)

parallel creation (Text Reference)

rebuild example (Text Reference)

partitioned index creation

example (Text Reference)

partitioned index-organized tables

restrictions for LOB columns (Application Developer's Guide - Large Objects)

secondary indexes, updating (SQL Reference)

partitioned indexes (2 Day DBA)

     [entry #2] (Administrator's Guide)

     [entry #3] (Performance Tuning Guide)

     [entry #4] (SQL Reference)

     [entry #5] (SQL Reference)

     [entry #6] (SQL Reference)

     [entry #7] (SQL Reference)

adding partitions (Administrator's Guide)

creating local index on composite partitioned table (Administrator's Guide)

creating local index on hash partitioned table (Administrator's Guide)

creating range partitions (Administrator's Guide)

description (Administrator's Guide)

dropping partitions (Administrator's Guide)

global (Administrator's Guide)

local (Administrator's Guide)

local, creating (SQL Reference)

maintenance operations (Administrator's Guide)

maintenance operations, table of (Administrator's Guide)

modifying partition default attributes (Administrator's Guide)

modifying real attributes of partitions (Administrator's Guide)

moving partitions (Administrator's Guide)

rebuilding index partitions (Administrator's Guide)

renaming index partitions/subpartitions (Administrator's Guide)

secondary indexes on index-organized tables (Administrator's Guide)

splitting partitions (Administrator's Guide)

user-defined (SQL Reference)

partitioned loads

concurrent conventional path loads (Utilities)

SQL*Loader (Utilities)

partitioned objects

and EXPLAIN PLAN statement (Performance Tuning Guide)

partitioned outer join (Data Warehousing Guide)

partitioned spatial indexes (Spatial User's Guide and Reference)

exchanging partitions (Spatial User's Guide and Reference)

partitioned tables (Administrator's Guide)

     [entry #2] (SQL Reference)

adding partitions (Administrator's Guide)

adding subpartitions (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

coalescing partitions (Administrator's Guide)

creating hash partitions (Administrator's Guide)

creating list partitions (Administrator's Guide)

creating range partitions (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

creating range-hash partitions (Administrator's Guide)

creating range-list partitions (Administrator's Guide)

data warehouses (Data Warehousing Guide)

description (Administrator's Guide)

DISABLE ROW MOVEMENT (Administrator's Guide)

dropped partitions (Backup and Recovery Advanced User's Guide)

dropping (Administrator's Guide)

     [subentry #2] (New Features Guide)

dropping partitions (Administrator's Guide)

ENABLE ROW MOVEMENT (Administrator's Guide)

exchanging partitions (Administrator's Guide)

exchanging subpartitions (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

export consistency and (Utilities)

exporting (Utilities)

global indexes on (Administrator's Guide)

importing (Utilities)

     [subentry #2] (Utilities)

index-organized tables (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

     [subentry #3] (Administrator's Guide)

     [subentry #4] (Administrator's Guide)

loading (Utilities)

local indexes on (Administrator's Guide)

maintenance operations (Administrator's Guide)

maintenance operations, table of (Administrator's Guide)

marking indexes UNUSABLE (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

     [subentry #3] (Administrator's Guide)

     [subentry #4] (Administrator's Guide)

     [subentry #5] (Administrator's Guide)

     [subentry #6] (Administrator's Guide)

     [subentry #7] (Administrator's Guide)

     [subentry #8] (Administrator's Guide)

     [subentry #9] (Administrator's Guide)

     [subentry #10] (Administrator's Guide)

     [subentry #11] (Administrator's Guide)

     [subentry #12] (Administrator's Guide)

materialized views (Data Warehousing Guide)

merging partitions (Administrator's Guide)

modifying (Text Reference)

modifying default attributes (Administrator's Guide)

modifying real attributes of partitions (Administrator's Guide)

modifying real attributes of subpartitions (Administrator's Guide)

moving partitions (Administrator's Guide)

moving subpartitions (Administrator's Guide)

multicolumn partitioning keys (Administrator's Guide)

performing partial TSPITR (Backup and Recovery Advanced User's Guide)

rebuilding index partitions (Administrator's Guide)

redefining partitions online (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

rules for (Administrator's Guide)

renaming partitions (Administrator's Guide)

renaming subpartitions (Administrator's Guide)

split partitions (Backup and Recovery Advanced User's Guide)

splitting partitions (Administrator's Guide)

truncating partitions (Administrator's Guide)

truncating subpartitions (Administrator's Guide)

updating global indexes automatically (Administrator's Guide)

partitioned variables (OLAP DML Reference)

     [entry #2] (OLAP DML Reference)

aggregating (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

defining (OLAP DML Reference)

deleting data from (OLAP DML Reference)

maintaining (OLAP DML Reference)

retrieving dimensions of (OLAP DML Reference)

retrieving partitioning method (OLAP DML Reference)

partitioning

     [entry #2] (Data Warehousing Guide)

     [entry #3] (Label Security Administrator's Guide)

     [entry #4] (Label Security Administrator's Guide)

     [entry #5] (OLAP Application Developer's Guide)

by range (SQL Reference)

clauses

of ALTER INDEX (SQL Reference)

of ALTER TABLE (SQL Reference)

composite (Data Warehousing Guide)

     [subentry #2] (Data Warehousing Guide)

creating partitions (Administrator's Guide)

data (Data Warehousing Guide)

data segment compression (Data Warehousing Guide)

bitmap indexes (Data Warehousing Guide)

default partition (Administrator's Guide)

default subpartition (Administrator's Guide)

distribution value (Performance Tuning Guide)

examples of (Performance Tuning Guide)

examples of composite (Performance Tuning Guide)

hash (Data Warehousing Guide)

     [subentry #2] (Performance Tuning Guide)

index-organized tables (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

     [subentry #3] (Administrator's Guide)

     [subentry #4] (Administrator's Guide)

indexes (Administrator's Guide)

     [subentry #2] (Data Warehousing Guide)

list (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

     [subentry #3] (Administrator's Guide)

     [subentry #4] (Data Warehousing Guide)

maintaining partitions (Administrator's Guide)

materialized views (Data Warehousing Guide)

methods (Administrator's Guide)

of materialized view logs (SQL Reference)

     [subentry #2] (SQL Reference)

of materialized views (SQL Reference)

     [subentry #2] (SQL Reference)

     [subentry #3] (SQL Reference)

prebuilt tables (Data Warehousing Guide)

range (Data Warehousing Guide)

     [subentry #2] (Data Warehousing Guide)

     [subentry #3] (Performance Tuning Guide)

range-hash (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

range-list (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

     [subentry #3] (Data Warehousing Guide)

See also partitioned tables

start and stop columns (Performance Tuning Guide)

subpartition templates (Administrator's Guide)

tables (Administrator's Guide)

tables containing Oracle objects (Application Developer's Guide - Object-Relational Features)

partitioning a database migration (Utilities)

advantages of (Utilities)

disadvantages of (Utilities)

procedure during export (Utilities)

partitioning methods (OLAP DML Reference)

partitions

     [entry #2] (Concepts)

     [entry #3] (Concepts)

     [entry #4] (Concepts)

     [entry #5] (OLAP DML Reference)

     [entry #6] (OLAP DML Reference)

adding (OLAP DML Reference)

     [subentry #2] (SQL Reference)

adding rows to (SQL Reference)

adding values to (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

affinity (Data Warehousing Guide)

allocating extents for (SQL Reference)

based on literal values (SQL Reference)

bitmap indexes (Concepts)

     [subentry #2] (Data Warehousing Guide)

composite

specifying (SQL Reference)

concat (OLAP DML Reference)

converting into nonpartitioned tables (SQL Reference)

DATE datatype (Data Warehousing Guide)

deallocating unused space from (SQL Reference)

defining (OLAP DML Reference)

list partitions (OLAP DML Reference)

deleting (OLAP DML Reference)

deleting data (OLAP DML Reference)

dropping (SQL Reference)

dynamic partitioning (Concepts)

equipartitioning

examples (Data Warehousing Guide)

local indexes (Data Warehousing Guide)

exchanging with tables (SQL Reference)

extents

allocating for an index (SQL Reference)

external (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

     [subentry #3] (OLAP DML Reference)

getting ID (Spatial Topology and Network Data Models)

global indexes (Data Warehousing Guide)

hash

adding (SQL Reference)

coalescing (SQL Reference)

specifying (SQL Reference)

hash partitioning (Concepts)

index (SQL Reference)

inserting rows into (SQL Reference)

internal (OLAP DML Reference)

list (OLAP DML Reference)

list, adding (SQL Reference)

LOB storage characteristics of (SQL Reference)

local indexes (Data Warehousing Guide)

locking (SQL Reference)

locking segments of (OLAP DML Reference)

logging attribute (SQL Reference)

logging insert operations (SQL Reference)

materialized views (Concepts)

     [subentry #2] (Concepts)

merging (SQL Reference)

modifying (SQL Reference)

     [subentry #2] (SQL Reference)

moving to a different segment (SQL Reference)

moving values (OLAP DML Reference)

multicolumn keys (Data Warehousing Guide)

nonprefixed indexes (Concepts)

     [subentry #2] (Data Warehousing Guide)

     [subentry #3] (Data Warehousing Guide)

parallel DDL (Data Warehousing Guide)

partition bounds (Data Warehousing Guide)

partition pruning

DATE datatype (Data Warehousing Guide)

disk striping and (Data Warehousing Guide)

indexes (Data Warehousing Guide)

partitioning indexes (Data Warehousing Guide)

     [subentry #2] (Data Warehousing Guide)

partitioning keys (Data Warehousing Guide)

     [subentry #2] (Data Warehousing Guide)

physical attributes (Data Warehousing Guide)

changing (SQL Reference)

prefixed indexes (Data Warehousing Guide)

pruning (Data Warehousing Guide)

range (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

adding (SQL Reference)

specifying (SQL Reference)

range partitioning

disk striping and (Data Warehousing Guide)

removing rows from (SQL Reference)

     [subentry #2] (SQL Reference)

renaming (SQL Reference)

restrictions

datatypes (Data Warehousing Guide)

retrieving dimensions of (OLAP DML Reference)

retrieving names of (OLAP DML Reference)

revising values in (SQL Reference)

rules of parallelism (Data Warehousing Guide)

See also partitioned indexes.

See also partitioned tables.

segments (Concepts)

     [subentry #2] (Concepts)

specifying values of (OLAP DML Reference)

splitting (SQL Reference)

storage characteristics (SQL Reference)

tablespace for

defining (SQL Reference)

PARTITIONS clause

for hash partitions (Administrator's Guide)

PARTITION_ID column

PLAN_TABLE table (Performance Tuning Guide)

PARTITION_START column

PLAN_TABLE table (Performance Tuning Guide)

PARTITION_STOP column

PLAN_TABLE table (Performance Tuning Guide)

partition_storage_clause

of ALTER TABLE (SQL Reference)

pass-phrase

to read and parse server.key file (Security Guide)

pass-through SQL

avoiding SQL interpretation (Heterogeneous Connectivity Administrator's Guide)

executing statements (Heterogeneous Connectivity Administrator's Guide)

non-queries (Heterogeneous Connectivity Administrator's Guide)

queries (Heterogeneous Connectivity Administrator's Guide)

with bind variables (Heterogeneous Connectivity Administrator's Guide)

with IN bind variables (Heterogeneous Connectivity Administrator's Guide)

with IN OUT bind variables (Heterogeneous Connectivity Administrator's Guide)

with OUT bind variables (Heterogeneous Connectivity Administrator's Guide)

implications of using (Heterogeneous Connectivity Administrator's Guide)

overview (Heterogeneous Connectivity Administrator's Guide)

restrictions (Heterogeneous Connectivity Administrator's Guide)

passes option (sqlj -passes) (SQLJ Developer's Guide and Reference)

passes, two-pass compiling (SQLJ Developer's Guide and Reference)

passing options to other executables (SQLJ Developer's Guide and Reference)

password

changing (HTML DB User's Guide)

     [subentry #2] (HTML DB User's Guide)

     [subentry #3] (HTML DB User's Guide)

establish for listener (Security Guide)

     [subentry #2] (Security Guide)

     [subentry #3] (Security Guide)

     [subentry #4] (Security Guide)

in AUTHORIZATION clause (SQL*Module for Ada Programmer's Guide)

resetting (HTML DB User's Guide)

resetting and e-mailing (HTML DB User's Guide)

supplied at runtime (SQL*Module for Ada Programmer's Guide)

password aging and expiration (Security Guide)

grace period (Security Guide)

     [subentry #2] (Security Guide)

example (Security Guide)

password backup encryption (Backup and Recovery Advanced User's Guide)

PASSWORD command, 12 (SQL*Plus User's Guide and Reference)

     [entry #2] (SQL*Plus User's Guide and Reference)

password complexity verification (Security Guide)

     [entry #2] (Security Guide)

formatting of routine (Security Guide)

sample routine (Security Guide)

PASSWORD EXPIRE clause

of ALTER USER. See CREATE USER

of CREATE USER (SQL Reference)

password file

adding users (Administrator's Guide)

creating (Administrator's Guide)

ORAPWD utility (Administrator's Guide)

removing (Administrator's Guide)

setting REMOTE_LOGIN_PASSWORD (Administrator's Guide)

viewing members (Administrator's Guide)

password file authentication (Administrator's Guide)

for Automatic Storage Management (Administrator's Guide)

password files (2 Day DBA)

     [entry #2] (Security Guide)

     [entry #3] (Security Guide)

     [entry #4] (Security Guide)

connecting to Recovery Manager with (Backup and Recovery Advanced User's Guide)

creating new (Data Guard Concepts and Administration)

requirements (Data Guard Concepts and Administration)

setting REMOTE_LOGIN_PASSWORDFILE initialization parameter (Data Guard Concepts and Administration)

password management (Oracle Call Interface Programmer's Guide)

     [entry #2] (Oracle Call Interface Programmer's Guide)

account locking (Security Guide)

explicit (Security Guide)

ALTER PROFILE statement (Security Guide)

CREATE PROFILE statement (Security Guide)

expiration grace period (Security Guide)

     [subentry #2] (Security Guide)

explicitly expire (Security Guide)

failed login attempts (Security Guide)

failed logins resetting (Security Guide)

grace period

example (Security Guide)

history (Security Guide)

lifetime for password (Security Guide)

password complexity verification (Security Guide)

PASSWORD_LOCK_TIME (Security Guide)

PASSWORD_REUSE_MAX (Security Guide)

PASSWORD_REUSE_TIME (Security Guide)

sample password complexity verification routine (Security Guide)

UTLPWDMG.SQL

password management (Security Guide)

password management policy (Security Guide)

password option (customizer harness) (SQLJ Developer's Guide and Reference)

password option for checking (sqlj) (SQLJ Developer's Guide and Reference)

Password Policies (Enterprise User Administrator's Guide)

password security (Security Guide)

password, specifying (JDBC Developer's Guide and Reference)

passwords

account locking (Concepts)

     [subentry #2] (Security Guide)

administrative (Security Guide)

     [subentry #2] (Security Guide)

administrator privileges (Concepts)

authenticating (Reference)

     [subentry #2] (Reference)

change via ALTER USER statement (Security Guide)

changing at runtime with ALTER AUTHORIZATION (Pro*COBOL Programmer's Guide)

changing for roles (Security Guide)

complexity verification (Concepts)

     [subentry #2] (Security Guide)

connecting to RMAN (Backup and Recovery Advanced User's Guide)

connecting with (Concepts)

connecting without (Concepts)

     [subentry #2] (Security Guide)

database user authentication (Concepts)

     [subentry #2] (Security Guide)

default (Security Guide)

default for SYS and SYSTEM (Administrator's Guide)

defining (Pro*COBOL Programmer's Guide)

duration (Security Guide)

     [subentry #2] (Security Guide)

encrypted

database (Concepts)

encryption (Concepts)

     [subentry #2] (Security Guide)

     [subentry #3] (Security Guide)

     [subentry #4] (Security Guide)

expiration of (SQL Reference)

expiring (Security Guide)

grace period (SQL Reference)

guaranteeing complexity (SQL Reference)

hardcoding (Pro*COBOL Programmer's Guide)

history (Security Guide)

PASSWORD_REUSE_MAX (Security Guide)

PASSWORD_REUSE_TIME (Security Guide)

length, history, and complexity (Security Guide)

length, history, and complexity, (Security Guide)

limiting use and reuse (SQL Reference)

Listener Control utility access (Net Services Reference)

locking (SQL Reference)

making unavailable (SQL Reference)

management (Security Guide)

management rules (Security Guide)

     [subentry #2] (Security Guide)

parameters

of CREATE PROFILE (SQL Reference)

password file (Administrator's Guide)

password files (Concepts)

     [subentry #2] (Security Guide)

password reuse (Concepts)

     [subentry #2] (Security Guide)

privileges for changing for roles (Security Guide)

privileges to alter (Security Guide)

REMOTE_LOGIN_PASSWORDFILE initialization parameter (Reference)

resetting system (Data Mining Administrator's Guide)

reuse (Security Guide)

     [subentry #2] (Security Guide)

role (Security Guide)

roles (Security Guide)

security policy for users (Concepts)

     [subentry #2] (Security Guide)

setting REMOTE_LOGIN_PASSWORD parameter (Administrator's Guide)

special characters in (SQL Reference)

SYS and SYSTEM (Security Guide)

     [subentry #2] (Security Guide)

     [subentry #3] (Security Guide)

used in roles (Concepts)

     [subentry #2] (Security Guide)

user authentication (Security Guide)

PASSWORDS_listener_name networking parameter (Net Services Reference)

PASSWORDS_listener_name parameter (Net Services Administrator's Guide)

     [entry #2] (Net Services Reference)

PASSWORD_GRACE_TIME parameter

of ALTER PROFILE (SQL Reference)

of CREATE PROFILE (SQL Reference)

PASSWORD_instance_namenetworking parameter (Net Services Reference)

PASSWORD_LIFE_TIME (Security Guide)

PASSWORD_LIFE_TIME parameter

of ALTER PROFILE (SQL Reference)

of CREATE PROFILE (SQL Reference)

PASSWORD_LOCK_TIME (Security Guide)

PASSWORD_LOCK_TIME parameter

of ALTER PROFILE (SQL Reference)

of CREATE PROFILE (SQL Reference)

PASSWORD_REUSE_MAX (Security Guide)

PASSWORD_REUSE_MAX parameter

of ALTER PROFILE (SQL Reference)

of CREATE PROFILE (SQL Reference)

PASSWORD_REUSE_TIME (Security Guide)

PASSWORD_REUSE_TIME parameter

of ALTER PROFILE (SQL Reference)

of CREATE PROFILE (SQL Reference)

PASSWORD_VERIFIER column (Enterprise User Administrator's Guide)

PASSWORD_VERIFY_FUNCTION parameter

of ALTER PROFILE (SQL Reference)

of CREATE PROFILE (SQL Reference)

pasting text, 1.2.3.2 (SQL*Plus User's Guide and Reference)

patch set releases

upgrading (Data Guard Concepts and Administration)

patches

applying

using Streams (Streams Concepts and Administration)

patches, installing (Administrator's Guide)

patchsets (Managing Oracle Software Using Oracle Universal Installer and OPatch)

PATH

path (WITH clause), unsupported (SQLJ Developer's Guide and Reference)

path and classpath (SQLJ Developer's Guide and Reference)

path attribute (Text Reference)

path element

definition (XML DB Developer's Guide)

PATH environment variable, 1.2.2 (Administrator's Reference for UNIX-Based Operating Systems)

PATH environment variable, 4.2.1 (Administrator's Reference for UNIX-Based Operating Systems)

PATH environment variable, 6.4.1.1 (Administrator's Reference for UNIX-Based Operating Systems)

PATH environment variable, 6.4.1.2 (Administrator's Reference for UNIX-Based Operating Systems)

PATH function (SQL Quick Reference)

path ID

setting (Spatial Topology and Network Data Models)

path name

definition (XML DB Developer's Guide)

getting (Spatial Topology and Network Data Models)

resolution (XML DB Developer's Guide)

setting (Spatial Topology and Network Data Models)

path name, definition (XML Developer's Kit Programmer's Guide)

path rules (Ultra Search User's Guide)

     [entry #2] (Ultra Search User's Guide)

     [entry #3] (Ultra Search User's Guide)

path section searching (Text Application Developer's Guide)

path SQL function (XML DB Developer's Guide)

path table

definition (Spatial Topology and Network Data Models)

path type

setting (Spatial Topology and Network Data Models)

PATH variable, specifying (JDBC Developer's Guide and Reference)

path-based access to repository resources (XML DB Developer's Guide)

path-link table

definition (Spatial Topology and Network Data Models)

pathaliasproc (HTTP Server Administrator's Guide)

paths (Spatial Topology and Network Data Models)

adding (Spatial Topology and Network Data Models)

checking if active (Spatial Topology and Network Data Models)

checking if closed (Spatial Topology and Network Data Models)

checking if connected (Spatial Topology and Network Data Models)

checking if in logical network (Spatial Topology and Network Data Models)

checking if simple or complex (Spatial Topology and Network Data Models)

checking if temporary (Spatial Topology and Network Data Models)

complex (Spatial Topology and Network Data Models)

definition (Spatial Topology and Network Data Models)

deleting (Spatial Topology and Network Data Models)

getting cost (Spatial Topology and Network Data Models)

getting end node (Spatial Topology and Network Data Models)

getting geometry (Spatial Topology and Network Data Models)

getting name (Spatial Topology and Network Data Models)

getting node IDs (Spatial Topology and Network Data Models)

getting number of links (Spatial Topology and Network Data Models)

getting start node (Spatial Topology and Network Data Models)

getting type (Spatial Topology and Network Data Models)

minimum cost (Spatial Topology and Network Data Models)

returning all (Spatial Topology and Network Data Models)

setting geometry (Spatial Topology and Network Data Models)

setting ID (Spatial Topology and Network Data Models)

setting name (Spatial Topology and Network Data Models)

setting type (Spatial Topology and Network Data Models)

simple (Spatial Topology and Network Data Models)

temporary (Spatial Topology and Network Data Models)

PATH_SECTION_GROUP

example (Text Application Developer's Guide)

querying with (Text Reference)

PATH_SECTION_GROUP object (Text Reference)

     [entry #2] (Text Reference)

PATH_SECTION_GROUP system-defined preference (Text Reference)

PATH_VIEW (SQL Reference)

     [entry #2] (SQL Reference)

     [entry #3] (XML DB Developer's Guide)

pattern

check if it exists in BFILE using instr (Application Developer's Guide - Large Objects)

see if it exists IN LOB using (instr)

internal persistent LOBs (Application Developer's Guide - Large Objects)

pattern matching (OLAP DML Reference)

     [entry #2] (PL/SQL User's Guide and Reference)

table names during import (Utilities)

pattern-matching conditions (SQL Reference)

PAUSE command, 12 (SQL*Plus User's Guide and Reference)

PAUSE command, 5.12.3 (SQL*Plus User's Guide and Reference)

PAUSE variable, 12 (SQL*Plus User's Guide and Reference)

     [entry #2] (SQL*Plus User's Guide and Reference)

PAUSE variable, 4.10 (SQL*Plus User's Guide and Reference)

PAUSE_PROFILER function and procedure (PL/SQL Packages and Types Reference)

payloads

ANYDATA wrappers for (Streams Advanced Queuing User's Guide and Reference)

Internet operations (Streams Advanced Queuing User's Guide and Reference)

restrictions (Streams Advanced Queuing User's Guide and Reference)

structured (Streams Advanced Queuing User's Guide and Reference)

transformations with Messaging Gateway (Streams Advanced Queuing User's Guide and Reference)

XMLType (Streams Advanced Queuing User's Guide and Reference)

payment schedules (OLAP DML Reference)

for loan interest (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

for loans (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

PBMF image format (interMedia Reference)

pcbcfg.cfg file, 6.1.1 (Administrator's Reference for UNIX-Based Operating Systems)

pccfor.cfg file, 6.1.1 (Administrator's Reference for UNIX-Based Operating Systems)

PCDATA, definition (XML Developer's Kit Programmer's Guide)

PCM lock

mapping blocks to (Reference)

pcode

when generated for triggers (Application Developer's Guide - Fundamentals)

pcscfg.cfg file, 6.1.1 (Administrator's Reference for UNIX-Based Operating Systems)

PCTFREE parameter

     [entry #2] (Performance Tuning Guide)

     [entry #3] (Performance Tuning Guide)

     [entry #4] (interMedia User's Guide)

of ALTER CLUSTER (SQL Reference)

of ALTER INDEX (SQL Reference)

of ALTER MATERIALIZED VIEW LOG (SQL Reference)

of ALTER TABLE (SQL Reference)

of CREATE MATERIALIZED VIEW LOG. See CREATE TABLE.

of CREATE MATERIALIZED VIEW. See CREATE TABLE.

of CREATE TABLE (SQL Reference)

value for complex materialized views (Advanced Replication)

PCTFREE storage parameter

how it works (Concepts)

PCTUSED and (Concepts)

PCTINCREASE parameter (Administrator's Guide)

     [entry #2] (interMedia User's Guide)

altering (Administrator's Guide)

of STORAGE clause (SQL Reference)

PCTINCREASE parameter, recommended value for LOBs (Application Developer's Guide - Large Objects)

PCTSPACE transform parameter (New Features Guide)

PCTTHRESHOLD parameter

of CREATE TABLE (SQL Reference)

PCTUSED parameter

     [entry #2] (Performance Tuning Guide)

     [entry #3] (Performance Tuning Guide)

of ALTER CLUSTER (SQL Reference)

of ALTER INDEX (SQL Reference)

of ALTER MATERIALIZED VIEW LOG (SQL Reference)

of ALTER TABLE (SQL Reference)

of CREATE INDEX. See CREATE TABLE

of CREATE MATERIALIZED VIEW LOG. See CREATE TABLE.

of CREATE MATERIALIZED VIEW. See CREATE TABLE.

of CREATE TABLE (SQL Reference)

value for complex materialized views (Advanced Replication)

PCTUSED storage parameter

how it works (Concepts)

PCTFREE and (Concepts)

PCTVERSION (Application Developer's Guide - Large Objects)

     [entry #2] (Application Developer's Guide - Large Objects)

PCTVERSION option (interMedia User's Guide)

PCTVERSION parameter

of LOB storage (SQL Reference)

of LOB storage clause (SQL Reference)

PCT_ACCESS_DIRECT statistics

for index-organized tables (SQL Reference)

PCXF image format (interMedia Reference)

PCXRLE image compression format (interMedia Reference)

PD (positional descriptor) (XML DB Developer's Guide)

PDA (JDBC Developer's Guide and Reference)

PDA, definition (XML Developer's Kit Programmer's Guide)

PDF results using FOP (XML Developer's Kit Programmer's Guide)

peeking

bind variables (Performance Tuning Guide)

peer-to-peer replication. See multimaster replication

PEM (HTTP Server Administrator's Guide)

pending area for Database Resource Manager plans (Administrator's Guide)

     [entry #2] (Administrator's Guide)

validating plan schema changes (Administrator's Guide)

pending DML

viewing (Text Application Developer's Guide)

     [subentry #2] (Text Reference)

pending transaction tables (Administrator's Guide)

pending updates (Text Application Developer's Guide)

per-process max locked memory

Percentage Bar charts (New Features Guide)

PERCENTAGE function (OLAP DML Reference)

PERCENTAGE_TO_MEASURE function (Spatial User's Guide and Reference)

PERCENTILE_CONT function (SQL Quick Reference)

     [entry #2] (SQL Reference)

PERCENTILE_DISC function (SQL Quick Reference)

     [entry #2] (SQL Reference)

PERCENT_RANK (aggregate) function (SQL Quick Reference)

PERCENT_RANK (analytic) function (SQL Quick Reference)

PERCENT_RANK function (Data Warehousing Guide)

     [entry #2] (SQL Reference)

performance

     [entry #2] (Java Developer's Guide)

     [entry #3] (Java Developer's Guide)

     [entry #4] (Reference)

about (Streams Advanced Queuing User's Guide and Reference)

avoid memory overhead (PL/SQL User's Guide and Reference)

avoiding problems (PL/SQL User's Guide and Reference)

balancing against data availability (Data Guard Concepts and Administration)

balancing against data protection (Data Guard Concepts and Administration)

buffered messages (Streams Advanced Queuing User's Guide and Reference)

causes of poor (Pro*COBOL Programmer's Guide)

choosing a database character set (Globalization Support Guide)

concurrent processes (Streams Advanced Queuing User's Guide and Reference)

configuring I/O (Streams Advanced Queuing User's Guide and Reference)

constraint effects on (Concepts)

DSS database (Data Warehousing Guide)

during OCI Unicode character set conversion (Globalization Support Guide)

dynamic performance tables (V$) (Concepts)

emergencies (Performance Tuning Guide)

Enterprise Manager tools (Data Guard Broker)

group commits (Concepts)

guidelines

reading/writing large data chunks (Application Developer's Guide - Large Objects)

reading/writing large data chunks, temporary LOBs (Application Developer's Guide - Large Objects)

improvement method (Performance Tuning Guide)

improvement method steps (Performance Tuning Guide)

improving (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

improving when using integrity constraints (Utilities)

improving with PL/SQL (PL/SQL User's Guide and Reference)

index build (Concepts)

index column order (Administrator's Guide)

     [subentry #2] (Application Developer's Guide - Fundamentals)

issues when using external tables (Utilities)

location of datafiles and (Administrator's Guide)

mainframe (Performance Tuning Guide)

monitoring memory on Windows (Performance Tuning Guide)

monitoring redo transport services (Data Guard Concepts and Administration)

native compilation (Java Developer's Guide)

native dynamic SQL (Application Developer's Guide - Fundamentals)

network data model API (Spatial Topology and Network Data Models)

optimizing

executeArrayUpdate method (Oracle C++ Call Interface Programmer's Guide)

setDataBuffer method (Oracle C++ Call Interface Programmer's Guide)

optimizing for direct path loads (Utilities)

optimizing reading of SQL*Loader data files (Utilities)

Oracle Enterprise Manager tools (Data Guard Broker)

Oracle Streams AQ and RAC (Streams Advanced Queuing User's Guide and Reference)

packages (Concepts)

persistent messaging (Streams Advanced Queuing User's Guide and Reference)

prefixed and nonprefixed indexes (Data Warehousing Guide)

propagation tuning (Streams Advanced Queuing User's Guide and Reference)

queue table indexes (Streams Advanced Queuing User's Guide and Reference)

reasons for poor (Programmer's Guide to the Oracle Precompilers)

replication (Advanced Replication)

monitoring (Advanced Replication Management API Reference)

resource limits and (Concepts)

     [subentry #2] (Security Guide)

serial processes (Streams Advanced Queuing User's Guide and Reference)

shared pool (Reference)

shared servers (Streams Advanced Queuing User's Guide and Reference)

sort operations (Concepts)

storage parameters (Streams Advanced Queuing User's Guide and Reference)

tools for diagnosing and tuning (Performance Tuning Guide)

tuning original Import (Utilities)

UNIX-based systems (Performance Tuning Guide)

viewing execution plans (Performance Tuning Guide)

wildcard searches (Text Reference)

Windows (Performance Tuning Guide)

performance and tuning information (Spatial User's Guide and Reference)

for Spatial operators (Spatial User's Guide and Reference)

performance counters (OLAP Application Developer's Guide)

     [entry #2] (OLAP Reference)

performance enhancements (SQLJ Developer's Guide and Reference)

performance enhancements, standard vs. Oracle (JDBC Developer's Guide and Reference)

performance evaluation

performance extensions

defining column types (JDBC Developer's Guide and Reference)

prefetching rows (JDBC Developer's Guide and Reference)

TABLE_REMARKS reporting (JDBC Developer's Guide and Reference)

performance monitor (HTTP Server Administrator's Guide)

Performance Monitoring

using Enterprise Manager (New Features Guide)

performance monitoring

performance monitoring, DMS support (SQLJ Developer's Guide and Reference)

performance optimization (JDBC Developer's Guide and Reference)

performance results

guidelines for using interMedia objects (interMedia User's Guide)

performance tuning

     [entry #2] (HTML DB User's Guide)

application managed data buffering (Oracle C++ Call Interface Programmer's Guide)

array fetch using next() method (Oracle C++ Call Interface Programmer's Guide)

backup performance (Backup and Recovery Advanced User's Guide)

data buffering (Oracle C++ Call Interface Programmer's Guide)

disk bandwidth and RATE channel parameter (Backup and Recovery Advanced User's Guide)

Fast-Start Fault Recovery (Backup and Recovery Advanced User's Guide)

indexing (Text Application Developer's Guide)

instance recovery (Backup and Recovery Advanced User's Guide)

FAST_START_MTTR_TARGET (Backup and Recovery Advanced User's Guide)

setting FAST_START_MTTR_TARGET (Backup and Recovery Advanced User's Guide)

using V$INSTANCE_RECOVERY (Backup and Recovery Advanced User's Guide)

LARGE_POOL_SIZE initialization parameter (Backup and Recovery Advanced User's Guide)

long waits

defined (Backup and Recovery Advanced User's Guide)

Oracle Data Pump (Utilities)

querying (Text Application Developer's Guide)

short waits

definition of (Backup and Recovery Advanced User's Guide)

updating index (Text Application Developer's Guide)

performance tuning tools, 8.2.6 (Administrator's Reference for UNIX-Based Operating Systems)

performance tunning (Oracle C++ Call Interface Programmer's Guide)

connection sharing (Oracle C++ Call Interface Programmer's Guide)

reading and writing multiple LOBs (Oracle C++ Call Interface Programmer's Guide)

shared server environments (Oracle C++ Call Interface Programmer's Guide)

thread safety (Oracle C++ Call Interface Programmer's Guide)

thread safety (Oracle C++ Call Interface Programmer's Guide)

transparent application failover (Oracle C++ Call Interface Programmer's Guide)

performance, Oracle Label Security

ANALYZE command (Label Security Administrator's Guide)

indexes (Label Security Administrator's Guide)

label tag strategy (Label Security Administrator's Guide)

partitioning (Label Security Administrator's Guide)

READ privilege (Label Security Administrator's Guide)

performance. See also tuning

performing backups after unrecoverable operations (Backup and Recovery Basics)

period (.)

periodic purges

scheduling (Advanced Replication)

periodic pushes

scheduling (Advanced Replication)

Perl

access database (HTTP Server Administrator's Guide)

license (HTTP Server Administrator's Guide)

Regular Expression and compatibility with (New Features Guide)

Perl interpreter (HTTP Server Administrator's Guide)

permanent and temporary LOB instances (Application Developer's Guide - Fundamentals)

PERMANENT clause

of ALTER TABLESPACE (SQL Reference)

permission

Oracle-specific (Java Developer's Guide)

programs (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

types (Java Developer's Guide)

Permission class (Java Developer's Guide)

     [entry #2] (Java Developer's Guide)

     [entry #3] (Java Developer's Guide)

     [entry #4] (Java Developer's Guide)

     [entry #5] (Java Developer's Guide)

permission programs (OLAP DML Reference)

     [entry #2] (OLAP DML Reference)

     [entry #3] (OLAP DML Reference)

permissions (Java Developer's Guide)

     [entry #2] (OLAP DML Reference)

administrating (Java Developer's Guide)

assigning (Java Developer's Guide)

     [subentry #2] (Java Developer's Guide)

assigning to an object definition (OLAP DML Reference)

creating (Java Developer's Guide)

debugging (Java Developer's Guide)

deleting (Java Developer's Guide)

disabling (Java Developer's Guide)

enabling (Java Developer's Guide)

FilePermission (Java Developer's Guide)

granting (Java Developer's Guide)

     [subentry #2] (Java Developer's Guide)

granting policy (Java Developer's Guide)

     [subentry #2] (Java Developer's Guide)

granting, example (Java Developer's Guide)

grouped into roles (Java Developer's Guide)

JAVADEBUGPRIV role (Java Developer's Guide)

JAVASYSPRIV role (Java Developer's Guide)

JAVAUSERPRIV role (Java Developer's Guide)

JAVA_ADMIN role (Java Developer's Guide)

JAVA_DEPLOY role (Java Developer's Guide)

limiting (Java Developer's Guide)

     [subentry #2] (Java Developer's Guide)

     [subentry #3] (Java Developer's Guide)

limiting, example (Java Developer's Guide)

PUBLIC (Java Developer's Guide)

recalculating permission (OLAP DML Reference)

restricting (Java Developer's Guide)

     [subentry #2] (Java Developer's Guide)

restricting, example (Java Developer's Guide)

server.key file (Security Guide)

specifying conditions for accessing (OLAP DML Reference)

specifying policy (Java Developer's Guide)

SYS permission (Java Developer's Guide)

types (Java Developer's Guide)

violations of (OLAP DML Reference)

permissions to execute PL/SQL packages (JPublisher User's Guide)

PERMIT command (OLAP DML Reference)

PERMITERROR option (OLAP DML Reference)

PERMITRESET command (OLAP DML Reference)

PERMIT_READ program (OLAP DML Reference)

     [entry #2] (OLAP DML Reference)

PERMIT_WRITE program (OLAP DML Reference)

     [entry #2] (OLAP DML Reference)

persistent copies of objects, 17.3.1 (Pro*C/C++ Precompiler Programmer's Guide)

persistent messaging

compared to buffered (Streams Advanced Queuing User's Guide and Reference)

performance (Streams Advanced Queuing User's Guide and Reference)

tuning (Streams Advanced Queuing User's Guide and Reference)

persistent objects (Oracle C++ Call Interface Programmer's Guide)

     [entry #2] (Oracle C++ Call Interface Programmer's Guide)

     [entry #3] (Oracle Call Interface Programmer's Guide)

creating (Oracle C++ Call Interface Programmer's Guide)

meta-attributes (Oracle Call Interface Programmer's Guide)

standalone objects (Oracle C++ Call Interface Programmer's Guide)

types

embedded objects (Oracle C++ Call Interface Programmer's Guide)

nonreferenceable objects (Oracle C++ Call Interface Programmer's Guide)

referenceable objects (Oracle C++ Call Interface Programmer's Guide)

standalone objects (Oracle C++ Call Interface Programmer's Guide)

persistent objects, 17.3.1 (Pro*C/C++ Precompiler Programmer's Guide)

persistentObject (Data Mining Application Developer's Guide)

Personal Digital Assistant (PDA) (JDBC Developer's Guide and Reference)

Personal Digital Assistant, definition (XML Developer's Kit Programmer's Guide)

Personal Edition database

installation (Data Guard Broker)

Personal Express (obsolete) (OLAP Application Developer's Guide)

personnel checklist (Security Guide)

personnel security (Security Guide)

pessimistic locking (Application Developer's Guide - Workspace Manager)

     [entry #2] (Application Developer's Guide - Workspace Manager)

pet magnet (Text Application Developer's Guide)

gist (Text Application Developer's Guide)

illustration (Text Application Developer's Guide)

themes (Text Application Developer's Guide)

pfile settings (OLAP Application Developer's Guide)

PGA Advisor

     [entry #2] (Concepts)

description (2 Day DBA)

PGA allocation (OLAP Reference)

PGA target

setting (2 Day DBA)

PGA. See program global area (PGA)

PGA_AGGREGATE_TARGET initialization parameter (Concepts)

     [entry #2] (Data Warehousing Guide)

     [entry #3] (Performance Tuning Guide)

     [entry #4] (Performance Tuning Guide)

     [entry #5] (Performance Tuning Guide)

     [entry #6] (Performance Tuning Guide)

     [entry #7] (Performance Tuning Guide)

     [entry #8] (Reference)

setting with ALTER SYSTEM (SQL Reference)

PGA_AGGREGATE_TARGET parameter (OLAP Application Developer's Guide)

PGA_TARGET parameter (OLAP Application Developer's Guide)

PGMF image format (interMedia Reference)

phantom reads (Concepts)

     [entry #2] (SQLJ Developer's Guide and Reference)

PHASE_COMPLETED column (Enterprise User Administrator's Guide)

     [entry #2] (Enterprise User Administrator's Guide)

phonetic writing systems, encoding (Globalization Support Guide)

photogrammetry

description (Spatial GeoRaster)

PHP (HTTP Server Administrator's Guide)

license (HTTP Server Administrator's Guide)

php.ini (HTTP Server Administrator's Guide)

phrase query (Text Application Developer's Guide)

physical access control checklist (Security Guide)

physical attributes clause

of ALTER CLUSTER (SQL Reference)

of ALTER INDEX (SQL Reference)

of ALTER MATERIALIZED VIEW LOG (SQL Reference)

of ALTER TABLE (SQL Reference)

of CREATE CLUSTER (SQL Reference)

of CREATE MATERIALIZED VIEW (SQL Reference)

of CREATE TABLE (SQL Reference)

     [subentry #2] (SQL Reference)

physical backups (Backup and Recovery Basics)

physical database structures

control files (Concepts)

datafiles (Concepts)

physical design (Data Warehousing Guide)

structures (Data Warehousing Guide)

physical guesses in logical rowids (Concepts)

staleness (Concepts)

statistics for (Concepts)

physical layer (Net Services Administrator's Guide)

physical reads from cache statistic (Performance Tuning Guide)

physical rowids (PL/SQL User's Guide and Reference)

physical security (Security Guide)

physical standby database

activating (SQL Reference)

activation (New Features Guide)

convert to reporting database (New Features Guide)

physical standby databases (Concepts)

activating as a clone database (Data Guard Concepts and Administration)

altering

online redo log files (Data Guard Concepts and Administration)

applying redo data (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

cascading (Data Guard Concepts and Administration)

Redo Apply technology (Data Guard Concepts and Administration)

applying redo log files

starting (Data Guard Concepts and Administration)

benefits (Data Guard Concepts and Administration)

choosing a target for failover (Data Guard Concepts and Administration)

cloning

creating a restore point (Data Guard Concepts and Administration)

for testing, development, and reporting (Data Guard Concepts and Administration)

configuration options (Data Guard Concepts and Administration)

converting to a logical standby database (Data Guard Concepts and Administration)

converting to a read/write database (Data Guard Concepts and Administration)

creating

checklist of tasks (Data Guard Concepts and Administration)

configuring a listener (Data Guard Concepts and Administration)

directory structure (Data Guard Concepts and Administration)

initialization parameters for (Data Guard Concepts and Administration)

traditional initialization parameter file (Data Guard Concepts and Administration)

with Data Guard broker (Data Guard Concepts and Administration)

defined (Data Guard Concepts and Administration)

during switchovers (Data Guard Broker)

failover

checking for updates (Data Guard Concepts and Administration)

finding gaps with V$ARCHIVE_GAP view (Data Guard Concepts and Administration)

flashing back after failover (Data Guard Concepts and Administration)

managing parallel apply (Data Guard Broker)

manually resolving archive gaps (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

monitoring (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

     [subentry #3] (Data Guard Concepts and Administration)

     [subentry #4] (Data Guard Concepts and Administration)

online backups and (Data Guard Concepts and Administration)

opening for read-only or read/write access (Data Guard Concepts and Administration)

opening for read/write access (Data Guard Concepts and Administration)

read-only (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

read/write testing and reporting (Data Guard Concepts and Administration)

recovering through OPEN RESETLOGS (Data Guard Concepts and Administration)

Redo Apply (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

resynchronizing with primary database branch of redo (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

role transition and (Data Guard Concepts and Administration)

rolling forward

when lagging far behind the primary database (Data Guard Concepts and Administration)

when nologging changes applied to a small subset of data files (Data Guard Concepts and Administration)

when nologging changes are widespread (Data Guard Concepts and Administration)

rolling forward with BACKUP INCREMENTAL FROM SCN command (Data Guard Concepts and Administration)

setting VALID_FOR attribute (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

shutting down (Data Guard Concepts and Administration)

starting

log apply services (Data Guard Concepts and Administration)

real-time apply (Data Guard Concepts and Administration)

state transitions (Data Guard Broker)

support for DDL (Data Guard Concepts and Administration)

support for DML (Data Guard Concepts and Administration)

switchover to the primary role (Data Guard Broker)

synchronizing with the primary database (Data Guard Concepts and Administration)

tuning the log apply rate (Data Guard Concepts and Administration)

upgrading (Data Guard Concepts and Administration)

using transportable tablespaces (Data Guard Concepts and Administration)

physical storage

GeoRaster objects (Spatial GeoRaster)

physical table name

and Workspace Manager infrastructure (Application Developer's Guide - Workspace Manager)

getting (Application Developer's Guide - Workspace Manager)

PhysicalDataSet (Data Mining Application Developer's Guide)

PIC G for Globalization Support characters (Pro*COBOL Programmer's Guide)

PIC N for Globalization Support characters (Pro*COBOL Programmer's Guide)

PICT image format (interMedia Reference)

PICX precompiler option (Pro*COBOL Programmer's Guide)

     [entry #2] (Pro*COBOL Programmer's Guide)

PID file (HTTP Server Administrator's Guide)

PidFile (HTTP Server Administrator's Guide)

PIECED parameter

SQL*Loader (Utilities)

piecewise binds and defines for LOBs (Oracle Call Interface Programmer's Guide)

piecewise fetch (Oracle Call Interface Programmer's Guide)

PIECEWISE member procedure

of ANYDATA TYPE (PL/SQL Packages and Types Reference)

of ANYDATASET TYPE (PL/SQL Packages and Types Reference)

piecewise operations (Oracle Call Interface Programmer's Guide)

fetch (Oracle Call Interface Programmer's Guide)

     [subentry #2] (Oracle Call Interface Programmer's Guide)

in PL/SQL (Oracle Call Interface Programmer's Guide)

insert (Oracle Call Interface Programmer's Guide)

update (Oracle Call Interface Programmer's Guide)

valid datatypes (Oracle Call Interface Programmer's Guide)

pin count (Oracle Call Interface Programmer's Guide)

pin duration

example (Oracle Call Interface Programmer's Guide)

of objects (Oracle Call Interface Programmer's Guide)

PING procedure (PL/SQL Packages and Types Reference)

pinning (Oracle Call Interface Programmer's Guide)

pinning objects (Oracle C++ Call Interface Programmer's Guide)

     [entry #2] (Oracle C++ Call Interface Programmer's Guide)

     [entry #3] (Oracle Call Interface Programmer's Guide)

pipe (PL/SQL User's Guide and Reference)

pipe interface (Backup and Recovery Advanced User's Guide)

PIPE networking parameter (Net Services Reference)

PIPE ROW statement

for returning rows incrementally (PL/SQL User's Guide and Reference)

pipe, compiler output messages (SQLJ Developer's Guide and Reference)

piped log (HTTP Server Administrator's Guide)

Pipeline Definition Language (XML Developer's Kit Programmer's Guide)

Pipeline Definition Language, definition (XML Developer's Kit Programmer's Guide)

PIPELINED

function option (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

PIPELINED clause

of CREATE FUNCTION (SQL Reference)

pipelined functions

exception handling (PL/SQL User's Guide and Reference)

fetching from results of (PL/SQL User's Guide and Reference)

for querying a table (PL/SQL User's Guide and Reference)

overview (PL/SQL User's Guide and Reference)

passing data with cursor variables (PL/SQL User's Guide and Reference)

performing DML operations inside (PL/SQL User's Guide and Reference)

performing DML operations on (PL/SQL User's Guide and Reference)

returning results from (PL/SQL User's Guide and Reference)

transformation of data (PL/SQL User's Guide and Reference)

transformations (PL/SQL User's Guide and Reference)

writing (PL/SQL User's Guide and Reference)

pipelined table functions (Concepts)

pipelines

between table functions (PL/SQL User's Guide and Reference)

returning results from table functions (PL/SQL User's Guide and Reference)

support collection types (PL/SQL User's Guide and Reference)

using table functions (PL/SQL User's Guide and Reference)

writing table functions (PL/SQL User's Guide and Reference)

pipelining

definition (PL/SQL User's Guide and Reference)

pivoting (Data Warehousing Guide)

     [entry #2] (Data Warehousing Guide)

     [entry #3] (OLAP Application Developer's Guide)

pivoting cube edges, example of (OLAP Developer's Guide to the OLAP API)

PIX Firewall (Security Guide)

pixelOrder operator (interMedia Reference)

     [entry #2] (interMedia Reference)

pizza shredder (Text Application Developer's Guide)

PKCS #11 devices (Advanced Security Administrator's Guide)

PKCS #11 error messages

ORA-40300 (Advanced Security Administrator's Guide)

ORA-40301 (Advanced Security Administrator's Guide)

ORA-40302 (Advanced Security Administrator's Guide)

PKCS #5 (Security Guide)

PKCS #7 certificate chain (Advanced Security Administrator's Guide)

difference from X.509 certificate (Advanced Security Administrator's Guide)

PKENCODE function (Text Reference)

PKI (Concepts)

     [entry #2] (Security Guide)

pkREFs (Application Developer's Guide - Object-Relational Features)

PL/I

BASED variables (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

labels (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

preprocessor not supported (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

use of apostrophes in (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

use of pointers in embedded SQL (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

PL/I datatypes

allowed in SQL declare section (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

CHARACTER VARYING (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

FIXED DECIMAL (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

supported by Oracle Precompilers (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

PL/SQL

     [entry #2] (Application Developer's Guide - Fundamentals)

     [entry #3] (Application Developer's Guide - Large Objects)

     [entry #4] (Concepts)

     [entry #5] (HTTP Server Administrator's Guide)

     [entry #6] (Oracle Call Interface Programmer's Guide)

     [entry #7] (Programmer's Guide to the Oracle Precompilers)

about (SQL*Module for Ada Programmer's Guide)

advantages (PL/SQL User's Guide and Reference)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

and LOBs, semantics changes (Application Developer's Guide - Large Objects)

and the SQLCA (Programmer's Guide to the Oracle Precompilers)

and WRAP utility (New Features Guide)

anonymous blocks (Application Developer's Guide - Fundamentals)

     [subentry #2] (Concepts)

     [subentry #3] (Concepts)

     [subentry #4] (PL/SQL User's Guide and Reference)

     [subentry #5] (Security Guide)

applications

Common Sort (New Features Guide)

Common Territory (New Features Guide)

Common Time Zone (New Features Guide)

Translated Locale Names (New Features Guide)

architecture (PL/SQL User's Guide and Reference)

assigning Boolean values (PL/SQL User's Guide and Reference)

assigning query result to variable (PL/SQL User's Guide and Reference)

assigning values to variables (PL/SQL User's Guide and Reference)

auditing of statements within (Concepts)

     [subentry #2] (Security Guide)

best practices information on OTN (PL/SQL User's Guide and Reference)

bind variables

object types (Application Developer's Guide - Object-Relational Features)

binding and defining nested tables (Oracle Call Interface Programmer's Guide)

binding and defining REF cursors (Oracle Call Interface Programmer's Guide)

binding placeholders (Oracle Call Interface Programmer's Guide)

BLAS subprogram (New Features Guide)

blocks (PL/SQL User's Guide and Reference)

structure (PL/SQL User's Guide and Reference)

blocks in executable statements (SQLJ Developer's Guide and Reference)

blocks, embedded in Oracle7 precompiler programs (Programmer's Guide to the Oracle Precompilers)

BOOLEAN type (SQLJ Developer's Guide and Reference)

calling Java from (Java Developer's Guide)

calling remote stored procedures (Application Developer's Guide - Fundamentals)

CASE expressions (PL/SQL User's Guide and Reference)

changing locator-data linkage (Application Developer's Guide - Large Objects)

character sets (PL/SQL User's Guide and Reference)

client applications (interMedia User's Guide)

CLOB variables in (Application Developer's Guide - Large Objects)

CLOB variables in PL/SQL (Application Developer's Guide - Large Objects)

CLOB versus VARCHAR2 comparison (Application Developer's Guide - Large Objects)

CLOBs passed in like VARCHAR2s (Application Developer's Guide - Large Objects)

collection types (PL/SQL User's Guide and Reference)

collections

overview (PL/SQL User's Guide and Reference)

comments (PL/SQL User's Guide and Reference)

compared to Java (Application Developer's Guide - Fundamentals)

comparisons (PL/SQL User's Guide and Reference)

compile-time warnings (PL/SQL User's Guide and Reference)

compiler limitations (PL/SQL User's Guide and Reference)

compiler parameter settings (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

     [subentry #3] (PL/SQL User's Guide and Reference)

compiler parameters (PL/SQL User's Guide and Reference)

compiling PL/SQL code for native execution (PL/SQL User's Guide and Reference)

conditional compilation (New Features Guide)

     [subentry #2] (PL/SQL User's Guide and Reference)

     [subentry #3] (PL/SQL User's Guide and Reference)

configuring your environment (interMedia User's Guide)

constants (PL/SQL User's Guide and Reference)

control structures (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

creating VPD policies (Label Security Administrator's Guide)

creating Web applications and pages (PL/SQL User's Guide and Reference)

cursor FOR loop (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

cursor variables (Application Developer's Guide - Fundamentals)

data abstraction (PL/SQL User's Guide and Reference)

database triggers (Concepts)

datatype equivalents (Pro*COBOL Programmer's Guide)

datatypes (Concepts)

     [subentry #2] (PL/SQL Packages and Types Reference)

     [subentry #3] (PL/SQL User's Guide and Reference)

in a stored procedure definition (SQL*Module for Ada Programmer's Guide)

numeric codes for (PL/SQL Packages and Types Reference)

DBMS_LOB package compared with OCI (Data Cartridge Developer's Guide)

debugging (Data Cartridge Developer's Guide)

debugging with JDeveloper tutorial on Oracle by Example (PL/SQL User's Guide and Reference)

declarations

constants (PL/SQL User's Guide and Reference)

defining a CLOB Variable on a VARCHAR (Application Developer's Guide - Large Objects)

defining output variables (Oracle Call Interface Programmer's Guide)

demo directory (Data Cartridge Developer's Guide)

demos (PL/SQL User's Guide and Reference)

dependencies among library units (Application Developer's Guide - Fundamentals)

differences from C and C++ (Data Cartridge Developer's Guide)

displaying output (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

dynamic SQL (Concepts)

dynamically modifying SQL statements (Security Guide)

embedded (Pro*COBOL Programmer's Guide)

embedded PL/SQL (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

engine (PL/SQL User's Guide and Reference)

environment (PL/SQL User's Guide and Reference)

error handling

overview (PL/SQL User's Guide and Reference)

errors (PL/SQL User's Guide and Reference)

exception (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

exception handlers (Application Developer's Guide - Fundamentals)

exception handling (Concepts)

exceptions (PL/SQL User's Guide and Reference)

executing (Concepts)

expressions (PL/SQL User's Guide and Reference)

external procedures (Concepts)

freeing temporary LOBs automatically and manually (Application Developer's Guide - Large Objects)

functions

     [subentry #2] (PL/SQL User's Guide and Reference)

     [subentry #3] (PL/SQL User's Guide and Reference)

arguments (Application Developer's Guide - Fundamentals)

DBMS_MGWADM package subprograms (PL/SQL Packages and Types Reference)

DBMS_MGWMSG package subprograms (PL/SQL Packages and Types Reference)

overloading (Application Developer's Guide - Fundamentals)

parameter default values (Application Developer's Guide - Fundamentals)

purity level (Application Developer's Guide - Fundamentals)

RESTRICT_REFERENCES pragma (Application Developer's Guide - Fundamentals)

return values for (SQL*Module for Ada Programmer's Guide)

using (Application Developer's Guide - Fundamentals)

gateway (Concepts)

generating XML with DBMS_XMLQuery (XML Developer's Kit Programmer's Guide)

hiding or obfuscating source code (PL/SQL User's Guide and Reference)

HTML tags (interMedia User's Guide)

input data (PL/SQL User's Guide and Reference)

integrating with server (Programmer's Guide to the Oracle Precompilers)

integration with server (Pro*COBOL Programmer's Guide)

invoking with dynamic SQL (Application Developer's Guide - Fundamentals)

keywords (PL/SQL User's Guide and Reference)

language constructs (Concepts)

LAPACK subprogram (New Features Guide)

lexical units (PL/SQL User's Guide and Reference)

limit on BLOB size (JDBC Developer's Guide and Reference)

limitations of programs (PL/SQL User's Guide and Reference)

limits on programs (PL/SQL User's Guide and Reference)

literals (PL/SQL User's Guide and Reference)

loading data (interMedia User's Guide)

example (interMedia User's Guide)

logical operators (PL/SQL User's Guide and Reference)

matrix math (New Features Guide)

media queries (interMedia User's Guide)

mode of a parameter (SQL*Module for Ada Programmer's Guide)

name resolution (PL/SQL User's Guide and Reference)

naming conventions (PL/SQL User's Guide and Reference)

native execution (Concepts)

new features (PL/SQL User's Guide and Reference)

obfuscation of dynamically generated source code (New Features Guide)

object views (Application Developer's Guide - Object-Relational Features)

     [subentry #2] (Concepts)

objects (Application Developer's Guide - Fundamentals)

opening a cursor variable

anonymous block (Pro*COBOL Programmer's Guide)

stored procedure (Pro*COBOL Programmer's Guide)

Oracle By Example tutorial (PL/SQL User's Guide and Reference)

out bind variables (Oracle C++ Call Interface Programmer's Guide)

output data (PL/SQL User's Guide and Reference)

overloaded procedures (Label Security Administrator's Guide)

overview (Application Developer's Guide - Fundamentals)

     [subentry #2] (Oracle C++ Call Interface Programmer's Guide)

overview of (Concepts)

package (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

packages (Application Developer's Guide - Fundamentals)

     [subentry #2] (Concepts)

     [subentry #3] (Data Cartridge Developer's Guide)

     [subentry #4] (Java Developer's Guide)

and GDK (New Features Guide)

DBMS_OUTPUT (New Features Guide)

UTL_I18N (New Features Guide)

UTL_NLA (New Features Guide)

parse locks (Concepts)

parsing DDL statements (Concepts)

performance

advantage (PL/SQL User's Guide and Reference)

performance problems (PL/SQL User's Guide and Reference)

piecewise operations (Oracle Call Interface Programmer's Guide)

PL/SQL engine (Concepts)

products containing (Concepts)

portability (PL/SQL User's Guide and Reference)

procedural aspects (PL/SQL User's Guide and Reference)

procedures

     [subentry #2] (PL/SQL User's Guide and Reference)

DBMS_MGWADM package subprograms (PL/SQL Packages and Types Reference)

DBMS_MGWMSG package subprograms (PL/SQL Packages and Types Reference)

profiling and tracing programs (PL/SQL User's Guide and Reference)

program body

of CREATE FUNCTION (SQL Reference)

program units (Application Developer's Guide - Fundamentals)

     [subentry #2] (Concepts)

     [subentry #3] (Concepts)

     [subentry #4] (Concepts)

compiled (Concepts)

compiled (Concepts)

shared SQL areas and (Concepts)

querying data (PL/SQL User's Guide and Reference)

RAISE statement (Application Developer's Guide - Fundamentals)

recompiling (PL/SQL User's Guide and Reference)

RECORD type (SQLJ Developer's Guide and Reference)

records

overview (PL/SQL User's Guide and Reference)

recreating labels for import (Label Security Administrator's Guide)

relationship with SQL (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

replaced views and program units (Administrator's Guide)

reserved words (PL/SQL User's Guide and Reference)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

restrictions (JDBC Developer's Guide and Reference)

retrieving media (interMedia User's Guide)

     [subentry #2] (interMedia User's Guide)

roles in procedures (Security Guide)

running in background (HTML DB User's Guide)

sample program (SQL*Module for Ada Programmer's Guide)

sample programs (PL/SQL User's Guide and Reference)

SA_UTL package (Label Security Administrator's Guide)

scope of identifiers (PL/SQL User's Guide and Reference)

serially reusable packages (Application Developer's Guide - Fundamentals)

server pages (Application Developer's Guide - Fundamentals)

Server Pages (PSPs) (PL/SQL User's Guide and Reference)

setting context (Security Guide)

space padding (JDBC Developer's Guide and Reference)

SQL support (PL/SQL User's Guide and Reference)

statements (PL/SQL User's Guide and Reference)

stored procedures (Concepts)

     [subentry #2] (Concepts)

     [subentry #3] (Concepts)

     [subentry #4] (JDBC Developer's Guide and Reference)

subprogram (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

subprograms (PL/SQL User's Guide and Reference)

calling (PL/SQL User's Guide and Reference)

syntax of language elements (PL/SQL User's Guide and Reference)

TABLE type (SQLJ Developer's Guide and Reference)

tables (Application Developer's Guide - Fundamentals)

of records (Application Developer's Guide - Fundamentals)

transaction processing (PL/SQL User's Guide and Reference)

trigger bodies (Application Developer's Guide - Fundamentals)

     [subentry #2] (Application Developer's Guide - Fundamentals)

trusted stored program units (Label Security Administrator's Guide)

tuning code (PL/SQL User's Guide and Reference)

tuning computation-intensive programs (PL/SQL User's Guide and Reference)

tuning dynamic SQL programs (PL/SQL User's Guide and Reference)

uploading media (interMedia User's Guide)

     [subentry #2] (interMedia User's Guide)

user locks (Concepts)

user-defined errors (Application Developer's Guide - Fundamentals)

user-defined record (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

uses in OCI applications (Oracle Call Interface Programmer's Guide)

using dynamic SQL (PL/SQL User's Guide and Reference)

using in LONG-to-LOB migration (Application Developer's Guide - Large Objects)

using in OCI applications (Oracle Call Interface Programmer's Guide)

using in OCI programs (Oracle Call Interface Programmer's Guide)

using NOCOPY for tuning (PL/SQL User's Guide and Reference)

using transformation pipelines (PL/SQL User's Guide and Reference)

using with objects (Application Developer's Guide - Object-Relational Features)

UTL_HTTP package (interMedia Reference)

     [subentry #2] (interMedia Reference)

     [subentry #3] (interMedia Reference)

     [subentry #4] (interMedia Reference)

     [subentry #5] (interMedia Reference)

     [subentry #6] (interMedia Reference)

     [subentry #7] (interMedia Reference)

     [subentry #8] (interMedia Reference)

variables (PL/SQL User's Guide and Reference)

warning messages (PL/SQL User's Guide and Reference)

Web applications (PL/SQL User's Guide and Reference)

     [subentry #2] (interMedia User's Guide)

Web toolkit (Application Developer's Guide - Fundamentals)

writing reusable code (PL/SQL User's Guide and Reference)

PL/SQL and SQL and Unicode (Globalization Support Guide)

PL/SQL and SQL examples (Spatial User's Guide and Reference)

PL/SQL API (Data Mining Application Developer's Guide)

sample applications (Data Mining Application Developer's Guide)

     [subentry #2] (Data Mining Application Developer's Guide)

     [subentry #3] (Data Mining Application Developer's Guide)

PL/SQL APIs (Data Mining Administrator's Guide)

sample programs (Data Mining Administrator's Guide)

     [subentry #2] (Data Mining Administrator's Guide)

PL/SQL APIs for XMLType (XML DB Developer's Guide)

PL/SQL application

PL/SQL block execution

effect on SQLCA components (Pro*COBOL Programmer's Guide)

PL/SQL blocks

embedded in Oracle7 precompiler programs (Pro*COBOL Programmer's Guide)

PL/SQL compiler

parameters (SQL Reference)

     [subentry #2] (SQL Reference)

     [subentry #3] (SQL Reference)

     [subentry #4] (SQL Reference)

     [subentry #5] (SQL Reference)

PL/SQL conversion functions see conversion functions, PL/SQL

PL/SQL data types, special support (JPublisher User's Guide)

PL/SQL demo files for GeoRaster (Spatial GeoRaster)

PL/SQL demonstrations, 7.2 (Administrator's Reference for UNIX-Based Operating Systems)

PL/SQL DOM

examples (XML DB Developer's Guide)

PL/SQL examples

network data model (Spatial Topology and Network Data Models)

PL/SQL functions

calling in contains (Text Application Developer's Guide)

PL/SQL Gateway

definition (Application Developer's Guide - Fundamentals)

PL/SQL Gateway feature (interMedia User's Guide)

PL/SQL index-by tables (JDBC Developer's Guide and Reference)

mapping (JDBC Developer's Guide and Reference)

scalar data types (JDBC Developer's Guide and Reference)

PL/SQL kernel demonstrations, 7.2 (Administrator's Reference for UNIX-Based Operating Systems)

PL/SQL packages

     [entry #2] (interMedia User's Guide)

DBMS_JOB (Data Warehousing Guide)

PL/SQL packages see packages, PL/SQL

PL/SQL procedures

DBMS_CDC_PUBLISH.PURGE (Data Warehousing Guide)

     [subentry #2] (Data Warehousing Guide)

DBMS_CDC_PUBLISH.PURGE_CHANGE_SET (Data Warehousing Guide)

DBMS_CDC_PUBLISH.PURGE_CHANGE_TABLE (Data Warehousing Guide)

DBMS_CDC_PUBLISH_DROP_CHANGE_TABLE (Data Warehousing Guide)

DBMS_CDC_SUBSCRIBE.PURGE_WINDOW (Data Warehousing Guide)

EXPLAIN_MVIEW (Performance Tuning Guide)

TUNE_MVIEW (Performance Tuning Guide)

PL/SQL Server Pages (Concepts)

PL/SQL source files output from SQL*Module (SQL*Module for Ada Programmer's Guide)

PL/SQL stored procedures

executing within RMAN (Recovery Manager Reference)

PL/SQL subprogram

calling from Pro*COBOL (Pro*COBOL Programmer's Guide)

PL/SQL subprograms, translating top level (JPublisher User's Guide)

PL/SQL supplied packages

supported (Data Guard Concepts and Administration)

unsupported (Data Guard Concepts and Administration)

PL/SQL table (Pro*COBOL Programmer's Guide)

     [entry #2] (Programmer's Guide to the Oracle Precompilers)

PL/SQL types

corresponding JDBC types (JDBC Developer's Guide and Reference)

limitations (JDBC Developer's Guide and Reference)

PL/SQL web toolkit functions, 4.5.3 (HTTP Server mod_plsql User's Guide)

PL/SQL Web Toolkit photo album sample application (interMedia User's Guide)

     [entry #2] (interMedia User's Guide)

PL/SQL wrapper (JPublisher User's Guide)

PL/SQL wrapper functions see wrapper functions, PL/SQL

PL/SQL, 1.4 (Pro*C/C++ Precompiler Programmer's Guide)

PL/SQL, 4.5 (SQL*Plus User's Guide and Reference)

placeholder Source

new feature (OLAP Developer's Guide to the OLAP API)

placeholder Source objects

definition (OLAP Developer's Guide to the OLAP API)

example of (OLAP Developer's Guide to the OLAP API)

     [subentry #2] (OLAP Developer's Guide to the OLAP API)

placeholder, duplicate (Programmer's Guide to the Oracle Precompilers)

naming (Programmer's Guide to the Oracle Precompilers)

using in dynamic SQL statements (Programmer's Guide to the Oracle Precompilers)

placeholders

duplicate (PL/SQL User's Guide and Reference)

     [subentry #2] (Pro*COBOL Programmer's Guide)

plain text

bypassing filtering (Text Reference)

filtering to (Text Reference)

     [subentry #2] (Text Reference)

highlight markup (Text Reference)

     [subentry #2] (Text Reference)

indexing with NULL_FILTER (Text Application Developer's Guide)

     [subentry #2] (Text Reference)

offsets for highlighting (Text Reference)

plain text filtering (Text Application Developer's Guide)

plaintext (HTTP Server Administrator's Guide)

PLAINTEXT function

of HTF package (PL/SQL Packages and Types Reference)

PLAINTEXT procedure

of HTP package (PL/SQL Packages and Types Reference)

plan

SQL execution (Concepts)

     [subentry #2] (Concepts)

plan schemas for Database Resource Manager (Administrator's Guide)

     [entry #2] (Administrator's Guide)

     [entry #3] (Administrator's Guide)

     [entry #4] (Administrator's Guide)

     [entry #5] (Administrator's Guide)

     [entry #6] (Administrator's Guide)

examples (Administrator's Guide)

validating plan changes (Administrator's Guide)

plan stability (PL/SQL Packages and Types Reference)

     [entry #2] (Performance Tuning Guide)

     [entry #3] (SQL Reference)

limitations of (Performance Tuning Guide)

preserving execution plans (Performance Tuning Guide)

procedures for the cost-based optimizer (Performance Tuning Guide)

use of hints (Performance Tuning Guide)

plan, execution (Pro*COBOL Programmer's Guide)

     [entry #2] (Programmer's Guide to the Oracle Precompilers)

planning

for replication (Advanced Replication)

     [subentry #2] (Advanced Replication Management API Reference)

internal networks

availability (Net Services Administrator's Guide)

connect-time failover (Net Services Administrator's Guide)

connection pooling (Net Services Administrator's Guide)

JDBC drivers (Net Services Administrator's Guide)

listener queue size (Net Services Administrator's Guide)

naming methods (Net Services Administrator's Guide)

protocol conversion (Net Services Administrator's Guide)

scalability (Net Services Administrator's Guide)

security (Net Services Administrator's Guide)

security (Net Services Administrator's Guide)

session data unit (SDU) size (Net Services Administrator's Guide)

session multiplexing (Net Services Administrator's Guide)

tuning and performance (Net Services Administrator's Guide)

Internet networks

access control (Net Services Administrator's Guide)

availability (Net Services Administrator's Guide)

connect-request timeouts (Net Services Administrator's Guide)

JDBC drivers (Net Services Administrator's Guide)

naming methods (Net Services Administrator's Guide)

scalability (Net Services Administrator's Guide)

security (Net Services Administrator's Guide)

tuning and performance (Net Services Administrator's Guide)

session data unit (SDU) size (Net Services Administrator's Guide)

plans

star transformations (Data Warehousing Guide)

PLAN_TABLE

PLAN_TABLE sample table (SQL Reference)

PLAN_TABLE table

     [entry #2] (Reference)

BYTES column (Performance Tuning Guide)

CARDINALITY column (Performance Tuning Guide)

COST column (Performance Tuning Guide)

creating (Performance Tuning Guide)

     [subentry #2] (Performance Tuning Guide)

displaying (Performance Tuning Guide)

DISTRIBUTION column (Performance Tuning Guide)

ID column (Performance Tuning Guide)

OBJECT_INSTANCE column (Performance Tuning Guide)

OBJECT_NAME column (Performance Tuning Guide)

OBJECT_NODE column (Performance Tuning Guide)

OBJECT_OWNER column (Performance Tuning Guide)

OBJECT_TYPE column (Performance Tuning Guide)

OPERATION column (Performance Tuning Guide)

OPTIMIZER column (Performance Tuning Guide)

OPTIONS column (Performance Tuning Guide)

OTHER column (Performance Tuning Guide)

OTHER_TAG column (Performance Tuning Guide)

PARENT_ID column (Performance Tuning Guide)

PARTITION_ID column (Performance Tuning Guide)

PARTITION_START column (Performance Tuning Guide)

PARTITION_STOP column (Performance Tuning Guide)

POSITION column (Performance Tuning Guide)

REMARKS column (Performance Tuning Guide)

SEARCH_COLUMNS column (Performance Tuning Guide)

STATEMENT_ID column (Performance Tuning Guide)

TIMESTAMP column (Performance Tuning Guide)

platform, determining (OLAP DML Reference)

PLSQL datatypes

numeric literals (PL/SQL User's Guide and Reference)

plsql.conf (HTTP Server Administrator's Guide)

     [entry #2] (HTTP Server Administrator's Guide)

     [entry #3] (HTTP Server Administrator's Guide)

PlsqlAfterProcedure (HTTP Server Administrator's Guide)

PlsqlAlwaysDescribeProcedure (HTTP Server Administrator's Guide)

PlsqlAuthenticationMode (HTTP Server Administrator's Guide)

PlsqlBeforeProcedure (HTTP Server Administrator's Guide)

PlsqlBindBucketLengths (HTTP Server Administrator's Guide)

PlsqlBindBucketsWidth (HTTP Server Administrator's Guide)

PlsqlCacheCleanupTime (HTTP Server Administrator's Guide)

PlsqlCacheDirectory (HTTP Server Administrator's Guide)

PlsqlCacheEnable (HTTP Server Administrator's Guide)

PlsqlCacheMaxAge (HTTP Server Administrator's Guide)

PlsqlCacheMaxSize (HTTP Server Administrator's Guide)

PlsqlCacheTotalSize (HTTP Server Administrator's Guide)

PlsqlCGIEnvironmentList (HTTP Server Administrator's Guide)

PlsqlCompatibilityMode (HTTP Server Administrator's Guide)

PlsqlConnectionTimeout (HTTP Server Administrator's Guide)

PlsqlConnectionValidation (HTTP Server Administrator's Guide)

PlsqlDatabaseConnectString (HTTP Server Administrator's Guide)

PlsqlDatabasePassword (HTTP Server Administrator's Guide)

PlsqlDatabaseUserName (HTTP Server Administrator's Guide)

PlsqlDefaultPage (HTTP Server Administrator's Guide)

PlsqlDMSEnable (HTTP Server Administrator's Guide)

PlsqlDocumentPath (HTTP Server Administrator's Guide)

PlsqlDocumentProcedure (HTTP Server Administrator's Guide)

PlsqlDocumentTablename (HTTP Server Administrator's Guide)

PlsqlErrorStyle (HTTP Server Administrator's Guide)

ApacheStyle (HTTP Server Administrator's Guide)

DebugStyle (HTTP Server Administrator's Guide)

ModplsqlStype (HTTP Server Administrator's Guide)

PlsqlExclusionList (HTTP Server Administrator's Guide)

PlsqlFetchBufferSize (HTTP Server Administrator's Guide)

plsqlfile option (JPublisher User's Guide)

PlsqlIdleSessionCleanupInterval (HTTP Server Administrator's Guide)

PlsqlInfoLogging (HTTP Server Administrator's Guide)

InfoDebug (HTTP Server Administrator's Guide)

PlsqlLogDirectory (HTTP Server Administrator's Guide)

PlsqlLogEnable (HTTP Server Administrator's Guide)

plsqlmap option (JPublisher User's Guide)

PlsqlMaxRequestsPerSession (HTTP Server Administrator's Guide)

PlsqlNLSLanguage (HTTP Server Administrator's Guide)

plsqlpackage option (JPublisher User's Guide)

PlsqlPathAlias (HTTP Server Administrator's Guide)

PlsqlPathAliasProcedure (HTTP Server Administrator's Guide)

PlsqlRequestValidationFunction (HTTP Server Administrator's Guide)

PlsqlSessionCookieName (HTTP Server Administrator's Guide)

PlsqlSessionStateManagement (HTTP Server Administrator's Guide)

PlsqlTransferMode (HTTP Server Administrator's Guide)

PlsqlUploadAsLongRaw (HTTP Server Administrator's Guide)

PLSQL_CCFLAGS initialization parameter

     [entry #2] (Reference)

conditional compilation (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

setting with ALTER SYSTEM (SQL Reference)

use with conditional compilation (PL/SQL User's Guide and Reference)

plsql_code_type column

native compilation (PL/SQL User's Guide and Reference)

PLSQL_CODE_TYPE initialization parameter

     [entry #2] (Reference)

setting PL/SQL native compilation (PL/SQL User's Guide and Reference)

setting with ALTER SYSTEM (SQL Reference)

use with conditional compilation (PL/SQL User's Guide and Reference)

PLSQL_COMPILER_FLAGS initialization parameter (Application Developer's Guide - Fundamentals)

     [entry #2] (Reference)

PLSQL_DEBUG initialization parameter

     [entry #2] (Reference)

setting with ALTER SYSTEM (SQL Reference)

use with conditional compilation (PL/SQL User's Guide and Reference)

PLSQL_DEBUG session parameter (SQL Reference)

PLSQL_LINE flag

use with conditional compilation (PL/SQL User's Guide and Reference)

PLSQL_NATIVE_LIBRARY_DIR initialization parameter

     [entry #2] (Reference)

for native compilation (PL/SQL User's Guide and Reference)

Real Application Clusters with native compilation (PL/SQL User's Guide and Reference)

setting with ALTER SYSTEM (SQL Reference)

PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT initialization parameter

     [entry #2] (Reference)

for native compilation (PL/SQL User's Guide and Reference)

setting with ALTER SYSTEM (SQL Reference)

PLSQL_OPTIMIZE_LEVEL initialization parameter

     [entry #2] (Reference)

optimizing PL/SQL programs (PL/SQL User's Guide and Reference)

setting with ALTER SYSTEM (SQL Reference)

use with conditional compilation (PL/SQL User's Guide and Reference)

PLSQL_TRACE_VERSION procedure (PL/SQL Packages and Types Reference)

PLSQL_UNIT flag

use with conditional compilation (PL/SQL User's Guide and Reference)

PLSQL_V2_COMPATIBILITY initialization parameter (Reference)

setting with ALTER SYSTEM (SQL Reference)

PLSQL_WARNINGS initialization parameter (PL/SQL User's Guide and Reference)

     [entry #2] (Reference)

setting with ALTER SYSTEM (SQL Reference)

use with conditional compilation (PL/SQL User's Guide and Reference)

PLS_INTEGER datatype (PL/SQL User's Guide and Reference)

compared to BINARY_INTEGER (PL/SQL User's Guide and Reference)

new features (PL/SQL User's Guide and Reference)

overflow condition (PL/SQL User's Guide and Reference)

range update (PL/SQL User's Guide and Reference)

plug-in (HTTP Server Administrator's Guide)

pluggable tablespaces

with 8.0-style queues (Streams Advanced Queuing User's Guide and Reference)

PLUGGABLE_SET_CHECK view (Reference)

plus method, example of (OLAP Developer's Guide to the OLAP API)

PLUSTRACE

PM (Security Guide)

PM schema (Application Developer's Guide - Large Objects)

general description (Sample Schemas)

     [subentry #2] (Sample Schemas)

installing (Sample Schemas)

scripts (Sample Schemas)

Pmarkers

with PCT (Data Warehousing Guide)

PMML (Data Mining Application Developer's Guide)

decision tree (Data Mining Concepts)

PMON background process (Concepts)

     [entry #2] (Concepts)

PMON process (Net Services Administrator's Guide)

     [entry #2] (Net Services Administrator's Guide)

pmscfg.cfg file, 6.1.1 (Administrator's Reference for UNIX-Based Operating Systems)

PNAME

command-line option (SQL*Module for Ada Programmer's Guide)

PNG image format

support by GeoRaster (Spatial GeoRaster)

PNGF image format (interMedia Reference)

PNMF image format (interMedia Reference)

PNO clause, 12 (SQL*Plus User's Guide and Reference)

PObject class (Oracle C++ Call Interface Programmer's Guide)

methods (Oracle C++ Call Interface Programmer's Guide)

point

data (Spatial User's Guide and Reference)

illustration and examples of point-only geometry (Spatial User's Guide and Reference)

locating on geometric segment (Spatial User's Guide and Reference)

LRS (Spatial User's Guide and Reference)

on surface of polygon (Spatial User's Guide and Reference)

oriented point (Spatial User's Guide and Reference)

projection of onto geometric segment (Spatial User's Guide and Reference)

     [subentry #2] (Spatial User's Guide and Reference)

shape (Spatial User's Guide and Reference)

point geometries

adding (Spatial Topology and Network Data Models)

point of interest (POI)

GC_POI_<suffix> table (Spatial User's Guide and Reference)

point of recoverability

recovery window (Backup and Recovery Advanced User's Guide)

point-in-time recovery (Backup and Recovery Advanced User's Guide)

clone database (Concepts)

Oracle Streams (PL/SQL Packages and Types Reference)

     [subentry #2] (Streams Replication Administrator's Guide)

performing

with current control file (Backup and Recovery Basics)

tablespace (Backup and Recovery Advanced User's Guide)

     [subentry #2] (Backup and Recovery Advanced User's Guide)

     [subentry #3] (Backup and Recovery Advanced User's Guide)

     [subentry #4] (Backup and Recovery Advanced User's Guide)

user-managed (Backup and Recovery Advanced User's Guide)

point-to-point

support in AQ (XML DB Developer's Guide)

point-to-point messages

about (Streams Advanced Queuing User's Guide and Reference)

pointer

pointer to

CTX_ADM package (PL/SQL Packages and Types Reference)

pointer variables

pointers

REF CIRSOR (PL/SQL User's Guide and Reference)

use of in PL/I (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

POINT_AT_BEARING function (Spatial User's Guide and Reference)

POISSON_DIST_FIT procedure (PL/SQL Packages and Types Reference)

policies

applying to schemas (Label Security Administrator's Guide)

     [subentry #2] (Label Security Administrator's Guide)

applying to tables (Label Security Administrator's Guide)

     [subentry #2] (Label Security Administrator's Guide)

auditing (Security Guide)

creating (Label Security Administrator's Guide)

enforcement guidelines (Label Security Administrator's Guide)

enforcement options (Label Security Administrator's Guide)

     [subentry #2] (Label Security Administrator's Guide)

     [subentry #3] (Label Security Administrator's Guide)

     [subentry #4] (Label Security Administrator's Guide)

     [subentry #5] (Label Security Administrator's Guide)

     [subentry #6] (Label Security Administrator's Guide)

managing (Label Security Administrator's Guide)

multiple (Label Security Administrator's Guide)

     [subentry #2] (Label Security Administrator's Guide)

     [subentry #3] (Label Security Administrator's Guide)

password management (Security Guide)

privileges (Label Security Administrator's Guide)

     [subentry #2] (Label Security Administrator's Guide)

     [subentry #3] (Label Security Administrator's Guide)

     [subentry #4] (Label Security Administrator's Guide)

terminology (Label Security Administrator's Guide)

policy (Text Reference)

create script (Text Reference)

duplicate with script (Text Reference)

report describing (Text Reference)

policy for ora:contains XPath function (Oracle)

definition (XML DB Developer's Guide)

policy function (Security Guide)

policy label column

indexing (Label Security Administrator's Guide)

inserting data when hidden (Label Security Administrator's Guide)

introduction (Label Security Administrator's Guide)

     [subentry #2] (Label Security Administrator's Guide)

retrieving (Label Security Administrator's Guide)

retrieving hidden (Label Security Administrator's Guide)

storing label tag (Label Security Administrator's Guide)

policy table

managing (Java Developer's Guide)

modifying (Java Developer's Guide)

setting permissions (Java Developer's Guide)

viewing (Java Developer's Guide)

policy types

context-sensitive (Security Guide)

     [subentry #2] (Security Guide)

     [subentry #3] (Security Guide)

new features (Security Guide)

shared (Security Guide)

     [subentry #2] (Security Guide)

static (Security Guide)

     [subentry #2] (Security Guide)

     [subentry #3] (Security Guide)

policy-based document services (Text Reference)

PolicyTable class

specifying policy (Java Developer's Guide)

updating (Java Developer's Guide)

     [subentry #2] (Java Developer's Guide)

PolicyTableManager class

delete method (Java Developer's Guide)

disable method (Java Developer's Guide)

enable method (Java Developer's Guide)

PolicyTablePermission (Java Developer's Guide)

     [entry #2] (Java Developer's Guide)

     [entry #3] (Java Developer's Guide)

     [entry #4] (Java Developer's Guide)

policy_DBA role (Label Security Administrator's Guide)

     [entry #2] (Label Security Administrator's Guide)

     [entry #3] (Label Security Administrator's Guide)

     [entry #4] (Label Security Administrator's Guide)

     [entry #5] (Label Security Administrator's Guide)

     [entry #6] (Label Security Administrator's Guide)

     [entry #7] (Label Security Administrator's Guide)

POLICY_FILTER procedure (Text Reference)

POLICY_GIST procedure (Text Reference)

POLICY_HIGHLIGHT procedure (Text Reference)

POLICY_INVOKER attribute (Security Guide)

POLICY_MARKUP procedure (Text Reference)

POLICY_SNIPPET procedure (Text Reference)

POLICY_THEMES procedure

syntax (Text Reference)

POLICY_TOKENS procedure

syntax (Text Reference)

polling (Application Developer's Guide - Large Objects)

     [entry #2] (Application Developer's Guide - Large Objects)

     [entry #3] (Application Developer's Guide - Large Objects)

Polycenter advanced file system, 8.4.2 (Administrator's Reference for UNIX-Based Operating Systems)

polygon

area of (Spatial User's Guide and Reference)

boundary of (Spatial User's Guide and Reference)

buffer (Spatial User's Guide and Reference)

centroid (Spatial User's Guide and Reference)

compound (Spatial User's Guide and Reference)

exterior and interior rings (Spatial User's Guide and Reference)

     [subentry #2] (Spatial User's Guide and Reference)

     [subentry #3] (Spatial User's Guide and Reference)

     [subentry #4] (Spatial User's Guide and Reference)

point on surface (Spatial User's Guide and Reference)

self-crossing not supported (Spatial User's Guide and Reference)

with hole (LRS measure values) (Spatial User's Guide and Reference)

polygon collection (Spatial User's Guide and Reference)

polygon data (Spatial User's Guide and Reference)

polygon geometries

adding (Spatial Topology and Network Data Models)

POLYGONTOLINE function (Spatial User's Guide and Reference)

polymorphism (Application Developer's Guide - Object-Relational Features)

     [entry #2] (Application Developer's Guide - Object-Relational Features)

     [entry #3] (Application Developer's Guide - Object-Relational Features)

     [entry #4] (Java Developer's Guide)

See also substitutability

POOL (POO) attribute (Net Services Administrator's Guide)

pool size (Java)

adjusting before importing GeoRaster data (Spatial GeoRaster)

PoolConfig() method (JDBC Developer's Guide and Reference)

POP command (OLAP DML Reference)

     [entry #2] (OLAP DML Reference)

     [entry #3] (OLAP DML Reference)

     [entry #4] (OLAP DML Reference)

popping a whole series at once (OLAP DML Reference)

POPLEVEL command (OLAP DML Reference)

nesting (OLAP DML Reference)

using (OLAP DML Reference)

populate index parameter (Text Reference)

populate parameter (Text Reference)

populate() method (JDBC Developer's Guide and Reference)

populating

alias dimensions (OLAP DML Reference)

measure (Spatial User's Guide and Reference)

Popup List of Values (HTML DB User's Guide)

Popup List of Values template

Application Identification

Application (HTML DB User's Guide)

Buttons (HTML DB User's Guide)

Form Icon (HTML DB User's Guide)

     [subentry #2] (HTML DB User's Guide)

Page Attributes (HTML DB User's Guide)

Pagination (HTML DB User's Guide)

Result Set (HTML DB User's Guide)

Search Field (HTML DB User's Guide)

Template Subscription (HTML DB User's Guide)

Window (HTML DB User's Guide)

popup LOV template

editing (HTML DB User's Guide)

Port (HTTP Server Administrator's Guide)

port (HTTP Server Administrator's Guide)

changing (HTTP Server Administrator's Guide)

designated for notification (Streams Advanced Queuing User's Guide and Reference)

port 1024 (Net Services Reference)

port 1521

     [entry #2] (Net Services Reference)

if not using (Net Services Administrator's Guide)

port 1575 (Net Services Reference)

port 1630 (Net Services Reference)

port 1646 (Net Services Reference)

port 1830 (Net Services Reference)

port 2483 (Net Services Reference)

port 2484 (Net Services Reference)

port conflict, 2.3.1 (SQL*Plus User's Guide and Reference)

PORT networking parameter (Net Services Reference)

     [entry #2] (Net Services Reference)

     [entry #3] (Net Services Reference)

port numbers

setting nondefault (Data Guard Broker)

     [subentry #2] (Data Guard Broker)

port numbers, allowed (Net Services Reference)

portability (PL/SQL User's Guide and Reference)

ports

privileged (Net Services Administrator's Guide)

     [subentry #2] (Net Services Reference)

Portuguese

supplied stoplist (Text Reference)

PORT_STRING function (PL/SQL Packages and Types Reference)

POSITION column

PLAN_TABLE table (Performance Tuning Guide)

position method (OLAP Developer's Guide to the OLAP API)

description (OLAP Developer's Guide to the OLAP API)

example of (OLAP Developer's Guide to the OLAP API)

POSITION parameter

using with data containing tabs (Utilities)

with multiple SQL*Loader INTO TABLE clauses (Utilities)

     [subentry #2] (Utilities)

     [subentry #3] (Utilities)

position() method (JDBC Developer's Guide and Reference)

     [entry #2] (JDBC Developer's Guide and Reference)

     [entry #3] (JDBC Developer's Guide and Reference)

positional descriptor (PD) (XML DB Developer's Guide)

positional iterators

accessing (SQLJ Developer's Guide and Reference)

declaring (SQLJ Developer's Guide and Reference)

instantiating and populating (SQLJ Developer's Guide and Reference)

navigation with next() (SQLJ Developer's Guide and Reference)

scrollable (SQLJ Developer's Guide and Reference)

using (SQLJ Developer's Guide and Reference)

positional parameter association (SQL*Module for Ada Programmer's Guide)

positioned (Oracle Call Interface Programmer's Guide)

deletes (Oracle Call Interface Programmer's Guide)

positioned delete (SQLJ Developer's Guide and Reference)

positioned update (SQLJ Developer's Guide and Reference)

positioning in result sets (JDBC Developer's Guide and Reference)

positions

CompoundCursor (OLAP Developer's Guide to the OLAP API)

Cursor (OLAP Developer's Guide to the OLAP API)

parent starting and ending (OLAP Developer's Guide to the OLAP API)

ValueCursor (OLAP Developer's Guide to the OLAP API)

POSITIVE

BINARY_INTEGER subtype (PL/SQL User's Guide and Reference)

POSITIVE and POSITIVEN subtypes (PL/SQL User's Guide and Reference)

positive infinity value (Application Developer's Guide - Fundamentals)

POSITIVEN

BINARY_INTEGER subtype (PL/SQL User's Guide and Reference)

POSIX

Oracle support for regular expressions (Application Developer's Guide - Fundamentals)

POSIX regular expression standard (SQL Reference)

POSIX standard

metacharacters in Oracle regular expressions (Application Developer's Guide - Fundamentals)

POST (HTTP Server Administrator's Guide)

POST method, 1.3 (HTTP Server mod_plsql User's Guide)

posting for notification (Streams Advanced Queuing User's Guide and Reference)

posting, message

definition (Application Developer's Guide - Fundamentals)

postinstallation tasks

POST_INSTANTIATION_SETUP procedure (PL/SQL Packages and Types Reference)

     [entry #2] (Streams Concepts and Administration)

     [entry #3] (Streams Replication Administrator's Guide)

     [entry #4] (Streams Replication Administrator's Guide)

     [entry #5] (Streams Replication Administrator's Guide)

     [entry #6] (Streams Replication Administrator's Guide)

pound sign (#), 12 (SQL*Plus User's Guide and Reference)

POUTFILEUNIT option (OLAP DML Reference)

power demand cartridge example (Data Cartridge Developer's Guide)

demo file (extdemo1.sql) (Data Cartridge Developer's Guide)

POWER function (SQL Quick Reference)

     [entry #2] (SQL Reference)

POWERMULTISET function (Application Developer's Guide - Object-Relational Features)

     [entry #2] (SQL Quick Reference)

     [entry #3] (SQL Reference)

POWERMULTISET_BY_CARDINALITY function (Application Developer's Guide - Object-Relational Features)

     [entry #2] (SQL Quick Reference)

     [entry #3] (SQL Reference)

PPMF image format (interMedia Reference)

PQ_DISTRIBUTE hint (SQL Reference)

practical security concerns (Security Guide)

PRAGMA

compiler directive with AUTONOMOUS_TRANSACTION (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

compiler directive with AUTONOMOUS_TRANSACTION for procedures (PL/SQL User's Guide and Reference)

compiler directive with EXCEPTION_INIT (PL/SQL User's Guide and Reference)

compiler directive with RESTRICT_REFERENCES (PL/SQL User's Guide and Reference)

compiler directive with SERIALLY_REUSABLE (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

pragma (Application Developer's Guide - Fundamentals)

RESTRICT_REFERENCES (Application Developer's Guide - Fundamentals)

SERIALLY_REUSABLE pragma (Application Developer's Guide - Fundamentals)

     [subentry #2] (Application Developer's Guide - Fundamentals)

PRAGMA clause

of ALTER TYPE (SQL Reference)

of CREATE TYPE (SQL Reference)

     [subentry #2] (SQL Reference)

PRAGMA RESTRICT_REFERENCES (SQL Reference)

pragma RESTRICT_REFERENCES (Application Developer's Guide - Object-Relational Features)

     [entry #2] (Data Cartridge Developer's Guide)

pragmas

AUTONOMOUS_TRANSACTION (PL/SQL User's Guide and Reference)

compiler directives (PL/SQL User's Guide and Reference)

EXCEPTION_INIT (PL/SQL User's Guide and Reference)

RESTRICT_REFERENCES (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

     [subentry #3] (PL/SQL User's Guide and Reference)

PRAGMA_EXCEPTION_INIT procedure

assigning exception names (Administrator's Guide)

pre-requisite checks (Managing Oracle Software Using Oracle Universal Installer and OPatch)

command line parameters (Managing Oracle Software Using Oracle Universal Installer and OPatch)

Pre-Upgrade Information Utility (New Features Guide)

preamble (SQL*Module for Ada Programmer's Guide)

syntax of (SQL*Module for Ada Programmer's Guide)

to a module (SQL*Module for Ada Programmer's Guide)

prebuilt materialized views (Data Warehousing Guide)

precedence

of an Assignment (OLAP Developer's Guide to the OLAP API)

of conditions (SQL Reference)

of numbers (SQL Reference)

of operators (SQL Reference)

precedence of operators (Text Reference)

altering (Text Reference)

     [subentry #2] (Text Reference)

equivalence operator (Text Reference)

example (Text Reference)

viewing (Text Reference)

precedence of precompiler options, 10.2.2 (Pro*C/C++ Precompiler Programmer's Guide)

     [entry #2] (Pro*C/C++ Precompiler Programmer's Guide)

precedence, operator (PL/SQL User's Guide and Reference)

precision

     [entry #2] (Programmer's Guide to the Oracle Precompilers)

extracting (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

in the FIXED DECIMAL PL/I datatype (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

number of digits of (SQL Reference)

of NUMBER datatype (SQL Reference)

precision and scale

using the SQLPRC procedure to extract (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

precision of digits

specifying (PL/SQL User's Guide and Reference)

PRECLOSE function

of HTF package (PL/SQL Packages and Types Reference)

PRECLOSE procedure

of HTP package (PL/SQL Packages and Types Reference)

precommit handlers (Streams Concepts and Administration)

creating (Streams Concepts and Administration)

monitoring (Streams Concepts and Administration)

removing (Streams Concepts and Administration)

setting (Streams Concepts and Administration)

precompilation

     [entry #2] (Programmer's Guide to the Oracle Precompilers)

conditional (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

generated code (Pro*COBOL Programmer's Guide)

separate (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

precompilation unit (Pro*COBOL Programmer's Guide)

     [entry #2] (Programmer's Guide to the Oracle Precompilers)

precompilation unit, 10.3 (Pro*C/C++ Precompiler Programmer's Guide)

precompilation unit, 3.1 (Pro*C/C++ Precompiler Programmer's Guide)

precompiled header files, 5.5 (Pro*C/C++ Precompiler Programmer's Guide)

precompiled header files, A.2.2 (Pro*C/C++ Precompiler Programmer's Guide)

precompiler (Programmer's Guide to the Oracle Precompilers)

precompiler command

     [entry #2] (Programmer's Guide to the Oracle Precompilers)

issuing (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

optional arguments of (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

required arguments (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

precompiler configuration files

precompiler default values (SQL*Module for Ada Programmer's Guide)

precompiler directives, EXEC SQL DECLARE DATABASE (Programmer's Guide to the Oracle Precompilers)

precompiler executables

Precompiler options

MODE (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

precompiler options

abbrevating name (Programmer's Guide to the Oracle Precompilers)

abbreviating name (Pro*COBOL Programmer's Guide)

ANSI Dynamic SQL (Pro*COBOL Programmer's Guide)

ASACC (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

ASSUME_SQLCODE (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

AUTO_CONNECT (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

CLOSE_ON_COMMIT (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

COMMON_NAME (Programmer's Guide to the Oracle Precompilers)

CONFIG (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

current values (Pro*COBOL Programmer's Guide)

DATE_FORMAT (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

DBMS (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

DECLARE_SECTION (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

default settings (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

DEFINE (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

displaying (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

     [subentry #4] (Programmer's Guide to the Oracle Precompilers)

displaying syntax, default, purpose (Pro*COBOL Programmer's Guide)

DYNAMIC (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

END_OF_FETCH (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

entering (Pro*COBOL Programmer's Guide)

entering from a configuration file (Programmer's Guide to the Oracle Precompilers)

entering inline (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

entering on the command line (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

ERRORS (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

FIPS (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

FORMAT (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

Globalization Support_LOCAL (Programmer's Guide to the Oracle Precompilers)

HOLD_CURSOR (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

HOST (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

INAME (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

INCLUDE (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

inline versus on the command line (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

IRECLEN (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

list (Pro*COBOL Programmer's Guide)

LITDELIM (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

LNAME (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

LRECLEN (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

LTYPE (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

macro and micro (Pro*COBOL Programmer's Guide)

MAXLITERAL (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

MAXOPENCURSORS (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (Pro*COBOL Programmer's Guide)

     [subentry #4] (Programmer's Guide to the Oracle Precompilers)

MODE (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (Pro*COBOL Programmer's Guide)

     [subentry #4] (Pro*COBOL Programmer's Guide)

     [subentry #5] (Programmer's Guide to the Oracle Precompilers)

MULTISUBPROG (Programmer's Guide to the Oracle Precompilers)

name of the system configuration file (Pro*COBOL Programmer's Guide)

NESTED (Pro*COBOL Programmer's Guide)

NLS_LOCAL (Pro*COBOL Programmer's Guide)

ONAME (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

ORACA (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

ORECLEN (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

PAGELEN (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

PICX (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

precedence (Pro*COBOL Programmer's Guide)

PREFETCH (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

RELEASE_CURSOR (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

respecifying (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

scope of (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

     [subentry #4] (Programmer's Guide to the Oracle Precompilers)

scope of inline options (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

SELECT_ERROR (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

specifying (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

SQLCHECK (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

syntax for (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

table of how macro options set micro options (Pro*COBOL Programmer's Guide)

THREADS (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (Pro*COBOL Programmer's Guide)

TYPE_CODE (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

UNSAFE_NULL (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

USERID (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

VARCHAR (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

XREF (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

precompiler README files, 6.1.3 (Administrator's Reference for UNIX-Based Operating Systems)

precompilers

     [entry #2] (Application Developer's Guide - Fundamentals)

     [entry #3] (SQL Reference)

     [entry #4] (SQL*Module for Ada Programmer's Guide)

advantages (Pro*COBOL Programmer's Guide)

anonymous blocks (Concepts)

     [subentry #2] (Concepts)

applications (Application Developer's Guide - Fundamentals)

changing (Upgrade Guide)

upgrading options (Upgrade Guide)

bind variables (Concepts)

     [subentry #2] (Concepts)

calling stored procedures and packages (Application Developer's Guide - Fundamentals)

compared to OCI (Application Developer's Guide - Fundamentals)

control of parsing and private SQL areas (Performance Tuning Guide)

cursors (Concepts)

     [subentry #2] (Concepts)

embedded SQL (Concepts)

     [subentry #2] (Concepts)

Globalization Support (Pro*COBOL Programmer's Guide)

language support (Pro*COBOL Programmer's Guide)

running (Pro*COBOL Programmer's Guide)

upgrading applications (Upgrade Guide)

using PL/SQL (Pro*COBOL Programmer's Guide)

PRECOMPUTE statement (OLAP DML Reference)

preconfigured authentication schemes (HTML DB User's Guide)

predefined exceptions

raising explicitly (PL/SQL User's Guide and Reference)

redeclaring (PL/SQL User's Guide and Reference)

predefined symbols, 2.4.1 (Pro*C/C++ Precompiler Programmer's Guide)

predefined variable

predetermined size fields

SQL*Loader (Utilities)

predetermined size LOBs (Utilities)

predicate operators (Application Developer's Guide - Rules Manager and Expression Filter)

predicate table (Application Developer's Guide - Rules Manager and Expression Filter)

     [entry #2] (Application Developer's Guide - Rules Manager and Expression Filter)

querying (Application Developer's Guide - Rules Manager and Expression Filter)

predicates

     [entry #2] (PL/SQL User's Guide and Reference)

access mediation (Label Security Administrator's Guide)

dynamic

in security policies (Concepts)

in security policies (Security Guide)

errors (Label Security Administrator's Guide)

evaluating in a sparse predicate group (Application Developer's Guide - Rules Manager and Expression Filter)

evaluating in a stored predicate group (Application Developer's Guide - Rules Manager and Expression Filter)

evaluating in an indexed predicate group (Application Developer's Guide - Rules Manager and Expression Filter)

indexable (Application Developer's Guide - Rules Manager and Expression Filter)

indexed (Application Developer's Guide - Rules Manager and Expression Filter)

label tag performance strategy (Label Security Administrator's Guide)

multiple (Label Security Administrator's Guide)

partition pruning

indexes (Data Warehousing Guide)

sparse (Application Developer's Guide - Rules Manager and Expression Filter)

     [subentry #2] (Application Developer's Guide - Rules Manager and Expression Filter)

spatial (Application Developer's Guide - Rules Manager and Expression Filter)

     [subentry #2] (Application Developer's Guide - Rules Manager and Expression Filter)

stored (Application Developer's Guide - Rules Manager and Expression Filter)

used with policy (Label Security Administrator's Guide)

XPath (Application Developer's Guide - Rules Manager and Expression Filter)

predicates, XPath

mapping to SQL (XML DB Developer's Guide)

collection (XML DB Developer's Guide)

PREDICT (Data Mining Application Developer's Guide)

PREDICT procedure (PL/SQL Packages and Types Reference)

PREDICTION (Data Mining Application Developer's Guide)

     [entry #2] (Data Mining Application Developer's Guide)

     [entry #3] (Data Mining Application Developer's Guide)

PREDICTION function (SQL Reference)

PREDICTION_COST (Data Mining Application Developer's Guide)

     [entry #2] (Data Mining Application Developer's Guide)

PREDICTION_COST function (SQL Reference)

PREDICTION_DETAILS (Data Mining Application Developer's Guide)

     [entry #2] (Data Mining Application Developer's Guide)

PREDICTION_DETAILS function (SQL Reference)

PREDICTION_PROBABILITY (Data Mining Application Developer's Guide)

PREDICTION_PROBABILITY function (SQL Reference)

PREDICTION_SET (Data Mining Application Developer's Guide)

     [entry #2] (Data Mining Application Developer's Guide)

PREDICTION_SET function (SQL Reference)

predictive analysis applications (OLAP Application Developer's Guide)

predictive analytics (Data Mining Application Developer's Guide)

add-in (Data Mining Concepts)

DATE and TIMESTAMP (Data Mining Application Developer's Guide)

Java API (Data Mining Application Developer's Guide)

     [subentry #2] (Data Mining Application Developer's Guide)

Oracle Spreadsheet Add-In (Data Mining Application Developer's Guide)

PL/SQL API (Data Mining Application Developer's Guide)

Predictive Analytics Package (New Features Guide)

preference classes

viewing (Text Reference)

preference values

viewing (Text Reference)

preferences

about (Text Reference)

and CTXSYS (Text Application Developer's Guide)

changing (Text Reference)

creating (Text Reference)

creating (examples) (Text Application Developer's Guide)

creating with admin tool (Text Application Developer's Guide)

dropping (Text Application Developer's Guide)

     [subentry #2] (Text Reference)

purging for a specific user (HTML DB User's Guide)

replacing (Text Reference)

specifying for indexing (Text Reference)

system-defined (Text Reference)

viewing (Text Reference)

viewing for a specific user (HTML DB User's Guide)

vs. types (Text Reference)

Preferences screen, 1.3.8 (SQL*Plus User's Guide and Reference)

PREFERRED

preferred credentials (2 Day DBA)

setting (2 Day DBA)

preferred term operator

example (Text Reference)

PreferredApplyInstance property (Data Guard Broker)

     [entry #2] (Data Guard Broker)

prefetch count

set (Oracle C++ Call Interface Programmer's Guide)

prefetch limit (Oracle C++ Call Interface Programmer's Guide)

PREFETCH precompiler option (Pro*COBOL Programmer's Guide)

     [entry #2] (Pro*COBOL Programmer's Guide)

PREFETCH precompiler option, 10.5.42 (Pro*C/C++ Precompiler Programmer's Guide)

PREFETCH precompiler option, 6.6.3 (Pro*C/C++ Precompiler Programmer's Guide)

PREFETCH precompiler option, A.3.3 (Pro*C/C++ Precompiler Programmer's Guide)

prefetching

during OCIStmtExecute() (Oracle Call Interface Programmer's Guide)

setting prefetch memory size (Oracle Call Interface Programmer's Guide)

setting row count (Oracle Call Interface Programmer's Guide)

prefetching rows (JDBC Developer's Guide and Reference)

     [entry #2] (JDBC Developer's Guide and Reference)

     [entry #3] (SQLJ Developer's Guide and Reference)

suggested default (JDBC Developer's Guide and Reference)

prefix option (AuditorInstaller) (SQLJ Developer's Guide and Reference)

prefixed indexes (Data Warehousing Guide)

     [entry #2] (Data Warehousing Guide)

prefixes

to pass options to customizer (SQLJ Developer's Guide and Reference)

to pass options to Java compiler (SQLJ Developer's Guide and Reference)

to pass options to Java VM (SQLJ Developer's Guide and Reference)

prefixes of data dictionary views (Concepts)

prefix_index attribute (Text Reference)

prefix_length_max attribute (Text Reference)

prefix_length_min attribute (Text Reference)

PREFORMAT clause, 3.5.1.5 (SQL*Plus User's Guide and Reference)

PREFORMAT, 3.5.1.5 (SQL*Plus User's Guide and Reference)

PREOPEN function

of HTF package (PL/SQL Packages and Types Reference)

PREOPEN procedure

of HTP package (PL/SQL Packages and Types Reference)

preparation

data (Data Mining Concepts)

prepare a distributed transaction branch (JDBC Developer's Guide and Reference)

PREPARE command

     [entry #2] (Programmer's Guide to the Oracle Precompilers)

examples (Programmer's Guide to the Oracle Precompilers)

See SQL PREPARE command

prepare multiple branches in a single message (Oracle Call Interface Programmer's Guide)

prepare phase

abort response (Administrator's Guide)

in two-phase commit (Administrator's Guide)

prepared response (Administrator's Guide)

read-only response (Administrator's Guide)

recognizing read-only nodes (Administrator's Guide)

steps (Administrator's Guide)

PREPARE SQL statement, F.69 (Pro*C/C++ Precompiler Programmer's Guide)

PREPARE statement (Pro*COBOL Programmer's Guide)

effect on data definition statements (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

examples (Pro*COBOL Programmer's Guide)

in dynamic SQL method 4 (Pro*COBOL Programmer's Guide)

use in Dynamic SQL Method 4 (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

using in dynamic SQL (Pro*COBOL Programmer's Guide)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (Programmer's Guide to the Oracle Precompilers)

     [subentry #4] (Programmer's Guide to the Oracle Precompilers)

PREPARE statement, 14.5.5 (Pro*C/C++ Precompiler Programmer's Guide)

PREPARE TO SWITCHOVER clause

of ALTER DATABASE (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

     [subentry #3] (Data Guard Concepts and Administration)

     [subentry #4] (SQL Reference)

prepare/commit phases

effects of failure (Administrator's Guide)

failures during (Administrator's Guide)

locked resources (Administrator's Guide)

pending transaction table (Administrator's Guide)

prepareCall() (JDBC Developer's Guide and Reference)

prepareCall() method (JDBC Developer's Guide and Reference)

     [entry #2] (JDBC Developer's Guide and Reference)

     [entry #3] (JDBC Developer's Guide and Reference)

     [entry #4] (JDBC Developer's Guide and Reference)

     [entry #5] (JDBC Developer's Guide and Reference)

prepared data (Data Mining Concepts)

prepared response

two-phase commit (Administrator's Guide)

prepared statement

passing BFILE locator (JDBC Developer's Guide and Reference)

passing LOB locators (JDBC Developer's Guide and Reference)

PREPARED status (Oracle C++ Call Interface Programmer's Guide)

     [entry #2] (Oracle C++ Call Interface Programmer's Guide)

PreparedStatement object

creating (JDBC Developer's Guide and Reference)

PREPARER process (Data Guard Concepts and Administration)

staging LCRs in SGA (Data Guard Concepts and Administration)

prepareStatement() (JDBC Developer's Guide and Reference)

prepareStatement() method (JDBC Developer's Guide and Reference)

     [entry #2] (JDBC Developer's Guide and Reference)

     [entry #3] (JDBC Developer's Guide and Reference)

     [entry #4] (JDBC Developer's Guide and Reference)

     [entry #5] (JDBC Developer's Guide and Reference)

code example (JDBC Developer's Guide and Reference)

PREPARE_COLUMN_VALUES procedures (PL/SQL Packages and Types Reference)

     [entry #2] (PL/SQL Packages and Types Reference)

PREPARE_COLUMN_VALUES_NVARCHAR2 procedure (PL/SQL Packages and Types Reference)

PREPARE_COLUMN_VALUES_ROWID procedure (PL/SQL Packages and Types Reference)

PREPARE_FOR_EXPORT procedure (Spatial Topology and Network Data Models)

PREPARE_FOR_NEW_PRIMARY subprogram (PL/SQL Packages and Types Reference)

PREPARE_FOR_TTS procedure (Spatial User's Guide and Reference)

PREPARE_GLOBAL_INSTANTIATION procedure (PL/SQL Packages and Types Reference)

     [entry #2] (Streams Replication Administrator's Guide)

     [entry #3] (Streams Replication Administrator's Guide)

PREPARE_INSTANTIATED_MASTER procedure (Advanced Replication Management API Reference)

     [entry #2] (Advanced Replication Management API Reference)

PREPARE_INSTANTIATED_MASTERS procedure (Advanced Replication Management API Reference)

PREPARE_SCHEMA_INSTANTIATION procedure (PL/SQL Packages and Types Reference)

     [entry #2] (Streams Replication Administrator's Guide)

     [entry #3] (Streams Replication Administrator's Guide)

PREPARE_TABLE_INSTANTIATION procedure (PL/SQL Packages and Types Reference)

     [entry #2] (Streams Replication Administrator's Guide)

     [entry #3] (Streams Replication Administrator's Guide)

preparing

images for matching (interMedia User's Guide)

preparing to upgrade (Upgrade Guide)

collecting optimizer statistics (Upgrade Guide)

preprocessor

not supported in SQL blocks (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

preprocessor directives

preprocessor, support of, 4.1 (Pro*C/C++ Precompiler Programmer's Guide)

prerequisites

for creating a database (Administrator's Guide)

installation (Data Guard Broker)

setting a nondefault port number (Data Guard Broker)

     [subentry #2] (Data Guard Broker)

SQL*Loader (Utilities)

switchover (Data Guard Broker)

Presentation Beans (OLAP Application Developer's Guide)

presentation layer (Net Services Administrator's Guide)

FTP (Net Services Administrator's Guide)

HTTP (Net Services Administrator's Guide)

JavaTTC (Net Services Administrator's Guide)

Two-Task Common (TTC) (Net Services Administrator's Guide)

WebDAV (Net Services Administrator's Guide)

PRESENTNNV function (SQL Quick Reference)

     [entry #2] (SQL Quick Reference)

     [entry #3] (SQL Quick Reference)

     [entry #4] (SQL Quick Reference)

     [entry #5] (SQL Quick Reference)

     [entry #6] (SQL Quick Reference)

     [entry #7] (SQL Reference)

PRESENTV function (SQL Quick Reference)

     [entry #2] (SQL Reference)

PRESERVE MATERIALIZED VIEW LOG option

TRUNCATE TABLE statement (Advanced Replication Management API Reference)

PRESERVE parameter (Utilities)

preserve parameter

Database Character Set Scanner (Globalization Support Guide)

preserved snapshots (Performance Tuning Guide)

PreserveMessageID (Streams Advanced Queuing User's Guide and Reference)

preserving

whitespace (Utilities)

Presidential Inaugural Addresses (HTML DB User's Guide)

prespawned dedicated servers (Net Services Reference)

     [entry #2] (Net Services Reference)

PRESPAWN_DESC networking parameter (Net Services Reference)

     [entry #2] (Net Services Reference)

PRESPAWN_LIST networking parameter (Net Services Reference)

PRESPAWN_MAX networking parameter (Net Services Reference)

     [entry #2] (Net Services Reference)

pretty-printing (XML DB Developer's Guide)

in book examples (XML DB Developer's Guide)

not done by SQL/XML functions (XML DB Developer's Guide)

PREVIOUS function (SQL Quick Reference)

     [entry #2] (SQL Reference)

previous releases, migrating from (Text Application Developer's Guide)

previous releases, migrating to (Text Application Developer's Guide)

Previous runs

control file (HTML DB User's Guide)

previous() method (result set) (JDBC Developer's Guide and Reference)

previousNode() (XML C++ API Reference)

     [entry #2] (XML C++ API Reference)

previousSibling() (XML C++ API Reference)

pre_geocoded_location element (Spatial User's Guide and Reference)

pre_geocoded_locations attribute

of route request (Spatial User's Guide and Reference)

PRE_INSTANTIATION_SETUP procedure (PL/SQL Packages and Types Reference)

     [entry #2] (Streams Concepts and Administration)

     [entry #3] (Streams Replication Administrator's Guide)

     [entry #4] (Streams Replication Administrator's Guide)

     [entry #5] (Streams Replication Administrator's Guide)

     [entry #6] (Streams Replication Administrator's Guide)

PRE_PAGE_SGA initialization parameter (Reference)

setting with ALTER SYSTEM (SQL Reference)

PRGERR keyword (SIGNAL) (OLAP DML Reference)

PRGTRACE option (OLAP DML Reference)

primary and secondary instances (Net Services Administrator's Guide)

primary binding (Data Cartridge Developer's Guide)

primary database

ARCHIVELOG mode (Data Guard Broker)

backups and (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

configuration (Data Guard Broker)

configuring

for cross-instance archival (Data Guard Concepts and Administration)

on Real Application Clusters (Data Guard Concepts and Administration)

single-instance (Data Guard Concepts and Administration)

connecting to (Data Guard Broker)

     [subentry #2] (Data Guard Broker)

constructing a standby database (Data Guard Broker)

     [subentry #2] (Data Guard Broker)

data files

adding (Data Guard Concepts and Administration)

renaming (Data Guard Concepts and Administration)

Data Guard configuration (Data Guard Broker)

defined (Data Guard Concepts and Administration)

during failover (Data Guard Broker)

during switchover (Data Guard Broker)

failed

reenabling (Data Guard Broker)

failover and (Data Guard Concepts and Administration)

Flashback Database (Data Guard Broker)

gap resolution (Data Guard Concepts and Administration)

gathering redo log archival information (Data Guard Concepts and Administration)

health check (Data Guard Broker)

initialization parameters

and physical standby database (Data Guard Concepts and Administration)

monitoring events on (Data Guard Concepts and Administration)

network connections

avoiding network hangs (Data Guard Concepts and Administration)

detecting disconnections (Data Guard Concepts and Administration)

handling network timeouts (Data Guard Concepts and Administration)

preparing for

physical standby database creation (Data Guard Concepts and Administration)

preparing for switchover (Data Guard Broker)

prerequisite conditions for

logical standby database creation (Data Guard Concepts and Administration)

Real Application Clusters and

setting up (Data Guard Concepts and Administration)

setting up (Data Guard Concepts and Administration)

redo transport services on (Data Guard Concepts and Administration)

reducing workload on (Data Guard Concepts and Administration)

reinstantiation (New Features Guide)

reinstating

REINSTATEMENT command (Data Guard Broker)

reinstating after a fast-start failover (Data Guard Broker)

setting archive tracing (Data Guard Concepts and Administration)

sharing a flash recovery area (Data Guard Concepts and Administration)

shutting down when fast-start failover is enabled (Data Guard Broker)

standby redo log files on (Data Guard Broker)

state transitions (Data Guard Broker)

switching over to the standby role (Data Guard Broker)

switchover (Data Guard Concepts and Administration)

switchovers

initiating (Data Guard Concepts and Administration)

tablespaces

adding (Data Guard Concepts and Administration)

dropping (Data Guard Concepts and Administration)

primary databases

ARCHIVELOG mode (Data Guard Concepts and Administration)

software requirements (Data Guard Concepts and Administration)

using V$ARCHIVED_LOG view to find missing log files (Data Guard Concepts and Administration)

Primary Display Attributes (HTML DB User's Guide)

Cursor Focus (HTML DB User's Guide)

Page Template (HTML DB User's Guide)

Standard Tab Set (HTML DB User's Guide)

Title (HTML DB User's Guide)

primary filter (Spatial User's Guide and Reference)

     [entry #2] (Spatial User's Guide and Reference)

     [entry #3] (Spatial User's Guide and Reference)

primary key (Java Developer's Guide)

PRIMARY KEY clause

of constraints (SQL Reference)

of CREATE TABLE (SQL Reference)

primary key columns

logged with supplemental logging (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

PRIMARY KEY constraint (Performance Tuning Guide)

PRIMARY KEY constraints

     [entry #2] (Concepts)

     [entry #3] (Data Warehousing Guide)

associated indexes (Administrator's Guide)

choosing a primary key (Application Developer's Guide - Fundamentals)

constraint checking (Concepts)

described (Concepts)

disabling (Application Developer's Guide - Fundamentals)

dropping associated indexes (Administrator's Guide)

effect on direct path load (Utilities)

enabling (Application Developer's Guide - Fundamentals)

enabling on creation (Administrator's Guide)

foreign key references when dropped (Administrator's Guide)

indexes associated with (Administrator's Guide)

indexes used to enforce (Concepts)

name of (Concepts)

materialized views (Advanced Replication)

     [subentry #2] (Advanced Replication)

maximum number of columns (Concepts)

multiple columns in (Application Developer's Guide - Fundamentals)

NOT NULL constraints implied by (Concepts)

replicated tables (Advanced Replication)

UNIQUE key constraint vs. (Application Developer's Guide - Fundamentals)

primary key constraints (SQL Reference)

enabling (SQL Reference)

index on (SQL Reference)

primary key OIDs

example (Utilities)

primary key REF columns (Utilities)

     [entry #2] (Utilities)

primary keys (Concepts)

advantages of (Concepts)

defined (Concepts)

generating values for (SQL Reference)

primary level sort (Globalization Support Guide)

primary role (Data Guard Concepts and Administration)

primary sites

ownership (Advanced Replication)

primary Source objects

definition (OLAP Developer's Guide to the OLAP API)

from MdmSource objects (OLAP Developer's Guide to the OLAP API)

result of getSource method (OLAP Developer's Guide to the OLAP API)

primary-key-based REFs (Application Developer's Guide - Object-Relational Features)

primitive event (Application Developer's Guide - Rules Manager and Expression Filter)

     [entry #2] (Application Developer's Guide - Rules Manager and Expression Filter)

     [entry #3] (Application Developer's Guide - Rules Manager and Expression Filter)

     [entry #4] (Application Developer's Guide - Rules Manager and Expression Filter)

as an XML document (Application Developer's Guide - Rules Manager and Expression Filter)

defined as XML document (Application Developer's Guide - Rules Manager and Expression Filter)

primitive events using relational tables

storing in relational tables (Application Developer's Guide - Rules Manager and Expression Filter)

primitive types (Spatial User's Guide and Reference)

primitives

See topological elements

principal, definition (XML Developer's Kit Programmer's Guide)

principle of least privilege (Security Guide)

     [entry #2] (Security Guide)

     [entry #3] (Security Guide)

     [entry #4] (Security Guide)

print buffer (OLAP Reference)

     [entry #2] (OLAP Reference)

PRINT clause, 12 (SQL*Plus User's Guide and Reference)

PRINT command, 12 (SQL*Plus User's Guide and Reference)

PRINT function

of HTF package (PL/SQL Packages and Types Reference)

Print Mode template (HTML DB User's Guide)

print option (customizer harness) (SQLJ Developer's Guide and Reference)

PRINT procedure

of HTP package (PL/SQL Packages and Types Reference)

PRINT SCRIPT command (Recovery Manager Reference)

PRINTER environment variable, 1.2.2 (Administrator's Reference for UNIX-Based Operating Systems)

Printer Friendly mode (HTML DB User's Guide)

PRINTER_FRIENDLY substitution string (HTML DB User's Guide)

printing

printjoins attribute (Text Reference)

printjoins character (Text Application Developer's Guide)

PRINTLOG procedure (OLAP Reference)

PRINTS procedure

of HTP package (PL/SQL Packages and Types Reference)

PrintWriter for a data source (JDBC Developer's Guide and Reference)

PRINT_BACKTRACE procedure (PL/SQL Packages and Types Reference)

PRINT_CGI_ENV procedure (PL/SQL Packages and Types Reference)

PRINT_INSTANTIATIONS procedure (PL/SQL Packages and Types Reference)

print_media creation (Application Developer's Guide - Large Objects)

print_media table definition (Application Developer's Guide - Large Objects)

PRINT_MULTI procedure (PL/SQL Packages and Types Reference)

PRINT_POST_PROCESSED_SOURCE Procedure (PL/SQL Packages and Types Reference)

PRINT_ROW_LIST procedure (PL/SQL Packages and Types Reference)

PRIOR clause

of hierarchical queries (SQL Reference)

PRIOR method

collections (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

PRIOR operator (SQL Reference)

Prior Period (OLAP Reference)

     [entry #2] (OLAP Reference)

prior probabilities (Data Mining Application Developer's Guide)

prior probabilities table (Data Mining Application Developer's Guide)

     [entry #2] (Data Mining Application Developer's Guide)

PRIOR row operator (PL/SQL User's Guide and Reference)

priorities

job (Administrator's Guide)

priority

during propagation (Streams Advanced Queuing User's Guide and Reference)

specifying during enqueuing (Streams Advanced Queuing User's Guide and Reference)

Priority (JMS)

about (Streams Advanced Queuing User's Guide and Reference)

setting for all messages from a MessageProducer (Streams Advanced Queuing User's Guide and Reference)

priority groups

adding members to (Advanced Replication Management API Reference)

altering members

priorities (Advanced Replication Management API Reference)

values (Advanced Replication Management API Reference)

creating (Advanced Replication Management API Reference)

dropping (Advanced Replication Management API Reference)

removing members from (Advanced Replication Management API Reference)

     [subentry #2] (Advanced Replication Management API Reference)

site priority groups

adding members to (Advanced Replication Management API Reference)

priority groups conflict resolution method (Advanced Replication)

priors (Data Mining Concepts)

privacy (Security Guide)

     [entry #2] (Security Guide)

PRIVATE clause

of CREATE OUTLINE (SQL Reference)

private database links (Administrator's Guide)

private interconnect

private key (HTTP Server Administrator's Guide)

private memory, B.5.1 (Administrator's Reference for UNIX-Based Operating Systems)

private objects

packages (PL/SQL User's Guide and Reference)

private outlines

use by the optimizer (SQL Reference)

Private Schemas (Security Guide)

private SQL area

association with cursors (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

opening (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

purpose (Pro*COBOL Programmer's Guide)

     [subentry #2] (Programmer's Guide to the Oracle Precompilers)

private SQL areas

cursors and (Application Developer's Guide - Fundamentals)

     [subentry #2] (Concepts)

described (Concepts)

how managed (Concepts)

private SQL areas, B.5.1 (Administrator's Reference for UNIX-Based Operating Systems)

private synonyms (Administrator's Guide)

Private Use Area (Globalization Support Guide)

PRIVATE_SGA parameter

of ALTER PROFILE (SQL Reference)

of ALTER RESOURCE COST (SQL Reference)

PRIVATE_SGA variable (Performance Tuning Guide)

privgroup file, B.2.1 (Administrator's Reference for UNIX-Based Operating Systems)

privgroup file, B.4.1 (Administrator's Reference for UNIX-Based Operating Systems)

privilege auditing

turning off (Security Guide)

turning on (Security Guide)

privilege management (Application Developer's Guide - Workspace Manager)

     [entry #2] (Security Guide)

privileged ports (Net Services Administrator's Guide)

     [entry #2] (Net Services Reference)

privileges

     [entry #2] (Security Guide)

ACCESS_ANY_WORKSPACE (Application Developer's Guide - Workspace Manager)

ACCESS_WORKSPACE (Application Developer's Guide - Workspace Manager)

acquired by role on object types (Application Developer's Guide - Object-Relational Features)

adding redo log groups (Administrator's Guide)

administrator (Concepts)

statement execution audited (Security Guide)

ALTER ANY TYPE on object types (Application Developer's Guide - Object-Relational Features)

altering

passwords (Security Guide)

users (Security Guide)

altering indexes (Administrator's Guide)

altering role authentication method (Security Guide)

altering tables (Administrator's Guide)

application developers (Security Guide)

application developers and (Concepts)

     [subentry #2] (Security Guide)

AQ system privilege

granting (Streams Advanced Queuing User's Guide and Reference)

granting in JMS (Streams Advanced Queuing User's Guide and Reference)

revoking (Streams Advanced Queuing User's Guide and Reference)

revoking in JMS (Streams Advanced Queuing User's Guide and Reference)

audit object (Security Guide)

auditing system (Security Guide)

auditing use of (Security Guide)

     [subentry #2] (Security Guide)

cascading revokes (Security Guide)

checked when parsing (Concepts)

checked when pinning object types (Application Developer's Guide - Object-Relational Features)

closing a database link (Administrator's Guide)

column (Security Guide)

column level for object tables (Application Developer's Guide - Object-Relational Features)

COMPACCESS (Label Security Administrator's Guide)

     [subentry #2] (Label Security Administrator's Guide)

connection (2 Day DBA)

CREATE ANY TYPE on object types (Application Developer's Guide - Object-Relational Features)

CREATE DBLINK statement (Security Guide)

CREATE_ANY_WORKSPACE (Application Developer's Guide - Workspace Manager)

CREATE_WORKSPACE (Application Developer's Guide - Workspace Manager)

creating database links (Administrator's Guide)

creating integrity constraints (Application Developer's Guide - Fundamentals)

creating roles (Security Guide)

creating tables (Administrator's Guide)

creating tablespaces (Administrator's Guide)

creating triggers (Application Developer's Guide - Fundamentals)

creating users (Security Guide)

database (Java Developer's Guide)

     [subentry #2] (SQL*Module for Ada Programmer's Guide)

database administrator (Administrator's Guide)

DBMS_AQIN (Streams Advanced Queuing User's Guide and Reference)

DBMS_LOGSTDBY package (PL/SQL Packages and Types Reference)

definition (Concepts)

DELETE on object types (Application Developer's Guide - Object-Relational Features)

description (Application Developer's Guide - Workspace Manager)

DROP ANY TYPE on object types (Application Developer's Guide - Object-Relational Features)

dropping indexes (Administrator's Guide)

dropping online redo log members (Administrator's Guide)

dropping profiles (Security Guide)

dropping redo log groups (Administrator's Guide)

dropping roles (Security Guide)

dropping tables (Administrator's Guide)

dropping triggers (Application Developer's Guide - Fundamentals)

enabling and disabling triggers (Administrator's Guide)

encapsulating in stored procedures (Security Guide)

EXECUTE ANY TYPE on object types (Application Developer's Guide - Object-Relational Features)

     [subentry #2] (Application Developer's Guide - Object-Relational Features)

EXECUTE ANY TYPE on object types with ADMIN OPTION (Application Developer's Guide - Object-Relational Features)

EXECUTE on object types (Application Developer's Guide - Object-Relational Features)

EXECUTE on object types with GRANT option (Application Developer's Guide - Object-Relational Features)

EXEMPT ACCESS POLICY

effect on direct path export (Utilities)

flashback (Application Developer's Guide - Fundamentals)

for external tables (Administrator's Guide)

forcing a log switch (Administrator's Guide)

FREEZE_ANY_WORKSPACE (Application Developer's Guide - Workspace Manager)

FREEZE_WORKSPACE (Application Developer's Guide - Workspace Manager)

FULL (Label Security Administrator's Guide)

     [subentry #2] (Label Security Administrator's Guide)

     [subentry #3] (Label Security Administrator's Guide)

function-based indexes (Concepts)

     [subentry #2] (Concepts)

getting (Application Developer's Guide - Workspace Manager)

grant option (Application Developer's Guide - Workspace Manager)

granted to PUBLIC user group (Application Developer's Guide - Workspace Manager)

granting (Application Developer's Guide - Rules Manager and Expression Filter)

     [subentry #2] (Application Developer's Guide - Workspace Manager)

     [subentry #3] (Application Developer's Guide - Workspace Manager)

     [subentry #4] (PL/SQL Packages and Types Reference)

     [subentry #5] (Security Guide)

     [subentry #6] (Security Guide)

     [subentry #7] (Security Guide)

     [subentry #8] (Ultra Search User's Guide)

examples of (Security Guide)

examples of (Security Guide)

multiparent graph workspaces (Application Developer's Guide - Workspace Manager)

granting object privileges (Security Guide)

granting system privileges (Security Guide)

granting, about (Security Guide)

grouping with roles (Security Guide)

index creation (Application Developer's Guide - Fundamentals)

individual privilege names (Security Guide)

INSERT on object types (Application Developer's Guide - Object-Relational Features)

listing grants (Security Guide)

managing (Application Developer's Guide - Workspace Manager)

     [subentry #2] (Security Guide)

     [subentry #3] (Security Guide)

managing with procedures (Administrator's Guide)

managing with synonyms (Administrator's Guide)

managing with views (Administrator's Guide)

manually acquiring locks (Application Developer's Guide - Fundamentals)

manually archiving (Administrator's Guide)

materialized views (Advanced Replication)

     [subentry #2] (Advanced Replication)

MERGE_ANY_WORKSPACE (Application Developer's Guide - Workspace Manager)

MERGE_WORKSPACE (Application Developer's Guide - Workspace Manager)

middle tier (Security Guide)

object (2 Day DBA)

     [subentry #2] (Security Guide)

     [subentry #3] (Security Guide)

     [subentry #4] (Security Guide)

object types in types or tables (Application Developer's Guide - Object-Relational Features)

object types with CREATE TYPE (Application Developer's Guide - Object-Relational Features)

object types with DELETE (Application Developer's Guide - Object-Relational Features)

object types with INSERT (Application Developer's Guide - Object-Relational Features)

object types with SELECT (Application Developer's Guide - Object-Relational Features)

object types with UPDATE (Application Developer's Guide - Object-Relational Features)

on object types (Application Developer's Guide - Object-Relational Features)

on selected columns (Security Guide)

on subtypes of object types (SQL Reference)

Oracle Label Security (Label Security Administrator's Guide)

Oracle Streams administrator (PL/SQL Packages and Types Reference)

     [subentry #2] (PL/SQL Packages and Types Reference)

     [subentry #3] (Streams Concepts and Administration)

monitoring (Streams Concepts and Administration)

overview of (Concepts)

     [subentry #2] (Security Guide)

parameters

admin_option (Streams Advanced Queuing User's Guide and Reference)

grantee (Streams Advanced Queuing User's Guide and Reference)

grant_option (Streams Advanced Queuing User's Guide and Reference)

policies for managing (Concepts)

     [subentry #2] (Security Guide)

procedures (Security Guide)

creating and altering (Security Guide)

executing (Security Guide)

in packages (Security Guide)

PROFILE_ACCESS (Label Security Administrator's Guide)

     [subentry #2] (Label Security Administrator's Guide)

program units (Label Security Administrator's Guide)

queue privilege

granting (Streams Advanced Queuing User's Guide and Reference)

granting in JMS (Streams Advanced Queuing User's Guide and Reference)

revoking (Streams Advanced Queuing User's Guide and Reference)

revoking in JMS (Streams Advanced Queuing User's Guide and Reference)

READ (Label Security Administrator's Guide)

     [subentry #2] (Label Security Administrator's Guide)

recompiling packages (Administrator's Guide)

recompiling procedures (Administrator's Guide)

recompiling triggers (Application Developer's Guide - Fundamentals)

recompiling views (Administrator's Guide)

remote login (Reference)

REMOVE_ANY_WORKSPACE (Application Developer's Guide - Workspace Manager)

REMOVE_WORKSPACE (Application Developer's Guide - Workspace Manager)

renaming objects (Administrator's Guide)

renaming redo log members (Administrator's Guide)

required for Export and Import (Utilities)

required for indexing (Text Reference)

required for propagation (Streams Advanced Queuing User's Guide and Reference)

required for SQL*Loader (Utilities)

required to create procedures (Data Cartridge Developer's Guide)

RESTRICTED SESSION system privilege (Administrator's Guide)

RESTRICTED_SESSION privilege (Reference)

     [subentry #2] (Reference)

revoked

object dependencies and (Concepts)

revoking (Application Developer's Guide - Rules Manager and Expression Filter)

     [subentry #2] (Application Developer's Guide - Workspace Manager)

     [subentry #3] (Application Developer's Guide - Workspace Manager)

     [subentry #4] (Application Developer's Guide - Workspace Manager)

     [subentry #5] (PL/SQL Packages and Types Reference)

     [subentry #6] (Security Guide)

     [subentry #7] (Security Guide)

     [subentry #8] (Security Guide)

     [subentry #9] (Ultra Search User's Guide)

multiparent graph workspaces (Application Developer's Guide - Workspace Manager)

revoking from a grantee (SQL Reference)

revoking object (Security Guide)

revoking object privileges (Security Guide)

     [subentry #2] (Security Guide)

revoking system privileges (Security Guide)

roles (Concepts)

     [subentry #2] (Security Guide)

restrictions on (Security Guide)

ROLLBACK_ANY_WORKSPACE (Application Developer's Guide - Workspace Manager)

ROLLBACK_WORKSPACE (Application Developer's Guide - Workspace Manager)

row label (Label Security Administrator's Guide)

rules (Streams Concepts and Administration)

Scheduler (Administrator's Guide)

schema object (Concepts)

     [subentry #2] (Security Guide)

     [subentry #3] (Security Guide)

DML and DDL operations (Security Guide)

granting and revoking (Security Guide)

packages (Security Guide)

procedures (Security Guide)

security (Streams Advanced Queuing User's Guide and Reference)

See also system privileges or object privileges

See also system privileges.

SELECT on object types (Application Developer's Guide - Object-Relational Features)

SELECT_ANY_DICTIONARY (Streams Advanced Queuing User's Guide and Reference)

sequences (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

     [subentry #3] (Administrator's Guide)

SQL Access Advisor (Performance Tuning Guide)

SQL statements permitted (Security Guide)

stored procedure execution (Application Developer's Guide - Fundamentals)

synonyms (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

SYSDBA (2 Day DBA)

system (2 Day DBA)

     [subentry #2] (Concepts)

     [subentry #3] (Security Guide)

     [subentry #4] (Security Guide)

ANY (Security Guide)

CREATE (Security Guide)

DROP ANY TABLE (Security Guide)

granting and revoking (Security Guide)

SELECT ANY DICTIONARY (Security Guide)

SYSTEM and OBJECT (Security Guide)

     [subentry #2] (Security Guide)

system on object types (Application Developer's Guide - Object-Relational Features)

table-level select privileges (Reference)

taking tablespaces offline (Administrator's Guide)

to start up or shut down a database (Concepts)

Topic privileges

granting in JMS (Streams Advanced Queuing User's Guide and Reference)

revoking in JMS (Streams Advanced Queuing User's Guide and Reference)

trigger privileges (Security Guide)

triggers (Application Developer's Guide - Fundamentals)

truncating (Administrator's Guide)

trusted stored program units (Label Security Administrator's Guide)

UNDER ANY TYPE on object types (Application Developer's Guide - Object-Relational Features)

UNDER ANY VIEW on object types (Application Developer's Guide - Object-Relational Features)

UPDATE on object types (Application Developer's Guide - Object-Relational Features)

using a view (Administrator's Guide)

using sequences (Administrator's Guide)

viewing users having Workspace Manager system-level privileges (Application Developer's Guide - Workspace Manager)

views (Administrator's Guide)

     [subentry #2] (Administrator's Guide)

     [subentry #3] (Administrator's Guide)

     [subentry #4] (Security Guide)

creating (Security Guide)

using (Security Guide)

when running SQL*Module application (SQL*Module for Ada Programmer's Guide)

WRITEACROSS (Label Security Administrator's Guide)

     [subentry #2] (Label Security Administrator's Guide)

     [subentry #3] (Label Security Administrator's Guide)

WRITEDOWN (Label Security Administrator's Guide)

     [subentry #2] (Label Security Administrator's Guide)

     [subentry #3] (Label Security Administrator's Guide)

     [subentry #4] (Label Security Administrator's Guide)

WRITEUP (Label Security Administrator's Guide)

     [subentry #2] (Label Security Administrator's Guide)

     [subentry #3] (Label Security Administrator's Guide)

privileges required

to publish change data (Data Warehousing Guide)

privileges, access (XML DB Developer's Guide)

PRIVS function (Label Security Administrator's Guide)

PRKA messages, E.2 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

PRKC messages, E.3 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

PRKD messages, E.4 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

PRKE messages, E.5 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

PRKH messages, E.6 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

PRKI messages, E.7 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

PRKN messages, E.8 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

PRKO messages, E.9 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

PRKP messages, E.10 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

PRKR messages, E.11 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

PRKS messages, E.12 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

PRKU messages, E.13 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

PRKV messages, E.14 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

PRN function

of HTF package (PL/SQL Packages and Types Reference)

PRN procedure

of HTP package (PL/SQL Packages and Types Reference)

Pro*C

embedded SQL with user-defined datatypes (Application Developer's Guide - Object-Relational Features)

object cache (Application Developer's Guide - Object-Relational Features)

Pro*C Precompiler

overview (Concepts)

Pro*C++ Precompiler

overview (Concepts)

Pro*C/C++

associative access (Application Developer's Guide - Object-Relational Features)

converting between Oracle and C types (Application Developer's Guide - Object-Relational Features)

data conversion (Globalization Support Guide)

navigational access (Application Developer's Guide - Object-Relational Features)

NVARCHAR datatype (Globalization Support Guide)

overview of application development (Application Developer's Guide - Fundamentals)

processing SQL statements (Concepts)

user-defined datatypes (Application Developer's Guide - Object-Relational Features)

UVARCHAR datatype (Globalization Support Guide)

VARCHAR datatype (Globalization Support Guide)

Pro*C/C++ Precompiler

Pro*C/C++ precompiler

available LOB functions (Application Developer's Guide - Large Objects)

     [subentry #2] (Application Developer's Guide - Large Objects)

LOB buffering (Application Developer's Guide - Large Objects)

locators (Application Developer's Guide - Large Objects)

modifying internal LOB values (Application Developer's Guide - Large Objects)

opening and closing internal LOBs and external LOBs (BFILEs) (Application Developer's Guide - Large Objects)

providing an allocated input locator pointer (Application Developer's Guide - Large Objects)

reading or examining internal and external LOB values (Application Developer's Guide - Large Objects)

statements for BFILEs (Application Developer's Guide - Large Objects)

statements for temporary LOBs (Application Developer's Guide - Large Objects)

Pro*C/C++ precompiler, 6.3 (Administrator's Reference for UNIX-Based Operating Systems)

Pro*COBOL

how it works (Pro*COBOL Programmer's Guide)

overview of application development (Application Developer's Guide - Fundamentals)

Pro*COBOL Precompiler (Concepts)

Pro*COBOL precompiler

available LOB functions (Application Developer's Guide - Large Objects)

LOB buffering (Application Developer's Guide - Large Objects)

locators (Application Developer's Guide - Large Objects)

modifying internal LOB values (Application Developer's Guide - Large Objects)

providing an allocated input locator (Application Developer's Guide - Large Objects)

reading or examining internal and external LOBs (Application Developer's Guide - Large Objects)

statements for BFILEs (Application Developer's Guide - Large Objects)

temporary LOBs (Application Developer's Guide - Large Objects)

Pro*COBOL precompiler, 6.4 (Administrator's Reference for UNIX-Based Operating Systems)

Pro*FORTRAN demonstration programs, 6.5.1 (Administrator's Reference for UNIX-Based Operating Systems)

Pro*FORTRAN Precompiler (Concepts)

proactive monitoring (Performance Tuning Guide)

PROBE_VERSION procedure (PL/SQL Packages and Types Reference)

problems in current release (Spatial User's Guide and Reference)

geodetic data (Spatial User's Guide and Reference)

procedural database extension, 7.1.5 (Pro*C/C++ Precompiler Programmer's Guide)

procedural elements (Oracle C++ Call Interface Programmer's Guide)

procedural replication (Advanced Replication)

conflicts and (Advanced Replication Management API Reference)

detecting conflicts (Advanced Replication)

generating replication support for (Advanced Replication Management API Reference)

restrictions (Advanced Replication)

     [subentry #2] (Advanced Replication Management API Reference)

serialization of transactions (Advanced Replication Management API Reference)

user-defined types (Advanced Replication Management API Reference)

using (Advanced Replication Management API Reference)

wrapper (Advanced Replication)

procedural security (Security Guide)

PROCEDURE

with CREATE statement (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

     [subentry #3] (PL/SQL User's Guide and Reference)

procedure

COPY_POLICY (Text Reference)

CREATE_INSTANCE (Ultra Search User's Guide)

CREATE_SCHEDULE (Ultra Search User's Guide)

CTX_DDL.ADD_INDEX (Text Reference)

CTX_DDL.REPLACE_INDEX_METADATA (Text Reference)

CTX_OUTPUT.ADD_TRACE (Text Reference)

CTX_OUTPUT.END_QUERY_LOG (Text Reference)

CTX_OUTPUT.GET_TRACE_VALUE (Text Reference)

CTX_OUTPUT.REMOVE_TRACE (Text Reference)

CTX_OUTPUT.RESET_TRACE (Text Reference)

CTX_OUTPUT_LOG_TRACES (Text Reference)

DROP_INSTANCE (Ultra Search User's Guide)

DROP_SCHEDULE (Ultra Search User's Guide)

external

definition (Application Developer's Guide - Fundamentals)

GRANT_ADMIN (Ultra Search User's Guide)

INTERVAL (Ultra Search User's Guide)

IS_ADMIN_READONLY (Ultra Search User's Guide)

REVOKE_ADMIN (Ultra Search User's Guide)

SET_INSTANCE (Ultra Search User's Guide)

SET_SCHEDULE (Ultra Search User's Guide)

UPDATE_CRAWLER_CONFIG (Ultra Search User's Guide)

UPDATE_SCHEDULE (Ultra Search User's Guide)

procedure attribute (Text Reference)

procedure calls, stored (SQLJ Developer's Guide and Reference)

procedure declaration

syntax (PL/SQL User's Guide and Reference)

procedure definitions (SQL*Module for Ada Programmer's Guide)

procedure name (SQL*Module for Ada Programmer's Guide)

PROCEDURE statement

procedures

     [entry #2] (Concepts)

     [entry #3] (Concepts)

     [entry #4] (Concepts)

     [entry #5] (Java Developer's Guide)

     [entry #6] (SQL*Module for Ada Programmer's Guide)

3GL, calling (SQL Reference)

advantages of (Concepts)

attributes (Oracle Call Interface Programmer's Guide)

auditing (Security Guide)

     [subentry #2] (Security Guide)

avoid run-time compilation (SQL Reference)

body (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

called by triggers (Application Developer's Guide - Fundamentals)

calling (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

     [subentry #3] (SQL Reference)

case of generated output code files (SQL*Module for Ada Programmer's Guide)

compile (2 Day DBA)

compile explicitly (SQL Reference)

contrasted with anonymous blocks (Concepts)

contrasted with functions (Concepts)

create (2 Day DBA)

creating (PL/SQL User's Guide and Reference)

     [subentry #2] (PL/SQL User's Guide and Reference)

     [subentry #3] (PL/SQL User's Guide and Reference)

     [subentry #4] (SQL Reference)

     [subentry #5] (SQL Reference)

cursors and (Concepts)

declaration (PL/SQL User's Guide and Reference)

declare section in (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

declaring

as a Java method (SQL Reference)

as C functions (SQL Reference)

definer's rights (Security Guide)

roles disabled (Security Guide)

definition (2 Day DBA)

delete (2 Day DBA)

dependency tracking in (Concepts)

examples of (Security Guide)

     [subentry #2] (Security Guide)

execute (2 Day DBA)

executing (Concepts)

     [subentry #2] (SQL Reference)

external (Administrator's Guide)

     [subentry #2] (Application Developer's Guide - Fundamentals)

     [subentry #3] (SQL Reference)

     [subentry #4] (SQL Reference)

running from remote database (SQL Reference)

external procedures (Concepts)

granting

system privileges for (SQL Reference)

in a module (SQL*Module for Ada Programmer's Guide)

in PL/SQL (PL/SQL User's Guide and Reference)

INVALID status (Concepts)

invalidating local objects dependent on (SQL Reference)

invoker's rights (Security Guide)

roles used (Security Guide)

issuing COMMIT or ROLLBACK statements (SQL Reference)

links to examples (PL/SQL User's Guide and Reference)

location transparency in distributed databases (Administrator's Guide)

modify (2 Day DBA)

name resolution in distributed databases (Administrator's Guide)

naming rules (SQL Reference)

parts (PL/SQL User's Guide and Reference)

prerequisites for compilation of (Concepts)

privileges

create or alter (Security Guide)

executing (Security Guide)

executing in packages (Security Guide)

privileges executed with (SQL Reference)

     [subentry #2] (SQL Reference)

re-creating (SQL Reference)

recompiling (Administrator's Guide)

     [subentry #2] (SQL Reference)

recompiling with ALTER PROCEDURE (PL/SQL User's Guide and Reference)

remote calls (Administrator's Guide)

removing from the database (SQL Reference)

replicating (Advanced Replication)

schema executed in (SQL Reference)

     [subentry #2] (SQL Reference)

security enhanced by (Concepts)

     [subentry #2] (Security Guide)

shared pool (Reference)

shared SQL areas and (Concepts)

specification (PL/SQL User's Guide and Reference)

specifying schema and privileges for (SQL Reference)

standalone (SQL*Module for Ada Programmer's Guide)

stored (SQL*Module for Ada Programmer's Guide)

stored procedures (Concepts)

     [subentry #2] (Concepts)

     [subentry #3] (Concepts)

synonyms for (SQL Reference)

top-level (SQL*Module for Ada Programmer's Guide)

understanding PL/SQL (PL/SQL User's Guide and Reference)

procedures, overloaded (Label Security Administrator's Guide)

procedures, PL/SQL

registerSchema (XML DB Developer's Guide)

schemaValidate (XML DB Developer's Guide)

setSchemaValidated (XML DB Developer's Guide)

PROCEDURE_FILTER (Text Application Developer's Guide)

PROCEDURE_FILTER object (Text Reference)

process

application level (HTML DB User's Guide)

as a shared component (HTML DB User's Guide)

Cache Management (HTML DB User's Guide)

Data Manipulation (HTML DB User's Guide)

Form Pagination (HTML DB User's Guide)

handle attributes (Oracle Call Interface Programmer's Guide)

implementing background PL/SQL (HTML DB User's Guide)

On Demand (HTML DB User's Guide)

     [subentry #2] (HTML DB User's Guide)

PL/SQL (HTML DB User's Guide)

Report Pagination (HTML DB User's Guide)

Web Services (HTML DB User's Guide)

process affinity to RADs, F.1.7 (Administrator's Reference for UNIX-Based Operating Systems)

process information (HTTP Server Administrator's Guide)

mod_status (HTTP Server Administrator's Guide)

performance monitor (HTTP Server Administrator's Guide)

ps utility (HTTP Server Administrator's Guide)

process monitor (PMON) (Administrator's Guide)

Process Monitor Daemon (OPROCD)

process monitor process (PMON)

cleans up timed-out sessions (Concepts)

     [subentry #2] (Security Guide)

described (Concepts)

parallel DML process recovery (Data Warehousing Guide)

process( ) method (interMedia Reference)

     [entry #2] (interMedia Reference)

channelOrder operator (interMedia Reference)

contentFormat operator (interMedia Reference)

contrast operator (interMedia Reference)

cut operator (interMedia Reference)

fileFormat operator (interMedia Reference)

fixedScale operator (interMedia Reference)

flip operator (interMedia Reference)

gamma operator (interMedia Reference)

inputChannels operator (interMedia Reference)

     [subentry #2] (interMedia Reference)

maxScale operator (interMedia Reference)

mirror operator (interMedia Reference)

operators (interMedia Reference)

page operator (interMedia Reference)

pixelOrder operator (interMedia Reference)

quantize operator (interMedia Reference)

rotate operator (interMedia Reference)

scale operator (interMedia Reference)

scanlineOrder operator (interMedia Reference)

tiled operator (interMedia Reference)

xScale operator (interMedia Reference)

yScale operator (interMedia Reference)

process() (XML C++ API Reference)

     [entry #2] (XML C++ API Reference)

     [entry #3] (XML C++ API Reference)

processAudioCommand( ) method (interMedia Reference)

processCommand( ) method (interMedia Reference)

processCopy( ) method (interMedia Reference)

channelOrder operator (interMedia Reference)

contentFormat operator (interMedia Reference)

contrast operator (interMedia Reference)

cut operator (interMedia Reference)

fileFormat operator (interMedia Reference)

fixedScale (interMedia Reference)

flip (interMedia Reference)

gamma (interMedia Reference)

inputChannels operator (interMedia Reference)

     [subentry #2] (interMedia Reference)

maxScale (interMedia Reference)

mirror (interMedia Reference)

operators (interMedia Reference)

page (interMedia Reference)

pixelOrder operator (interMedia Reference)

quantize (interMedia Reference)

rotate (interMedia Reference)

scale (interMedia Reference)

scanlineOrder operator (interMedia Reference)

tiled (interMedia Reference)

xScale (interMedia Reference)

yScale (interMedia Reference)

processCopy( ) method for BFILEs (interMedia Reference)

processCopy( ) method for BLOBs (interMedia Reference)

processes

     [entry #2] (Concepts)

and memory contention in parallel processing (Data Warehousing Guide)

archiver (ARCn) (Concepts)

     [subentry #2] (Data Guard Concepts and Administration)

background (Concepts)

diagrammed (Concepts)

checkpoint (CKPT) (Concepts)

checkpoints and (Concepts)

CJQ0 (Data Guard Concepts and Administration)

classes of parallel execution (Concepts)

     [subentry #2] (Concepts)

DBSNMP (Data Guard Concepts and Administration)

dedicated server (Concepts)

derived parameter values (Reference)

dispatcher process maximum number (Reference)

distributed transaction resolution (Concepts)

DMON (Data Guard Broker)

job queue (Concepts)

listener (Concepts)

     [subentry #2] (Concepts)

shared servers and (Concepts)

log writer (LGWR) (Concepts)

     [subentry #2] (Data Guard Concepts and Administration)

maximum shared server processes (Reference)

multiple-process Oracle (Concepts)

number of server processes (Reference)

     [subentry #2] (Reference)

     [subentry #3] (Reference)

     [subentry #4] (Reference)

Oracle (Concepts)

Oracle database (Data Guard Broker)

Oracle, definition (Concepts)

parallel execution coordinator (Concepts)

parallel execution servers (Concepts)

preventing switchover (Data Guard Concepts and Administration)

process monitor (PMON) (Concepts)

QMN0 (Data Guard Concepts and Administration)

queue monitor (QMNn) (Concepts)

recoverer (RECO) (Concepts)

recovery (Reference)

scheduling (Performance Tuning Guide)

See also managed recovery process (MRP)

See also server processes

server (Concepts)

dedicated (Concepts)

shared (Concepts)

shared (Concepts)

shadow (Concepts)

shared server (Concepts)

client requests and (Concepts)

SQL Apply architecture (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

structure (Concepts)

system monitor (SMON) (Concepts)

trace files (Reference)

trace files for (Concepts)

user (Concepts)

recovery from failure of (Concepts)

sharing server processes (Concepts)

user processes (Reference)

PROCESSES initialization parameter

     [entry #2] (Advanced Replication)

     [entry #3] (Performance Tuning Guide)

     [entry #4] (Reference)

     [entry #5] (Streams Concepts and Administration)

     [entry #6] (Ultra Search User's Guide)

setting before database creation (Administrator's Guide)

setting with ALTER SYSTEM (SQL Reference)

processing

DDL statements (Concepts)

distributed, definition (Concepts)

DML statements (Concepts)

overview (Concepts)

parallel SQL (Concepts)

     [subentry #2] (Concepts)

queries (Concepts)

processing operators (interMedia Reference)

See also operators

processingInstruction() (XML C++ API Reference)

ProcessingInstructionRef Interface

Dom package (XML C++ API Reference)

getData() (XML C++ API Reference)

getTarget() (XML C++ API Reference)

ProcessingInstructionRef() (XML C++ API Reference)

setData() (XML C++ API Reference)

~ProcessingInstructionRef() (XML C++ API Reference)

ProcessingInstructionRef() (XML C++ API Reference)

processor binding on SMP systems

Processor Interface

getProcessorId() (XML C++ API Reference)

     [subentry #2] (XML C++ API Reference)

process() (XML C++ API Reference)

     [subentry #2] (XML C++ API Reference)

XPath package (XML C++ API Reference)

XPointer package (XML C++ API Reference)

processSourceCommand( ) method (interMedia Reference)

processVideoCommand( ) method (interMedia Reference)

processWithBinXPath() (XML C++ API Reference)

PROCESSXSL function (PL/SQL Packages and Types Reference)

processXSL PL/SQL procedure (XML DB Developer's Guide)

PROCESS_RULES procedure (PL/SQL Packages and Types Reference)

PROC_READY (HTTP Server Administrator's Guide)

Producer class (Oracle C++ Call Interface Programmer's Guide)

methods (Oracle C++ Call Interface Programmer's Guide)

product language selections (Managing Oracle Software Using Oracle Universal Installer and OPatch)

Product User Profile table, 9.1 (SQL*Plus User's Guide and Reference)

Product User Profile table, 9.6.5 (SQL*Plus User's Guide and Reference)

production database

See primary database

production environment (Security Guide)

productivity (Java Developer's Guide)

     [entry #2] (PL/SQL User's Guide and Reference)

products and options

install only as necessary (Security Guide)

PRODUCT_COMPONENT_VERSION view (Administrator's Guide)

     [entry #2] (Reference)

PRODUCT_USER_PROFILE table (Security Guide)

     [entry #2] (Security Guide)

     [entry #3] (Security Guide)

PRODUCT_USER_PROFILE table, 4.1.2 (Administrator's Reference for UNIX-Based Operating Systems)

PROFILE clause

of ALTER USER. See CREATE USER

of CREATE USER (SQL Reference)

profile customization (see customization) (SQLJ Developer's Guide and Reference)

profile option (sqlj -profile) (SQLJ Developer's Guide and Reference)

profile-keys class (SQLJ Developer's Guide and Reference)

     [entry #2] (SQLJ Developer's Guide and Reference)

profiles

     [entry #2] (OLAP DML Reference)

     [entry #3] (Security Guide)

adding resource limits (SQL Reference)

administering (2 Day DBA)

assigning to a user (SQL Reference)

auditors for debugging (SQLJ Developer's Guide and Reference)

binary portability (SQLJ Developer's Guide and Reference)

changing resource limits (SQL Reference)

code layers (SQLJ Developer's Guide and Reference)

creating (SQL Reference)

examples (SQL Reference)

creation during code generation (SQLJ Developer's Guide and Reference)

deassigning from users (SQL Reference)

debug option (SQLJ Developer's Guide and Reference)

disabling resource limits (Security Guide)

dropping (Security Guide)

dropping resource limits (SQL Reference)

enabling resource limits (Security Guide)

functionality at runtime (SQLJ Developer's Guide and Reference)

generated profiles (SQLJ Developer's Guide and Reference)

granting

system privileges for (SQL Reference)

listing (Security Guide)

managing (Security Guide)

modifying, examples (SQL Reference)

more about profiles (SQLJ Developer's Guide and Reference)

overview (SQLJ Developer's Guide and Reference)

password management (Security Guide)

     [subentry #2] (Security Guide)

print option (SQLJ Developer's Guide and Reference)

privileges for dropping (Security Guide)

removing from the database (SQL Reference)

resource limits (Reference)

     [subentry #2] (Reference)

sample profile entry (SQLJ Developer's Guide and Reference)

use of jar files (SQLJ Developer's Guide and Reference)

user, definition (Concepts)

verify option (SQLJ Developer's Guide and Reference)

viewing (Security Guide)

when to use (Concepts)

profiles (sqlnet.ora)

configuring

advanced options (Net Services Administrator's Guide)

default domains (Net Services Administrator's Guide)

default configuration (Net Services Administrator's Guide)

naming methods, specifying (Net Services Administrator's Guide)

routing connection requests (Net Services Administrator's Guide)

PROFILE_ACCESS privilege (Label Security Administrator's Guide)

     [entry #2] (Label Security Administrator's Guide)

PROGRAM command (OLAP DML Reference)

Program Global Area (PGA) (Programmer's Guide to the Oracle Precompilers)

program global area (PGA)

     [entry #2] (Concepts)

components (2 Day DBA)

definition

description (2 Day DBA)

direct path read (Performance Tuning Guide)

direct path write (Performance Tuning Guide)

effect of MAX_ENABLED_ROLES on (Security Guide)

shared server (Concepts)

shared servers (Concepts)

     [subentry #2] (Performance Tuning Guide)

program interface (Concepts)

Oracle side (OPI) (Concepts)

structure of (Concepts)

user side (UPI) (Concepts)

Program Name field in Oracle Net Manager (Net Services Administrator's Guide)

     [entry #2] (Net Services Administrator's Guide)

PROGRAM networking parameter (Net Services Administrator's Guide)

     [entry #2] (Net Services Administrator's Guide)

     [entry #3] (Net Services Reference)

program structure (SQL*Module for Ada Programmer's Guide)

program structure of a SQL*Module application (SQL*Module for Ada Programmer's Guide)

program termination

     [entry #2] (Pro*COBOL Programmer's Guide)

     [entry #3] (Programmer's Guide to the Oracle Precompilers)

program units (Concepts)

     [entry #2] (Concepts)

     [entry #3] (PL/SQL User's Guide and Reference)

prerequisites for compilation of (Concepts)

shared pool and (Concepts)

program units in PL/SQL (Application Developer's Guide - Fundamentals)

programmatic environments

available functions (Application Developer's Guide - Large Objects)

compared (Application Developer's Guide - Large Objects)

for Oracle objects (Application Developer's Guide - Object-Relational Features)

     [subentry #2] (Application Developer's Guide - Object-Relational Features)

programmatic environments for LOBs (Application Developer's Guide - Large Objects)

programmatic interfaces

about (Streams Advanced Queuing User's Guide and Reference)

ANYDATA queues (Streams Advanced Queuing User's Guide and Reference)

AQ XML servlet (Streams Advanced Queuing User's Guide and Reference)

comparison (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

JMS (Streams Advanced Queuing User's Guide and Reference)

OCCI (Streams Advanced Queuing User's Guide and Reference)

OCI (Streams Advanced Queuing User's Guide and Reference)

OCI security (Streams Advanced Queuing User's Guide and Reference)

OO4O (Streams Advanced Queuing User's Guide and Reference)

PL/SQL (Streams Advanced Queuing User's Guide and Reference)

Programmer's Analysis Kit (HP PAK), 8.2.6 (Administrator's Reference for UNIX-Based Operating Systems)

programming guidelines (Pro*COBOL Programmer's Guide)

programming guidelines, 2.3 (Pro*C/C++ Precompiler Programmer's Guide)

programming language support (Pro*COBOL Programmer's Guide)

     [entry #2] (Programmer's Guide to the Oracle Precompilers)

programming languages (Performance Tuning Guide)

programming techniques

collections (HTML DB User's Guide)

database links (HTML DB User's Guide)

implementing Web services (HTML DB User's Guide)

running background PL/SQL (HTML DB User's Guide)

programs

adding program contents to a definition (OLAP DML Reference)

altering (Administrator's Guide)

branching (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

     [subentry #3] (OLAP DML Reference)

branching in (OLAP DML Reference)

branching labels (OLAP DML Reference)

calling (OLAP DML Reference)

case statement (OLAP DML Reference)

comment lines in (OLAP DML Reference)

compiling (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

     [subentry #3] (OLAP DML Reference)

     [subentry #4] (OLAP DML Reference)

     [subentry #5] (OLAP DML Reference)

conditional execution of commands (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

creating (Administrator's Guide)

debugging (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

     [subentry #3] (OLAP DML Reference)

     [subentry #4] (OLAP DML Reference)

     [subentry #5] (OLAP DML Reference)

declaring arguments in (OLAP DML Reference)

defining (OLAP DML Reference)

deleting (OLAP DML Reference)

determining how invoked (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

disabling (Administrator's Guide)

dropping (Administrator's Guide)

enabling (Administrator's Guide)

error handling (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

     [subentry #3] (OLAP DML Reference)

errors in (OLAP DML Reference)

executing (OLAP DML Reference)

finding line causing error (OLAP DML Reference)

halting execution with an error (OLAP DML Reference)

hiding (OLAP DML Reference)

local variable (OLAP DML Reference)

overview (Administrator's Guide)

passing arguments to (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

     [subentry #3] (OLAP DML Reference)

     [subentry #4] (OLAP DML Reference)

performance cost (OLAP DML Reference)

permission (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

     [subentry #3] (OLAP DML Reference)

     [subentry #4] (OLAP DML Reference)

     [subentry #5] (OLAP DML Reference)

     [subentry #6] (OLAP DML Reference)

     [subentry #7] (OLAP DML Reference)

     [subentry #8] (OLAP DML Reference)

     [subentry #9] (OLAP DML Reference)

     [subentry #10] (OLAP DML Reference)

PERMIT_READ (OLAP DML Reference)

PERMIT_WRITE (OLAP DML Reference)

preserving environment (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

preserving status (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

     [subentry #3] (OLAP DML Reference)

     [subentry #4] (OLAP DML Reference)

     [subentry #5] (OLAP DML Reference)

     [subentry #6] (OLAP DML Reference)

repeating commands (OLAP DML Reference)

restoring previous values (OLAP DML Reference)

returning a value (OLAP DML Reference)

running (OLAP DML Reference)

saving compiled code (OLAP DML Reference)

saving current values (OLAP DML Reference)

startup (OLAP DML Reference)

statements for (OLAP DML Reference)

suspending execution (OLAP DML Reference)

terminating execution of (OLAP DML Reference)

testing by running (OLAP DML Reference)

timing execution (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

trigger (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

     [subentry #3] (OLAP DML Reference)

     [subentry #4] (OLAP DML Reference)

     [subentry #5] (OLAP DML Reference)

     [subentry #6] (OLAP DML Reference)

     [subentry #7] (OLAP DML Reference)

     [subentry #8] (OLAP DML Reference)

     [subentry #9] (OLAP DML Reference)

unhiding (OLAP DML Reference)

using (Administrator's Guide)

PROGRAM_ERROR exception (PL/SQL User's Guide and Reference)

PROGRAM_INFO Record Type (PL/SQL Packages and Types Reference)

progress monitoring for advisors (New Features Guide)

progressive relaxation template (Text Reference)

projected coordinates (Spatial User's Guide and Reference)

     [entry #2] (Spatial User's Guide and Reference)

projections (Spatial User's Guide and Reference)

     [entry #2] (Spatial User's Guide and Reference)

MDSYS.SDO_PROJECTIONS_OLD_FORMAT table (Spatial User's Guide and Reference)

MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table (Spatial User's Guide and Reference)

PROJECT_PT function (Spatial User's Guide and Reference)

PROJECT_PT function (Spatial User's Guide and Reference)

prolog, definition (XML Developer's Kit Programmer's Guide)

prompt

PROMPT clause, 12 (SQL*Plus User's Guide and Reference)

PROMPT clause, 5.12.1 (SQL*Plus User's Guide and Reference)

PROMPT command, 12 (SQL*Plus User's Guide and Reference)

PROMPT command, 5.12.1 (SQL*Plus User's Guide and Reference)

prompts for value

propagated (Label Security Administrator's Guide)

PROPAGATEORIGINALEXCEPTION procedure (PL/SQL Packages and Types Reference)

     [entry #2] (PL/SQL Packages and Types Reference)

propagation (Advanced Replication)

altering method (Advanced Replication Management API Reference)

     [subentry #2] (Advanced Replication Management API Reference)

disabling (Advanced Replication Management API Reference)

exceptions in PL/SQL (PL/SQL User's Guide and Reference)

initiating (Advanced Replication)

modes (Advanced Replication)

of changes (Advanced Replication Management API Reference)

parallel (Advanced Replication)

implementing (Advanced Replication)

monitoring (Advanced Replication Management API Reference)

monitoring (Advanced Replication Management API Reference)

tuning (Advanced Replication)

security context of propagator (Advanced Replication)

status of (Advanced Replication Management API Reference)

propagation jobs (Streams Concepts and Administration)

altering (Streams Concepts and Administration)

job queue processes (Streams Concepts and Administration)

managing (Streams Concepts and Administration)

monitoring (Streams Concepts and Administration)

RESTRICTED SESSION (Streams Concepts and Administration)

scheduling (Streams Concepts and Administration)

trace files (Streams Concepts and Administration)

troubleshooting (Streams Concepts and Administration)

job queue processes (Streams Concepts and Administration)

propagations

     [entry #2] (Streams Concepts and Administration)

     [entry #3] (Streams Concepts and Administration)

     [entry #4] (Streams Replication Administrator's Guide)

about (Streams Advanced Queuing User's Guide and Reference)

in JMS (Streams Advanced Queuing User's Guide and Reference)

altering (PL/SQL Packages and Types Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

in JMS (Streams Advanced Queuing User's Guide and Reference)

ANYDATA queues

about (Streams Advanced Queuing User's Guide and Reference)

examples (Streams Advanced Queuing User's Guide and Reference)

examples (Streams Advanced Queuing User's Guide and Reference)

architecture (Streams Concepts and Administration)

BFILE objects (Streams Advanced Queuing User's Guide and Reference)

binary files (Streams Concepts and Administration)

buffered messages (Streams Advanced Queuing User's Guide and Reference)

buffered queues (Streams Concepts and Administration)

creating (PL/SQL Packages and Types Reference)

     [subentry #2] (PL/SQL Packages and Types Reference)

     [subentry #3] (PL/SQL Packages and Types Reference)

     [subentry #4] (PL/SQL Packages and Types Reference)

     [subentry #5] (PL/SQL Packages and Types Reference)

     [subentry #6] (PL/SQL Packages and Types Reference)

     [subentry #7] (Streams Advanced Queuing User's Guide and Reference)

     [subentry #8] (Streams Concepts and Administration)

     [subentry #9] (Streams Replication Administrator's Guide)

database links

creating (Streams Replication Administrator's Guide)

creating (Streams Replication Administrator's Guide)

creating (Streams Replication Administrator's Guide)

creating (Streams Replication Administrator's Guide)

DBMS_PROPAGATION_ADM package (PL/SQL Packages and Types Reference)

debugging (Streams Advanced Queuing User's Guide and Reference)

destination queue (Streams Concepts and Administration)

directed networks (Streams Concepts and Administration)

disabling (Streams Advanced Queuing User's Guide and Reference)

in JMS (Streams Advanced Queuing User's Guide and Reference)

with Messaging Gateway (Streams Advanced Queuing User's Guide and Reference)

dropping (PL/SQL Packages and Types Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

     [subentry #3] (Streams Concepts and Administration)

enabling (Streams Advanced Queuing User's Guide and Reference)

in JMS (Streams Advanced Queuing User's Guide and Reference)

with Messaging Gateway (Streams Advanced Queuing User's Guide and Reference)

ensured delivery (Streams Concepts and Administration)

error handling (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

in JMS (Streams Advanced Queuing User's Guide and Reference)

failures (Streams Advanced Queuing User's Guide and Reference)

features (Streams Advanced Queuing User's Guide and Reference)

inboxes and outboxes (Streams Advanced Queuing User's Guide and Reference)

JMS messages with Messaging Gateway

inbound (Streams Advanced Queuing User's Guide and Reference)

outbound (Streams Advanced Queuing User's Guide and Reference)

job queue processes (Streams Advanced Queuing User's Guide and Reference)

managing (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

     [subentry #3] (Streams Concepts and Administration)

messages with LOBs (Streams Advanced Queuing User's Guide and Reference)

Messaging Gateway

altering subscribers (Streams Advanced Queuing User's Guide and Reference)

configuring for (Streams Advanced Queuing User's Guide and Reference)

monitoring (Streams Advanced Queuing User's Guide and Reference)

resetting with (Streams Advanced Queuing User's Guide and Reference)

schedule, altering (Streams Advanced Queuing User's Guide and Reference)

subscribers, about (Streams Advanced Queuing User's Guide and Reference)

subscribers, creating (Streams Advanced Queuing User's Guide and Reference)

subscribers, removing (Streams Advanced Queuing User's Guide and Reference)

monitoring (Streams Concepts and Administration)

     [subentry #2] (Streams Concepts and Administration)

optimizing (Streams Advanced Queuing User's Guide and Reference)

parameters

destination (Streams Advanced Queuing User's Guide and Reference)

destination_queue (Streams Advanced Queuing User's Guide and Reference)

duration (Streams Advanced Queuing User's Guide and Reference)

latency (Streams Advanced Queuing User's Guide and Reference)

next_time (Streams Advanced Queuing User's Guide and Reference)

start_time (Streams Advanced Queuing User's Guide and Reference)

priority and ordering of messages (Streams Advanced Queuing User's Guide and Reference)

privileges required (Streams Advanced Queuing User's Guide and Reference)

propagation user (PL/SQL Packages and Types Reference)

queue-to-dblink

about (Streams Advanced Queuing User's Guide and Reference)

scheduling (Streams Advanced Queuing User's Guide and Reference)

with RAC (Streams Advanced Queuing User's Guide and Reference)

queue-to-queue

     [subentry #2] (Streams Concepts and Administration)

     [subentry #3] (Streams Concepts and Administration)

     [subentry #4] (Streams Concepts and Administration)

     [subentry #5] (Streams Replication Administrator's Guide)

about (Streams Advanced Queuing User's Guide and Reference)

buffered messages (Streams Advanced Queuing User's Guide and Reference)

Oracle Real Application Clusters (Streams Concepts and Administration)

propagation job (Streams Concepts and Administration)

schedule (Streams Concepts and Administration)

scheduling (Streams Advanced Queuing User's Guide and Reference)

with RAC (Streams Advanced Queuing User's Guide and Reference)

remote consumers

about (Streams Advanced Queuing User's Guide and Reference)

rule sets

removing (Streams Concepts and Administration)

specifying (Streams Concepts and Administration)

rules

     [subentry #2] (Streams Concepts and Administration)

     [subentry #3] (Streams Concepts and Administration)

adding (Streams Concepts and Administration)

defining global (PL/SQL Packages and Types Reference)

defining message (PL/SQL Packages and Types Reference)

defining schema (PL/SQL Packages and Types Reference)

defining subset (PL/SQL Packages and Types Reference)

defining table (PL/SQL Packages and Types Reference)

for LCRs (PL/SQL Packages and Types Reference)

for user messages (PL/SQL Packages and Types Reference)

removing (Streams Concepts and Administration)

schedules

about (Streams Advanced Queuing User's Guide and Reference)

altering (Streams Advanced Queuing User's Guide and Reference)

creating syntax (Streams Advanced Queuing User's Guide and Reference)

creating with Messaging Gateway (Streams Advanced Queuing User's Guide and Reference)

in JMS (Streams Advanced Queuing User's Guide and Reference)

in JMS (Streams Advanced Queuing User's Guide and Reference)

removing with Messaging Gateway (Streams Advanced Queuing User's Guide and Reference)

scheduling

in JMS (Streams Advanced Queuing User's Guide and Reference)

security (Streams Advanced Queuing User's Guide and Reference)

source queue (Streams Concepts and Administration)

starting (PL/SQL Packages and Types Reference)

     [subentry #2] (Streams Concepts and Administration)

statistics (Streams Advanced Queuing User's Guide and Reference)

stopping (PL/SQL Packages and Types Reference)

     [subentry #2] (Streams Concepts and Administration)

third-party support (Streams Advanced Queuing User's Guide and Reference)

TIB/Rendezvous (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

transformations

rule-based (Streams Concepts and Administration)

troubleshooting (Streams Concepts and Administration)

checking queues (Streams Concepts and Administration)

checking status (Streams Concepts and Administration)

security (Streams Concepts and Administration)

tuning (Streams Advanced Queuing User's Guide and Reference)

unscheduling (Streams Advanced Queuing User's Guide and Reference)

in JMS (Streams Advanced Queuing User's Guide and Reference)

using HTTP (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

using HTTP and HTTPS (Streams Advanced Queuing User's Guide and Reference)

WebSphere MQ (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

with Messaging Gateway (Streams Advanced Queuing User's Guide and Reference)

with RAC (Streams Advanced Queuing User's Guide and Reference)

propagator

registering (Advanced Replication Management API Reference)

     [subentry #2] (Advanced Replication Management API Reference)

     [subentry #3] (Advanced Replication Management API Reference)

replication (Advanced Replication)

properties (Data Guard Broker)

     [entry #2] (OLAP DML Reference)

AlternateLocation (Data Guard Broker)

ApplyInstanceTimeout (Data Guard Broker)

ApplyParallel (Data Guard Broker)

configurable (Data Guard Broker)

     [subentry #2] (Data Guard Broker)

copying with an object definition (OLAP DML Reference)

creating for objects (OLAP DML Reference)

database (Data Guard Broker)

DelayMins (Data Guard Broker)

Dependency (Data Guard Broker)

listing for objects (OLAP DML Reference)

LsbyASkipErrorCfgPr (Data Guard Broker)

LsbyDSkipErrorCfgPr (Data Guard Broker)

LsbyMaxSga (Data Guard Broker)

LsbyTxnConsistency (Data Guard Broker)

managing (Data Guard Broker)

monitorable (Data Guard Broker)

obtaining in SQL (OLAP Reference)

PreferredApplyInstance (Data Guard Broker)

setting (Data Guard Broker)

     [subentry #2] (Data Guard Broker)

     [subentry #3] (Data Guard Broker)

in server parameter file (Data Guard Broker)

in server parameter file (Data Guard Broker)

StandbyArchiveLocation (Data Guard Broker)

StatusReport (Data Guard Broker)

properties files

overview (JPublisher User's Guide)

structure and syntax (JPublisher User's Guide)

properties files (translator)

default properties files (SQLJ Developer's Guide and Reference)

overview (SQLJ Developer's Guide and Reference)

setting input file (SQLJ Developer's Guide and Reference)

syntax (SQLJ Developer's Guide and Reference)

properties files, SQLJ DMS (SQLJ Developer's Guide and Reference)

properties, Java, getProperty() (SQLJ Developer's Guide and Reference)

property

CHARSETFORM (Application Developer's Guide - Fundamentals)

CHARSETID (Application Developer's Guide - Fundamentals)

INDICATOR (Application Developer's Guide - Fundamentals)

PROPERTY command (OLAP DML Reference)

event (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

trigger (OLAP DML Reference)

     [subentry #2] (OLAP DML Reference)

Property event (OLAP DML Reference)

property pages

configuring (Data Guard Broker)

database (Data Guard Broker)

PropertyPermission (Java Developer's Guide)

     [entry #2] (Java Developer's Guide)

     [entry #3] (Java Developer's Guide)

props option (properties file) (JPublisher User's Guide)

props option (sqlj -props) (SQLJ Developer's Guide and Reference)

protected resources (HTTP Server Administrator's Guide)

protecting

Web site (HTTP Server Administrator's Guide)

protection modes (Concepts)

after a failover (Data Guard Broker)

     [subentry #2] (Data Guard Broker)

     [subentry #3] (Data Guard Broker)

benefits (Data Guard Broker)

configuration (Data Guard Broker)

downgrading (Data Guard Broker)

maximum availability mode (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

maximum performance mode (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

maximum protection mode (Data Guard Concepts and Administration)

     [subentry #2] (Data Guard Concepts and Administration)

monitoring (Data Guard Concepts and Administration)

of a database

changing in a broker configuration (Data Guard Broker)

redo transport services setup (Data Guard Broker)

See data protection modes

setting for a broker configuration (Data Guard Broker)

updating (Data Guard Broker)

upgrading (Data Guard Broker)

protein sequences (Data Mining Application Developer's Guide)

protocol (interMedia User's Guide)

PROTOCOL (PRO or PROT) attribute (Net Services Administrator's Guide)

protocol address (Net Services Administrator's Guide)

protocol for connections

between database and ASM (New Features Guide)

PROTOCOL networking parameter (Net Services Reference)

     [entry #2] (Net Services Reference)

     [entry #3] (Net Services Reference)

     [entry #4] (Net Services Reference)

     [entry #5] (Net Services Reference)

protocol server (XML DB Developer's Guide)

architecture (XML DB Developer's Guide)

configuration parameters (XML DB Developer's Guide)

event-based logging (XML DB Developer's Guide)

FTP (XML DB Developer's Guide)

configuration parameters (XML DB Developer's Guide)

HTTP (XML DB Developer's Guide)

configuration parameters (XML DB Developer's Guide)

WebDAV (XML DB Developer's Guide)

configuration parameters (XML DB Developer's Guide)

protocol.ora file (Net Services Reference)

     [entry #2] (Net Services Reference)

     [entry #3] (Security Guide)

     [entry #4] (Security Guide)

parameters (Security Guide)

protocols

     [entry #2] (Net Services Reference)

     [entry #3] (Net Services Reference)

configuring addresses (Net Services Reference)

FTP (Net Services Administrator's Guide)

HTTP (Net Services Administrator's Guide)

     [subentry #2] (Net Services Administrator's Guide)

IPC (Net Services Reference)

     [subentry #2] (Net Services Reference)

Named Pipes (Net Services Administrator's Guide)

     [subentry #2] (Net Services Reference)

     [subentry #3] (Net Services Reference)

Oracle support for (Net Services Administrator's Guide)

SDP (Net Services Reference)

TCP/IP (Net Services Administrator's Guide)

     [subentry #2] (Net Services Reference)

TCP/IP with SSL (Net Services Administrator's Guide)

     [subentry #2] (Net Services Reference)

WebDAV (Net Services Administrator's Guide)

protocols, 5.3 (Administrator's Reference for UNIX-Based Operating Systems)

protocols, access to repository resources (XML DB Developer's Guide)

prove_themes attribute (Text Reference)

Provision Workspace Wizard (HTML DB User's Guide)

proxies (Security Guide)

auditing clients of (Security Guide)

proxy authentication and authorization (Security Guide)

proxies, for Web services call-outs from database (JPublisher User's Guide)

     [entry #2] (JPublisher User's Guide)

proximity operator, see NEAR operator

proxy

connect (Enterprise User Administrator's Guide)

     [subentry #2] (Enterprise User Administrator's Guide)

proxy access (Oracle Call Interface Programmer's Guide)

proxy authentication (New Features Guide)

     [entry #2] (Oracle Call Interface Programmer's Guide)

     [entry #3] (Oracle Call Interface Programmer's Guide)

     [entry #4] (Oracle Call Interface Programmer's Guide)

     [entry #5] (Security Guide)

proxy authorization (Security Guide)

proxy clause

of ALTER USER (SQL Reference)

     [subentry #2] (SQL Reference)

     [subentry #3] (SQL Reference)

proxy connections (Oracle C++ Call Interface Programmer's Guide)

using createProxyConnection method (Oracle C++ Call Interface Programmer's Guide)

proxy materialized view administrator

creating (Advanced Replication Management API Reference)

     [subentry #2] (Advanced Replication Management API Reference)

     [subentry #3] (Advanced Replication Management API Reference)

     [subentry #4] (Advanced Replication Management API Reference)

     [subentry #5] (Advanced Replication Management API Reference)

     [subentry #6] (Advanced Replication Management API Reference)

     [subentry #7] (Advanced Replication Management API Reference)

PROXY ONLY option

of BACKUP (Backup and Recovery Advanced User's Guide)

PROXY option

of BACKUP (Backup and Recovery Advanced User's Guide)

proxy server

     [entry #2] (HTTP Server Administrator's Guide)

     [entry #3] (Net Services Administrator's Guide)

     [entry #4] (Ultra Search User's Guide)

defining (HTML DB User's Guide)

PROXY SERVER substitution string (HTML DB User's Guide)

proxy servers

auditing clients (Security Guide)

ProxyRequests (HTTP Server Administrator's Guide)

proxywsdl option (JPublisher User's Guide)

PROXY_USER attribute (Security Guide)

     [entry #2] (Security Guide)

PROXY_USERID attribute (Security Guide)

PROXY_USERS view (Reference)

     [entry #2] (Security Guide)

pruning

partition (Data Warehousing Guide)

partitions (Data Warehousing Guide)

pruning partitions

DATE datatype (Data Warehousing Guide)

EXPLAIN PLAN (Data Warehousing Guide)

indexes (Data Warehousing Guide)

PS procedure

of HTP package (PL/SQL Packages and Types Reference)

ps utility (HTTP Server Administrator's Guide)

PS$ tables (OLAP Application Developer's Guide)

pseudocode

triggers (Concepts)

pseudocolor

checking for (Spatial GeoRaster)

pseudocolor table (Spatial GeoRaster)

pseudocolumn (Programmer's Guide to the Oracle Precompilers)

CURRVAL (Programmer's Guide to the Oracle Precompilers)

LEVEL (Programmer's Guide to the Oracle Precompilers)

NEXTVAL (Programmer's Guide to the Oracle Precompilers)

ROWID (Programmer's Guide to the Oracle Precompilers)

ROWNUM (Programmer's Guide to the Oracle Precompilers)

SYSDATE (Programmer's Guide to the Oracle Precompilers)

UID (Programmer's Guide to the Oracle Precompilers)

USER (Programmer's Guide to the Oracle Precompilers)

pseudocolumns

     [entry #2] (Pro*COBOL Programmer's Guide)

     [entry #3] (SQL Reference)

CHECK constraints prohibit

LEVEL and ROWNUM (Concepts)

COLUMN_VALUE (SQL Reference)

CONNECT_BY_ISCYCLE (SQL Reference)

CONNECT_BY_ISLEAF (SQL Reference)

CURRVAL (PL/SQL User's Guide and Reference)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (SQL Reference)

hierarchical queries (SQL Reference)

LEVEL (PL/SQL User's Guide and Reference)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (SQL Reference)

list of (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

modifying views (Application Developer's Guide - Fundamentals)

     [subentry #2] (Concepts)

NEXTVAL (PL/SQL User's Guide and Reference)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (SQL Reference)

OBJECT_ID (SQL Reference)

     [subentry #2] (SQL Reference)

     [subentry #3] (SQL Reference)

     [subentry #4] (SQL Reference)

     [subentry #5] (SQL Reference)

OBJECT_VALUE (SQL Reference)

ORA_ROWSCN (SQL Reference)

ROWID (Concepts)

     [subentry #2] (PL/SQL User's Guide and Reference)

     [subentry #3] (SQL Reference)

ROWNUM (PL/SQL User's Guide and Reference)

     [subentry #2] (Pro*COBOL Programmer's Guide)

     [subentry #3] (SQL Reference)

uses for (SQL Reference)

SQL (PL/SQL User's Guide and Reference)

UROWID (PL/SQL User's Guide and Reference)

use in PL/SQL (PL/SQL User's Guide and Reference)

USER (Security Guide)

versions queries (SQL Reference)

XMLDATA (SQL Reference)

pseudostructured data

See semistructured data

pseudotype, VARCHAR (Programmer's Guide to the Oracle Precompilers)

PSP application (Text Application Developer's Guide)

     [entry #2] (Text Application Developer's Guide)

PSP. See PL/SQL Server Pages

PSTUBTBL view (Reference)

PT function (Text Reference)

PT operator (Text Reference)

PTX Agent, 8.2.5.2 (Administrator's Reference for UNIX-Based Operating Systems)

PUBLIC (Security Guide)

     [entry #2] (Security Guide)

granting and revoking privileges to (Security Guide)

procedures and (Security Guide)

revoke all unnecessary privileges and roles (Security Guide)

user group (Security Guide)

     [subentry #2] (Security Guide)

     [subentry #3] (Security Guide)

public class name / source name check (SQLJ Developer's Guide and Reference)

PUBLIC clause

of ALTER DATABASE

thread of redo (Reference)

of CREATE OUTLINE (SQL Reference)

of CREATE SYNONYM (SQL Reference)

of DROP DATABASE LINK (SQL Reference)

public database links (Administrator's Guide)

connected user (Administrator's Guide)

dropping (SQL Reference)

fixed user (Administrator's Guide)

public fixed user database links (Administrator's Guide)

public key (HTTP Server Administrator's Guide)

public key infrastructure (Concepts)

     [entry #2] (Security Guide)

Public Key Infrastructure (PKI)

certificate (Advanced Security Administrator's Guide)

certificate authority (Advanced Security Administrator's Guide)

certificate revocation lists (Advanced Security Administrator's Guide)

PKCS #11 hardware devices (Advanced Security Administrator's Guide)

wallet (Advanced Security Administrator's Guide)

public key infrastructure (PKI) (Advanced Security Administrator's Guide)

     [entry #2] (Advanced Security Administrator's Guide)

public objects

packages (PL/SQL User's Guide and Reference)

PUBLIC permissions (Java Developer's Guide)

public synonyms (Administrator's Guide)

     [entry #2] (SQL Reference)

dropping (SQL Reference)

PUBLIC, definition (XML Developer's Kit Programmer's Guide)

public-key cryptography (HTTP Server Administrator's Guide)

public-key encryption (HTTP Server Administrator's Guide)

public/private key pair (HTTP Server Administrator's Guide)

publication

DDL statements (Concepts)

defined (Data Warehousing Guide)

DML statements (Concepts)

logon/logoff events (Concepts)

system events

server errors (Concepts)

startup/shutdown (Concepts)

using triggers (Concepts)

PUBLICSYN view (Reference)

PUBLIC_DEFAULT profile

dropping profiles and (Security Guide)

PUBLIC_DEPENDENCY view (Reference)

PUBLIC_URL_PREFIX substitution string (HTML DB User's Guide)

publish-subscribe (Application Developer's Guide - Fundamentals)

COMPATIBLE parameter (Oracle Call Interface Programmer's Guide)

example (Oracle Call Interface Programmer's Guide)

functions (Oracle Call Interface Programmer's Guide)

handle attributes (Oracle Call Interface Programmer's Guide)

     [subentry #2] (Oracle Call Interface Programmer's Guide)

LDAP registration (Oracle Call Interface Programmer's Guide)

notification callback (Oracle Call Interface Programmer's Guide)

subscription handle (Oracle Call Interface Programmer's Guide)

_SYSTEM_TRIG_ENABLED parameter (Oracle Call Interface Programmer's Guide)

publish-subscribe functions (Oracle Call Interface Programmer's Guide)

publish-subscribe support

event publication (Concepts)

triggers (Concepts)

publish/subscribe (Streams Advanced Queuing User's Guide and Reference)

about (Streams Advanced Queuing User's Guide and Reference)

setting up (Streams Advanced Queuing User's Guide and Reference)

     [subentry #2] (Streams Advanced Queuing User's Guide and Reference)

support in AQ (XML DB Developer's Guide)

publisher

definition (Data Warehousing Guide)

publishers

components associated with (Data Warehousing Guide)

defined (Data Warehousing Guide)

determining the source tables (Data Warehousing Guide)

privileges for reading views (Data Warehousing Guide)

purpose (Data Warehousing Guide)

table partitioning properties and (Data Warehousing Guide)

tasks (Data Warehousing Guide)

publishing

     [entry #2] (Java Developer's Guide)

     [entry #3] (Java Developer's Guide)

     [entry #4] (Java Developer's Guide)

AQ (JPublisher User's Guide)

asynchronous AutoLog mode

step-by-step example (Data Warehousing Guide)

asynchronous HotLog mode

step-by-step example (Data Warehousing Guide)

example (Java Developer's Guide)

     [subentry #2] (Java Developer's Guide)

PL/SQL packages (JPublisher User's Guide)

queue (JPublisher User's Guide)

server-side Java classes (JPublisher User's Guide)

SQL object types (JPublisher User's Guide)

stream (JPublisher User's Guide)

synchronous mode

step-by-step example (Data Warehousing Guide)

topic (JPublisher User's Guide)

publishing change data

preparations for (Data Warehousing Guide)

privileges required (Data Warehousing Guide)

publishing JMS messages

specifying a recipient list (Streams Advanced Queuing User's Guide and Reference)

specifying delivery mode, priority, and time to live (Streams Advanced Queuing User's Guide and Reference)

specifying Topic (Streams Advanced Queuing User's Guide and Reference)

with minimal specification (Streams Advanced Queuing User's Guide and Reference)

PULL_SIMPLE_TABLESPACE procedure (PL/SQL Packages and Types Reference)

PULL_TABLESPACES procedure (PL/SQL Packages and Types Reference)

punctuation, encoding (Globalization Support Guide)

punctuations attribute (Text Reference)

PUPBLD.SQL, 9.1.1 (SQL*Plus User's Guide and Reference)

purchase order example

object types (Concepts)

purchase-order XML document (XML DB Developer's Guide)

     [entry #2] (XML DB Developer's Guide)

purchase-order XML schema (XML DB Developer's Guide)

     [entry #2] (XML DB Developer's Guide)

annotated (XML DB Developer's Guide)

     [subentry #2] (XML DB Developer's Guide)

graphical representation (XML DB Developer's Guide)

revised (XML DB Developer's Guide)

     [subentry #2] (XML DB Developer's Guide)

purge

following notification (Streams Advanced Queuing User's Guide and Reference)

PURGE function (Advanced Replication Management API Reference)

     [entry #2] (Advanced Replication Management API Reference)

PURGE procedure (PL/SQL Packages and Types Reference)

PURGE statement (SQL Quick Reference)

     [entry #2] (SQL Reference)

PURGELDAPCACHE function (PL/SQL Packages and Types Reference)

purges

DBA_REPCATLOG table (Advanced Replication Management API Reference)

deferred transaction queue

     [subentry #2] (Advanced Replication Management API Reference)

master sites (Advanced Replication Management API Reference)

materialized view sites (Advanced Replication Management API Reference)

materialized view sites (Advanced Replication Management API Reference)

monitoring (Advanced Replication Management API Reference)

scheduling continuous (Advanced Replication)

scheduling periodic (Advanced Replication)

PURGE_FILE_GROUP procedure (PL/SQL Packages and Types Reference)

PURGE_LOG procedure (Advanced Replication Management API Reference)

PURGE_LOST_DB_ENTRY procedure

     [entry #2] (PL/SQL Packages and Types Reference)

DBMS_TRANSACTION package (Administrator's Guide)

PURGE_MASTER_LOG procedure (Advanced Replication Management API Reference)

PURGE_MIXED procedure (PL/SQL Packages and Types Reference)

PURGE_MVIEW_FROM_LOG procedure (Advanced Replication Management API Reference)

     [entry #2] (Advanced Replication Management API Reference)

     [entry #3] (Advanced Replication Management API Reference)

     [entry #4] (Advanced Replication Management API Reference)

PURGE_QUEUE_TABLE Procedure (PL/SQL Packages and Types Reference)

PURGE_SESSION Subprogram (PL/SQL Packages and Types Reference)

PURGE_SOURCE_CATALOG procedure (PL/SQL Packages and Types Reference)

PURGE_STATISTICS procedure (Advanced Replication Management API Reference)

     [entry #2] (Advanced Replication Management API Reference)

PURGE_STATS procedure (PL/SQL Packages and Types Reference)

purging

queue tables (Streams Advanced Queuing User's Guide and Reference)

the subscription window (PL/SQL Packages and Types Reference)

purging change tables

automatically (Data Warehousing Guide)

by name (Data Warehousing Guide)

in a named changed set (Data Warehousing Guide)

on the staging database (Data Warehousing Guide)

publishers (Data Warehousing Guide)

subscribers (Data Warehousing Guide)

purging data (Data Warehousing Guide)

purity level (Data Cartridge Developer's Guide)

purity of stored function, definition (Application Developer's Guide - Fundamentals)

purity rules (PL/SQL User's Guide and Reference)

PUSH command (OLAP DML Reference)

     [entry #2] (OLAP DML Reference)

     [entry #3] (OLAP DML Reference)

marking start of series (OLAP DML Reference)

placement (OLAP DML Reference)

using (OLAP DML Reference)

PUSH function (Advanced Replication Management API Reference)

     [entry #2] (Advanced Replication Management API Reference)

pushes

deferred transaction queue

     [subentry #2] (Advanced Replication Management API Reference)

scheduling continuous (Advanced Replication)

scheduling periodic (Advanced Replication)

PUSHLEVEL command (OLAP DML Reference)

nesting (OLAP DML Reference)

placement (OLAP DML Reference)

PUSH_PRED hint (SQL Reference)

PUSH_SUBQ hint (SQL Reference)

PUT (HTTP Server Administrator's Guide)

PUT procedure (PL/SQL Packages and Types Reference)

PUT procedures (PL/SQL Packages and Types Reference)

put() method

for Properties object (JDBC Developer's Guide and Reference)

for type maps (JDBC Developer's Guide and Reference)

     [subentry #2] (JDBC Developer's Guide and Reference)

putBytes() method (JDBC Developer's Guide and Reference)

putChars() method (JDBC Developer's Guide and Reference)

PUTF procedure (PL/SQL Packages and Types Reference)

PUTF_NCHAR procedure (PL/SQL Packages and Types Reference)

putMetadata( ) method (interMedia Reference)

putMetadata( ) method for BFILEs (interMedia Reference)

putMetadata( ) method for BLOBs (interMedia Reference)

PUT_FILE procedure (PL/SQL Packages and Types Reference)

PUT_LINE

displaying output with (PL/SQL User's Guide and Reference)

PUT_LINE procedure (PL/SQL Packages and Types Reference)

PUT_LINE procedures (PL/SQL Packages and Types Reference)

PUT_LINE_NCHAR procedure (PL/SQL Packages and Types Reference)

PUT_NCHAR procedure (PL/SQL Packages and Types Reference)

PUT_RAW function (PL/SQL Packages and Types Reference)

PX_JOIN_FILTER hint (SQL Reference)

pyramid keyword for storageParam (Spatial GeoRaster)

pyramid levels

definition (Spatial GeoRaster)

pyramidLevel attribute of SDO_GEORASTER (Spatial GeoRaster)

pyramid type (Spatial GeoRaster)

pyramidLevel attribute of SDO_RASTER (Spatial GeoRaster)

pyramidParams parameter (Spatial GeoRaster)

pyramids (Spatial GeoRaster)

deleting data for (Spatial GeoRaster)

formulas for determining (Spatial GeoRaster)

generating data for (Spatial GeoRaster)

illustration of (Spatial GeoRaster)

pyramid parameters (Spatial GeoRaster)

returning level number of top pyramid (Spatial GeoRaster)

P_DISPLAY_NAME (OLAP Reference)

     [entry #2] (OLAP Reference)

p_table_clause (Text Reference)