Index_H

---

H

Hangcheck-timer, 296–98

cmcfg.ora file and, 690

configuration parameters, 297–98

defined, 296

quorum disk requirement, 690

See also Preinstallation

Hard parses, 201–2, 581–85

large number of, 581

number of, obtaining, 582

See also Parses

HASH_AREA_SIZE parameter, 379–80

Hash clusters, 252–54

creating, 252–53

sorted, 253–54

See also Clusters

HASH_JOIN_ENABLED parameter, 379

Hash partitioning, 260–62

defined, 260

mapping hash values, 261

partition pruning, 262

row distribution, 261–62

uses, 260

See also Database partitioning

Heartbeat verification, 635

High availability, 31–34

configuration, 32

defined, 32

freeze, 493

location, 132

mode, 134

PI, 135

role, 134

SCN, 134–35

unfrozen, 496–97

Global service daemon (GSD), 115, 127

defined, 115

starting, 317, 318

GSDCTL utility, 721

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, 656–57

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

GV$FALSE_PING, 359–60

GV$FILE_CACHE_TRANSFER, 361–62

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

redundancy levels, 33, 390

scenario, 391

See also Availability

Hints

defined, 217–18

parallel query using, 217–19

types of, 218

Horizontal scalability, 24, 35

defined, 35

illustrated, 24, 392

See also Scalability

Host-based failover, 142

Hot backup, 461–63

defined, 461

procedure, 461–62

See also Backup(s)

Hyper Messaging Protocol (HMP), 47–48

---