L

L format element, NLS 2-23

L number format element, SQL 2-41

L variable in SQLDA

how value is set, PC_ 15-8

purpose of, PC_ 15-8

label name

maximum length of, PC_ 9-25

Label Template dialog box, LEG C-6

label templates, LEG C-1

components, LEG C-4, LEG C-10

creating, LEG C-10

customizing, LEG C-2

editing, LEG C-11

how NetWorker uses, LEG C-5

numbering sequences, LEG C-8

organizational structure, LEG C-10

pool, matching to a, LEG C-5

separator, LEG C-9

sequence number, LEG C-9

labeling storage volumes, LEG C-1

labels

block, PLS 2-40

GOTO statement, PLS 3-15

loop, PLS 3-8

volume, LEG C-5

LAG function, SQL 4-40

LAG/LEAD functions, DWG 17-46

Lamport SCN generation, PSC 6-6

LAN environments

vulnerabilities of, OAS 1-3

language

database default language, SRF 1-77

LANGUAGE clause

of CREATE FUNCTION, SQL 7-289

of CREATE PROCEDURE, SQL 7-357

of CREATE TYPE, SQL 7-442

of CREATE TYPE BODY, SQL 7-450

LANGUAGE parameter (Oracle Version 6), PSC A-23

language support, NLS 1-5, PCO 1-3

Export, SUT 1-54

Import, SUT 2-52

languages

overriding, NLS 2-6

large files

operating system dependencies, MIG 9-50

large object (LOB) datatypes, PLS 2-22

large object, see LOB

Large Objects (LOBs), PC_ A-4

Large Objects. See LOBs

large objects. See LOBs

large pool, SCN 7-12, STU 20-64

overview of, SCN 1-15

LARGE_POOL_MIN_ALLOC initialization parameter: obsolete

LARGE_POOL_SIZE initialization parameter, SRF 1-50

changes in release 8.1, MIG 8-5

parallel execution allocation, MIG B-10

LARGE_POOL_SIZE parameter, DWG 18-10, STU 20-64

LAST collection method, PLS 4-23

LAST_DAY function, SQL 4-41

LAST_VALUE function, DWG 17-42, SQL 4-42

latches, PSA 7-19, PSC 4-3, PSC 4-8

analyzing statistics for, PSA 12-28

contention, STU 2-13, STU 18-12

described, SCN 241

redo allocation latch, STU 21-16

redo copy latches, STU 21-16

latency, PSC 2-4, PSC 8-11

of the interconnect, PSC 2-7

latency parameter in scheduling propagation, ADQ 6-2

latest timestamp

conflict resolution method, REP 5-12

launching Oracle Directory Manager, OID 4-2

LBS, See Lob Buffering Subsystem (LBS)

LCD, SMS 19-1

LCK0 background process, SCN 1-18, SCN 8-13

LCKn process, PSC 5-17

role in recovery, PSA 14-5

LDA, PC_ 5-50

remote and multiple connections, PC_ 5-51

setup for OCI rel 8, PC_ 5-50

LDAP, GTK 2-10, GTK 3-74

add/modify performance, OID 13-12

and internationalization, OID 1-3, OID 2-26

and Internet, OID 1-3

and thin clients, OID 1-3

and Transport Layer Security, OID 1-3

conventions, for modifying entries, OID 7-22

extensibility, OID 1-3

IETF approval

knowledge references, OID 1-3

referrals, OID 1-3

search filters, IETF-compliant, OID A-4

security, OID 1-3

server instances, OID 2-30, OID 2-31

components, OID 2-32

starting, OID 3-3

servers, multithreaded, OID 1-4

standard syntaxes, OID 2-6

syntax, OID F-6

enforced by Oracle Internet Directory, OID F-7

recognized by Oracle Internet Directory, OID F-7

Version 3, OID 1-3, OID 1-4

vs. DAP, OID 1-3

LDAP Data Interchange Format (LDIF)

when using bulkload, OID A-20

LDAP Interchange Format (LDIF), OID 4-14, OID A-2

LDAP schema, OAS E-1

attributes, NET D-1 to NET D-5

object classes, NET D-1 to NET D-5

LDAP search performance, OID 13-12

LDAP server instances

starting, OID 3-4

stopping, OID 3-4

ldapadd, OID 4-14, OID A-7

adding entries, OID A-7

adding JPEG images, OID A-9

and NLS, OID 11-6

ldapaddmt, OID 4-14, OID A-9

adding entries concurrently, OID A-9

and NLS, OID 11-6

log, OID A-9

syntax, OID A-9

ldapbind, OID A-6

and NLS, OID 11-6

ldap-bind operation, OID 2-21

ldapcompare, OID 4-14, OID 7-25, OID A-17

and NLS, OID 11-6

syntax, OID A-17

ldapdelete, OID 4-14, OID A-16

and NLS, OID 11-6

deleting entries, OID A-16

syntax, OID A-16

ldapmoddn, OID 4-14, OID A-18

and NLS, OID 11-7

moving entries, OID 7-25

moving subtrees, OID 7-25

renaming entries, OID 7-25

renaming subtrees, OID 7-25

ldapmodify, OID 4-14, OID A-11

adding ACPs, OID 9-48

adding attributes, OID 6-31

adding entry-level ACIs, OID 9-49

adding object classes, OID 6-17

adding values to multiple-valued attributes, OID A-13

and NLS, OID 11-6

change types, OID A-12

changing audit level, OID 5-29

creating group entries, OID A-13

deleting entries, OID A-14

LDIF files in, OID A-7, OID A-9, OID A-11, OID A-14

modifying attributes, OID 6-31

modifying object classes, OID 6-17

replacing attribute values, OID A-13

syntax, OID A-11

ldapmodify tool, NET 6-31

ldapmodifymt, OID 4-14

and NLS, OID 11-6

multithreaded processing, OID A-15

using, OID A-14

ldap.ora file, PSG 3-16

creating, NET 2-44, NET 6-18, PSG 3-16

default configuration, PSG 3-16

DEFAULT_ADMIN_CONTEXT parameter, NET C-78

DIRECTORY_SERVERS parameter, NET C-78

DIRECTORY_TYPE parameter, NET C-78

ldaprepl.sh, OID 10-7

ldapsearch, OID A-4

and NLS, OID 11-6

filters, OID A-6

querying audit log, OID 5-24

syntax, OID A-4

LDIF

file-based modification, not supported by bulkmodify, OID A-23

files, in ldapmodify commands, OID A-7, OID A-9, OID A-11, OID A-14

formatting notes, OID A-3

formatting rules, OID A-3

using, OID 4-14, OID A-2

LDIF file

for adding configuration set entries, OID 5-12

referencing in commands, OID 5-14

ldifwrite, OID A-21

and NLS, OID 11-8

syntax, OID A-21

LEAD function, SQL 4-44

LEADING hint, STU 7-22

leading whitespace

definition, SUT 5-82

trimming and SQL*Loader, SUT 5-85

leaf blocks, SCN 10-30

minimizing contention for, PSA 6-11

leaf-level attributes, ADO 7-1

leaf-level scalar attributes, ADO 7-1

LEAST function, SQL 4-45

least recently used (LRU) algorithm

database buffers and, SCN 7-4

dictionary cache, SCN 2-4

full table scans and, SCN 7-4

latches, SCN 8-8

shared SQL pool, SCN 7-8, SCN 7-11

least recently used list (LRU), STU 18-10

LEAST_UB function

desupported, MIG 9-30

Legato Storage Manager, GTK 4-6

length

an internal persistent LOB, ADL 9-135

getting BFILE, ADL 11-143

specifying record length for export, SUT 1-24, SUT 2-26

temporary LOB, ADL 10-89

LENGTH function, SQL 4-45

length indicator

determining size, SUT 5-77

length of a numeric field, SUT 5-16

length subfield

VARCHAR DATA

SQL*Loader, SUT 5-62

length() - oracle.ODCI.ODCIArgDescList.length(), JPR 3-8

length() - oracle.ODCI.ODCIColInfoList.length(), JPR 3-16

length() - oracle.ODCI.ODCIObjectList.length(), JPR 3-44

length() - oracle.ODCI.ODCIRidList.length(), JPR 3-59

