---

H

handle

user, STU 25-23

handle attributes, OCI 2-12

reading, OCI 2-12

setting, OCI 2-12

handle functions, OCI 15-27

Handler Name option, NET 7-7

handler, exception, PLS 6-2

HANDLER_NAME parameter, NET 7-7

handles, OCI 2-6

advantages of, OCI 2-8

allocating, OCI 2-7, OCI 2-22

bind handle, OCI 2-10

C datatypes, OCI 2-6

child freed when parent freed, OCI 2-7

define handle, OCI 2-10

describe handle, OCI 2-11

direct path, OCI 2-12

environment handle, OCI 2-8

error handle, OCI 2-9

freeing, OCI 2-7

hierarchy of, OCI 2-8

process, OCI 2-12

process attributes, OCI A-49

server handle, OCI 2-9

service context handle, OCI 2-9

statement handle, OCI 2-10

subscription, OCI 2-11, OCI 9-31

transaction handle, OCI 2-9

types, OCI 2-6

user session handle, OCI 2-9

handles for SQL statements, SCN 1-17, SCN 7-9

handling exceptions, PLS 6-1

raised in declaration, PLS 6-16

raised in handler, PLS 6-17

using OTHERS handler, PLS 6-15

handling of nulls, PLS 2-48

handshake, SSL, OAS 9-7

hardware

architecture, SPS 3-1

evaluating, SAD 1-18

requirements, SPS 3-3

scalability, SPS 2-2

hardware failures, SBR 1-12

hardware requirements, PSC 2-2

hash

distribution value, STU 13-8

used by the Biometric Authentication Adapter, OAS 7-3

used in the Biometric Authentication Service, OAS 7-2

hash area, STU 2-11, STU 27-3

hash cluster, SPS 17-7

free lists, SPS 11-12, SPS A-20

hash cluster, single-table-only, GTK 2-26

hash clusters, SCN 1-29, SCN 10-50

allocation of space for, SCN 10-55

altering, SAD 18-8

choosing key, ADG 6 - 20, SAD 18-6

clusters, SAD 18-1

collision resolution, SCN 10-53

contrasted with index, SCN 10-51

controlling space use of, SAD 18-6

creating, ADG 6 - 20, SAD 18-4, SQL 7-239

dropping, ADG 6 - 21, SAD 18-9

estimating storage, SAD 18-4

example, SAD 18-7

managing, SAD 18-1

overview of, SCN 1-29

root block, ADG 6 - 20

root blocks, SCN 10-55

scans of, SCN 23-35, SCN 23-39, SCN 23-41

single-table hash clusters, SCN 10-57

single-table, creating, SQL 7-239

specifying hash function for, SQL 7-239

storage of, SCN 10-51

usage, SAD 18-2

when to use, ADG 6 - 20

HASH hint, SQL 2-59, STU 7-44

HASH IS clause

of CREATE CLUSTER, SQL 7-239

hash join, SCN 24-7, STU 26-22, STU 27-3

HASH_AREA_SIZE parameter, SCN 24-8

HASH_MULTIBLOCK_IO_COUNT parameter, SCN 24-8

index join, SCN 23-36, SCN 23-49

hash partition

adding, SQL 7-149

hash partitioning, GTK 2-46, STU 13-14, STU 26-46

examples of, STU 13-15

hash partitioning clause

of CREATE TABLE, SQL 7-364, SQL 7-377

HASH_AJ hint, SCN 24-13, SQL 2-59, STU 7-44, STU 7-55, STU 7-56

HASH_AREA_SIZE parameter, SCN 24-8, SRF 1-47, STU 7-21, STU 26-21

and parallel execution, STU 26-21

example, STU 27-7

of ALTER SESSION, SQL 7-82

relationship to memory, STU 27-7

HASH_JOIN_ENABLED parameter, SCN 24-7, SRF 1-47, STU 7-22

of ALTER SESSION, SQL 7-83

HASH_MULTIBLOCK_IO_COUNT parameter, SCN 24-8, SRF 1-48, STU 7-22, STU 26-29

of ALTER SESSION, SQL 7-83

of ALTER SYSTEM, SQL 7-102

HASH_SJ hint, SCN 24-13, SQL 2-59, STU 7-44, STU 7-49, STU 7-56

hashed locks, PSC 1-18

fixed, PSC 1-18

releasable, PSC 1-18

when to use, PSC 1-19

hashed partitions

performance considerations, STU 26-48

hashed PCM lock, SPS 9-4, SPS 9-17, SPS 9-21, SPS 9-22

creation, SPS 9-3

introduction, SPS 7-5

