Oracle8i Generic Documentation Master Index
Release 8.1.5

A68826-01

Library

Product

Contents

Index

Prev Top Next


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
LCKN 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
LMDN 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
DBMS_LOB package, SPR 17 - 1
definition, PCO 13-2
deleting, ADL 2-14
DIRECTORY attribute, PCO 13-26
downgrading, MIG 12-19
external, PC_ 16-2, PCO 13-2, PCO 13-7, SQL 2-19
FILEEXISTS attribute, PCO 13-26
FILENAME attribute, PCO 13-26
flushing, ADL 2-15
in index-organized tables, GTK 2-29
in partitioned tables, ADL 6-2
in the object cache, ADL 2-14
indexes for, SQL 7-375
initializing, PC_ 16-8
inline storage, ADL 1-47
internal, PC_ 16-2, PCO 13-2, PCO 13-7, SQL 2-19
internal LOBs
CACHE / NOCACHE, ADL 3-10
CHUNK, ADL 3-11
deleting, ADL 2-14
ENABLE | DISABLE STORAGE IN ROW, ADL 3-12
initializing, ADL 5-93
locators, ADL 1-47
locking before updating, ADL 3-146, ADL 3-182, ADL 3-192, ADL 3-201, ADL 3-217, ADL 3-227
LOGGING / NOLOGGING, ADL 3-10
PCTVERSION, ADL 3-9
setting to empty, ADL 3-8
tablespace and LOB index, ADL 3-9
tablespace and storage characteristics, ADL 3-8
ISOPEN attribute, PCO 13-26
ISTEMPORARY attribute, PCO 13-26
LENGTH attribute, PCO 13-26
loading, SUT 5-99
loading external, SUT 5-99
loading internal LOBs, SUT 5-99
LOB chunk size, GTK 2-34
LOB demo program, PCO 13-29
LOB DESCRIBE use, PCO 13-24
LOB locators, ADL 2-2
locators, ADL 1-47, PC_ 16-3, PCO 13-3
locators for, SQL 7-374
locators in C, PC_ 16-7
modifying physical attributes of, SQL 7-136
number of bytes manipulated in, SQL 7-375
object cache, ADL 2-14
omitting old values for, REP 6-42
Open/Close/IsOpen APIs, GTK 2-34
partitioning of tables with, GTK 2-47
performance, best practices, ADL 2-24
performing SELECT on, ADL 1-49
piecewise operations, ADL 2-5
read consistent locators, ADL 2-2
removing from index-organized tables, MIG 12-7
removing from partitioned tables, MIG 12-20
rules for all statements, PCO 13-8
rules for buffering subsystem, PCO 13-9
rules for statements, PCO 13-10
setting to contain a locator, ADL 1-47
setting to NULL, ADL 3-7
specifying directories for, SQL 7-264
SQL*Loader support, GTK 2-36
storage
in-line, SQL 7-374
outside of row, SQL 7-374
storage characteristics of, SQL 7-373
support for, REP 2-26, REP 3-17, REP A-3
tables
adding partitions, ADL 6-6
creating, ADL 6-3
creating indexes, ADL 6-5
exchanging partitions, ADL 6-5
merging partitions, ADL 6-6
moving partitions, ADL 6-6
partitioning, ADL 6-3
splitting partitions, ADL 6-6
temporary, GTK 2-33, PC_ 16-3, PCO 13-3, PCO 13-8
typical uses, ADL 1-39
updated LOB locators, ADL 2-5
using polling method to read and write, PCO 13-27
value, ADL 1-47
variable width character sets for CLOBs and NCLOBs, GTK 2-34
varying-width character data, ADL 2-25
LOCAL, NET 6-67
LOCAL clause
of CREATE INDEX, SQL 7-284
local connections
multithreaded shared servers, MIG 2-16
local coordinator, DDS 3-7
local currency, SRF 1-78
local currency symbol, NLS 2-20
local databases, SCN 1-35
local index, STU 26-74
local indexes, SCN 11-29, SCN 11-34
bitmap indexes
on partitioned tables, SCN 10-36
parallel query and DML, SCN 10-33
building partitions in parallel, SCN 11-30
equipartitioning, SCN 11-29
managing partitions, SCN 11-59
local instance
node, SPS 18-20
local I/O, SPS 2-3
local jobs
displaying, REP 7-14
editing properties of, REP 7-15
local lock, SPS 7-2
local naming
advantages and disadvantages, NET 3-8
client configuration for, NET 6-20
client load balancing, NET 4-10
configuration file
new parameters in release 8.1, NET 4-15 to NET 4-17
configuration file changes in release 8.1, NET 4-9 to NET 4-12
configuration file sample, NET B-5
configuration file, described, NET 6-6
configuration parameter reference, NET C-31 to NET C-49
configuring, NET 6-12
configuring protocol addresses, NET 6-64
configuring with Net8 Assistant, NET 6-14
configuring with Net8 Configuration Assistant, NET 6-13
connecting with, NET 8-8
connect-time failover, NET 4-12
default configuration, NET 6-13
described, NET 1-4, NET 6-5
establishing a connection with, NET 3-5, NET 8-8
listener configuration for, NET 6-21
recommended for, NET 3-8
server configuration for, NET 6-14
LOCAL option
forcing a checkpoint, SPS 18-18, SPS 21-9
verifying access to files, SPS 6-2
local striping, STU 26-40
local subprogram, PLS 1-18
local users, SQL 7-344, SQL 7-426
LOCAL_LISTENER attribute, NET 7-59
LOCAL_LISTENER parameter, NET 4-23, NET 6-16, NET 6-66, NET 6-67, NET 7-60, NET 9-5, PSC 3-6, PSC 4-17, PSC 4-37, SRF 1-58
LOCAL_LU parameter, NET 6-78
LOCAL_LU_NAME parameter, NET 6-78
locally managed tablespaces, GTK 2-41
compatibility, MIG 8-9
converting to dictionary tablespaces, MIG 12-5
storage characteristics, SQL 7-576
locally partitioned indexes, SQL 7-284
locally-managed tablespaces, SCN 3-8
temporary tablespaces, SCN 3-13
location
rollback segments, SAD 21-7
Location of Included Files, PC_ E-2
Location Transparency, DDS 6-5
location transparency, DDS 2-20, PCO 3-16, SCN 1-35
how provided, PC_ 3-15
using procedures, DDS 2-24
locator, OCI 2-14
for FILEs, OCI 7-4
for LOB datatype, OCI 2-15, OCI 7-2
LOB, DCI 6-3
locator variable, PLS 6-22
locators, ADG 16 - 33, ADG 18 - 20, ADL 1-47
accessing a LOB through, ADL 1-49
cannot span transactions, ADL 1-49
multiple, ADL 2-2
read consistent, ADL 2-2, ADL 2-3, ADL 2-9, ADL 2-12, ADL 2-19, ADL 2-21, ADL 2-22, ADL 2-24
read consistent locators, ADL 2-2
selecting, ADL 1-49
setting column / attribute to contain, ADL 1-47
updated, ADL 2-2, ADL 2-5, ADL 2-10, ADL 2-12, ADL 2-19
lock, PLS 5-41
boundary, SPS 11-18
conversion, SPS 8-4
cost of, SPS 7-7
dictionary cache, SPS 10-5
DML, SPS 7-3, SPS 10-3
enqueue, SPS 7-3
fine grain, SPS 7-5
global, SPS 18-9
group-based, SPS 8-9, SPS 8-10
hashed, SPS 7-5
identifier, SPS 7-8
implementations, PCM, SPS 7-5
instance, SPS 7-2, SPS 7-4
latch, SPS 7-3
library cache, SPS 10-4
local, SPS 7-2
mastering, SPS 8-9, SPS 19-8
mode compatibility, SPS 9-11
mode, and buffer state, SPS 9-10
modes, PLS 5-41
mount lock, SPS 7-2, SPS 10-5
name format, SPS 7-8
names, SRF A-12
non-PCM, SPS 7-3, SPS 7-5
OPS exclusive mode, SPS 7-2
OPS shared mode, SPS 7-2
overriding, PLS 5-47
overview of locking mechanisms, SPS 7-1
ownership by IDLM, SPS 8-10
PCM lock, SPS 9-3, SPS 11-15, SPS 17-11
process-owned, SPS 8-10
released by ROLLBACK statement, PC_ F-101, PCO F-76
request, handling by IDLM, SPS 8-3
rollback segment, SPS 6-9
row, SPS 4-15, SPS 10-3
row cache, SPS 6-6
system change number, SPS 10-4
table, SPS 7-3, SPS 7-5, SPS 7-6, SPS 10-3
transaction, SPS 4-13, SPS 7-2, SPS 10-3
types of, SPS 7-2
using FOR UPDATE clause, PLS 5-47
LOCK ANY TABLE system privilege, SQL 7-500
lock contention, STU 2-11
detecting, SPS 19-3
pinpointing, SPS 19-4
lock conversion, SRF 3-15, SRF 3-18, SRF 3-19, SRF 3-43, SRF 3-72
detecting, SPS 19-3
excessive rate, SPS 19-7
lock element, SPS 7-9
correspondence to locks, SPS 9-15
creation, SPS 9-19
fixed, SRF 1-46
free, SPS 9-20
LRU list, SPS 9-20
mode, SPS 9-20
name, SPS 9-16
non-fixed, SRF 1-46
non-fixed mode, SPS 9-20
number, SPS 9-24
valid bit, SPS 9-20
Lock Manager, PSC 4-4
lock manager wait for remote message wait event, SRF A-38
lock operations
in Cache Fusion, SPS 20-6
lock process (LCK0), SCN 1-20, SCN 8-13
LOCK TABLE command, ADG 8 - 12, SCN 16-4
in distributed transactions, DDS 2-26
LOCK TABLE statement, PCO 3-28, PLS 5-48, SQL 7-520
example, PCO 3-28
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-96
using the NOWAIT parameter, PCO 3-29
lock value block, SPS 10-4
LOCK_NAME_SPACE parameter, SRF 1-59
LOCK_SGA parameter, SCN 7-13, SCN 7-17, SRF 1-59
LOCK_SGA_AREAS parameter, SRF 1-59
locking, OCI 13-12, PC_ 3-24, PCO 3-19, PCO 3-27
automatic
overriding, SQL 7-520
definition of, PC_ 3-16
explicit versus implicit, PC_ 3-24, PCO 3-27
indexed foreign keys and, ADG 5 - 11
manual (explicit), ADG 8 - 11
modes, PCO 3-19
modes of, PC_ 3-16
objects, OCI 13-12
optimistic model, OCI 13-13
overriding default, PC_ 3-24, PCO 3-27
privileges needed, PCO 3-31
privileges needed to obtain, PC_ 3-27
row locking mode, ADG 8 - 19
serializable mode, ADG 8 - 19
table versus row, PC_ 3-24
unindexed foreign keys and, ADG 5 - 10
uses for, PC_ 3-24
using the FOR UPDATE OF clause, PCO 3-27
using the LOCK TABLE statement, PCO 3-28
with FOR UPDATE OF, PC_ 3-24
with the LOCK TABLE statement, PC_ 3-25
locks, SCN 1-32, SCN 27-3
after committing transactions, SCN 17-6
automatic, SCN 1-32, SCN 27-15, SCN 27-19
conversion, SCN 27-16
data, SCN 27-20
duration of, SCN 27-15
deadlocks, SCN 27-17, SCN 27-18
avoiding, SCN 27-19
dictionary, SCN 27-28
clusters and, SCN 27-29
duration of, SCN 27-29
dictionary cache, SCN 27-30
distributed, ADG 8 - 11
DML acquired, SCN 27-27
diagrammed, SCN 27-25
DML lock limit, DML_LOCKS, MIG B-8
DML partition locks, SCN 11-45
escalation does not occur, SCN 27-17
exclusive table locks (X), SCN 27-25
file management locks, SCN 27-30
how Oracle uses, SCN 27-15
in distributed transactions, DDS 3-20
internal, SCN 27-29
job queue, SAD 8-9
latches and, SCN 27-30
LOCK TABLE command, ADG 8 - 12, ADG 8 - 13
log management locks, SCN 27-30
manual, SCN 1-33, SCN 27-31
examples of behavior, SCN 27-32
monitoring, SAD 4-8
object level locking, SCN 13-15
Oracle Lock Management Services, SCN 27-39
overview of, SCN 1-32, SCN 27-3
parallel cache management (PCM), SCN 27-20
parallel DML, SCN 26-42
parse, SCN 16-11, SCN 27-29
privileges for manual acquirement, ADG 8 - 16
rollback segment, SCN 27-30
row (TX), SCN 27-20
block-level recovery, SCN 32-14
row exclusive locks (RX), SCN 27-23
row share table locks (RS), SCN 27-23
share row exclusive locks (SRX), SCN 27-25
share table locks (S), SCN 27-24
share-subexclusive locks (SSX), SCN 27-25
subexclusive table locks (SX), SCN 27-23
subshare table locks (SS), SCN 27-23
table (TM), SCN 27-21
table lock, SRF 1-111
table lock modes, SCN 27-22
tablespace, SCN 27-30
types of, SCN 27-19
user locks, ADG 8 - 21
UTLLOCKT.SQL script, ADG 8 - 22
locks. See table locks.
LOG, NET 11-20, NET 11-22
Export parameter, SUT 1-21, SUT 1-39
Import parameter, SUT 2-26
SQL*Loader command-line parameter, SUT 6-6
log, STU 21-15
log buffer space wait event, SRF A-39
log buffer tuning, STU 2-10, STU 19-7
log entries, SCN 1-12, SCN 32-9
See also redo log files, SCN 1-12
log file
accessibility, SPS 5-9
redo log file, SPS 21-1
specifying for SQL*Loader, SUT 6-6
log file parallel write wait event, SRF A-39
log file sequential read wait event, SRF A-39
log file single write wait event, SRF A-40
log file switch (archiving needed) wait event, SRF A-40
log file switch (checkpoint incomplete) wait event, SRF A-40
log file switch (clearing log file) wait event, SRF A-40
log file switch completion wait event, SRF A-41
log file sync wait event, SRF A-41
log files
after a discontinued load, SUT 5-34
CMADM_PID.LOG, NET 11-22
CMAN_PID.LOG, NET 11-22
CMAN_PID.TRC, NET 11-37
default names for, NET 11-18
example, SUT 4-26, SUT 4-31
Export, SUT 1-21, SUT 1-39
for listener, NET 11-25
Import, SUT 2-26
LISTENER.LOG, NET 11-21
NAMES.LOG, NET 11-21
SQL*Loader, SUT 3-14
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 11-20
using to track errors, NET 11-25
LOG function, SQL 4-21
log history, SPS 14-4, SPS 21-6, SPS 22-9
log management locks, SCN 27-30
log sequence number, SPS 21-5, SPS 21-6
control files, SAD 6-5
requested during recovery, SBR 14-10
log sequence numbers, SCN 1-48
log sequence recovery, SBR 3-29
log switch, SPS 6-5
adding or dropping files, SPS 14-9
ALTER SYSTEM SWITCH LOGFILE, SCN 8-12
archiver process, SCN 1-19, SCN 8-12
closed thread, SPS 21-11
forcing, SPS 21-10, SPS 21-11, SPS 21-16, SPS A-19
global, SPS 21-16
log history, SPS 21-6
log switch/archive wait event, SRF A-41
log switches
description, SAD 6-5
forcing, SAD 6-16
log sequence numbers, SAD 6-5
multiplexed redo log files and, SAD 6-7, SBR 2-14
privileges, SAD 6-16
recovery catalog records, SBR 6-27
waiting for archiving to complete, SAD 6-7, SBR 2-14
log writer process (LGWR), SCN 1-19, SCN 8-9
archiving modes, SCN 32-18
group commits, SCN 8-10
manual archiving and, SCN 32-20
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-12
system change numbers, SCN 17-6
trace file monitoring, SAD 4-11
trace files and, SAD 6-6, SBR 2-13
write-ahead, SCN 8-9
writing to online redo log files, SAD 6-2, SAD 6-3
log writer process (LGWR) tuning, STU 20-21, STU 20-40
LOG_ALLOCATION parameter (Oracle Version 6), SPS A-19, SPS A-21
LOG_ARCHIVE_BUFFER_SIZE initialization parameter, SAD 7-23
LOG_ARCHIVE_BUFFER_SIZE parameter, SRF 1-59
LOG_ARCHIVE_BUFFERS initialization parameter, SAD 7-23
LOG_ARCHIVE_BUFFERS parameter, SRF 1-59
setting, SAD 7-23
LOG_ARCHIVE_DEST initialization parameter, SBR 14-8, SBR 14-10, SBR 14-28, SBR 14-31
specifying destinations using, SAD 7-11, SBR 2-19, SBR 16-10
LOG_ARCHIVE_DEST parameter, SBR 16-7, SPS 22-9, SPS 22-10, SRF 1-60
of ALTER SYSTEM, SQL 7-104
specifying for recovery, SPS 22-10
LOG_ARCHIVE_DEST_n initialization parameter, GTK 2-50
LOG_ARCHIVE_DEST_n initialization parameter, SAD 7-11, SBR 2-19, SBR 14-8, SBR 14-10, SBR 16-6, SBR 16-10
REOPEN option, SAD 7-19, SBR 16-11
LOG_ARCHIVE_DEST_n parameter, SRF 1-61
of ALTER SESSION, SQL 7-83
of ALTER SYSTEM, SQL 7-104
LOG_ARCHIVE_DEST_STATE_n parameter, SRF 1-62
of ALTER SESSION, SQL 7-84
of ALTER SYSTEM, SQL 7-104
LOG_ARCHIVE_DUPLEX_DEST initialization parameter
specifying destinations using, SAD 7-11, SBR 2-19, SBR 16-10
LOG_ARCHIVE_DUPLEX_DEST parameter, SRF 1-63
of ALTER SYSTEM, SQL 7-104
LOG_ARCHIVE_FORMAT initialization parameter, SBR 14-7, SBR 14-10
LOG_ARCHIVE_FORMAT parameter, PSC 6-10, SPS 18-10, SPS 21-5, SPS 22-10, SRF 1-64
same for all instances, SPS 22-10
used in recovery, SPS 22-10
LOG_ARCHIVE_MAX_PROCESSES initialization parameter, SAD 7-20
LOG_ARCHIVE_MAX_PROCESSES parameter, SCN 1-19, SCN 8-12, SRF 1-64
automatic archiving, SCN 32-19
of ALTER SYSTEM, SQL 7-105
LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, SAD 7-17
LOG_ARCHIVE_MIN_SUCCEED_DEST parameter, SRF 1-65
of ALTER SESSION, SQL 7-84
of ALTER SYSTEM, SQL 7-105
LOG_ARCHIVE_START initialization parameter, SAD 7-9
bad param destination state, SAD 7-14
setting, SAD 7-9
LOG_ARCHIVE_START parameter, SCN 32-19, SRF 1-66
automatic archiving, SPS 18-8, SPS 21-3
creating a database, SPS 14-2
LOG_BLOCK_CHECKSUM initialization parameter
enabling redo block checking with, SAD 6-16
LOG_BLOCK_CHECKSUM parameter, SRF 1-66
LOG_BUFFER parameter, SCN 7-6, SRF 1-67, STU 19-6, STU 20-40
and parallel execution, STU 26-26
setting, STU 21-16
system global area size and, SCN 7-13
LOG_CHECKPOINT_INTERVAL initialization parameter, STU 20-39
recovery time, STU 25-4
LOG_CHECKPOINT_INTERVAL parameter, SCN 32-13, SRF 1-67
of ALTER SYSTEM, SQL 7-105
LOG_CHECKPOINT_TIMEOUT initialization parameter, STU 20-39
recovery time, STU 25-3
LOG_CHECKPOINT_TIMEOUT parameter, SCN 32-13, SRF 1-68
inactive instance, SPS 21-10
of ALTER SYSTEM, SQL 7-105
LOG_CHECKPOINTS_TO_ALERT parameter, SRF 1-69
LOG_DEBUG_MULTI_INSTANCE parameter (Oracle Version 6), SPS A-21
LOG_DIRECTORY parameter, NET 11-21, NET C-62
LOG_DIRECTORY_CLIENT parameter, NET 11-20, NET C-8
LOG_DIRECTORY_SERVER parameter, NET 11-20, NET C-8
LOG_FILE parameter, NET 11-21, NET C-62
LOG_FILE_CLIENT parameter, NET 11-20, NET C-9
LOG_FILE_NAME_CONVERT parameter, SRF 1-69
LOG_FILE_SERVER parameter, NET 11-20, NET C-9
LOG_FILES initialization parameter
number of log files, SAD 6-10
LOG_FILES parameter, SRF 1-70
obsolete for 8.1, SPS A-5
LOG_LEVEL parameter, NET 11-22, NET C-78
LOG_SIMULTANEOUS_COPIES parameter, SRF 1-70, STU 21-19
LOG_SMALL_ENTRY_MAX_SIZE parameter, SRF 1-70, STU 21-19
LOG_STATS command, NET A-41, NET A-42
LOGFILE clause
of CREATE CONTROLFILE, SQL 7-246
OF CREATE DATABASE, SQL 7-251
logfile clauses
of ALTER DATABASE, SQL 7-9
LOGFILE GROUP clause
of CREATE CONTROLFILE, SQL 7-247
logging
and redo log size, SQL 7-371
specifying minimal, SQL 7-371
LOGGING / NOLOGGING, ADL 3-10
LOGGING clause
of ALTER INDEX, SQL 7-36
of ALTER MATERIALIZED VIEW, SQL 7-48
of ALTER MATERIALIZED VIEW LOG, SQL 7-56
of ALTER TABLE, SQL 7-142
of ALTER TABLESPACE, SQL 7-166
of CREATE INDEX, SQL 7-282
of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-316
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-303
of CREATE TABLE, SQL 7-371
of CREATE TABLESPACE, SQL 7-395
logging in
when SecurID is in next code mode, OAS 6-16
with PINPAD card, OAS 6-17
with standard card, OAS 6-16
logging into Oracle
using DCE authentication, OAS 21
using SecurID authentication, OAS 6-13
logging mode
direct-load INSERT, SCN 25-5
NOARCHIVELOG mode and, SCN 25-5
parallel DDL, SCN 26-31, SCN 26-32
partitions, SCN 11-58
SQL operations affected by, SCN 25-7
LOGGING option, STU 26-76
logical backups
definition, SBR 3-14
logical blocks, SCN 4-2
logical database, SPS 1-18
logical database structures, SCN 1-5, SCN 1-9
tablespaces, SCN 3-6
logical operators, SQL 3-10
Logical Reads data view, STU 15-9
logical reads limit, SCN 29-17
Logical Reads/Rows Fetched Ratio data view, STU 15-9
logical records
consolidating multiple physical records using SQL*Loader, SUT 5-36
logical rowid, PLS 2-16
logical ROWIDs, GTK 2-29
logical rowids, SCN 12-20
index on index-organized table, SCN 10-39
physical guesses, SCN 10-39, SCN 12-20
staleness of guesses, SCN 12-21
statistics for guesses, SCN 12-21
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-64
of CREATE PROFILE, SQL 7-340
LOGICAL_READS_PER_SESSION parameter
of ALTER PROFILE, SQL 7-64
of ALTER RESOURCE COST, SQL 7-69
of CREATE PROFILE, SQL 7-340
LOGIN_DENIED exception, PLS 6-5
LogMiner, SAD 7-25
LogMiner utility, SAD 7-25, SAD 7-31
dictionary file, SAD 7-27
using the, SAD 7-29, SAD 7-30
using to analyze archived redo logs, SAD 7-25
LogMiner, redo log analysis, GTK 2-40
LOGOFF
triggers on, SQL 7-405
LOGOFF event
triggers on, SQL 7-405
LOGON
triggers on, SQL 7-405
logon, PC_ 3-2
Logon Data Area, PC_ 5-50
Logon Data Area (LDA), PCO 3-16
LOGON event
triggers on, SQL 7-405
logons
automatic, PCO 3-10
concurrent, PCO 3-14
explicit, PCO 3-5
requirements, PCO 3-3
logons cumulative statistic, SRF C-11
logons current statistic, SRF C-11
logs
UNIX, LEG 4-10
Windows NT, LEG 4-10
LOGSOURCE variable
SET command, SBR 14-8, SBR 14-12
LONG
external datatype, OCI 3-13
LONG columns, DDS 2-26
converting to LOB columns, SQL 2-15, SQL 2-18
maximum width, PCO 4-3
restrictions on, SQL 2-15
to store text strings, SQL 2-15
to store view definitions, SQL 2-15
where referenced from, SQL 2-15
LONG data
C language datatype LONG FLOAT, SUT 5-60
exporting, SUT 1-55
importing, SUT 2-61
loading
SQL*Loader, SUT 5-64
loading with direct path load, SUT 8-14
LONG datatype, ADG 4 - 15, PC_ 4-7, PLS 2-15, SAD 12-18, SQL 2-15
automatically the last column, SCN 10-7
defined, SCN 12-7
external, PCO 4-11
in triggers, SQL 2-16
maximum length, PLS 2-15
partitioning restriction, SCN 11-14
restrictions, PCO 4-3, PLS 2-15
restrictions on, ADG 4 - 16
storage of, SCN 10-7
use in triggers, ADG 13 - 20
LONG datatypes
compared with CHAR, PCO 4-3
internal, PCO 4-3
where allowed, PCO 4-3
LONG RAW
data
converting from CHAR data, SQL 2-19
datatype, SQL 2-18
external datatype, OCI 3-15
LONG RAW column
maximum width, PCO 4-4
LONG RAW columns, DDS 2-26
LONG RAW datatype, ADG 4 - 16, ADG 4 - 18, PC_ 4-9, PLS 2-15, SCN 12-14
compared with LONG, PCO 4-4
converting, PCO 4-53, PLS 2-29
indexing prohibited on, SCN 12-15
internal, PCO 4-4
maximum length, PLS 2-15
partitioning restriction, SCN 11-14
restrictions, PCO 4-4
restrictions on, ADG 4 - 16
similarity to LONG datatype, SCN 12-15
use in triggers, ADG 13 - 20
LONG RAW datatypes
external, PCO 4-11
long running operations, statistics generation for, GTK 2-28
LONG VARCHAR
datatype, PC_ 4-10
external datatype, OCI 3-16
LONG VARCHAR datatype, PCO 4-12
DB2, SQL 2-25
SQL/DS, SQL 2-25
LONG VARGRAPHIC datatype (SQL/DS or DB2), SQL 2-25
LONG VARRAW, SUT 5-63
external datatype, OCI 3-16
LONG VARRAW datatype, PC_ 4-10, PCO 4-12
long waits
definition, STU 20-47
lookup tables, STU 28-5
(dimension tables), STU 28-5
star queries, SCN 24-14
loop
counter, PLS 3-10
kinds, PLS 3-6
label, PLS 3-8
LOOP statement, PLS 3-6
forms, PLS 3-6
syntax, PLS 11-98
loopback test, NET 11-4
loosely coupled system
cache consistency, SPS 3-8
characteristics, SPS 3-5
disk access, SPS 3-3
hardware architecture, SPS 3-2, SPS 3-6
tightly coupled nodes, SPS 3-5
loss of
inactive log group, SBR 15-7
LOW_VALUE statistics, SCN 23-52
LOWER function, ADG 6 - 8, SQL 4-22
lowercase significance, SRF 1-3
LPAD function, SQL 4-22
LRECLEN precompiler option, PCO 14-28
LRM, SMS 18-1
LRU, SCN 7-3, SCN 7-4, SCN 8-8
aging policy, STU 19-31
dictionary cache, SCN 2-4
latch, STU 19-34, STU 19-40
latch contention, STU 19-40, STU 21-20
latches, SCN 8-8
shared SQL pool, SCN 7-8, SCN 7-10
LRU list
lock elements, SPS 9-20
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-27
modifying on UNIX, LEG 2-28
modifying on Windows NT, LEG 2-28
specifying, LEG 2-26
using wildcard to grant privileges, LEG 2-27
architecture, LEG 2-2, LEG 2-3
bootstrap backups
automatic, LEG 4-5
maintaining information, LEG 4-9
manual, LEG 4-9
server, LEG 4-5
Command-Line Utilities Help, Windows, LEG 1-14
components, LEG 1-3
configuration
client resource, LEG 2-20, LEG 2-21, LEG 2-22
overview, LEG 2-2
resource dependencies, LEG 2-3
resource types, LEG 2-2
server resource, LEG 2-23, LEG 2-24, LEG 2-26
storage devices, LEG 3-2, LEG 3-4, LEG 3-6, LEG 3-7, LEG 3-8, LEG 3-9
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
lsnr_listener_name parameter, PSC 4-19, PSC B-5, PSC B-10, PSC C-7
LSNRCTL
see Listener Control Utility (LSNRCTL)
LSNRCTL control utility
DBSNMP STARTommand, PSC 5-13, PSC B-12
START command, PSC 4-18, PSC 4-39
STOP command, PSC 4-16, PSC 4-37
LTRIM function, SQL 4-22
LTYPE precompiler option, PC_ 10-28, PCO 14-28
LU_NAME parameter, NET 6-78
LU6.2
described, NET 4-26
parameters for addresses, NET 6-78
supporting networks, NET 4-26
supporting topologies, NET 4-26
lvalue, PC_ 4-11
LXBCNF executable, NLS B-16
LXEGEN executable, NLS B-11
LXINST executable, NLS B-13



Prev

Top

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index