LENGTHB function, SQL 4-46

length-value pair specified LOBs, SUT 5-104

Less or Equal filter, OID 6-9, OID 7-7, OID 9-22, OID 9-29

less than tests, SQL 3-5

level 0 incremental backups, RMN 1-50

LEVEL clause

of ALTER DIMENSION, SQL 7-25

of CREATE DIMENSION, SQL 7-279

LEVEL pseudocolumn, PLS 5-4, SQL 2-58, SQL 7-577

and hierarchical queries, SQL 2-58

LEVEL pseudocolumns, PCO 4-12

level relationships, DWG 2-7

purpose, DWG 2-7

levels, DWG 2-6, DWG 2-7

adding to a dimension, SQL 7-27

dropping from a dimension, SQL 7-27

of dimensions, defining, SQL 7-279

lexical units, PLS 2-2

LFI, SMS 20-1

LGWR background process, SCN 8-9

See also log writer process

LGWR process

log history, PSA 13-7

LGWR_IO_SLAVES initialization parameter: obsolete

libraries, ADG 1-38

creating, SQL 7-316

foreign function

exporting, SUT 1-57

importing, SUT 2-58

granting

system privileges on, SQL 7-523

re-creating, SQL 7-316

removing from the database, SQL 7-484

library

alias, DCI 4-2

shared, DCI 2-7, DCI 4-2

library cache, SCN 7-7, SCN 7-8, SCN 7-10, STU 2-12

memory allocation, STU 19-16

tuning, STU 19-14

library cache locks, PSA 7-19, PSC 4-7

library units

remote dependencies, ADG 9-28

library units. See Java schema objects

LICENSE_MAX_SESSIONS initialization parameter, SRF 1-51

changing while instance runs, SAD 22-4

setting, SAD 22-4

setting before database creation, SAD 2-23

LICENSE_MAX_SESSIONS parameter, SCN 299

of ALTER SYSTEM, SQL 7-111

LICENSE_MAX_USERS initialization parameter, SRF 1-51

changing while database runs, SAD 22-6

setting, SAD 22-6

setting before database creation, SAD 2-23

LICENSE_MAX_USERS parameter

of ALTER SYSTEM, SQL 7-112

LICENSE_SESSION_WARNING initialization parameter

setting before database creation, SAD 2-23

LICENSE_SESSIONS_WARNING initialization parameter, SRF 1-52

changing while instance runs, SAD 22-4

setting, SAD 22-4

LICENSE_SESSIONS_WARNING parameter, SCN 299

of ALTER SYSTEM, SQL 7-112

licenses

maximum sessions, SRF 1-51

maximum users, SRF 1-51

warning for concurrent user sessions, SRF 1-52

licensing

complying with license agreement, SAD 2-23, SAD 22-2

concurrent usage, SAD 22-3, SCN 299

named user, SAD 22-2, SAD 22-5, SCN 300

number of concurrent sessions, SAD 2-23

privileges for changing named user limits, SAD 22-6

privileges for changing session limits, SAD 22-5

session-based, SAD 22-2

viewing current limits, SCN 300

viewing limits, SAD 22-6

life cycle

of a standby database, SBY 1-16

Lightweight Directory Access Protocol (LDAP), ADG 11-56

Lightweight Directory Access Protocol. See LDAP.

lightweight sessions, ADG 11-69, SCN 287

LIKE, STU 4-66

LIKE comparison operator, PLS 2-46, PLS 5-6

LIKE conditions, SQL 5-18

LIKE operator, NLS 4-10, SQL 3-8

LIMIT clause, PLS 4-39

LIMIT collection method, PLS 4-22

limit on length of recipient lists, ADQ 6-3

limitations of SSL, OAS 10-10

limitations, PL/SQL, PLS E-1

limits

concurrent usage, SAD 22-3

session, high water mark, SAD 22-3

limits on the database, SRF 4-1

line continuation, PCO 2-13

linear regression functions, DWG 17-48, SQL 4-71

line-mode commands, batching, OID 6-17

lines

continuation, PC_ 2-13

maximum length, PC_ 2-13

LINES precompiler option, PC_ 10-27

linguistic definitions, NLS A-19

supported, NLS A-19

linguistic indexes, NLS 2-29

linguistic sorts, NLS 2-28, SRF 1-78

controlling, NLS 4-9

link

database link, PC_ 3-14

link layer, described, NET 3-4

linking, OCI 2-37, PC_ 2-17, PCO 2-27

issues, OCI 1-24

modes, OCI 1-24

on UNIX, PC_ 1-9

on VMS, PC_ 1-9

support for single-task, OCI 1-27

two-task, PC_ 2-17

Linking in an XA Library, PC_ E-3

LIST CHAINED ROWS clause

of ANALYZE, SQL 7-207

LIST CHAINED ROWS option, SAD 19-9

list command (RMAN), RMN 1-24, RMN 10-83

incarnation of database option, RMN 3-13

list separator, NLS 2-33

LIST_DELEGATED command, NET A-37

LIST_DOMAINS command, NET A-37

LIST_OBJECTS command, NET A-38

Listen Capability, ADQ 8-98

LISTENER

parameter for the multi-threaded server, PSA 1-13

listener

configuring for Oracle Enterprise Manager, GTK 3-76

connect-time failover, PSC 8-10

load balancing, PSC A-5

starting in the DCE environment, OAS 15-2

starting in the DEC environment, OAS 15-2

transparent application failover, PSC 8-10

LISTENER (LIS or LIST) attribute, NET 9-5, PSG 4-8

listener addresses, NET B-1

Listener Control Utility (LSNRCTL)

see LSNRCTL utility

listener endpoint, setting on server when configuring SSL, OAS 10-30

listener vs. registration for notification, ADQ 6-3

listener, for directory database, OID 2-30, OID 2-32

restarting, OID 10-6

stopping, OID 10-6

listener.log file, NET 12-19

listener.ora, OID 10-6, OID B-7

LISTENER.ORA file, SCN 6-6

configuring, SBY 2-11, SBY 2-13, SBY 5-5

format, SBY 5-5, SBY 5-16

listener.ora file, PSG 3-14, PSG 3-40

configuration parameter reference, NET C-48 to NET C-58

default configuration, PSG 3-14

described, NET 1-5

migrating, MIG F-15

modifying after migration, MIG 8-6

modifying after upgrading, MIG 8-6

Oracle Enterprise Manager service discovery, PSG C-4

Oracle Parallel Server Management requirements, PSG 6-6

OSS.SOURCE.MY_WALLET parameter, OAS 10-21

parameters

ADDRESS, NET C-49

ADDRESS_LIST, NET C-49

CONNECT_TIMEOUT_listener_name, NET C-54

DESCRIPTION, NET C-49

GLOBAL_DBNAME, MIG F-15, NET 7-13, NET C-51

LOG_DIRECTORY_listener_name, NET C-54

LOG_FILE_listener_name, NET C-55

LOGGING_listener_name, NET C-55

ORACLE_HOME, MIG F-15, NET 7-13, NET 8-47, NET 8-49, NET C-51

OSS.MY.WALLET, NET C-55

PASSWORDS_listener_name, NET C-55

POOL_SIZE, NET 7-17

PRESPAWN_DESC, NET C-54

PRESPAWN_LIST, NET C-53

PRESPAWN_MAX, NET 7-16, NET C-53

PROGRAM, NET 8-47, NET 8-49, NET C-51

PROTOCOL, NET 7-16

SAVE_CONFIG_ON_STOP_listener_name, NET C-56

SID_DESC, NET C-52

SID_LIST_listener_name, NET C-50, NET C-52

SID_NAME, MIG F-15, NET 7-13, NET 8-47, NET 8-49, NET C-52

SQLNET.CLIENT_AUTHENTICATION, NET C-56

STARTUP_WAITTIME_listener_name, NET C-56

TIMEOUT, NET 7-17

TRACE_DIRECTORY_listener_name, NET C-56

TRACE_FILE_listener_name, NET C-57

TRACE_FILEN_listener_name, NET C-57

TRACE_FILENO_listener_name, NET C-57

TRACE_LEVEL_listener_name, NET C-58

