H

handle attributes, OCI 2-13

reading, OCI 2-13

setting, OCI 2-13

handle functions, OCI 15-27

handlers, exception, PLS 6-2

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-13

process attributes, OCI A-50

server handle, OCI 2-9

service context handle, OCI 2-9

statement handle, OCI 2-10

subscription, OCI 2-12, OCI 9-33

transaction handle, OCI 2-10

types, OCI 2-6

user session handle, OCI 2-9

handles for SQL statements, SCN 1-15, 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-49

handshake

SSL, OAS 10-6

hardware

evaluating, SAD 1-18

for parallel processing, PSC 2-1

requirements, PSC 3-2

scalability, PSC 8-11

hardware failures, SBR 1-12

hardware requirements, PSG 2-2

hardware-based connection redirection, OID 14-6

hasChildNodes() - oracle.xml.parser.v2.DTD.hasChildNodes(), JPR 4-28

hasChildNodes() - oracle.xml.parser.v2.XMLNode.hasChildNodes(), JPR 4-111

hash

distribution value, STU 5-8

used by the Biometric Authentication Adapter, OAS 8-3

used in the Biometric Authentication Service, OAS 8-2

hash areas, DWG 18-35, STU 2-12

hash cluster

free lists, PSC A-22

hash clusters, PSA 8-5, SCN 1-28, SCN 10-54

advantages and disadvantages, SAD 17-2 to SAD 17-3

allocation of space for, SCN 10-59

altering, SAD 17-9

choosing key, SAD 17-5

collision resolution, SCN 10-57

contrasted with index, SCN 10-55

contrasted with index clusters, SAD 17-2

controlling space use of, SAD 17-5

creating, SAD 17-4, SQL 7-257

dropping, SAD 17-9

estimating storage, SAD 17-8

examples, SAD 17-7

hash function, SAD 17-2, SAD 17-3, SAD 17-4, SAD 17-6

HASH IS option, SAD 17-4, SAD 17-6

HASHKEYS option, SAD 17-4, SAD 17-7

how to use, ADG 5-19 to ADG 5-20

overview of, SCN 1-28

root blocks, SCN 10-59

scans of, STU 4-22, STU 4-36, STU 4-38

single-table, SAD 17-5

single-table hash clusters, SCN 10-61

single-table, creating, SQL 7-257

single-table-only, GTK 3-26

SIZE option, SAD 17-6

specifying hash function for, SQL 7-257

storage of, SCN 10-55

hash functions

for hash cluster, SAD 17-2

HASH hint, SQL 2-65, STU 7-11

HASH IS clause

of CREATE CLUSTER, SQL 7-257

hash join, STU 4-53

HASH_AREA_SIZE parameter, STU 4-54

HASH_MULTIBLOCK_IO_COUNT parameter, STU 4-54

index join, STU 4-24

hash joins, DWG 18-19, DWG 18-35

hash partition

adding, SQL 7-160

hash partitioning, DWG 5-5, GTK 3-46, PSA 5-15, SAD 15-5

hash partitioning clause

of CREATE TABLE, SQL 7-387, SQL 7-402

hash partitions, STU 5-14

examples of, STU 5-14

HASH_AJ hint, SQL 2-65, STU 4-61, STU 7-22, STU 7-23

HASH_AREA_SIZE initialization parameter, SRF 1-43

HASH_AREA_SIZE parameter, DWG 18-39, STU 4-29, STU 4-54

and parallel execution, DWG 18-18, DWG 18-19

of ALTER SESSION, SQL 7-88

relationship to memory, DWG 18-38

HASH_JOIN_ENABLED initialization parameter, SRF 1-44

HASH_JOIN_ENABLED parameter, STU 4-29, STU 4-53

of ALTER SESSION, SQL 7-88

HASH_MULTIBLOCK_IO_COUNT initialization parameter, SRF 1-44

HASH_MULTIBLOCK_IO_COUNT parameter, DWG 18-26, STU 4-30, STU 4-54

of ALTER SESSION, SQL 7-88

of ALTER SYSTEM, SQL 7-111

HASH_SJ hint, SQL 2-65, STU 4-62, STU 7-23

hashed locks

when to use, PSC 5-32

hashed PCM locks, PSC 5-4

hashing, STU 12-26

static, lock mastering scheme, PSC 3-5

