Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)

P

P1 RAW parameter, 163 ‚ 166, 175

Parallel Cache Management (PCM), 217 ‚ 221

parent latches, 144, 145

parsing, 153 ‚ 156

partitioning, repository snapshots, 243

past image (PI) buffer class, 228

patch numbers , Oracle9 i Database, 44

PCM (Parallel Cache Management), 217 ‚ 221

PCTFREE, 166, 189 ‚ 190

PE enqueue, 235

Performance page, Oracle EM Database Control, 267 ‚ 270

PGA (Program Global Area), 120, 285 ‚ 286

physiological logging, 198

PI (past image) buffer class, 228

pings , 220 ‚ 221

PL/SQL code, 86 ‚ 101

data source for, 87 ‚ 88

events to monitor, 92 ‚ 100

library cache pin events and, 61

overview of, 86 ‚ 87

pros and cons of, 100 ‚ 101

repositories, 90 ‚ 92

sampling frequency for, 88 ‚ 90

placeholder events, 230

Preserved Snapshot Sets

creating and dropping, 250 ‚ 251

EM managing, 244 ‚ 247

overview of, 244

primary key enforcement, 181

process events, 285

process trace events, 278 ‚ 279

PROCESSES parameter, 204

processstate dumps, 313

Program Global Area (PGA), 120, 285 ‚ 286