TRACE_TIMESTAMP_listener_name, NET C-58

USE_PLUG_AND_PLAY_listener_name, NET C-58

parameters for DCE, OAS 14-4

prespawned dedicated servers, MIG F-16

release 8.1, changes in, NET C-84

SID_LIST_listener_name not required, NET C-84

SID_DESC parameter, PSG C-4

SID_LIST_listener_name parameter, PSG 3-40, PSG 6-6, PSG C-4

SSL_CLIENT_AUTHENTICATION parameter, OAS 10-22

upgrading, MIG F-15

USE_PLUG_AND_PLAY_listener_name, MIG F-20

listeners, DDS 7-2, NET 7-13, NET 8-49, SCN 6-6, SCN 8-14

adjusting queuesize for, NET 7-12

client load balancing, NET xviii, NET 2-20

configuration file, NET 1-5, NET 6-2

configuring, NET 7-1 to NET 7-20

address for Oracle Connection Manager, NET 8-42

address list, NET 8-2

directory naming method, NET 6-28

external procedures connections, NET 7-13, NET 8-45

global database name, NET 7-13

Heterogeneous Services connections, NET 8-49

host naming method, NET 6-75

local naming method, NET 6-15

multihomed hosts, NET 7-7

non-default address, NET 7-10

Oracle Enterprise Manager, NET 7-13

Oracle home directory, NET 7-13

Oracle Names, NET 6-64

Oracle System Identifier, NET 7-13

Oracle8i JServer, NET 7-8

prespawned dedicated servers, NET 7-16

protocol addresses, NET 7-6, NET B-1

SID, NET 7-13

configuring for Oracle Enterprise Manager, MIG F-15

connection load balancing, NET xviii, NET 2-26

connect-time failover, NET 2-21

default address, NET 2-24

default configuration, NET 7-3

direct hand-off, NET xviii, NET 2-9

GLOBAL_DBNAME parameter, PSG 3-15

handling concurrent connections, NET 7-12

increasing queuesize, NET 7-12

listener.ora file, PSG 3-14

log files, NET 12-21, NET 12-25

audit trail, NET 12-25

configuring, NET 12-22

direct hand-off event information, NET 12-28

service registration event information, NET 12-26

lsnr_listener_name parameter in db_name.conf file, PSG B-9

multihomed hosts, NET 7-7

multiple addresses, NET 8-2

overview, NET 2-5

prespawned dedicated servers, MIG F-16, NET 2-17

queuesize, NET 5-6

redirect connections, NET 2-9

service names, SCN 6-6

service naming, NET xviii

service registration, NET xviii, NET 2-22

starting

from the command line, NET 11-7

from the Control Panel, NET 11-7

testing configuration, NET 11-15

tns_admin parameter in db_name.conf file, PSG B-8

trace files, NET 12-38

Transparent Application Failover, NET 2-21

listener.trc file, NET 12-34

listing database links, DDS 2-21, DDS 5-7, DDS 5-9

listObjList clause (RMAN), RMN 10-92

lists

attributes, OCI 6-18

lists (RMAN), RMN 4-2 to RMN 4-4

backups and copies, RMN 4-3, RMN 4-10

backups and copies made before specified date, RMN 4-10

scenarios, RMN 4-10

LITDELIM option

purpose, PCO 14-26

LITDELIM precompiler option, PCO 2-14, PCO 14-26

literal invocation

constructor methods, ADO 2-3

literals, PLS 2-7

Boolean, PLS 2-9

character, PLS 2-8

in SQL statements and functions, SQL 2-2

in SQL syntax, SQL 2-2

numeric, PLS 2-7

string, PLS 2-9

syntax, PLS 11-97

LLU parameter, NET B-3

LLU_NAME parameter, NET B-3

LM_LOCKS parameter, PSA 1-8, PSA 1-14, PSC A-8, SRF 1-52

LM_PROCS initialization parameter

obsolete

LM_PROCS parameter, PSC A-8

LM_RESS initialization parameter, SRF 1-53

LM_RESS parameter, PSA 1-14, PSC A-8

LMDn process, PSC A-9

LMON

and cluster reorganization, PSC 9-14

LMON process, PSC A-9

LN function, SQL 4-46

LNAME precompiler option, PC_ 10-28, PCO 14-26

LNPROC

VMS link script, PC_ 1-9

LOAD

SQL*Loader command-line parameter, SUT 6-6

load

parallel, DWG 14-15

load balancing, PSC A-15, STU 20-22

client, NET 2-20, NET C-40

client load balancing, PSC 8-10

connection, NET 2-26

in parallel execution, PSA 2-5

Net8, MIG 9-47

load balancing, network level, OID 14-5

-load option, in bulkload, OID 7-29

LOAD_BALANCE parameter, MIG F-11, NET 8-4, NET C-40, NET C-82, NET C-87, PSG 4-2

LOAD_TNSNAMES command, MIG F-21, MIG F-24, NET 6-67, NET A-39

LOADFROMFILE()

BFILE character set conversions needed before using, ADL 10-34

loading

a LOB with BFILE data, ADL 11-46

combined physical records, SUT 4-15

data into internal LOB, ADL 9-38

datafiles containing tabs

SQL*Loader, SUT 5-49

delimited, free-format files, SUT 4-11

external LOB (BFILE) data into table, ADL 11-42

fixed-length data, SUT 4-8

LOB with data from a BFILE, ADL 9-40

LOBs, SUT 5-98

negative numbers, SUT 4-15

subpartitioned tables, SUT 8-6

tables, SUT 8-6

temporary LOB with data from BFILE, ADL 10-33

variable-length data, SUT 4-5

loading Oracle service names into CDS, OAS 14-17

loadjava and dropjava, GTK 3-21

loadjava utility, ADG 1-36

loadpsp command, ADG 12-11

LOB, ADL 5-13

amount and offset parameters, OCI 15-111

attributes of transient objects, OCI 7-4

binding, OCI 5-10

buffering, OCI 7-9

callbacks, OCI 7-11

character sets, OCI 15-111

creating, OCI 7-2

creating temporary, OCI 7-16

DDL for, DCI 6-2

defining, OCI 5-21

duration of temporary, OCI 7-16

example of temporary, OCI 7-17

external, DCI 6-2

external datatypes, OCI 3-19

external procedure use, DCI 6-11

fetching data, OCI 4-15

fixed-width character sets, OCI 15-111

freeing temporary, OCI 7-16

internal, DCI 6-2

locator, DCI 6-3, OCI 2-15

modifying, OCI 7-2

OCI functions, OCI 7-4

OCI use with, DCI 6-6

overview, DCI 1-9

temporary, OCI 7-15

triggers and, DCI 6-12

value, DCI 6-2

varying-width character sets, OCI 15-111

LOB (large object) datatypes, PLS 2-22

LOB and precompiler datatypes, PCO 13-21

LOB APPEND SQL statement, PC_ F-71

LOB APPEND statement, PC_ 16-12, PCO F-58

LOB ASSIGN SQL statement, PC_ F-72

LOB ASSIGN statement, PC_ 16-12, PCO F-59

LOB Attributes, Propagation of Messages with, ADQ 8-108

LOB buffering

BLOB-buffering with JDBC, ADL 3-40

buffer-enabled locators, ADL 5-27

disable for temporaryLOBs, ADL 10-194

example, ADL 5-24

flushing for temporary LOBs, ADL 10-187

flushing the buffer, ADL 5-25

flushing the updated LOB through LBS, ADL 5-26

guidelines, ADL 5-21

OCI example, ADL 5-28

OCI functions, ADL 3-16

OCILobFlushBuffer(), ADL 5-26

Oracle Objects for OLE (OO4O)

methods for internal LOBs, ADL 3-35

physical structure of buffer, ADL 5-23

Pro*C/C++ precompiler statements, ADL 3-25

Pro*COBOL precompiler statements, ADL 3-29

temporary LOBs

CACHE, NOCACHE, CACHE READS, ADL 10-8

usage notes, ADL 5-23

LOB Buffering SubSystem (LBS)

LOB Buffering Subsystem (LBS)

advantages, ADL 5-21

buffer-enabled locators, ADL 5-26

buffering example using OCI, ADL 5-28

example, ADL 5-24

