Oracle Essentials Oracle Database 11g (73 page)

BOOK: Oracle Essentials Oracle Database 11g
6.54Mb size Format: txt, pdf, ePub

performance tuning

P

basics, 154

read operations, minimizing, 292

pages, 337

persistent beans, 323

parallel bitmap star joins, 21

PGA (Program Global Area), 76, 176

parallel execution (PE) processes (see PE)

private SQL area, 180

Parallel Fail Safe, 27, 272

sort area, 181

parallelization, 20

system resources, 179

block-range, 170

phantom reads, 190

databases, large, 169

physical databases, 33

index scans, 175

physical files, 36, 48

operations available, 172

ping, 216

partition-based, 174

PITR (point-in-time recovery), 280

self-tuning adaptive, 174

PKI (Public Key Infrastructure), 148

subpartitions, 175

PL/SQL

tables and, 175

stored procedures, 10

parity, 263

triggers, 108

parse

PL/SQL expressions, 98

excessive, 183

PL/SQL Function Result Cache in shared

phase, 214

pool area, 51

380

|

Index

PLAN_TABLE, 118

R

PMON (Process Monitor), 53

RAC (see Real Application Clusters)

point-in-time recovery (PITR), 280

RAC Guard, 27, 272

policy, 143

RAD (Rapid Application Development), 30

polymorphism, 321

RAID (Redundant Array of Inexpensive

pools, sizing, 162

Disks)

portals

basics, 163, 262

pages, 337

control files, need for backup, 39

portlets, 337

interactions, 169

Pribyl, Bill, 145

levels, 263

primary keys, 5

most relevant to performance, 163

business relationships, identify, 103

selection, 263

constraints, 105

RAID-S arrays, 166

private SQL areas, 180

range-range partitioning, 236

private synonyms, 99

ranking functions, 233

privileges, 140

Rapid Application Development (RAD), 30

Procedural Gateways, 308

RAW, 86

procedures (see stored procedures)

RAW datatype, 86

Process Monitor (PMON), 53

RDBMS (relational database management

PROCESSES, 38

systems)

processes and threads, 54

Oracle products family, 7

production tests, 118

READ COMMITTED isolation level, 191

Program Global Area (see PGA)

read locks, 188

programming tools, 9

read operations, example, 196

projects

read-only tablespaces, 279

causes of failure, 249

REAL, 85

effective strategy, 251

Real Application Clusters (RAC)

requirements for success, 249

availability, 217, 270

prompt for default security settings, 139

basics, 26, 215, 269

propagation, 219

Cache Fusion support, 216

pseudocolumns, 86

hardware failover, compared to, 269

Public Key Infrastructure (PKI), 148

history, 296

PUBLIC pseudorole, 141

node failure management, 271

public synonyms, 99

parallelism, 170

publish-and-subscribe functionality, Oracle8i

physical distancing of clusters, 282

AQ, 220

recovery phases, 271

publishers, 315

Transparent Application Failover

publishing solutions, 242

(TAF), 272

Real Application Testing Option, 27, 131

Q

realms, 152

QMN (Queue Monitor), 54

Real-Time Decisions (RTD), 235

Query Management Facility, 3

RECO (Recover), 53

query optimization, 109, 120

records, 4

cost-based optimizer, 110

Recover (RECO), 53

decision support queries, 230, 233

recovery, 24

execution path, 109

backups, using, 276

optimizer tool, 5

complete database recovery, 276

ORDER BY conditions, 109

fault-tolerant disk arrays and, 162

parallelizable operations, 173

instance failures, 133

rule-based optimizer, 109

operations, 134

Queue Monitor (QMN), 54

overview, 135

PITR, 280

Index

|

381

recovery
(continued)

Reuter, Andreas, 202

planning, 275

reverse key indexes, 94

preparations, 133

REVOKE command, 142

targeted and rollforward, 276

RFID, 345

testing, 135, 275

RMAN (Recovery Manager)

Recovery Manager (see RMAN)

basics, 24, 278

RECYCLE buffer pool, 50

incremental backups, 278

redo log buffer

options, 134

defined, 51

ROLAP (Relational Online Analytical

size and performance, 178

Processing), 245

redo logs

roles, 141

archives, 45, 48, 162, 284

rollback, 78, 200, 261

checkpoint records, 259

ROLLBACK statements, 187

cold backups and, 276

segments

defined, 42

basics, 78

device assignment, 161

Flashback Query and, 79

fast commits and, 79

undo information, 192

filenames, 44

rollforward, 259

mirroring to remote site, 285

rolling upgrade, 59, 300

multiplexing, 43

round-trip engineering, 30

naming conventions, 45

ROWID pseudocolumn, 86

online, 46

rows, 90

sequence numbers, 44

RSI (Relational Software, Incorporated), 2

suppression of logging, 42

RTD (Real-Time Decisions), 235

threading, 43

RULE mode, 115

