Oracle8
i
Generic Documentation Master Index
Release 8.1.5
A68826-01
Library
Product
Contents
Index
L
L format element, NLS 2-20
L number format element, SQL 2-36
L variable in SQLDA
how value is set, PC_ 15-8
purpose of, PC_ 15-8
label
block, PLS 2-39
GOTO statement, PLS 3-15
loop, PLS 3-8
label name
maximum length of, PC_ 9-25
label template, LEG C-1
components, LEG C-4
customizing, LEG C-2
Label Template dialog box, LEG C-6
label templates
components, LEG C-10
creating, LEG C-10
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
data conversion, ADG 4 - 28
MLSLABEL datatype, ADG 4 - 23
volume, LEG C-5
Lamport SCN generation, SPS 4-7
LAN environments
vulnerabilities of, OAS 1-2
Language, DDS A-7
language
database default language, SRF 1-80
LANGUAGE clause
of CREATE FUNCTION, SQL 7-271
of CREATE PROCEDURE, SQL 7-335
of CREATE TYPE, SQL 7-416
of CREATE TYPE BODY, SQL 7-424
LANGUAGE parameter, DDS A-7
LANGUAGE parameter (Oracle Version 6), SPS A-21
Language support, NLS 1-3
language support, PCO 1-3
Export, SUT 1-53
Import, SUT 2-55
large data sets, DDS 7-2
large files
operating system dependencies, MIG 8-50
large object (LOB) datatypes, PLS 2-21
large object types
allowed in replicated tables, REP 2-26
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-54
overview of, SCN 1-16
LARGE_POOL_MIN_ALLOC parameter, SRF 1-53
LARGE_POOL_SIZE, STU 20-54
LARGE_POOL_SIZE initialization parameter
changes in release 8.1, MIG 6-3,
MIG 7-34
parallel execution allocation, MIG B-9
LARGE_POOL_SIZE parameter, SRF 1-53,
STU 26-12
LAST collection method, PLS 4-23
LAST_DAY function, SQL 4-19
latch, SPS 7-3,
SPS 10-5
latch activity wait event, SRF A-36
latch free wait event, SRF A-36
latches
contention, STU 2-12,
STU 18-9
described, SCN 27-30
LRU, SCN 8-8
redo allocation latch, STU 21-16
redo copy latches, STU 21-16
latency, SPS 1-11,
SPS 1-13,
SPS 2-2,
SPS 2-12,
SPS 3-3
latest timestamp
conflict resolution method, RAR 6-7,
REP 6-20
LBS
SeeLOB Buffering Subsystem
LCD, SMS 19-1
LCK0 background process, SCN 1-20,
SCN 8-13
LCK
N
process, PSC 1-10
LCKn process, SPS 5-5,
SPS 9-5
on multi-instance database, SPS 1-16
role in recovery, SPS 22-5
LDA, PC_ 5-50,
PCO 3-16
remote and multiple connections, PC_ 5-51
setup for OCI rel 8, PC_ 5-50
LDAP, GTK 2-73,
GTK 2-74
leading whitespace
definition, SUT 5-82
trimming and SQL*Loader, SUT 5-85
leaf blocks, SCN 10-28
leaf-level attributes, SCN 14-18
leaf-level scalar attributes, SCN 14-18
LEAST function, SQL 4-20
least recently used (LRU) algorithm
database buffers and, SCN 7-3
dictionary cache, SCN 2-4
full table scans and, SCN 7-4
latches, SCN 8-8
shared SQL pool, SCN 7-8,
SCN 7-10
least recently used list (LRU), STU 18-8
Legato Storage Manager, GTK 3-6
length
specifying record length for export, SUT 1-23,
SUT 2-27
LENGTH function, SQL 4-20
length indicator
determining size, SUT 5-78
length of a numeric field, SUT 5-16
length subfield
VARCHAR DATA
SQL*Loader, SUT 5-62
LENGTHB function, SQL 4-21
length-value pair specified LOBs, SUT 5-105
less than tests, SQL 3-5
level 0 incremental backups, SBR 4-39
LEVEL clause
of ALTER DIMENSION, SQL 7-24
of CREATE DIMENSION, SQL 7-260
LEVEL pseudocolumn, PLS 5-4,
SQL 2-53,
SQL 7-548
and hierarchical queries, SQL 2-53
LEVEL pseudocolumns, PCO 4-7
levels
adding to a dimension, SQL 7-26
dropping from a dimension, SQL 7-26
of dimensions, defining, SQL 7-260
lexical unit, PLS 2-2
LFI, SMS 20-1
LGWR, SAD 4-11
LGWR background process,
SCN 8-9
See also
log writer process
LGWR process, PSC 1-10,
SPS 5-5,
SPS 7-6
log history, SPS 21-6
LGWR_IO_SLAVES parameter
initialization parameters
LGWR_IO_SLAVES, SRF 1-54
libraries
creating, SQL 7-297
foreign function
exporting, SUT 1-55
importing, SUT 2-60
granting
system privileges on, SQL 7-497
re-creating, SQL 7-297
removing from the database, SQL 7-458
library, PLS 8-1
alias, DCI 4-2
shared, DCI 2-7,
DCI 4-2
library cache, SCN 7-6,
SCN 7-7,
SCN 7-10,
STU 2-10
memory allocation, STU 19-15
tuning, STU 19-13
library cache invalidation enqueue, SRF B-2
library cache load lock wait event, SRF A-37
library cache lock, SPS 10-4
library cache lock enqueue, SRF B-2
library cache lock wait event, SRF A-37
library cache pin enqueue, SRF B-2
library cache pin wait event, SRF A-38
library units
remote dependencies, ADG 10 - 28
library units.
See
Java schema objects
LICENSE_MAX_SESSIONS parameter, SCN 29-20,
SRF 1-54
changing while instance runs, SAD 23-4
of ALTER SYSTEM, SQL 7-103
setting, SAD 23-4
setting before database creation, SAD 2-12
LICENSE_MAX_USERS parameter, SRF 1-55
changing while database runs, SAD 23-6
of ALTER SYSTEM, SQL 7-103
setting, SAD 23-6
setting before database creation, SAD 2-12
LICENSE_SESSION_WARNING parameter
setting before database creation, SAD 2-12
LICENSE_SESSIONS_WARNING parameter, SCN 29-20,
SRF 1-55
changing while instance runs, SAD 23-4
of ALTER SYSTEM, SQL 7-103
setting, SAD 23-4
licenses
maximum sessions, SRF 1-54
maximum users, SRF 1-55
warning for concurrent user sessions, SRF 1-55
licensing
complying with license agreement, SAD 2-12,
SAD 23-2
concurrent usage, SAD 23-2,
SCN 29-20
named user, SAD 23-2,
SAD 23-5,
SCN 29-21
number of concurrent sessions, SAD 2-13
privileges for changing named user limits, SAD 23-6
privileges for changing session limits, SAD 23-5
session-based, SAD 23-2
viewing current limits, SCN 29-20
viewing limits, SAD 23-6
Lightweight Directory Access Protocol. See LDAP.
LIKE, SCN 23-5
LIKE comparison operator, PLS 2-45,
PLS 5-6
LIKE conditions, SQL 5-17
LIKE operator, NLS 4-9,
SQL 3-7
LIMIT collection method, PLS 4-22
limitations of SSL, OAS 9-11
limits
composite limits, SAD 23-19
concurrent usage, SAD 23-2
resource limits, SAD 23-19
session, high water mark, SAD 23-3
limits on the database, SRF 4-2
line continuation, PCO 2-13
lines
continuation, PC_ 2-14
maximum length, PC_ 2-14
LINES precompiler option, PC_ 10-27
linguistic definitions
supported, NLS A-17
linguistic definitions, NLS, NLS A-16,
NLS A-17
linguistic indexes, NLS 2-26
linguistic sorts, NLS 2-25,
SRF 1-81
controlling, NLS 4-8
link
database link, PC_ 3-14
link layer, described, NET 2-8
link qualifiers
master groups, REP 2-20
link specifications
incomplete, REP 7-33
linking, OCI 2-36,
PC_ 2-18,
PCO 2-28
issues, OCI 1-25
modes, OCI 1-25
on UNIX, PC_ 1-10
on VMS, PC_ 1-10
support for single-task, OCI 1-27
two-task, PC_ 2-18
Linking in an XA Library, PC_ E-3
links, SCN 33-6,
SPS 5-9
links, database, PCO 3-15
LIST CHAINED ROWS clause
of ANALYZE, SQL 7-192
LIST CHAINED ROWS option, SAD 20-9
list command (RMAN), SBR 4-20,
SBR 11-76
incarnation of database option, SBR 6-7
list separator, NLS 2-29
LISTENER, NET 1-3,
NET 4-22,
NET 6-6
Listener, DDS 6-2,
NET 7-59
listener, NET 6-71
adding an address, NET 7-3
adjusting queue size for, NET 3-14,
NET 6-70,
NET 8-13
Audit Trail and log files for, NET 11-25
client connections, described, NET 2-28
configuration file, NET 1-3
new parameters in release 8.1, NET 4-18
configuration file changes in release 8.1, NET 4-13
configuration file sample, NET B-6
configuration file, described, NET 6-6
configuration for Oracle Names, NET 6-40
configuration parameter reference, NET C-50 to
NET C-64
configuration with local naming, NET 6-21
configuring, NET 6-62 to
NET 6-75,
PSC 4-13
configuring a name, NET 6-69
configuring a non-default port for IIOP clients, NET 4-23,
NET 7-59
configuring a non-default port for Net8 clients, NET 4-23,
NET 6-67
configuring address for Oracle Connection Manager, NET 7-46
configuring for external procedures, NET 6-71,
NET 7-65,
NET 7-66
configuring for failover, PSC 4-36
configuring for host naming, NET 6-8
configuring for Oracle Enterprise Manager, NET 2-29,
NET 4-13,
NET 4-23,
NET 5-20,
NET 6-71,
NET 7-12,
NET C-40
configuring global database name, NET 6-71,
NET C-58
configuring listener addresses, NET 6-76
configuring lsnr_listener_name parameter, PSC B-10
configuring Oracle Home Directory, NET 6-72
configuring Oracle System Identifier (SID), NET 6-71
configuring protocol addresses, NET 6-64
configuring tns_admin parameter, PSC B-9
configuring to prespawn dedicated servers, NET 6-73
configuring with the Net8 Configuration Assistant, NET 4-22
configuring with the Oracle Database Configuration Assistant, NET 4-23
connections for IIOP clients, NET 7-52,
NET 7-54
connect-time failover, NET 2-29,
NET 4-12
control utility, see Listener Control Utility (LSNRCTL)
default configuration, NET 6-62
deleting protocol address, NET 7-5
handling concurrent connections, NET 6-70
in a typical Net8 connection, diagram, NET 2-28
in instance registration, SPS 18-31
increasing queuesize, NET 3-14,
NET 6-70
instance registration, NET 2-27
load balancing, NET 2-30,
SPS A-3
log files, NET 11-15,
NET 11-21
partial address listen, NET 2-23
service registration, NET 2-27
starting, NET 8-5,
PSC 4-18,
PSC 4-39
stopping, PSC 4-16,
PSC 4-37
stopping, error TNS-01169, NET 8-14
testing, NET 8-18
trace files, NET 11-36
transparent application failover, NET 2-29
LISTENER (LIS or LIST) attribute, NET 7-60,
NET 9-5
listener addresses, NET 6-76
LISTENER attribute, NET 4-23,
NET 6-66,
NET 7-59,
NET 7-60
Listener Control Utility (LSNRCTL)
command reference, NET A-4 to
NET A-30
described, NET 8-15
function of and syntax format, NET A-3
SET PASSWORD command, NET 8-14
starting a listener, NET 6-64,
NET 8-5
stopping a listener, NET 6-64
testing the network
listener endpoint, setting on server when configuring SSL, OAS 9-29
listener load balancing, using TRCROUTE, NET 8-24
listener processes, SCN 6-6,
SCN 8-14
service names, SCN 6-6
LISTENER.LOG file contents, NET 11-18
LISTENER.ORA
parameters, description, OAS 13-4
see listener, configuration file
LISTENER.ORA file, PSC 4-12,
PSC 5-7,
PSC B-9,
SCN 6-6
configuring, PSC 4-13
configuring for failover, PSC 4-36
default configuration, PSC 4-14
how used for auto-discovery, PSC C-6
SID_DESC parameter, PSC C-6
SID_LIST_
listener_name
parameter, PSC 4-12,
PSC 4-37,
PSC C-6
SID_NAME parameter, PSC C-6
LISTENER.TRC file contents, NET 11-32
listening queue, STU 22-3
listing backups and copies, SBR 7-3
listing database links, DDS 2-20
listObjList clause (RMAN), SBR 11-84
lists
attributes, OCI 6-18
lists, generating, SBR 7-2 to
SBR 7-4
listing backups and copies, SBR 7-3
scenarios, SBR 7-10
LITDELIM option
purpose, PCO 14-27
LITDELIM precompiler option, PCO 2-14,
PCO 14-27
literal, PLS 2-7
Boolean, PLS 2-8
character, PLS 2-8
numeric, PLS 2-7
string, PLS 2-8
syntax, PLS 11-93
literal invocation
constructor methods, SCN 14-4
literals
in SQL statements and functions, SQL 2-2
in SQL syntax, SQL 2-2
LLU parameter, NET 6-78
LLU_NAME parameter, NET 6-78
LM_LOCKS parameter, PSC 6-11,
PSC 6-12,
SPS 15-17,
SPS 15-18,
SPS 16-2,
SPS 18-11,
SPS 18-12,
SPS A-6,
SRF 1-56
LM_PROCS parameter, PSC 6-11,
PSC 6-12,
SPS 18-11,
SPS 18-12,
SPS A-6,
SRF 1-57
LM_RESS parameter, PSC 6-11,
PSC 6-12,
SPS 15-17,
SPS 15-18,
SPS 16-2,
SPS 16-5,
SPS 18-11,
SPS 18-12,
SPS A-6,
SRF 1-57
LMD0 process, PSC 1-10
LMD
N
process, PSC 1-15
LMDn process, SPS 5-5,
SPS A-8
definition, SPS 7-7
LMON process, PSC 1-10,
PSC 1-15,
SPS 5-5,
SPS A-8
definition, SPS 7-7
LN function, SQL 4-21
LNAME precompiler option, PC_ 10-28,
PCO 14-27
LNPROC
VMS link script, PC_ 1-10
LOAD, PSC 4-25,
PSC 4-41
SQL*Loader command-line parameter, SUT 6-6
Load, NET 5-25
load
parallel, STU 11-4,
STU 26-68
load balancing, SPS 12-5,
SPS A-13,
STU 11-6,
STU 20-22
client connections among listeners, SPS 18-32
client load balancing, NET 2-30,
NET C-41
connection load balancing, NET 2-30
in parallel execution, SPS 18-33
multi-threaded server, STU 23-5
Net8, MIG 8-47
of connections among nodes, SPS 18-32
load balancing, described, NET 2-30
LOAD_BALANCE parameter, NET 2-30,
NET 4-10,
NET 4-17,
NET 5-11,
NET 7-11,
NET C-41,
PSC 4-25,
PSC 4-41
configuring client load balancing, SPS 18-32
LOAD_TNSNAMES command, NET 5-25,
NET 5-28,
NET 6-43,
NET A-41
loading
datafiles containing tabs
SQL*Loader, SUT 5-50
Oracle objects, ADG 18 - 41
variable-length data, SUT 4-5
loading combined physical records, SUT 4-15
loading delimited, free-format files, SUT 4-11
loading fixed-length data, SUT 4-8
loading negative numbers, SUT 4-15
loading Oracle service names into CDS, OAS 13-16
loading TNSNAMES.ORA into Oracle Names, NET 5-28,
NET 6-43
loadjava and dropjava, GTK 2-21
loadjava utility, ADG 1 - 37
LOB, OCI 7-2
amount and offset parameters, OCI 15-108
attributes of transient objects, OCI 7-6
binding, OCI 5-10
buffering, OCI 7-11
callbacks, OCI 7-13
character sets, OCI 15-108
creating, OCI 7-4
creating temporary, OCI 7-18
DDL for, DCI 6-2
defining, OCI 5-17
duration of temporary, OCI 7-18
example of temporary, OCI 7-19
external, DCI 6-2
external datatypes, OCI 3-18
external procedure use, DCI 6-11
fetching data, OCI 4-15
fixed-width character sets, OCI 15-108
freeing temporary, OCI 7-18
internal, DCI 6-2
locator, DCI 6-3,
OCI 2-15
modifying, OCI 7-4
OCI functions, OCI 7-6
OCI use with, DCI 6-6
overview, DCI 1-9
storage characteristics, SQL 7-370
temporary, OCI 7-17
triggers and, DCI 6-12
value, DCI 6-2
varying-width character sets, OCI 15-108
LOB (large object) datatypes, PLS 2-21
LOB and precompiler datatypes, PCO 13-21
LOB APPEND SQL statement, PC_ F-72
LOB APPEND statement, PC_ 16-12,
PCO F-57
LOB ASSIGN SQL statement, PC_ F-73
LOB ASSIGN statement, PC_ 16-12,
PCO F-58
LOB Buffering System (LBS)
LOB CLOSE SQL statement, PC_ F-73
LOB CLOSE statement, PC_ 16-13,
PCO F-58
LOB columns
difference from LONG and LONG RAW, SQL 2-19
initializing, SQL 2-20
LOB COPY SQL statement, PC_ F-74
LOB COPY statement, PC_ 16-14,
PCO F-59
LOB CREATE statement, PCO F-59
LOB CREATE TEMPORARY SQL statement, PC_ F-74
LOB CREATE temporary statement, PC_ 16-15
LOB data, SUT 1-9
compression, SUT 1-16
Export, SUT 1-55
LOB data in delimited fields, SUT 5-100
LOB data in length-value pair fields, SUT 5-101
LOB data in predetermined size fields, SUT 5-99
LOB datatype
support in OO4O, ADG 1 - 17
use in triggers, ADG 13 - 20
LOB datatypes, SCN 12-12,
SQL 2-19
BFILE, SCN 12-14
BLOBs, SCN 12-13
CLOBs and NCLOBs, SCN 12-13
default logging mode, SCN 25-7
NOLOGGING mode, SCN 25-7
restrictions
parallel DDL, SCN 26-31
parallel DML, SCN 26-44
LOB DESCRIBE SQL statement, PC_ F-75
LOB DESCRIBE statement, PCO F-60
LOB DISABLE BUFFERING SQL statement, PC_ F-76
LOB DISABLE BUFFERING statement, PC_ 16-16,
PCO F-61
LOB ENABLE BUFFERING SQL statement, PC_ F-77
LOB ENABLE BUFFERING statement, PC_ 16-16,
PCO F-62
LOB ERASE SQL statement, PC_ F-77
LOB ERASE statement, PC_ 16-17,
PCO F-62
LOB FILE CLOSE ALL SQL statement, PC_ F-78
LOB FILE CLOSE ALL statement, PC_ 16-17
LOB file close all statement, PC_ 16-17
LOB FILE CLOSE statement, PCO F-63
LOB FILE SET SQL statement, PC_ F-79
LOB FILE SET statement, PC_ 16-18,
PCO F-64
LOB FLUSH BUFFER SQL statement, PC_ F-79
LOB FLUSH BUFFER statement, PC_ 16-19,
PCO F-64
LOB FREE TEMPORARY, PCO F-65
LOB FREE TEMPORARY SQL statement, PC_ F-80
LOB FREE TEMPORARY statement, PC_ 16-19
LOB functions, OCI 15-107
server roundtrips, OCI C-2
LOB index clause
of ALTER TABLE, SQL 7-132
of CREATE TABLE, SQL 7-375
LOB LOAD FROM FILE statement, PC_ 16-20
LOB LOAD SQL statement, PC_ F-80
LOB LOAD statement, PCO F-65
LOB locator, OCI 2-15,
OCI 7-2
attributes, OCI A-25
lob locator, PLS 2-21
LOB locators, SQL 2-19
LOB locators cannot span transactions, ADL 1-49
LOB OPEN SQL statement, PC_ F-81
LOB OPEN statement, PC_ 16-21,
PCO F-66
LOB READ SQL statement, PC_ F-82
LOB READ statement, PC_ 16-22,
PCO F-67
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-12
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-16
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
of ALTER MATERIALIZED VIEW, SQL 7-48
for partitions, SQL 7-132
of ALTER MATERIALIZED VIEW, SQL 7-45
of ALTER TABLE, SQL 7-131
of CREATE MATERIALIZED VIEW / SNAPSHOT, SQL 7-300
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-302
of CREATE TABLE, SQL 7-362,
SQL 7-373
LOB support in OO4O, ADG 1 - 17
LOB TRIM SQL statement, PC_ F-82
LOB TRIM statement, PCO F-67
LOB WRITE SQL statement, PC_ F-83
LOB WRITE statement, PCO F-68
LOBFILEs, SUT 3-22,
SUT 5-99,
SUT 5-102
example, SUT 4-39
LOBS
external (BFILEs), ADL 1-2
logging attribute of, SQL 7-371
tablespace for
defining, SQL 7-370
temporary, STU 19-30
LOBs, SUT 3-20
access methods, PC_ 16-5,
PCO 13-5
accessing through a locator, ADL 1-49
advantage of buffering, PCO 13-4
attributes and COBOL types, PCO 13-24
BFILES, PC_ 16-2
buffering
caveats, ADL 2-15
pages can be aged out, ADL 2-19
buffering operations, ADL 2-17
buffering subsystem, ADL 2-14
buffering system, PC_ 16-10
CHUNKSIZE attribute, PCO 13-26
compared with LONG and LONG RAW, PCO 13-3
compatibility, MIG 8-11,
MIG 8-25
convert LONG to LOB, GTK 2-33
DBMS_LOB API to append data to LOB, GTK 2-34