P Q R

Page 237

Data Pump Import utility, 128–134

interactive mode, 118–120

Master Control Process (MCP), 116–117

Oracle Enterprise Manager

administration and maintenance, 222–228

alert log viewer, 230

ANSI support for nested tables and VARRAY columns, 178–181

baselines, 230

changes to installation, 214–216

client tier, 213

communication components, 214

connecting to, 216

Console, 213

Database Control, 214, 215

EM2Go, 229

Grid Control, 215, 227

History, 230

home pages, 218–220

Job Scheduler, 221, 222, 223

middle tier, 213

new features, 217–218

Oracle Data Pump, 230

Oracle Management Service, 213

performance tuning, 225–227

provisioning, 220–221

redesigned architecture, 212–214

related links, 230

server tier, 213

server-generated alerts, 220

Studio Control, 216

Top Sessions, 227

Top SQL Assessment, 227–228

Oracle Internet Directory, 72

Oracle Managed Files, 223

Oracle Management Service, 213

Oracle Streams, enhancements, 200–202

owa_pattern package, 172

P

parallel query, VPD support for, 70

parameters

compatible, 5

for create_program procedure, 28–29

gcs_server_processes, 16

sga_target, 61

partition change tracking, 146–147

partitioning

hash-partitioned global indexes, 157–159

index-organized tables, 156

maintenance, 159

skipping unusable indexes, 160

PCT. See partition change tracking

performance tuning, 225–227

improvements to wait interface, 40–43

PL/SQL

other new packages, 176

regular expressions, 164–172

utl_compress package, 174–175

utl_mail package, 175

PL/SQL compiler, 181–183

compile-time warnings, 184–186

fine-grained debug privileges, 184

natively compiled PL/SQL features, 183–184

Portable Clusterware, 14

See also Real Application Clusters

processes, new, 232

program libraries, 27

provisioning

hardware, 220

software, 220–221

Q

query rewrite

asc keyword, 152–153

dbms_mview.explain_rewrite, 152

dependent Mview refresh and rewrite, 150–152

grouping statements, 153

rewrite_or_error hint, 152

and self-joins, 147–150

using unenforced trusted constraints, 150

quote character assignment, user-specified, 174

R

RAC. See Real Application Clusters

RBAL, 232

Real Application Clusters

Cluster Ready Services (CRS), 15

improvements, 14