P

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

P1-P3 colummn (V$ACTIVE_SESSION_HISTORY)
P1-P3 columns (V$SESSION_WAIT)
P1RAW column (V$SESSION_WAIT)
P1TEXT column (V$SESSION_WAIT)
P2RAW column (V$SESSION_WAIT)
P2TEXT column (V$SESSION_WAIT)
P3RRAW column (V$SESSION_WAIT)
packages
     DBMS_ADVISOR 2nd 3rd 4th 5th
         cross-checking results 2nd
         functions and procedures 2nd
         implementation scripts 2nd
         sample code listing 2nd
    DBMS_DATAPUMP [See Data Pump]
     DBMS_FILE_TRANSFER
     DBMS_RESOURCE_MANAGER 2nd
     DBMS_SCHEDULER 2nd
     DBMS_SQLTUNE 2nd 3rd 4th 5th
         errors 2nd
         functions and procedures 2nd
         sample code listing 2nd
     DBMS_STREAMS_AUTH 2nd 3rd
     DBMS_WORKLOAD_REPOSITORY 2nd
         creating snapshots 2nd
         deleting snapshots
         modifying AWR settings 2nd
     e DBMS_ADVISOR 2nd
partitioning
     application partitioning
     object partitioning
Patch Cache 2nd 3rd
patch mangement
patch sets
     applying 2nd
     obtaining 2nd
patch sets, applying 2nd
     logical databases 2nd 3rd 4th 5th 6th
     physical databases 2nd 3rd 4th 5th
patches
     Patch Cache 2nd 3rd
patching
     databases 2nd
     logical databases 2nd 3rd 4th 5th 6th
     physical databases 2nd 3rd 4th 5th
PENDING OFFLINE mode (tablespaces)
Perform Recovery screen (OEM)
performance
     computing grid
performance analysts
performance management
     ASH (Active Session History)
         buffer contents, dumping 2nd 3rd
         documentation
         fixed-size circular buffers 2nd
         hidden parameters
         limitations 2nd
         OEM Database Control 2nd
         session-state information 2nd 3rd 4th 5th 6th
         spot analysis example 2nd 3rd 4th 5th
         V$ACTIVE_SESSION_HISTORY 2nd 3rd
         V$ACTIVE_WAIT_HISTORY
         V$SESSION_WAIT 2nd
         WRH$_ACTIVE_SESSION_HISTORY 2nd
     AWR (Automatic Workload Repository) 2nd 3rd
         baselines 2nd 3rd 4th 5th 6th 7th
         buffers
         collections 2nd 3rd
         compared to STATSPACK 2nd
         customizing with OEM 2nd
         DBMS_WORKLOAD_REPOSITORY package 2nd 3rd 4th 5th 6th 7th
         dependencies 2nd 3rd
         emergency purging
         licensing information
         memory requirements
         new features 2nd
         overheads
         snapshots 2nd 3rd 4th 5th 6th
         storage and reporting 2nd 3rd 4th 5th
         suggested settings 2nd
         views 2nd 3rd
         WRH$ tables
         WRI$ tables
         WRM$ tables