flushing the buffer, ADL 5-25

flushing the updated LOB, ADL 5-26

guidelines, ADL 5-21

saving the state of locator to avoid reselect, ADL 5-27

usage, ADL 5-23

LOB CLOSE SQL statement, PC_ F-72

LOB CLOSE statement, PC_ 16-13, PCO F-59

LOB COPY SQL statement, PC_ F-73

LOB COPY statement, PC_ 16-14, PCO F-60

LOB CREATE statement, PCO F-60

LOB CREATE TEMPORARY SQL statement, PC_ F-73

LOB CREATE temporary statement, PC_ 16-15

LOB data, SUT 1-9

compression, SUT 1-17

Export, SUT 1-57

in delimited fields, SUT 5-99

in length-value pair fields, SUT 5-100

in predetermined size fields, SUT 5-99

LOB datatype

copying from LONG, MIG 8-2

support in OO4O, ADG 1-17

use in triggers, ADG 13-20

LOB datatypes, SCN 12-12, SQL 2-23

BFILE, SCN 12-14

BLOBs, SCN 12-13

CLOBs and NCLOBs, SCN 12-14

default logging mode, SCN 152

NOLOGGING mode, SCN 151

restrictions

parallel DDL, SCN 188

parallel DML, SCN 201

LOB DESCRIBE SQL statement, PC_ F-74

LOB DESCRIBE statement, PCO F-61

LOB DISABLE BUFFERING SQL statement, PC_ F-75

LOB DISABLE BUFFERING statement, PC_ 16-16, PCO F-62

LOB ENABLE BUFFERING SQL statement, PC_ F-76

LOB ENABLE BUFFERING statement, PC_ 16-16, PCO F-63

LOB ERASE SQL statement, PC_ F-76

LOB ERASE statement, PC_ 16-17, PCO F-63

LOB FILE CLOSE ALL SQL statement, PC_ F-77

LOB FILE CLOSE ALL statement, PC_ 16-18

LOB file close all statement, PC_ 16-18

LOB FILE CLOSE statement, PCO F-64

LOB FILE SET SQL statement, PC_ F-78

LOB FILE SET statement, PC_ 16-18, PCO F-65

LOB FLUSH BUFFER SQL statement, PC_ F-78

LOB FLUSH BUFFER statement, PC_ 16-19, PCO F-65

LOB FREE TEMPORARY, PCO F-66

LOB FREE TEMPORARY SQL statement, PC_ F-79

LOB FREE TEMPORARY statement, PC_ 16-19

LOB functions, OCI 15-110

server roundtrips, OCI C-3

LOB index clause

compatibility, MIG 9-27

of ALTER TABLE, SQL 7-142

of CREATE TABLE, SQL 7-399

LOB LOAD FROM FILE statement, PC_ 16-20

LOB LOAD SQL statement, PC_ F-79

LOB LOAD statement, PCO F-66

LOB locator, OCI 2-15

attributes, OCI A-26

copy semantics, ADL 2-3

external LOBs (BFILEs), ADL 2-3

internal LOBs, ADL 2-3

reference semantics, ADL 2-3

lob locators, PLS 2-22

LOB OPEN SQL statement, PC_ F-80

LOB OPEN statement, PC_ 16-21, PCO F-67

LOB READ SQL statement, PC_ F-81

LOB READ statement, PC_ 16-22, PCO F-68

LOB statements, PCO A-2

LOB APPEND, PCO 13-10

LOB ASSIGN, PCO 13-11

LOB CLOSE, PCO 13-12

LOB CLOSE ALL, PCO 13-16

LOB COPY, PCO 13-13

LOB CREATE TEMPORARY, PCO 13-14

LOB DISABLE BUFFERING, PCO 13-14

LOB ENABLE BUFFERING, PCO 13-15

LOB ERASE, PCO 13-15

LOB FILE SET, PCO 13-17

LOB FLUSH BUFFER, PCO 13-17

LOB FREE TEMPORARY, PCO 13-18

LOB LOAD FROM FILE, PCO 13-18

LOB OPEN, PCO 13-20

LOB READ, PCO 13-20

LOB TRIM, PCO 13-22

LOB WRITE, PCO 13-23

LOB storage clause

for partitions, SQL 7-142

of ALTER MATERIALIZED VIEW, SQL 7-47, SQL 7-51

of ALTER TABLE, SQL 7-141

of CREATE MATERIALIZED VIEW / SNAPSHOT, SQL 7-319

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-322

of CREATE TABLE, SQL 7-385, SQL 7-398

LOB support in OO4O, ADG 1-17

LOB TRIM SQL statement, PC_ F-81

LOB TRIM statement, PCO F-68

LOB WRITE SQL statement, PC_ F-82

LOB WRITE statement, PCO F-69

LOBFILEs, SUT 5-98, SUT 5-101

example, SUT 4-39

SQL*Loader DDL support, SUT 3-19

LOBS

storage parameters for, SAD 12-12

LOBs, ADL 5-20

access methods, PC_ 16-5, PCO 13-5

accessing through a locator, ADL 2-7

advantage of buffering, PCO 13-4

allowed in replicated tables, REP 7-2

attributes

initializing, SQL 2-24

attributes and COBOL types, PCO 13-24

attributes and object cache, ADL 5-20

BFILES, PC_ 16-2

buffering

caveats, ADL 5-21

pages can be aged out, ADL 5-26

buffering subsystem, ADL 5-21

buffering system, PC_ 16-10

buffering usage notes, ADL 5-23

CHUNKSIZE attribute, PCO 13-26

columns

difference from LONG and LONG RAW, SQL 2-23

populating, SQL 2-24

compared with LONG and LONG RAW, PCO 13-3

compatibility, ADL 1-5, MIG 9-11, MIG 9-26

convert LONG to LOB, GTK 3-33

datatypes versus LONG, ADL 1-3

DBMS_LOB API to append data to LOBs, GTK 3-34

DBMS_LOB package, SPR 18-1

definition, PCO 13-2

DIRECTORY attribute, PCO 13-26

downgrading, MIG 13-26

external, PC_ 16-2, PCO 13-2, PCO 13-7, SQL 2-23

external (BFILEs), ADL 2-2

FILEEXISTS attribute, PCO 13-26

FILENAME attribute, PCO 13-26

flushing, ADL 5-21

in index-organized tables, GTK 3-29

in partitioned tables, ADL 7-26

in the object cache, ADL 5-20

indexes for, SQL 7-399

initializing, PC_ 16-8

inline storage, ADL 2-5

interfaces, See programmatic environments

interMEDIA, ADL 1-4

internal, PC_ 16-2, PCO 13-2, PCO 13-7, SQL 2-23

creating an object in object cache, ADL 5-20

internal LOBs

CACHE / NOCACHE, ADL 7-8

CHUNK, ADL 7-10

copy semantics, ADL 2-3

ENABLE | DISABLE STORAGE IN ROW, ADL 7-11

initializing, ADL 11-98

locators, ADL 2-5

locking before updating, ADL 9-144, ADL 9-182, ADL 9-192, ADL 9-201, ADL 9-218, ADL 9-228

LOGGING / NOLOGGING, ADL 7-9

Oracle Objects for OLE (OO4O), modifying methods, ADL 3-33

PCTVERSION, ADL 7-7

setting to empty, ADL 2-9

tablespace and LOB index, ADL 7-7

tablespace and storage characteristics, ADL 7-5

transactions, ADL 2-2

ISOPEN attribute, PCO 13-26

ISTEMPORARY attribute, PCO 13-26

LENGTH attribute, PCO 13-26

loading, SUT 5-98

loading external, SUT 5-98

loading internal LOBs, SUT 5-98

LOB chunk size, GTK 3-34

LOB demo program, PCO 13-29

LOB DESCRIBE use, PCO 13-24

locators, ADL 2-5, ADL 5-2, PC_ 16-3, PCO 13-3, SQL 2-23, SQL 7-399

cannot span transactions, ADL 7-15

locators in C, PC_ 16-7

logging attribute of, SQL 7-395

migration issues, ADL 1-5

modifying physical attributes of, SQL 7-146

number of bytes manipulated in, SQL 7-399

object cache, ADL 5-20