releasable, SPS 9-4, SPS 15-7, SPS 15-9

specifying, SPS 15-8

hashing, STU 6-25

static, lock mastering scheme, SPS 8-9

HASHKEYS clause

of CREATE CLUSTER, SQL 7-239

HASHKEYS parameter, SCN 10-53, SCN 10-57

CREATE CLUSTER statement, STU 6-26

HAVING condition

of GROUP BY clause, SQL 7-550

header

rollback segment, SPS 14-7

segment, SPS 11-14, SPS 14-7

HEADER precompiler option, PC_ 5-36, PC_ 10-23

headers

of data blocks, SCN 4-4

of row pieces, SCN 10-5

HEADERS, optional, PCO A-3

heap, PCO 8-38

definition of, PC_ 9-37

heap memory

allocating cursor variables, PCO 6-33

heap tables, PCO 4-36

heap-organized tables

creating, SQL 7-365

HELP

Export parameter, SUT 1-20

Import parameter, SUT 2-24

help

Export, SUT 1-11

Field Help, LEG 1-14

How Do I Help, LEG 1-14

Import, SUT 2-9

UNIX, LEG 1-12

UNIX online manual pages, LEG 1-12

What Is This Help, LEG 1-14

Windows Command Line Utilities, LSM, LEG 1-14

Windows NT online help, LEG 1-13

HELP command

of LSNRCTL, reference, NET A-7

of NAMESCTL, reference, NET A-40

heterogeneous distributed databases, SCN 33-8

Heterogeneous Services, SCN 33-8

agents, DDS 5-5, SCN 33-9

compatibility, MIG 8-45

interoperability, MIG 8-45

multithreaded, MIG 8-45

application development issues, DDS 7-1

concepts, DDS 5-1

configuring to connect, NET 7-67

described, NET 7-67

overview, DDS 1-8

process architecture, DDS 5-5

heterogeneous services

agent self-registration, GTK 2-67

agent shared library, GTK 2-67

fixed views, GTK 2-67

multi-threaded service agent, GTK 2-67

Heterogeneous Services Parameters, SRF 1-11

hexadecimal strings

as part of a field comparison, SUT 5-15

SQL*Loader, SUT 5-46

hexadecimal value

returning, SQL 2-38

HEXTORAW function, ADG 4 - 25, SCN 12-23, SQL 2-32, SQL 4-17

HFILE OTT parameter, OCI 14-26, PC_ 19-29

HH date format element, SQL 2-41

HH12 date format element, SQL 2-41

HH24 date format element, SQL 2-41

HI_SHARED_MEMORY_ADDRESS parameter, SCN 7-13, SRF 1-49

hidden declaration, PLS 8-3

hiding PL/SQL code, ADG 10 - 27

hiding, information, PLS 1-15

hierarchical naming model

described, NET 2-38

diagram, NET 2-38

hierarchical queries, SQL 2-53, SQL 5-19, SQL 7-548

child nodes of, SQL 2-53

child rows of, SQL 5-19

illustrated, SQL 2-54

leaf nodes of, SQL 2-53

parent nodes of, SQL 2-53

parent rows of, SQL 5-19

hierarchical query clause

of SELECT and subqueries, SQL 7-543

hierarchies, SCN 1-29, SCN 10-18, STU 30-2

adding to a dimension, SQL 7-26

dropping from a dimension, SQL 7-26

join key, SCN 1-29, SCN 10-19

levels, SCN 1-29, SCN 10-18

multiple, STU 30-6

of dimensions, defining, SQL 7-261

rolling up and drilling down, STU 30-2

HIERARCHY clause

of ALTER DIMENSION, SQL 7-24

of CREATE DIMENSION, SQL 7-261

high availability

benefit of parallel databases, SPS 1-14

high security threshold, OAS 7-3

high speed interconnect, SPS 12-1

high water mark, SPS 11-17

definition, SPS 11-3, SPS 11-18

direct-load INSERT, SCN 25-3

for a session, SAD 23-3

moving, SPS 11-18, SPS 11-19

of clusters, SQL 7-5

of indexes, SQL 7-34

of tables, SQL 7-141, SQL 7-188

HIGH_VALUE statistics, SCN 23-52

high-speed bus, SPS 3-5, SPS 3-6

hint, NOCOPY, PLS 7-17

hint, optimizer, PCO D-5

hints, DDS 4-7, SQL 5-18, STU 7-36

access methods, STU 7-41

ALL_ROWS, STU 7-38

AND_EQUAL, STU 6-7, STU 7-49

as used in outlines, STU 7-26

CACHE, STU 7-63

cannot override sample access path, SCN 23-50