HASHKEYS clause

of CREATE CLUSTER, SQL 7-257

HASHKEYS parameter, SCN 10-57, SCN 10-61

CREATE CLUSTER statement, STU 12-27

hasMoreElements() - oracle.jms.AQjmsQueueBrowser.hasMoreElements(), JPR 2-148

HAVING condition

of GROUP BY clause, SQL 7-579

header

blocks, user undo segments, PSA 7-6

rollback segment, PSA 3-6

segment, PSA 3-6

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-25

definition of, PC_ 9-38

heap memory

allocating cursor variables, PCO 6-32

heap tables, PCO 4-32

heap-organized tables

creating, SQL 7-390

helo()

function of UTL_SMTP, SPR 65-5

help

Field Help, LEG 1-14

How Do I Help, LEG 1-14

UNIX, LEG 1-11

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 button, in Oracle Directory Manager, OID 4-12

HELP command

of CMCTL, NET A-82

of LSNRCTL, NET A-7

of NAMESCTL, NET A-36

Help menu item, in Oracle Directory Manager, OID 4-11

HELP parameter

Export, SUT 1-11, SUT 1-21

Import, SUT 2-8, SUT 2-22

heterogeneous distributed systems

accessing, DDS 7-2

definition, DDS 1-5

Heterogeneous Services

agent registration, DDS 7-5

avoiding configuration mismatches, DDS 7-6

disabling, DDS 7-9

enabling, DDS 7-5

agents, DDS 6-3, DDS 6-5, SRF 1-45

compatibility, MIG 9-45

interoperability, MIG 9-45

multithreaded, MIG 9-46

self-registration, DDS 7-7

application development, DDS 9-1, DDS 9-2

controlling array fetches between non-Oracle server and agent, DDS 9-11

controlling array fetches between Oracle server and agent, DDS 9-11

controlling reblocking of array fetches, DDS 9-11

DBMS_HS_PASSTHOUGH package, DDS 9-2

locking behavior of non-Oracle systems, DDS 9-12

pass-through SQL, DDS 9-2

using bulk fetches, DDS 9-9

using OCI for bulk fetches, DDS 9-10

configuring connections to, NET 8-49

creating database links, DDS 7-4

data dictionary, DDS 6-6

classes and instances, DDS 6-7

data dictionary views, DDS 7-9, DDS B-1

types, DDS 7-9

understanding sources, DDS 7-11

using general views, DDS 7-11

using SQL service views, DDS 7-13

using transaction service views, DDS 7-12

database links to non-Oracle systems, DDS 6-2

DBMS_HS package

using to specify initialization parameters, DDS 7-17

using to unspecify initialization parameters, DDS 7-18

defining maximum number of open cursors, DDS A-8

described, NET 8-49

dynamic performance views, DDS 7-15

V$HS_AGENT view, DDS 7-15

V$HS_SESSION view, DDS 7-16

features, DDS 1-6

generic connectivity

architecture, DDS 8-3

creating initialization file, DDS 8-7

datatype mapping, DDS 8-5

definition, DDS 8-2

editing initialization file, DDS 8-7

non-Oracle data dictionary access, DDS C-2

ODBC connectivity requirements, DDS 8-12

OLE DB (FS) connectivity requirements, DDS 8-15

OLE DB (FS) interfaces, DDS 8-16

OLE DB (SQL) connectivity requirements, DDS 8-14

restrictions, DDS 8-5

setting parameters for ODBC source, DDS 8-9

setting parameters for OLE DB source, DDS 8-11

SQL execution, DDS 8-5

supported functions, DDS 8-6

supported SQL syntax, DDS 8-5

supported tables, DDS C-3

types of agents, DDS 8-2

initialization parameters

specifying, DDS 7-17

unspecifying, DDS 7-18

installing data dictionary, DDS 7-2

locking behavior of non-Oracle systems, DDS 9-12

optimizing data transfer, DDS A-9

overview, DDS 1-5, DDS 6-2

parameters, SRF 1-11

process architecture, DDS 6-4, DDS 6-5

setting global name, DDS A-3

setting up access using transparent gateway, DDS 7-2

setting up environment, DDS 7-2

specifying cache high water mark, DDS A-3

specifying cache size, DDS A-9

specifying commit point strength, DDS A-2

specifying domain, DDS A-2