Open/Close/IsOpen APIs, GTK 3-34

partitioning of tables with, GTK 3-47

performance, best practices, ADL 7-34

performing SELECT on, ADL 2-7

piecewise operations, ADL 5-6

read consistent locators, ADL 5-2

reason for using, ADL 1-2

removing from index-organized tables, MIG 13-14

removing from partitioned tables, MIG 13-28

rules for all statements, PCO 13-9

rules for buffering subsystem, PCO 13-9

rules for statements, PCO 13-10

setting to contain a locator, ADL 2-5

setting to NULL, ADL 2-8

specifying directories for, SQL 7-282

SQL*Loader support, GTK 3-36

storage

characteristics, SQL 7-394, SQL 7-398

in-line, SQL 7-398

outside of row, SQL 7-398

support for, REP 3-22, REP A-7

tables

adding partitions, ADL 7-31

creating, ADL 7-28

creating indexes, ADL 7-30

exchanging partitions, ADL 7-30

merging partitions, ADL 7-31

moving partitions, ADL 7-31

partitioning, ADL 7-28

splitting partitions, ADL 7-31

tablespace for

defining, SQL 7-394

temporary, PC_ 16-3, PCO 13-3, PCO 13-8, GTK 3-33

typical uses, ADL 8-2

unstructured data, ADL 1-2

updated LOB locators, ADL 5-5

using polling method to read and write, PCO 13-27

value, ADL 2-5

variable width character sets for CLOBs and NCLOBs, GTK 3-34

varying-width character data, ADL 7-3

Local and Remote Recipients, ADQ 8-63

LOCAL clause

forcing a checkpoint, PSA 4-7, PSA 13-14

of CREATE INDEX, SQL 7-302

local connections

multithreaded shared servers, MIG 3-17

local coordinators, DDS 4-7

distributed transactions, DDS 4-6

local currency, SRF 1-75

local currency symbol, NLS 2-23

local databases, SCN 1-34

local indexes, DWG 6-3, DWG 6-6, DWG 18-55, SCN 11-29, SCN 11-33

bitmap indexes

on partitioned tables, SCN 10-39

parallel query and DML, SCN 10-35

building partitions in parallel, SCN 11-29

equipartitioning, SCN 11-29

managing partitions, SCN 11-59

local instances

nodes, PSA 4-4

local I/O, PSC 8-11

local locks, PSC 4-3

local naming

advantages and disadvantages, NET 5-3

client configuration for, NET 6-15

configuring, NET 6-5 to NET 6-15

connecting with, NET 6-15

default configuration, NET 6-6

described, NET 2-35

establishing a connection with, NET 2-35, NET 6-15

listener configuration for, NET 6-15

recommended for, NET 5-3

server configuration for, NET 6-6

LOCAL option

verifying access to files, PSC 7-2

local striping, DWG 4-4

local subprograms, PLS 1-18

local users, SQL 7-366, SQL 7-452

local work ratios

measuring, PSA 11-11

LOCAL_LISTENER initialization parameter, SRF 1-54

LOCAL_LISTENER parameter, NET 7-7, NET 7-10, NET 9-5, PSG 3-6, PSG 4-8

LOCAL_LU parameter, NET B-3

LOCAL_LU_NAME parameter, NET B-3

locally managed tablespaces, GTK 3-41, SAD 9-6 to SAD 9-8

compatibility, MIG 9-9

converting to dictionary tablespaces, MIG 13-12

DBMS_SPACE_ADMIN package, SAD 9-23

detecting and repairing defects, SAD 9-23

storage characteristics, SQL 7-606

temporary

creating, SAD 9-9

tempfiles, SAD 9-9

locally partitioned indexes, SQL 7-302

locally-managed tablespaces, SCN 3-8

temporary tablespaces, SCN 3-13

locating

directory entries by using distinguished names, OID 2-3

DN of parent, OID 7-13

location

wallet, OID 4-6

Location of Included Files, PC_ E-2

location transparency, SCN 1-34

distributed databases

creating using procedures, DDS 2-30

creating using synonyms, DDS 2-28

creating using views, DDS 2-26

how provided, PC_ 3-15

using procedures, DDS 2-30, DDS 2-31, DDS 2-32

location-independence, of directories, OID 1-2

locator, OCI 2-14

for LOB datatype, OCI 2-15

LOB, DCI 6-3

locator variables, PLS 6-22

locators, ADL 2-5, ADO 9-30

accessing a LOB through, ADL 2-7

BFILEs, ADL 11-12

guidelines, ADL 11-12

two rows can refer to the same file, ADL 11-12

buffer-enabled, ADL 5-27

cannot span transactions, ADL 7-15

copying temporary LOB, ADL 10-108

external LOBs (BFILEs), ADL 2-5

initializing LOB or BFILE to contain, ADL 2-6

LOB, cannot span transactions, ADL 5-13

multiple, ADL 5-2

OCI functions, ADL 3-16

Pro*COBOL precompiler statements, ADL 3-28

providing in Pro*COBOL precompiler, ADL 3-26

read consistent, ADL 5-2, ADL 5-3, ADL 5-10, ADL 5-13, ADL 5-25, ADL 5-28, ADL 5-29, ADL 5-30

read consistent locators, ADL 5-2

read consistent locators provide same LOB value regardless when SELECT occurs, ADL 5-3

reading and writing to a LOB using, ADL 5-16

returning nested tables as, ADO 6-18

saving the state to avoid reselect, ADL 5-27

see if LOB locator is initialized

internal persistent LOBs, ADL 9-169

selecting, ADL 2-7

setting column or attribute to contain, ADL 2-5

temporary, SELECT permanent LOB INTO, ADL 10-9

transaction boundaries, ADL 5-16

updated, ADL 5-2, ADL 5-5, ADL 5-10, ADL 5-13, ADL 5-25

lock

conversion, SRF 3-19

elements, number, PSA 7-6

released by ROLLBACK statement, PC_ F-100, PCO F-77

LOCK ANY TABLE system privilege, SQL 7-527

lock contention, STU 2-13

lock elements

correspondence to locks, PSC 5-14

free, PSC 5-19

LRU list, PSC 5-19

name, PSC 5-15

non-fixed mode, PSC 5-19

valid bit, PSC 5-19

Lock Manager, PSG 3-24, PSG 3-44

lock process, SAD 4-13

lock process (LCK0), SCN 1-18, SCN 8-13

LOCK TABLE command, ADG 7-12

LOCK TABLE statement, PCO 3-23, PLS 5-49, SCN 12, SQL 7-547

closes mall cursors, PC_ 3-25

example, PCO 3-23

example of, PC_ 3-25

locking tables with, PC_ 3-25

NOWAIT parameter in, PC_ 3-25

purpose of, PC_ 3-25

syntax, PLS 11-100

using the NOWAIT parameter, PCO 3-23

lock timeout interval

distributed transactions, DDS 5-4

LOCK_NAME_SPACE initialization parameter, RMN 8-8, SBY 5-2, SBY 5-9, SRF 1-54

LOCK_SGA parameter, SCN 7-14, SCN 7-18, SRF 1-55

LOCK_SGA_AREAS initialization parameter: obsolete

locking, OCI 13-12, PC_ 3-24, PCO 3-12, PCO 3-21

automatic

overriding, SQL 7-547

definition of, PC_ 3-16

explicit versus implicit, PC_ 3-24, PCO 3-21

indexed foreign keys and, SCN 269

manual (explicit), ADG 7-11

modes, PCO 3-12

modes of, PC_ 3-16

objects, OCI 13-12

optimistic model, OCI 13-13

overriding default, PC_ 3-24, PCO 3-21

privileges needed, PCO 3-25

privileges needed to obtain, PC_ 3-28

table versus row, PC_ 3-24

unindexed foreign keys and, SCN 268

uses for, PC_ 3-24

using the FOR UPDATE OF clause, PCO 3-21

using the LOCK TABLE statement, PCO 3-23

with FOR UPDATE OF, PC_ 3-24

with the LOCK TABLE statement, PC_ 3-25

locking policy

for indexes, PSA 6-13

locks, PLS 5-42, PSC 1-4, SCN 1-31, SCN 213

adding for new data files, PSA 3-9