Redundant Array of Inexpensive Disks (see

rule-based optimizer, 109

RAID)

rules, 101

REF datatype, 320

Rules Manager, 100

refresh, 200

run queue, 182

relational database management systems (see

runs, 181

RDBMS)

relational databases,
2, 5

S

Relational Online Analytical Processing

SANs (storage area networks), 165

(ROLAP), 245

Schema page, 131

Relational Software, Incorporated (RSI), 2

schemas, 4, 98

relationships, 103

SCN (System Change Number), 78, 192, 280

REMOTE_LISTENER, 38

scripts, database creation, 63

replication, 218, 311

Secure Backup Express (XE), 135

bandwidth and, 286

Secure Enterprise Search, 13

overhead, 288

Secure Keys, 327

reporting functions, 233, 242, 244

security

Reports

administration, 139

basics, 244

advanced options, 28, 148

Server, 336

applications, 146

Services, 339

auditing, 138, 150

request queues, 74

compliance, 151

resource delivery, 299

data access restrictions, 144

resource manager, 185

database features, 27

resource utilization, 184

distributed management, 147

RESTRICTED SESSION, 143

identity management, 141, 338

resumable space allocation, 60, 61

multitiered implementations, 147

RETENTION AREA, 135

Oracle Application Server, 338

382

|

Index

“out of the box” default prompt, 143

shared pool

patching, automated, 138

basics, 51

privileges, 141

size and performance, 177

third-party authentication services, 148

shared servers, 74, 212

user accounts, 147

connection process, 75

view-based, 144

data dictionary information, 76

security “rolling patch,” 138

initialization parameters, 74

security policies, 145

model, 74

Segment Advisor, 125, 158

shared SQL

segments, 41, 132

basics, 211

SELECT

bind variables, 214

basics, 234

SHARED_SERVERS, 38

model clause, 234

SHUTDOWN, 142

security privileges, 141

shutting down, databases, 69

self-managing features, 2

Sigma Dynamics, 235

sequences, 5, 98

SIMPLE_INTEGER, 85

SERIALIZABLE isolation level, 191

single database block I/Os, 160

serialization, 190

single source code model, 8

server, 71

SIP Servlet Container, 17

Server page, 130

sizing the sort area, 181

server processes, 70

SMALLINT, 85

dedicated, 73

SMON (System Monitor), 53

PGA and, 179

SMP (Symmetric Multiprocessing)

service management, 300

systems, 293

service names, 64

CPU quantity and system bus, 294

resolution, 64

defined, 169

(see also naming services)

snowflake schemas, 231

Service Registry

SOA (Service-Oriented Architecture), 323

advertisements, 16

SOA Suite for Middleware, 16, 345, 347

basics, 348

Software and Support page, 131

publishing, 16

software, additional needs, 236

Service Requests (SRs), 137

sort area, sizing, 181

Service-Oriented Architecture (SOA), 323

spatial

session beans, 323

information systems and Oracle, 13

session memory, 76

Spatial Option, 235

SESSIONS, 38

SPFILE, 37

SET ROLE command, using in

backup, 276

applications, 146

system parameter storage, 68

SGA (System Global Area)

spindles, 166

components, 50

SQL (Structured Query Language)

defined, 176

access to and from non-Oracle

memory

databases, 306

allocation, initialization

bad, 182

parameters, 176

basics, 5

components, 48

defined, 10

resources, 176, 179

DML, 77

pools, 51

plan baselines, 117

session data, for storage of, 76

statements

SGA_TARGET, 49

parsing and optimizing, 80

shadow processes, 70

table order and optimization, 110

shared locks, 188

tuning, 120

Index

|

383

SQL Advisor

data

combined functionality, 183

capture, 19

defined, 120

consumption, 19

performance, 124

staging, 19

tuning applications, 157

data divergence, 288

SQL EXPLAIN PLAN statement, 118

data tolerance, 286

SQL Performance Impact Advisor, 124

database administrators, 287

SQL Repair Advisor, 125

direct system dependencies,

SQL Test Case Builder, 138

avoiding, 218

SQL UPDATE, 194

distance between sites, 286

SQL*Analyzer tool, 117

export options, 288

SQL*Loader, direct path load, 240

hub-and-spoke architecture, 219

SQL*Net, configuration, 63

integration problems, 219

SQL*Plus, PL/SQL blocks and, 10

intersystem communication, 218

SQLJ, 322

messaging, 218

SQLNET file, 68

network and site stability, 287

Other books

Finals by Weisz, Alan
Shades of War by Dara Harper
Far Flies the Eagle by Evelyn Anthony
Furnace 5 - Execution by Alexander Gordon Smith
Year of the Unicorn by Andre Norton
The Folks at Fifty-Eight by Clark, Michael Patrick
Double_Your_Pleasure by Desconhecido(a)
Wishing on Willows: A Novel by Ganshert, Katie
The Bloodwater Mysteries: Skullduggery by Hautman, Pete/Logue, Mary