Index_P

P

PAGESIZE system variable, 183

parameters. See predefined resource parameters

parentheses ( ), and operator precedence, 75

partitioned tables, 251–254

passwords

assigning, 224–225

Change Password, 184

pattern matching, defined, 80

performance, optimizing, 241–265

data design tuning, 251–255

materialized views, 254–255

partitioned tables, 251–254

indexes and, 243–251

creating, dropping and maintaining, 247–248

data dictionary index information, 250–251

monitoring, 248–250

types of, 244–247, 244, 246

when to create, 243

memory tuning, 261–263, 261

Oracle’s Tuning Methodology, 242–243

SQL application tuning, 256–261

Explain Plan tool, 257–258, 258

Oracle optimizer, 258–261

Top SQL tool, 256–257, 256–257

personal databases, defined, 330

PFILEs, 261–262

PGA (Program Global Area), 163, 164

physical storage structures, 158, 161

basics of, 160–162

Oracle’s Tuning Methodology and, 242

pinned buffers, 164

predefined resource parameters, 225

PRIMARY KEY constraints, 147–149

primary keys, 5–6

private synonyms, 219

privileges, 227–234

DBA privileges, 228

DCL for handling, 40–41

object privileges, 229–231

roles, 232–234, 232

system privileges, 228–229

processes

defined, 163, 165

process failures, 268

profiles, creating and assigning, 225–226

Program Global Area (PGA), 163, 164

public synonyms, 219