after committing transactions, SCN 36

allocation, global cache, PSA 6-16

and resources, avoiding dynamic allocation, PSA 10-2

automatic, SCN 1-32, SCN 226, SCN 229

boundary, PSC 7-26

conversion, PSC 5-30, SCN 227, SRF 3-15, SRF 3-18, SRF 3-44, SRF 3-71

conversions, analyzing by type, PSA 12-26

convert timeouts, analyzing, PSA 12-13

cost of, PSC 5-6

data, SCN 230

duration of, SCN 226

data dictionary cache, PSA 7-19

database mount, PSA 7-19

deadlocks, SCN 227, SCN 228

avoiding, SCN 229

dictionary, SCN 239

clusters and, SCN 240

duration of, SCN 240

dictionary cache, PSA 7-19, PSC 4-7, SCN 241

distributed, ADG 7-11

DML, PSA 7-17, PSC 4-4, PSC 4-7

DML acquired, SCN 238

diagrammed, SCN 236

DML lock limit, DML_LOCKS, MIG B-9

DML partition locks, SCN 11-45

elements, PSA 9-14

fixed, SRF 1-41

non-fixed, SRF 1-41

enqueue, PSC 4-3

escalation does not occur, SCN 227

estimating number needed, PSA 7-3

exclusive table locks (X), SCN 236

file management locks, SCN 241

global, PSA 1-9, PSC 4-4

group-based, PSC 5-33

high convert rates, PSA 5-5

how Oracle uses, SCN 225

identifier, PSA 9-13

in distributed transactions, DDS 5-4

in non-Oracle systems, DDS 9-12

in-doubt distributed transactions, DDS 5-4, DDS 5-5

internal, SCN 240

job queue, SAD 8-9

latch, PSC 4-3

latches and, SCN 241

library cache, PSA 7-19, PSC 4-7

local, PSC 4-3

LOCK TABLE command, ADG 7-12, ADG 7-13

log management locks, SCN 241

manual, SCN 1-32, SCN 242

examples of behavior, SCN 243

mode compatibility, PSC 5-26

mode, and buffer state, PSC 5-24

modes, PLS 5-42

monitoring, SAD 4-15

mount lock, PSA 7-19

mount locks, PSC 4-8

name format, PSA 9-13

names, SRF A-11

non-PCM, PSC 4-4, PSC 4-5

object level locking, ADO 3-3, SCN 13-15

on KGL objects, SRF 2-113

Oracle Lock Management Services, SCN 250

overriding, PLS 5-48

overview of, SCN 1-31, SCN 213

ownership by DLM, PSC 5-33

parallel cache management (PCM), SCN 230

parallel DML, SCN 199

parse, SCN 20, SCN 240

PCM lock, PSA 8-9, PSC 7-21

privileges for manual acquirement, ADG 7-16

process-owned, PSC 5-33

re-mastering, PSC 9-15

request, handling by DLM, PSC 5-28

rollback segment, PSC 7-7, SCN 241

row, PSA 7-17, PSC 4-7, PSC 4-12

row (TX), SCN 231

block-level recovery, SCN 355

row cache, PSC 4-2

row exclusive locks (RX), SCN 234

row lock independence, PSC 4-12

row share table locks (RS), SCN 234

share row exclusive locks (SRX), SCN 235

share table locks (S), SCN 235

share-subexclusive locks (SSX), SCN 235

subexclusive table locks (SX), SCN 234

subshare table locks (SS), SCN 234

system change number, PSA 7-18

TABLE, PSA 7-17

table, PSA 7-17, PSC 4-4, PSC 4-5, PSC 4-7

table (TM), SCN 232

table lock, SRF 1-106

table lock modes, SCN 232

tables, PSC 4-13

tablespace, SCN 241

transaction, PSA 7-17, PSC 4-7

types of, SCN 229

user locks, ADG 7-20

using FOR UPDATE clause, PLS 5-48

UTLLOCKT.SQL script, ADG 7-21

value blocks, PSA 7-18

locks. See table locks

LOG

Export parameter, SUT 1-22, SUT 1-40

Import parameter, SUT 2-25

SQL*Loader command-line parameter, SUT 6-6

log, STU 21-16

log buffer tuning, STU 2-12, STU 19-7

log entries, SCN 1-9, SCN 349

See also redo log files, SCN 1-9

log files

after a discontinued load, SUT 5-34

cmadm_pidlog, NET 12-22

cmadmpid.log, NET 12-22

cman_pid.log, NET 12-22

cmanpid.log, NET 12-22

default names for, NET 12-19

example, SUT 4-26, SUT 4-31

Export, SUT 1-22, SUT 1-40

for listener, NET 12-25

Import, SUT 2-25

listener.log, NET 12-21

names.log, NET 12-21

redo log file, PSA 13-1

specifying for SQL*Loader, SUT 6-6

SQL*Loader, SUT 3-13

SQL*Loader datafile information, SUT 7-3

SQL*Loader global information, SUT 7-2

SQL*Loader header Information, SUT 7-2

SQL*Loader summary statistics, SUT 7-4

SQL*Loader table information, SUT 7-3

SQL*Loader table load information, SUT 7-4

sqlnet.log for clients and servers, NET 12-20

using to track errors, NET 12-24

LOG function, SQL 4-47

log history, PSA 3-3, PSA 13-7, PSA 14-9

log management locks, SCN 241

log sequence number

control files, SAD 6-5

log sequence numbers, PSA 13-6, PSA 13-7, SCN 1-47

requested during recovery, SBR 5-9

log sequence recovery, SBR 3-16

log switch

ALTER SYSTEM SWITCH LOGFILE, SCN 8-12

archiver process, SCN 1-18, SCN 8-12

forcing, PSC A-21

log switches, PSC 7-5

adding or dropping files, PSA 3-8

closed thread, PSA 13-15

description, SAD 6-5

forcing, PSA 13-15, PSA 13-21, SAD 6-16

global, PSA 13-21

log history, PSA 13-7

log sequence numbers, SAD 6-5

multiplexed redo log files and, SAD 6-7, SBR 2-14

privileges, SAD 6-16

recovery catalog records, RMN 3-34

waiting for archiving to complete, SAD 6-7, SBR 2-14

log writer process (LGWR), SAD 4-11, SCN 1-17, SCN 8-9

archiving modes, SCN 359

group commits, SCN 8-10

manual archiving and, SCN 361

multiplexed redo log files and, SAD 6-6, SBR 2-13

online redo logs available for use, SAD 6-3

redo log buffers and, SCN 7-6

starting new ARCn processes, SCN 8-13

system change numbers, SCN 36

trace file monitoring, SAD 4-16

trace files and, SAD 6-6, SBR 2-13

write-ahead, SCN 8-9

writing to online redo log files, SAD 6-3

log writer process (LGWR) tuning, STU 20-19, STU 20-41

LOG_ALLOCATION parameter (Oracle Version 6), PSC A-21, PSC A-23

LOG_ARCHIVE_BUFFER_SIZE initialization parameter, SAD 7-22

LOG_ARCHIVE_BUFFER_SIZE initialization parameter: obsolete

LOG_ARCHIVE_BUFFERS initialization parameter, SAD 7-22

setting, SAD 7-22

LOG_ARCHIVE_BUFFERS initialization parameter: obsolete

LOG_ARCHIVE_DEST initialization parameter, SBR 5-6, SBR 5-9, SBR 5-27, SBR 5-30, SBY 3-4, SRF 1-55

specifying destinations using, SAD 7-10, SBR 2-21

LOG_ARCHIVE_DEST parameter, PSA 1-8, PSA 14-8, PSA 14-9, PSG 4-11

of ALTER SYSTEM, SQL 7-112

specifying for recovery, PSA 14-9

LOG_ARCHIVE_DEST_n initialization parameter, GTK 3-50, SRF 1-56

LOG_ARCHIVE_DEST_n initialization parameter, SAD 7-10, SBR 2-21, SBR 5-6, SBR 5-9, SBY 3-4, SBY 5-8, SBY 5-9

ENABLE option, SBY 5-8

MANDATORY option, SBY 2-17

OPTIONAL option, SBY 2-17, SBY 5-8

