Index_D

---

D

Daemon processes, 662–67

importance, 662

tracing, 663–65

See also RAC diagnostics

Database administration, 327–30

AUM, 327–28

environment variables, 328

instance management, 328–30

schema management, 328

space management, 327

SYSTEM rollback segment, 328

Database block address (DBA), 132

Database buffer cache, 70–73

buffer size, 73

data buffers, 72

defined, 70

illustrated, 71

LRU area, 70

MRU area, 70

tuning, 73

Database configuration, 316–26

cluster, 316–24

parameter file, 324–26

password file, 326

illustrated, 39

as multidrop interconnect, 38

use, 39

See also Interconnects

Computer systems

auditability, 8

availability, 10–13

limitations, 3

manageability and maintainability, 8–9

memory, 3–4

MTTR, 7

portability, 5–6

recoverability, 6–7

reliability, 5

resources, 3

response, 14

scalability, 9–10

securability, 7

storage space, 3–4

Connection(s)

errors during restoration, 419

failover occurrence, 420

pre-establishing, 408–9

retrying, 407–8

Connect-time failover, 406–7

Consistent gets, 580–81

Control file, 75–77, 149

archived log information, 342

defined, 75–76

information, 76

layout, 77

See also Files

Conventional path load, 223–24

Cost-based optimizer (CBO), 107, 108

adjusting behavior of, 597

permutation combinations, 107

Cost-benefit analysis, 442–43

Costing model, 442, 443

CPU

compressed indexes and, 248

deficiencies, 616

Database Configuration Assistant (DBCA), 306–11

client connection selection screen, 309

database creation screen, 310

database identification window, 309

database storage window, 310

defined, 306

launching, 306

operations window, 307, 308

selection screen, 307

template selection screen, 307–8

use steps, 306–11

Database creation, 306–16

with DBCA, 306–11

manual, 311–16

scripts, 731–34

Database design

analysis and, 234

business requirements representation, 236

data warehouse, 277–80

future growth of business representation, 237

hash clusters, 252–54

indexing, 241–52

introduction, 233–35

logical model, 236

partitioning, 254–75

practices, 235–37

for RAC, 233–81

sequence number, 275–77

tablespace management, 237–41

Database partitioning, 255–68

composite, 264–68

data, 257–58

defined, 255

disadvantages, 256

hash, 260–63

illustrated, 256

list, 263–64

partitioned indexes, 268

range, 258–60

See also Partitioning

Database(s)

checkpoint, 478

crash, 485

creating, 454

data export from, 453

data import from, 454

quiescing, 330, 422–23

recovery, 500

recovery catalog, 465

starting, 455

target, 465

Database tuning, 606–15

DB_BLOCK_SIZE, 607–8

DML_LOCKS, 611–12

ENQUEUE_RESOURCES, 612

V$RESOURCE_LIMIT, 612–14

V$ROWCACHE, 614–15

V$SEGMENT_STATISTICS, 608–9

V$SEGSTAT, 610–11

See also Performance tuning

Database writer (DBWR), 72, 84–86

defined, 84–85

process definition, 86

write feature, 85

See also Background processes

Data block address (DBA), 8

Data blocks, 103–7

block header, 104–5

data layer, 105–7

defined, 103

dissection, 103

transferring, 129

See also Data storage

Data definition language (DDL), 166

locks, 178–79

parallel, 221–22

Data dictionary views, 333–34

Data files, 96–99, 148–49

allocated disk space and, 99

checkpoint, 478

DB_NAME parameter, 378

DB_nK_CACHE_SIZE parameter, 377–78

DB_RECOVERY_FILE_DEST parameter, 384–85

DB_RECOVERY_FILE_DEST_SIZE

parameter, 385

DB_RECYCLE_CACHE_SIZE parameter, 379, 594

DB_WAIT_FOR_LOCKS parameter, 385

DB_WRITER_PROCESSES parameter, 379

DBWR_TO_SLAVES parameter, 379

Decision support systems (DSS), 272

Deferred block cleanout, 159–60

Degree of parallelism (DOP), 219, 220–21

application, 220

calculation, 220–21

defined, 220

Device configuration, 290–92

Diagnosability daemon (DIAG) process, 128

Dictionary cache, 614

Dictionary-managed tablespaces (DMT), 92, 237

LMT vs., 237–38

migrating from, 241

Direct path

inserts, 624

read, 624

write, 623

Direct path loads, 224–26

defined, 224

restrictions, 225–26

SQL *Loader option, 224–25

See also Parallel load operations

Disaster tolerance, 34

Discrete transaction management, 174–75

Disk allocation, 59–61

file system, 59–60

raw partitions, 59

tradeoffs, 60–61

Disk configuration, 50–51