CLUSTER, STU 7-43

COST, PC_ C-5

degree of parallelism, STU 7-57

driving_site, DDS 4-8

extensible optimization, SCN 22-16

FIRST_ROWS, SRF 1-89, STU 7-39

for the ORACLE SQL statement optimizer, PC_ 6-16

FULL, STU 6-7, STU 7-42

HASH, STU 7-44

HASH_AJ, STU 7-44, STU 7-49, STU 7-55

HASH_SJ, STU 7-56

how to use, STU 7-36

in DELETE statements, PC_ F-46, PCO F-34

in SELECT statements, PC_ F-107, PCO F-82

in SQL statements, SQL 2-58

in UPDATE statements, PC_ F-115, PCO F-88

INDEX, SCN 24-15, STU 6-7, STU 7-44, STU 7-52

INDEX_ASC, STU 7-46

INDEX_DESC, STU 7-46, STU 7-47

INDEX_FFS, SCN 23-36, STU 7-48

INDEX_JOIN, SCN 23-36

join operations, STU 7-52

MERGE, SCN 23-17

MERGE_AJ, STU 7-49, STU 7-55

MERGE_AJ and HASH_AJ, SCN 24-13

MERGE_SJ, STU 7-56

MERGE_SJ and HASH_SJ, SCN 24-13

NO_MERGE, STU 7-65

no_merge, DDS 4-8

NOCACHE, STU 7-64

NOPARALLEL hint, STU 7-58

optimization approach and goal, STU 7-38

ORDERED, SCN 24-9, SCN 24-15, STU 7-51, STU 7-52

overriding optimizer choice, SCN 23-50

overriding OPTIMIZER_MODE and OPTIMIZER_GOAL, SCN 23-33

PARALLEL, SCN 26-17

PARALLEL hint, STU 7-57

parallel query option, STU 7-57

PARALLEL_INDEX, SCN 26-17

passing to the optimizer, SQL 7-585

PQ_DISTRIBUTE, STU 7-58

PUSH_JOIN_PRED, SCN 24-12

PUSH_SUBQ, STU 7-66

query rewrite, STU 31-4, STU 31-21

ROWID, STU 7-43

RULE, SRF 1-88, SRF 1-89, STU 7-41

STAR, SCN 24-15, STU 7-52

syntax, SQL 2-59

USE_CONCAT, STU 7-50

USE_HASH, SCN 24-7

USE_MERGE, STU 7-54

USE_NL, STU 7-53

histogram

creating, STU 7-5

number of buckets, STU 7-6

viewing, STU 7-6

histograms, SCN 22-8

historical database

maintenance operations, SCN 11-48

partitions, SCN 11-6

historical table

moving time window in, SAD 13-20

history, archive, SPS 21-6, SPS 22-9

hold time

changing, DDS 3-32

HOLD_CURSOR, STU 19-10

precompiler option

used to improved performance, PC_ C-12

what it affects, PC_ C-7

HOLD_CURSOR option

of ORACLE Precompilers, PC_ F-18, PCO F-15

using to improve performance, PCO D-11

what it affects, PCO D-7

HOLD_CURSOR precompiler option, PC_ 10-23, PCO 14-23

horizontal partitioning, SPS 2-12

host array

bulk binds, PLS 4-36

host arrays

advantages of, PC_ 8-2

declaring, PC_ 8-2

dimensioning, PC_ 8-2

in the DELETE statement, PC_ 8-13

in the INSERT statement, PC_ 8-11

in the SELECT statement, PC_ 8-5

in the UPDATE statement, PC_ 8-12

in the WHERE clause, PC_ 8-16

matching sizes of, PC_ 8-3

maximum size of, PC_ 8-2

referencing, PC_ 8-2, PC_ 8-3

restrictions on, PC_ 8-4, PC_ 8-10, PC_ 8-12, PC_ 8-13, PC_ 8-14

used as input host variables, PC_ 8-3

used as output host variables, PC_ 8-3

using in dynamic SQL method 4, PC_ 15-37

using in dynamic SQL statements, PC_ 13-29

using the FOR clause with, PC_ 8-14

using to improve performance, PC_ C-3

when not allowed, PC_ 8-2

HOST command, SPS 18-19

SQL*Plus, SAD 6-13

host command (RMAN), SBR 11-74

host language, PCO 2-4

definition of, PC_ 2-2, PC_ 2-3

host naming

advantages and disadvantages, NET 3-8

configuring, NET 6-7

connecting with, NET 8-8

described, NET 1-4, NET 6-5

establishing a connection with, NET 3-4, NET 8-8

recommended for, NET 3-8