REOPEN option, SAD 7-19, SBY 2-18, SBY 5-8

SERVICE option, SBY 5-8

specifying destinations using, SBY 5-7, SBY 5-8

LOG_ARCHIVE_DEST_n parameter

of ALTER SESSION, SQL 7-89, SQL 7-112

of ALTER SYSTEM, SQL 7-112

LOG_ARCHIVE_DEST_STATE_n initialization parameter, SRF 1-57

LOG_ARCHIVE_DEST_STATE_n parameter

of ALTER SESSION, SQL 7-89

of ALTER SYSTEM, SQL 7-113

LOG_ARCHIVE_DUPLEX_DEST initialization parameter, SRF 1-58

specifying destinations using, SAD 7-10, SBR 2-21

LOG_ARCHIVE_DUPLEX_DEST parameter

of ALTER SYSTEM, SQL 7-113

LOG_ARCHIVE_FORMAT initialization parameter, SBR 5-6, SBR 5-9, SBY 5-7, SRF 1-58

LOG_ARCHIVE_FORMAT parameter, PSA 1-11, PSA 13-6, PSA 14-9

same for all instances, PSA 14-9

used in recovery, PSA 14-9

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, SAD 7-20, SRF 1-59

LOG_ARCHIVE_MAX_PROCESSES parameter, SCN 1-18, SCN 8-13

automatic archiving, SCN 360

of ALTER SYSTEM, SQL 7-113

LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, SAD 7-16, SRF 1-60

LOG_ARCHIVE_MIN_SUCCEED_DEST parameter

of ALTER SESSION, SQL 7-89

of ALTER SYSTEM, SQL 7-113

LOG_ARCHIVE_START initialization parameter, SAD 7-8, SBY 5-18, SRF 1-61

bad param destination state, SAD 7-14

setting, SAD 7-8

LOG_ARCHIVE_START parameter, PSA 13-4, SCN 360

automatic archiving, PSA 1-4, PSA 13-4

creating a database, PSA 3-2

LOG_ARCHIVE_TRACE initialization parameter, SAD 7-25, SBY 4-6, SRF 1-62

LOG_ARCHIVE_TRACE parameter

of ALTER SYSTEM, SQL 7-113

LOG_BLOCK_CHECKSUM initialization parameter

enabling redo block checking with, SAD 6-17

LOG_BLOCK_CHECKSUM initialization parameter: obsolete

LOG_BUFFER initialization parameter, SRF 1-63

LOG_BUFFER parameter, SCN 7-6, STU 19-6, STU 20-41

and parallel execution, DWG 18-23

setting, STU 19-8

system global area size and, SCN 7-13

LOG_CHECKPOINT_INTERVAL initialization parameter, SRF 1-63, STU 20-40

recovery time, STU 24-5

LOG_CHECKPOINT_INTERVAL parameter, SCN 354

of ALTER SYSTEM, SQL 7-113

LOG_CHECKPOINT_TIMEOUT

new default value, MIG B-9

LOG_CHECKPOINT_TIMEOUT initialization parameter, SRF 1-64, STU 20-40

compatibility, MIG B-9

recovery time, STU 24-4

LOG_CHECKPOINT_TIMEOUT parameter, SCN 354

inactive instance, PSA 13-15

of ALTER SYSTEM, SQL 7-114

LOG_CHECKPOINTS_TO_ALERT initialization parameter, SRF 1-65

LOG_DEBUG_MULTI_INSTANCE parameter (Oracle Version 6), PSC A-23

LOG_DIRECTORY_CLIENT parameter, NET 12-20, NET C-7

LOG_DIRECTORY_listener_name parameter, NET 12-21, NET C-54

LOG_DIRECTORY_SERVER parameter, NET 12-20, NET C-7

LOG_FILE_CLIENT parameter, NET 12-20, NET C-7

LOG_FILE_listener_name parameter, NET 12-21, NET C-55

LOG_FILE_NAME_CONVERT initialization parameter, RMN 8-8, SBY 5-2, SBY 5-18, SRF 1-65

LOG_FILE_SERVER parameter, NET 12-20, NET C-7

LOG_FILES initialization parameter

number of log files, SAD 6-10

LOG_FILES initialization parameter: obsolete

LOG_FILES parameter

obsolete for 8.1, PSC A-6

LOG_LEVEL parameter, NET 12-22, NET C-73

LOG_SIMULTANEOUS_COPIES initialization parameter: obsolete

LOG_SIMULTANEOUS_COPIES parameter, STU 21-19

LOG_SMALL_ENTRY_MAX_SIZE initialization parameter: obsolete

LOG_SMALL_ENTRY_MAX_SIZE parameter, STU 21-19

LOG_STATS command, NET A-40

LOGFILE clause

of CREATE CONTROLFILE, SQL 7-265

OF CREATE DATABASE, SQL 7-269

logfile clauses

of ALTER DATABASE, SQL 7-9

LOGFILE GROUP clause

of CREATE CONTROLFILE, SQL 7-265

logging

and redo log size, SQL 7-396

debug, OID 5-23

OID Monitor activities, OID 2-31

specifying minimal, SQL 7-395

LOGGING / NOLOGGING, ADL 7-9

LOGGING clause, DWG 18-56

of ALTER INDEX, SQL 7-36

of ALTER MATERIALIZED VIEW, SQL 7-50

of ALTER MATERIALIZED VIEW LOG, SQL 7-60

of ALTER TABLE, SQL 7-152

of ALTER TABLESPACE, SQL 7-178

of CREATE INDEX, SQL 7-301

of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-336

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-322

of CREATE TABLE, SQL 7-395

of CREATE TABLESPACE, SQL 7-421

logging into Oracle

using DCE authentication, OAS 15-3

using SecurID authentication, OAS 7-10

when SecurID is in next code mode, OAS 7-13

with PINPAD card, OAS 7-14

with standard card, OAS 7-13

logging mode

direct-load INSERT, SCN 149

NOARCHIVELOG mode and, SCN 150

parallel DDL, SCN 187, SCN 189

partitions, SCN 11-58

SQL operations affected by, SCN 151

LOGGING_listener_name parameter, NET C-55

logical blocks, SCN 4-2

logical database structures, SCN 1-5

tablespaces, SCN 3-6

logical disks, OID 13-9

logical operators, SQL 3-11

Logical Reads data view, STU 14-9

logical reads limit, SCN 296

Logical Reads/Rows Fetched Ratio data view, STU 14-9

logical records

consolidating multiple physical records using SQL*Loader, SUT 5-36

logical ROWIDs, GTK 3-29

logical rowids, PLS 2-17, SCN 12-20

index on index-organized table, SCN 10-42

physical guesses, SCN 10-42, SCN 12-21

staleness of guesses, SCN 12-22

statistics for guesses, SCN 12-22

logical structure of a database, SAD 1-19

logical structure of database, STU 2-9

LOGICAL_READS_PER_CALL parameter

of ALTER PROFILE, SQL 7-69

of CREATE PROFILE, SQL 7-362

LOGICAL_READS_PER_SESSION parameter

of ALTER PROFILE, SQL 7-69

of ALTER RESOURCE COST, SQL 7-74

of CREATE PROFILE, SQL 7-362

login

superuser

login

anonymously, OID 4-4

user, OID 4-4

login triggers, ADG 11-49, ADG 11-52, ADG 11-53

LOGIN_DENIED exception, PLS 6-5

login_user event attribute, ADG 14-4

LogMiner

compatibility, MIG 9-43

LogMiner utility, SAD 7-26 to SAD 7-35

dictionary file, SAD 7-28

using the, SAD 7-30

using to analyze archived redo logs, SAD 7-26

LogMiner, redo log analysis, GTK 3-40

LOGOFF

triggers on, SQL 7-431

LOGOFF event

triggers on, SQL 7-431

LOGON

triggers on, SQL 7-431

logon, PC_ 3-2

Logon Data Area, PC_ 5-50

LOGON event

triggers on, SQL 7-431

logons

automatic, PCO 3-9

concurrent, PCO 3-4

explicit, PCO 3-5

requirements, PCO 3-2

logs

UNIX, LEG 4-12

Windows NT, LEG 4-12

LOGSOURCE variable

