Index_S

---

S

Scalability, 35–36, 432–35

best-case scenario, 450

clustering and, 25

configuring RAC for, 433–35

defined, 9

dependencies, 393

features, 432–33

functionality, 9–10

horizontal, 24, 35, 392

measurement, 449–50

OPS, 113

requirements, 391–92

vertical, 24, 392

Schema management, 328

Scripts, 731–42

capture session statistics, 738–42

database creation, 731–34

initialization parameter file, 734–37

Oracle Net files, 737–38

Scstat command, 636

Securability, 7

Security, 34

Segments, 99–102

data, 99

index, 99

level statistics, 373, 608–9, 610

rollback, 99–101, 151–54

temporary, 101–2

undo, 101

See also Data storage

Semaphores, 476

Sequence generators, 122

Sequences, 275–77

defined, 276

developer creation of, 276

uses, 275–76

Server Management (SRVM), 115

Server parameter file, 324–25

Server-side failover, 142–43

SERVICE_NAMES parameter, 382

SESSION_CACHED_CURSORS parameter, 382, 585

Session data unit (SDU), 554

Session-wide statistics, 374

SGA_MAX_SIZE parameter, 383, 596

Shared pool, 68–69

advice, 588–89

size, 587

statistics, 528

SHARED_POOL parameter, 587

Single-instance configuration, 324

clustered configuration vs., 450–51

in enterprise system, 451

migrating to RAC, 451–55

Single instance transaction behavior, 166–82

autonomous transactions, 175–76

discrete management, 174–75

isolation levels, 176–77

lock management, 177–82

transaction naming, 174

two-phase commit operation, 172–74

Snapshot process, 89

Soft parse, 202

Sorted hash clusters, 253–54

Space management, 327

Speedup curve, 206

Split partition, 273–74

SQL Trace, 548–49

defined, 548

for execution plan, 550

generation, 548

SRVCTL utility, 461, 721–27

ADD subcommand, 725–26

CONFIG subcommand, 724–25

defined, 721–22

DELETE subcommand, 725–26

GET subcommand, 727

MOVE subcommand, 726–27

RENAME subcommand, 725–26

SET subcommand, 726–27

START subcommand, 722–23

STATUS subcommand, 724

STOP subcommand, 723

UNSET subcommand, 726–27

Static views, 334–35, 336

STATISTICS_LEVEL parameter, 383, 578

STATSPACK, 322, 517–34

cache sizes, 528

configuration, 521–26

data collection phase, 518

defined, 517

execution, 526

functionality, 517

installing, 520–21

instance characteristics, 528

instance efficiency percentages, 528

latency values, 645, 646

level 0, 522

level 5, 523

level 6, 523

level 7, 523

level 10, 524

load profile, 528

parameters and values, 525

prerequisites, 518–19

report analysis, 527–34

report generator, 526

reporting, 526–34

reporting phase, 518

scripts, 518, 519–20

scripts interface, 519

scripts list, 520

shard pool statistics, 528

snapshot level, 522–24

snapshots, 521

SQL threshold, 524–26

top 5 timed events, 528

transaction counter, 517

UTLBSTAT/UTLESTAT vs., 517

wait event statistics, 622

workload characteristics, 529

Storage area network (SAN) access model, 58

Storage subsystem, 630–33

Storage system

access pattern standards, 56

architectures, 56–59

NAS access model, 58–59

SAN access model, 58

traditional direct attached access model, 57

Streams Pool, 64, 70

STREAMS_POOL_SIZE parameter, 385

Striping

all files, 56

benefits, 51–52

defined, 51

effects, 52

Subpartitions, 266

Symmetric multiprocessor (SMP) model, 19

advantages, 20

architecture, 19–20

clustered, 25

System change number (SCN), 122, 134–35

checkpoint, 504

Lamport generation scheme, 135

resynchronizing, 135

System global area (SGA), 64, 67–68

database buffer cache, 70–73

defined, 67

divisions, 68

dynamic management, 75

Java pool, 69

large pool, 70

redo log buffers, 73–75

shared information, 67

shared pool, 68–69

size parameters, 75

streams pool, 70

System management, 34

System monitor (SMON), 84

SYSTEM rollback segment, 328

read-only, 94–95

recovery, 499–500

temporary, 94

transportable, 93–94

undo, 95, 101, 603

See also Data storage

---