specifying instance identifier, DDS A-3

SQL service, DDS 6-4

testing connections, DDS 7-4

transaction service, DDS 6-3

tuning internal data buffering, DDS A-10

types, DDS 6-3

heterogeneous services, SCN 375

agent self-registration, GTK 3-67

agent shared library, GTK 3-67

fixed views, GTK 3-67

hexadecimal string

passing to DBMS_LOB.WRITE(), ADL 9-202, ADL 10-152

hexadecimal strings

as part of a field comparison, SUT 5-15

SQL*Loader, SUT 5-46

hexadecimal value

returning, SQL 2-43

HEXTORAW function, ADG 3-25, SCN 12-24, SQL 2-37, SQL 4-37

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

HH date format element, SQL 2-46

HH12 date format element, SQL 2-46

HH24 date format element, SQL 2-46

HI_SHARED_MEMORY_ADDRESS initialization parameter, SRF 1-45

HI_SHARED_MEMORY_ADDRESS parameter, SCN 7-14

hidden declarations, PLS 8-3

hiding PL/SQL code, ADG 9-28

hierarchical naming model

described, NET 4-17

diagram, NET 4-17

hierarchical queries, SQL 2-58, SQL 5-20, SQL 7-577

child nodes of, SQL 2-58

child rows of, SQL 5-20

illustrated, SQL 2-59

leaf nodes of, SQL 2-58

parent nodes of, SQL 2-58

parent rows of, SQL 5-20

hierarchical query clause

of SELECT and subqueries, SQL 7-571

hierarchies, DWG 9-3, SCN 1-28, SCN 10-20

adding to a dimension, SQL 7-27

drilling across, DWG 9-5

dropping from a dimension, SQL 7-27

how used, DWG 2-6

join key, SCN 1-28, SCN 10-20

levels, SCN 1-28, SCN 10-20

multiple, DWG 9-8

of dimensions, defining, SQL 7-279

overview, DWG 2-6

rolling up and drilling down, DWG 9-3

HIERARCHY clause

of ALTER DIMENSION, SQL 7-25

of CREATE DIMENSION, SQL 7-279

high availability, GTK 2-2

and multi-master replication, OID 14-7

and the Cluster Manager, PSC 3-3

benefit of parallel databases, PSC 1-3

configurations for, PSC 9-17

configuring, PSG 5-1 to PSG 5-16

definition of, PSC 1-3, PSC 9-2

of Oracle Internet Directory, OID 14-1

primary and secondary instances, PSG 5-6

TAF, PSG 5-2

Transparent Application Failover, PSG 5-2

high security threshold, OAS 8-3

high speed interconnect, PSA 5-3

high water mark, PSC 7-25, SAD 12-15

definition, PSC 7-11, PSC 7-26

direct-load INSERT, SCN 147

for a session, SAD 22-3

moving, PSC 7-26, PSC 7-27

of clusters, SQL 7-5

of indexes, SQL 7-35

of tables, SQL 7-150, SQL 7-203

HIGH_VALUE statistics, STU 4-26

hint, DETERMINISTIC, PLS 7-6

hint, NOCOPY, PLS 7-17

hint, optimizer, PCO D-5

hints, DDS 3-8, SQL 5-19, STU 7-2

access methods, STU 7-9

ALL_ROWS hint, STU 7-6

AND_EQUAL hint, STU 7-16, STU 12-7

as used in outlines, STU 10-3

CACHE hint, STU 7-30

cannot override sample access path, STU 4-25

CHOOSE hint, STU 7-8

CLUSTER hint, STU 7-11

COST, PC_ C-5

degree of parallelism, STU 7-24

DRIVING_SITE, DDS 3-9

extensible optimization, SCN 140, STU 4-33

FIRST_ROWS, SRF 1-86

FIRST_ROWS hint, STU 7-7

for the ORACLE SQL statement optimizer, PC_ 6-16

FULL hint, STU 7-10, STU 12-7

global, STU 7-37

HASH hint, STU 7-11

HASH_AJ hint, STU 7-22

HASH_SJ hint, STU 7-23

how to use, STU 7-2

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

in SELECT statements, PC_ F-106, PCO F-83

in SQL statements, SQL 2-63

in UPDATE statements, PC_ F-114, PCO F-89

INDEX hint, STU 7-12, STU 7-19, STU 12-7