performance tuning
     EXPLAIN PLAN command
     individual session tuning
     new features 2nd
     OEM (Oracle Enterprise Manager) 2nd 3rd
         advisors 2nd
         alerts 2nd
         configuration changes
         metrics 2nd
         OEM Database Control 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th
     Oracle Wait Interface 2nd 3rd 4th
     performance analysts
     RMAN (Recovery Manager) 2nd
     SQL Access Advisor 2nd 3rd
         APIs 2nd 3rd 4th 5th
         DBMS_ADVISOR package 2nd 3rd 4th 5th
         inputs 2nd
         materialized views
         new features
         OEM interface 2nd 3rd 4th 5th 6th 7th 8th
         potential pitfalls 2nd
         steps for use
     SQL Tuning Advisor 2nd
         access path analysis
         APIs 2nd 3rd 4th 5th 6th 7th
         Automatic Tuning Optimizer 2nd 3rd 4th
         DBMS_SQLTUNE package 2nd 3rd 4th 5th
         inputs 2nd
         OEM interface 2nd 3rd 4th
         potential pitfalls 2nd
         SQL profiling
         SQL structure analysis
         statistics analysis
         STS (SQL tuning sets) 2nd 3rd
     STATSPACK 2nd 3rd 4th 5th 6th
         extending
         limitations of 2nd
         service time 2nd 3rd
         snapshots
         wait time
     Time and Wait model 2nd 3rd 4th 5th 6th 7th
     views 2nd 3rd
         ALL_ views
         DBA_ views
         STATISTICS_LEVEL initialization parameter 2nd
         V$ENQUEUE_STATISTICS 2nd
         V$EVENT_HISTOGRAM 2nd 3rd 4th
         V$EVENTMETRIC
         V$FILE_HISTOGRAM 2nd 3rd 4th
         V$FILEMETRIC
         V$FILEMETRIC_HISTORY
         V$METRIC 2nd
         V$METRIC_HISTORY 2nd
         V$METRICGROUP 2nd
         V$METRICNAME 2nd
         V$OSSTAT 2nd
         V$SERVICE_EVENT 2nd 3rd
         V$SERVICE_STATS 2nd
         V$SERVICE_WAIT_CLASS 2nd
         V$SERVICEMETRIC
         V$SERVICEMETRIC_HISTORY
         V$SERVICES
         V$SESSION 2nd
         V$SQL 2nd
         V$SQLAREA 2nd
         V$SYS_TIME_MODEL 2nd
         V$SYSTEM_WAIT_CLASS 2nd
         V$TEMP_HISTOGRAM
performancing tuning
     ADDM (Automatic Database Diagnostic Monitor) 2nd
         accessing from OEM 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
         Additional Information findings 2nd
         addmrpt.sql script 2nd 3rd 4th
         ASH data 2nd
         cases when ADDM analysis is not done
         cross-verification from advisor views 2nd
         DBMS_ADVISOR package 2nd 3rd 4th
         expected I/O response time
         goal of 2nd
         idle events 2nd 3rd
         new features 2nd
         non-problematic areas 2nd
         problem areas handled by 2nd
         recommendations 2nd 3rd
         rules
         session management 2nd
         SQL statements consuming significant time 2nd 3rd 4th 5th
         SQL statements waiting for locks 2nd
         views 2nd 3rd 4th
PGA (Progam Global Area)
PGA Advisor
physical backups [See backups]
physical databases
     patching 2nd 3rd 4th 5th
PL/SQL
     Segment Advisor, invoking 2nd
platform-independent database installation questions 2nd 3rd 4th 5th
PLSQL_CODE_TYPE initialization parameter
PLSQL_DEBUG initialization parameter
PLSQL_WARNINGS initialization parameter
plus (+) sign
PMON (Process Monitor process)
pools
     Java pool 2nd
     large pool 2nd
     shared pool
     Streams pool
precedence
     Data Pump operations 2nd
PREPARE TO SWITCHOVER command 2nd
PRIMARY_ROLE keyword
procedures [See DBMS_SQLTUNE package;functions and procedures]
Process Monitor process (PMON)
processes 2nd
     background processes
         Archiver processes (ARCn)
         ASMB
         Change Tracking Writer processes (CTWR)
         Checkpoint process (CKPT)
         Database Writer process (DBWn)
         Job Queue processes (Jnnn)
         Log Writer process (LGWR)
         Memory Monitor Light process (MMNL)
         Memory Monitor processes (MMON)
         ORBn
         Process Monitor process (PMON)
         Queue Monitor processes (QMNn)
         RBAL
         Recovery Writer process (RVWR)
         System Monitor process (SMON)
     centralized job control
     definition of
     Oracle processes
     scheduling 2nd
     user processes
profiled resource usage
profiles
     SQL Tuning Advisor
profiles (SQL) 2nd 3rd 4th 5th
     compared to outlines
     tracing 2nd 3rd 4th
Progam Global Area (PGA)
PROGRAM colummn (V$ACTIVE_SESSION_HISTORY)
protocols
     SDP (Sockets Direct Protocol)
provisioning
PURGE command
purging
     recycle bin