Index_L

---

L

LAN interconnects, 39–40

Large pool, 70

Latches, 179–82, 581

free, 625

library cache, 625–26

Latencies

interconnect, 634, 638

STATSPACK values, 645, 646

Law of Diminishing Returns, 4

Least recently used (LRU) area, 70, 71, 72

Linux

RAC implementation, 681–97

watchdog daemon, 399–400

watchdog process, 687

Listener.ora file, 321

Listeners, 124

control utility, 324

load balancing, 432

List partitioning, 263–64

defined, 263

table use, 263

See also Partitioning

LMON trace analysis, 492

Load balancing, 31

starting, 329–30

system statistics information, 376

tuning, 455

verifying, 330

Instance tuning, 586–606, 639–44

defined, 587

log management, 598–602

memory management, 587–98

undo management, 602–6

See also Performance tuning

INSTANCE_TYPE parameter, 385

Intelligent agent, 322–23

Interconnect failure, 480–83

alert log, 481

manual intervention, 483

recovery and, 480

See also Failure(s)

Interconnects, 37–47, 46, 633–39

computer (CI), 38–39

configuration information, 635–36

defined, 37

Gigabit Ethernet, 41–44

identification, 708

illustrated, 38

InfiniBand, 44–46

LAN, 39–40

latencies, 634, 638

for polling, 47

public, 716

redundant private high-speed, 635

size limitation, 638

strengths, 37

VI, 46

See also Clusters

Internal locks, 179–82

Inter-operation parallelism, 213

Interprocess communication protocol (ICP), 124

Intra-operation parallelism, 212, 213

I/O

activity screen, 631

LOG_CHECKPOINT_TIMEOUT parameter, 380

Log files

evaluation of, 452–53

mining, 510–12

redo, 78–79, 149–50

Log force at commit algorithm, 477

Logging

logical, 472

physical, 472

physiological, 472

write-ahead, 476–77

Logical I/O (LIO), 580

Logical logging, 472

Log management, 598–602

FAST_START_MTTR_TARGET, 599–600

V$INSTANCE_RECOVERY, 600–601

V$MTTR_TARGET_ADVICE, 601–2

See also Instance tuning

LogMiner, 8, 508–13

archive redo log files, 509

components, 509–10

components illustration, 508

defined, 508

dictionary in flat file, 510

dynamic views, 509–10

implementation, 508

mining log files, 510–12

OEM create query interface, 512

OEM options interface, 513

online catalog, 510

online redo log files, 509

PL/SQL packages, 509

in RAC environment, 513

starting, 510

uses, 510

using, 510–13

LOG_PARALLELISM parameter, 381

Log writer (LGWR), 87–88

defined, 87–88

situations triggering, 88

client, 406–7

listener, 432

Load profile, 528

Local area networks (LANs)

Ethernet, 40

polling, 48

See also LAN interconnect

Local indexes, 241, 268

LOCAL_LISTENER parameter, 541

Locally managed tablespaces (LMT), 92–93, 238

benefits, 237–38

migrating to, 241

LOCK_CHECKPOINTS_TO_ALERT

parameter, 380

Lock manager

identifiers, 351

server process, 89

Lock process (LCK), 128

Locks

blocked, 364

blocking, 364

categories, 178–82

conversions, 658

DDL, 178–79

descriptions, 367

DML, 178

enqueue state objects, 357

internal, 179–82

latches, 179–82, 581

management, 177–82

mode compatibility matrix, 181

modes, 181–82

PCM, 363

protecting multiple buffers, 364

RAC structure, 181

request statistics, 358

Lock structure, 136–37

LOG_BUFFER parameter, 380

LOG_CHECKPOINT_INTERVAL parameter, 380

See also Background processes

Loosely coupled configuration, 25–36

availability, 31–32

common system disk, 29

CPU processor composition, 30

defined, 26

disaster tolerance, 34

failover, 34–35

growth potential/scalability, 35–36

operating system/file system flexibility, 30–31

resource sharing, 28–29

resource utilization, 29

system management and security, 34

tightly coupled vs., 27

user environment, 31

---