INDEX_ASC hint, STU 7-13

INDEX_DESC hint, STU 7-14, STU 7-15

INDEX_FFS, STU 4-23

INDEX_FFS hint, STU 7-15

INDEX_JOIN, STU 4-24

join operations, STU 7-19

LEADING hint, STU 7-22

MERGE_AJ and HASH_AJ, STU 4-61

MERGE_AJ hint, STU 7-22

MERGE_SJ and HASH_SJ, STU 4-62

MERGE_SJ hint, STU 7-23

NO_EXPAND hint, STU 7-17

NO_INDEX, STU 12-7

NO_INDEX hint, STU 7-15

NO_MERGE, DDS 3-9

NO_MERGE hint, STU 7-32

NO_PUSH_PRED hint, STU 7-34

NO_UNNEST hint, STU 7-33

NOCACHE hint, STU 7-31

NOPARALLEL hint, STU 7-26

NOREWRITE hint, STU 7-18

optimization approach and goal, STU 7-6

ORDERED, STU 4-59

ORDERED hint, STU 7-18

overriding optimizer choice, STU 4-25

overriding OPTIMIZER_MODE and OPTIMIZER_GOAL, STU 4-11

PARALLEL, SCN 173

PARALLEL hint, STU 7-25

parallel query option, STU 7-24

PARALLEL_INDEX, SCN 173

passing to the optimizer, SQL 7-616

PQ_DISTRIBUTE hint, STU 7-26

PUSH_JOIN_PRED, STU 4-87

PUSH_PRED hint, STU 7-34

PUSH_SUBQ hint, STU 7-34

query rewrite, DWG 19-5, DWG 19-28

REWRITE hint, STU 7-17

ROWID hint, STU 7-11

RULE, SRF 1-86

RULE hint, STU 7-8

STAR hint, STU 7-19

syntax, SQL 2-64

UNNEST hint, STU 7-32

USE_CONCAT hint, STU 7-16

USE_HASH, STU 4-53

USE_MERGE hint, STU 7-21

USE_NL hint, STU 7-20

using to tune distributed queries, DDS 3-8

histograms, SCN 131, STU 8-17

creating with user-defined buckets, DWG 17-53

number of buckets, STU 8-19

historical database

maintenance operations, SCN 11-47

partitions, SCN 11-6

historical tables

moving time window, SAD 15-33

history

archive, PSA 13-7, PSA 14-9

Hodges, Jeff, OID 2-34

HOLD_CURSOR

precompiler option

used to improved performance, PC_ C-12

what it affects, PC_ C-7

HOLD_CURSOR clause, STU 19-10

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-22

host arrays

advantages of, PC_ 8-2

bulk binds, PLS 4-41

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

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, PSA 4-6

host command (RMAN), RMN 10-81

host language, PCO 2-4

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

host naming

advantages and disadvantages, NET 5-4

configuring, NET 6-74 to NET 6-78

connecting with, NET 6-78

described, NET 2-36

establishing a connection with, NET 2-37, NET 6-78

listener configuration for, NET 6-75

recommended for, NET 5-4

requirements, NET 6-74

HOST parameter, NET B-4

HOST precompiler option, PCO 14-23

host program

definition of, PC_ 2-2

host programs, PCO 2-4

host structures

arrays in, PC_ 4-41

declaring, PC_ 4-39

host table elements

maximum, PCO 7-3

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

multi-dimensional, PCO 7-3

operations on, PCO 2-9

referencing, PCO 7-4

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

restrictions on, PCO 7-6

support for, PCO 4-19

testing with ping, LEG B-3

using in dynamic SQL statements, PCO 9-29

using in the DELETE statement, PCO 7-14

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 variables, PC_ 6-2, PCO 5-2

assigning a value, PCO 2-7

assigning values to, PC_ 2-5

declarations, PC_ 18-4

declaring, PC_ 2-10, PC_ 18-4, PCO 2-11, PCO 2-19, PCO 4-13

declaring and naming, PCO B-2

definition, PCO 2-16

definition of, PC_ 2-5

dummy, PC_ 13-3

host variable equivalencing, PC_ F-115, PCO F-90

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

in OPEN statement, PC_ F-92, PCO F-71

in user exits, PC_ 20-4

initializing, PCO 4-19

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-21, PCO 4-23