defined, 97

dump, 97

header, 98

recovery, 499

Data guard process, 91

Data layer, 105–7

free space, 106

row data, 106–7

row directory, 105

table directory, 105

See also Data blocks

Data Manipulation Language (DML), 62, 166

enqueues, lock modes on, 180

locks, 178

parallel, 222–23, 272

statement execution, 223

two-phase commit operation, 172–74

Data partitioning, 257–58

Data segments, 99

Data skew, 230

Data splitting, 230

Data storage, 91–107

data block, 103–7

data file, 96–99

extent management, 102–3

segments, 99–102

tablespace, 91–96

Data warehouses, 277–80

DBA_UNDO_EXTENTS parameter, 603–4

DB_BLOCK_SIZE parameter, 378, 607–8

default, 607

defined, 607

DB_CACHE_ADVICE parameter, 378, 592

DB_CACHE_SIZE parameter, 378, 591–92

DB_FLASHBACK_RETENTION_TARGET

parameter, 384

DB_KEEP_CACHE_SIZE parameter, 378, 593

DB_MULTIBLOCK_READ_COUNT parameter, 378

GV$FALSE_PING, 359–60

GV$FILE_CACHE_TRANSFER, 361–62, 656–57

GV$GC_ELEMENT, 363–64

GV$GC_ELEMENTS_WITH_COLLISIONS, 364

GV$GCSHVMASTER_INFO, 362

GV$GCSPFMASTER_INFO, 362–63

GV$GES_BLOCKING_ENQUEUE, 364–65

GV$GES_CONVERT_LOCAL, 365–66

GV$GES_CONVERT_REMOTE, 366–67

GV$GES_ENQUEUE, 367–68

GV$GES_RESOURCE, 369

GV$GES_STATISTICS, 369

GV$HVMASTER_INFO, 369–70

GV$LOCK_ACTIVITY, 658–59

GV$MTTR_TARGET_ADVICE, 370–71

GV$PGASTAT, 371

GV$PGA_TARGET_ADVICE, 371–72

GV$SEGMENT_STATISTICS, 373

GV$SESSION_LONGOPS, 598

GV$SESSION_WAIT, 373–74

GV$SESSTAT, 374–75

GV$SHARED_POOL_ADVICE, 375–76

GV$SYSSTAT, 376

GV$SYSTEM_EVENT, 376–77

on stand-alone configuration, 335, 389

V$BUFFER_POOL, 594

V$DB_CACHE_ADVICE, 592–93

V$INSTANCE_RECOVERY, 600–601

V$LIBRARYCACHE, 590–91

V$LIBRARY_CACHE_MEMORY, 590

V$MTTR_TARGET_ADVICE, 601–2

V$PGASTAT, 595

V$PGA_TARGET_ADVICE, 595–96

V$RESOURCE_LIMIT, 612–14

V$ROLLNAME, 604

V$ROWCACHE, 614–15

V$SEGMENT_STATISTICS, 608–9

V$SEGSTAT, 610–11

V$SGA_DYNAMIC_COMPONENTS, 594

Disk I/O

activity, 620, 621

buffer busy wait, 624–25

cache buffer chains, 626

cache buffer LRU chain, 626

direct I/O enabled, 624

direct path inserts, 624

direct path write, 623

latch free, 625

log file sync, 623

monitoring, 619–20

shared pool, 625–26

Disk I/O analysis, 619–26

from operating system, 619–21

from Oracle, 621–26

Dispatcher process, 90

Distributed lock manager (DLM), 613

DML_LOCKS parameter, 611–12

Domain Name Service (DNS), 31

Downtime, acceptable measurement, 12

Drop partition, 274–75

Dynamic views, 335, 336–77

defined, 336

dynamic nature, 335

GV$ACTIVE_INSTANCES, 338

GV$ARCHIVE, 338–39

GV$ARCHIVE_DEST, 339–42

GV$ARCHIVED_LOG, 342–45

GV$ARCHIVE_PROCESSES, 345–46

GV$BGPROCESS, 346

GV$BH, 346–48, 652

GV$CACHE, 350–51

GV$CACHE_LOCK, 351–53, 652

GV$CACHE_TRANSFER, 353–55, 652–53, 654

GV$CR_BLOCK_SERVER, 348–49

GV$DB_CACHE_ADVICE, 355–56

GV$DB_OBJECT_CACHE, 356–57

GV$ENQUEUE_LOCK, 357–58

GV$ENQUEUE_STAT, 358

GV$EVENT_NAME, 358–59

V$SHARED_POOL_ADVICE, 588–89

V$SQL_PLAN_STATISTICS, 585

V$STATISTICS_LEVEL, 578

V$UNDOSTAT, 602–3

See also Views

---