SET statement, SBR 5-6, SBR 5-10

LONG

external datatype, OCI 3-13

LONG columns, DDS 2-33

converting to LOB columns, SQL 2-19, SQL 2-22

restrictions on, SQL 2-20

to store text strings, SQL 2-19

to store view definitions, SQL 2-19

where referenced from, SQL 2-20

LONG data

C language datatype LONG FLOAT, SUT 5-60

exporting, SUT 1-57

importing, SUT 2-59

loading

SQL*Loader, SUT 5-64

loading with direct path load, SUT 8-14

LONG datatype, ADG 3-18, PC_ 4-7, PLS 2-16, SQL 2-19

automatically the last column, SCN 10-8

copying to LOB, MIG 8-2

defined, SCN 12-7

external, PCO 4-7

in triggers, SQL 2-20

maximum length, PLS 2-16

partitioning restriction, SCN 11-12

restrictions, PLS 2-16

restrictions on, ADG 3-18

storage of, SCN 10-8

use in triggers, ADG 13-20

LONG RAW

data

converting from CHAR data, SQL 2-23

datatype, SQL 2-22

external datatype, OCI 3-16

LONG RAW columns, DDS 2-33

LONG RAW datatype, ADG 3-18, ADG 3-20, PC_ 4-9, PLS 2-16, SCN 12-15

converting, PCO 4-49, PLS 2-30

indexing prohibited on, SCN 12-15

maximum length, PLS 2-16

partitioning restriction, SCN 11-12

restrictions on, ADG 3-18

similarity to LONG datatype, SCN 12-15

use in triggers, ADG 13-20

LONG RAW datatypes

external, PCO 4-7

long running operations, statistics generation for, GTK 3-27

LONG VARCHAR

datatype, PC_ 4-10

external datatype, OCI 3-16

LONG VARCHAR datatype, PCO 4-8

DB2, SQL 2-29

SQL/DS, SQL 2-29

LONG VARGRAPHIC datatype (SQL/DS or DB2), SQL 2-30

LONG VARRAW

external datatype, OCI 3-16

LONG VARRAW datatype, PC_ 4-10, PCO 4-8, SUT 5-63

LONG versus LOB datatypes, ADL 1-3

long waits

definition of, STU 20-57

lookup tables, DWG 8-7, DWG 16-2

star queries, DWG 16-2, STU 4-62

LOOP statement, PLS 3-6

forms, PLS 3-6

syntax, PLS 11-102

loopback test, NET 12-4

loops

counters, PLS 3-10

kinds, PLS 3-6

labels, PLS 3-8

loss of

inactive log group, SBR 6-8

LOW_GROUP for Database Resource Manager, SAD 25-12, SAD 25-20

LOW_VALUE statistics, STU 4-26

LOWER function, ADG 5-8, SQL 4-47

lowercase courier, defined, NET xx, PSG xxiii

lowercase significance, SRF 1-3

LPAD function, SQL 4-48

LRECLEN precompiler option, PCO 14-27

LRM, SMS 18-1

LRU, SCN 7-4, SCN 8-8

aging policy, STU 19-33

dictionary cache, SCN 2-4

latch, STU 19-35, STU 19-36, STU 19-41

latch contention, STU 19-41, STU 21-19

shared SQL pool, SCN 7-8, SCN 7-11

LRU list

lock elements, PSC 5-19

LSM

Administrator GUI

overview, LEG 2-10

UNIX, LEG 2-11

Volumes Window, LEG 3-20

Windows NT, LEG 2-13, LEG 2-14, LEG 2-16

administrators

acceptable names, LEG 2-28

modifying on UNIX, LEG 2-29

modifying on Windows NT, LEG 2-30

specifying, LEG 2-27

using wildcard to grant privileges, LEG 2-29

architecture, LEG 2-2, LEG 2-3

bootstrap backups

automatic, LEG 4-8

maintaining information, LEG 4-11

manual, LEG 4-11

server, LEG 4-7, LEG 4-8

Command-Line Utilities Help, Windows, LEG 1-14

components, LEG 1-3

configuration

client resource, LEG 2-20, LEG 2-22, LEG 2-23

overview, LEG 2-2

resource dependencies, LEG 2-3

resource types, LEG 2-2

server resource, LEG 2-24, LEG 2-25, LEG 2-27

storage devices, LEG 3-2, LEG 3-4, LEG 3-6, LEG 3-7, LEG 3-8, LEG 3-9

environment variables, LEG 4-2

features, LEG 1-3, LEG 1-4, LEG 1-5

how LSM backs up data, LEG 2-4

Japanese version for Windows NT, LEG 2-18

overview, LEG 1-2

SAP R/3 integration on Windows NT, LEG 1-7

tracking volume modes, LEG 2-9, LEG 4-3

lsnodes -l -n command, PSG 3-30

lsnr_listener_name parameter, PSG B-5, PSG B-9, PSG C-4

LSNRCTL utility, NET A-3, OID 10-6

command reference, NET A-4 to NET A-25

commands

CHANGE_PASSWORD, NET A-4

DBSNMP_START, NET A-5

DBSNMP_STATUS, NET A-5

DBSNMP_STOP, NET A-6

EXIT, NET A-6

HELP, NET A-7

QUIT, NET A-8

RELOAD, NET A-8

SAVE_CONFIG, NET A-9

SERVICES, NET A-9

SET, NET A-11

SET CONNECT_TIMEOUT, NET A-12

SET CURRENT_LISTENER, NET A-12

SET DISPLAYMODE, NET A-13

SET LOG_DIRECTORY, NET A-13

SET LOG_FILE, NET A-14

SET LOG_STATUS, NET A-14

SET PASSWORD, NET 11-7, NET A-15

SET STARTUP_WAITTIME, NET A-16

SET TRC_DIRECTORY, NET A-17

SET TRC_FILE, NET A-17

SET TRC_LEVEL, NET A-18

SET USE_PLUGANDPLAY, NET A-18

SHOW, NET A-19

SHOW CONNECT_TIMEOUT, NET A-19

SHOW CURRENT_LISTENER, NET A-19

SHOW DISPLAYMODE, NET A-19

SHOW LOG_DIRECTORY, NET A-19

SHOW LOG_FILE, NET A-19

SHOW LOG_STATUS, NET A-19

SHOW PASSWORD, NET A-19

SHOW RAW_MODE, NET A-19

SHOW SAVE_CONFIG_ON_STOP, NET A-19

SHOW STARTUP_WAITTIME, NET A-19

SHOW TRC_DIRECTORY, NET A-19

SHOW TRC_FILE, NET A-19

SHOW TRC_LEVEL, NET A-19

SHOW USE_PLUGANDPLAY, NET A-19

SPAWN, NET A-20

START, NET 11-7, NET A-20

STATUS, NET 11-7, NET A-22

STOP, NET 11-7, NET A-24

TRACE, NET A-24

VERSION, NET A-25

DBSNMP STARTommand, PSG 6-10, PSG B-11

described, NET 4-29

function of and syntax format

SET commands, NET A-3

SHOW command, NET A-3

START command, PSG 3-41

starting a listener, NET 7-5

stopping a listener, NET 7-5

testing the network, NET 11-3

LTRIM function, SQL 4-48

LTYPE precompiler option, PC_ 10-28, PCO 14-27

LU_NAME parameter, NET B-3

LU6.2 parameter

LU_NAME, NET B-3

MDN parameter, NET B-3

LU6.2 protocol, NET B-3

described, NET 4-4

LLU parameter, NET B-3

LLU_NAME, NET B-3

LOCAL_LU parameter, NET B-3

LOCAL_LU_NAME, NET B-3

MODE parameter, NET B-3

parameters for addresses, NET B-3

PARTNER_LU_LOCAL_ALIAS parameter, NET B-3

PARTNER_LU_NAME parameter, NET B-3

PLU parameter, NET B-3

PLU_LA parameter, NET B-3

supporting networks, NET 4-4

supporting topologies, NET 4-4

TP_NAME protocol, NET B-3

TPN parameter, NET B-3

lvalue, PC_ 4-11

LXBCNF executable, NLS B-17

LXEGEN executable, NLS B-12

LXINST executable, NLS B-13