requirements, NET 6-7

HOST parameter, NET 6-79

HOST precompiler option, PCO 14-24

host program

definition of, PC_ 2-2

host programs, PCO 2-4

host structures

arrays in, PC_ 4-40

declaring, PC_ 4-39

host table example, PCO 7-10

host tables, PCO 7-2

advantages, PCO 7-2

declaring, PCO 7-2

dimensioning, PCO 7-3

how to set up, LEG B-1

maximum size, PCO 7-3

multi-dimensional, PCO 7-3

operations on, PCO 2-9

referencing, PCO 7-3

restrictions, PCO 7-3, PCO 7-9, PCO 7-13, PCO 7-14, PCO 7-15

restrictions on, PCO 7-5

support for, PCO 4-22

testing with ping, LEG B-3

using in dynamic SQL statements, PCO 9-29

using in the DELETE statement, PCO 7-15

using in the INSERT statement, PCO 7-12

using in the SELECT statement, PCO 7-6

using in the UPDATE statement, PCO 7-13

using in the WHERE clause, PCO 7-18

using the FOR clause, PCO 7-16

using to improve performance, PCO D-3

variable-length, PCO 7-3

host variable, PLS 5-16

host variables, PC_ 6-2, PCO 5-2

assigning a value, PCO 2-7

assigning values to, PC_ 2-6

declarations, PC_ 18-4

declaring, PC_ 2-11, PC_ 18-4, PCO 2-11, PCO 2-20, PCO 4-17

declaring and naming, PCO B-2

definition, PCO 2-16

definition of, PC_ 2-6

dummy, PC_ 13-3

host variable equivalencing, PC_ F-116, PCO F-89

in EXECUTE statement, PC_ F-54, PCO F-41

in OPEN statement, PC_ F-93, PCO F-69

in user exits, PC_ 20-4

initializing, PCO 4-22

input versus output, PC_ 6-2

length up to 30 characters, PCO 2-8

must resolve to an address, PC_ 4-16

naming, PCO 2-8, PCO 4-23, PCO 4-25

overview, PCO 2-7

overview of, PC_ 2-6

purpose of, PC_ 6-2

referencing, PCO 2-8, PCO 4-23

requirements, PCO 2-7

requirements for, PC_ 2-6

restrictions, PCO 2-16, PCO 4-25

restrictions on, PC_ 4-16

rules for naming, PC_ 2-14

using in EXEC TOOLS statements, PCO 12-14

using in PL/SQL, PC_ 7-7, PCO 6-8

using in user exit, PCO 12-5

where allowed, PC_ 2-6, PCO 2-7

with PL/SQL, PCO 6-2

host, IDLM, SPS 9-8

HOSTNAME value, NET 7-19

hostname, Oracle server, LEG 2-22

HOSTS file, LEG B-9, NET 2-43

HOSTS.EQUIV file, PSC 2-14

hot backup mode

necessary for online O/S backups, SBR 13-7

hot backups

inconsistent whole database backups, SBR 3-4

hot buffers moved to head of LRU statistic, SRF C-11

HP's OpenView, SCN 33-20, DDS 1-20

HS parameter, NET 7-7, NET C-46

HS_ADMIN_ROLE role, SQL 7-503

HS_ALL_CAPS view, SRF 2-165

HS_ALL_DD view, SRF 2-165

HS_ALL_INITS view, SRF 2-166

HS_AUTOREGISTER, DDS 6-17

HS_AUTOREGISTER parameter, SRF 1-49

of ALTER SYSTEM, SQL 7-103

HS_BASE_CAPS view, SRF 2-166

HS_BASE_DD view, SRF 2-166

HS_CLASS_CAPS view, SRF 2-167

HS_CLASS_DD view, SRF 2-167

HS_CLASS_INIT view, SRF 2-168

HS_EXTERNAL_OBJECT_PRIVILEGES view, SRF 2-168

HS_EXTERNAL_OBJECTS data dictionary view, DDS 6-12

HS_EXTERNAL_OBJECTS view, SRF 2-168

HS_EXTERNAL_USER_PRIVILEGES view, SRF 2-169

HS_FDS_CLASS view, SRF 2-169

HS_FDS_INST view, SRF 2-169

HS_INST_CAPS view, SRF 2-170

HS_INST_DD view, SRF 2-170

HS_INST_INIT view, SRF 2-171

HTTPS, OAS 9-7

hybrid configurations

advanced replication, REP 1-12, SCN 34-13

hypertext markup language (HTML), PLS 8-17

hypertext transfer protocol (HTTP), PLS 8-17

hyphenation

of host variable names, PCO 2-16

---