overview, PCO 2-7

overview of, PC_ 2-5

purpose of, PC_ 6-2

referencing, PCO 2-8, PCO 4-20

requirements, PCO 2-7

requirements for, PC_ 2-5

restrictions, PCO 2-16, PCO 4-23

restrictions on, PC_ 4-16

rules for naming, PC_ 2-13

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

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

with PL/SQL, PCO 6-2

host, DLM, PSC 5-22

host-based failover, PSC 9-12

host.equiv file, PSG 2-11

hostname, ADG 12-1

hostname, Oracle server, LEG 2-23

HOSTS file, LEG B-9

hosts file, NET 4-22

hot backup mode

for online operating system backups, SBR 4-6

hot backups, SBR 3-6

inconsistent whole database backups, SBR 1-18

hot blocks

identifying, PSA 12-27

Howes, Tim and Mark Smith, OID 2-34

HP's OpenView, DDS 1-32, SCN 403

HS parameter, NET 8-9, NET C-45

HS_ADMIN_ROLE role, SQL 7-530

HS_ALL_CAPS view, SRF 2-146

HS_ALL_DD view, SRF 2-147

HS_ALL_INITS view, SRF 2-147

HS_AUTOREGISTER initialization parameter, DDS 7-17, SRF 1-45

using to enable agent self-registration, DDS 7-8

HS_AUTOREGISTER parameter

of ALTER SYSTEM, SQL 7-111

HS_BASE_CAPS view, DDS 7-10, SRF 2-148

HS_BASE_DD view, DDS 7-10, SRF 2-148

HS_CLASS_CAPS view, DDS 7-10, SRF 2-148

HS_CLASS_DD view, DDS 7-10, SRF 2-149

HS_CLASS_INIT view, DDS 7-10, SRF 2-149

HS_COMMIT_POINT_STRENGTH initialization parameter, DDS A-2

HS_DB_DOMAIN initialization parameter, DDS 7-18, DDS A-2

HS_DB_INTERNAL_NAME initialization parameter, DDS A-3

HS_DB_NAME initialization parameter, DDS A-3

HS_DESCRIBE_CACHE_HWM initialization parameter, DDS A-3

HS_EXTERNAL_OBJECT_PRIVILEGES view, SRF 2-149

HS_EXTERNAL_OBJECTS view, SRF 2-150

HS_EXTERNAL_USER_PRIVILEGES view, SRF 2-150

HS_FDS_CLASS view, DDS 7-10, SRF 2-150

HS_FDS_CONNECT_INFO initialization parameter, DDS A-4

specifying connection information, DDS 8-7

HS_FDS_FETCH_ROWS initialization parameter, DDS 9-11

HS_FDS_INST view, DDS 7-10, SRF 2-151

HS_FDS_SHAREABLE_NAME initialization parameter, DDS A-5

HS_FDS_TRACE initialization parameter, DDS A-5

HS_FDS_TRACE_FILE_NAME initialization parameter, DDS A-5

HS_FDS_TRACE_LEVEL initialization parameter

enabling agent tracing, DDS 8-8

HS_INST_CAPS view, DDS 7-10, SRF 2-151

HS_INST_DD view, DDS 7-10, SRF 2-152

HS_INST_INIT view, DDS 7-10, SRF 2-152

HS_LANGUAGE initialization parameter, DDS A-6

HS_NLS_DATE_FORMAT initialization parameter, DDS A-7

HS_NLS_DATE_LANGUAGE initialization parameter, DDS A-7

HS_NLS_NCHAR initialization parameter, DDS A-8

HS_OPEN_CURSORS initialization parameter, DDS A-8

HS_ROWID_CACHE_SIZE initialization parameter, DDS A-9

HS_RPC_FETCH_REBLOCKING initialization parameter, DDS 9-11, DDS A-9

HS_RPC_FETCH_SIZE initialization parameter, DDS 9-11, DDS A-10

HTML

displaying within PSP files, ADG 12-5

retrieving from PL/SQL, ADG 12-2

HTP and HTF packages, ADG 12-2

HTTP URLs, ADG 12-2

HTTPS, OAS 10-6

hybrid database environment

creating, SAD 2-6

hypertext markup language (HTML), PLS 8-18

hypertext transfer protocol (HTTP), PLS 8-18

hyphenation

of host variable names, PCO 2-16