Index_S

---

S

SBT interface, 307-308

Scheduler, 50

job classes, 52

jobs, 51-52

programs, 51

schedules, 50-51

windows, 52

Segment Advisor, 81-82

server-side load balancing, defined, 395-396

services

allocating workloads, 9

as applications, 179

configuring, 197

creating, 181-185, 196-197

from the database perspective, 179-181

defined, 178

gsd service, 197

limitations on the number of, 197

modifying, 188

prioritizing for availability, 180

Resource Manager and, 181

SRVCTL, 189-197

using DBCA to create, 182-185

using Enterprise Manager to view and manage, 186-189

viewing from within the database, 185-189

as a workload, 178

session-only dynamic parameters, 34

shared everything disk storage, 103

sharing data, 18

spfile, 29-30

modifying parameters in, 139-140

and RAC, 138-140

viewing, 139

split mirror

configuration, 322-323

RMAN backups from, 323-325

SQL Access Advisor, 46, 77

SQL Apply

changing default behavior, 243-244

monitoring progress, 239-240

processes, 238-239

stopping and starting, 239

SQL Tuning Advisor, 76-77

SRVCTL, 189-190

ASM instances, 192-193

creating services using, 196-197

disabling objects, 193-195

managing databases and instances, 191-195

managing services, 195-197

node applications, 190-191

SSH, 113-114

standbys

flash recovery area and, 310-311

logical standby databases, 207-208, 214-220, 238-244, 313

physical standby databases, 206-207, 208-214, 232-238, 314-316

redo logs, 225-226

using Flashback Database for reinstantiation, 353

using RMAN to build, 309-313

static database parameters, 30-33

storage. See Automatic Storage Management

Streams, 18

administering, 388-389

apply process, 361, 370

capture process, 360

configuring for downstream capture, 386-388

configuring replication, 365-372, 374-385

configuring the network, 367

conflict resolution, 371, 372-385

creating a capture process, 368-369

creating a propagation, 369-370

creating substitute key columns, 371

delete conflicts, 373

determining replication set, 363-364

determining replication sites, 364

downstream capture of LCRs, 385-386

enabling supplemental logging, 367-368

foreign key conflicts, 373-374

init.ora parameters, 365-366

instantiating the replica database, 369

local vs. downstream capture, 364

overview, 358-360

propagation, 360-361

putting databases in archivelog mode, 367

queues, 368

removing a Streams configuration from database, 389

replication, 362-388

role of the destination database, 364-365

rules, 361-362

setting up replication administrator users, 366

Streams pool vs. shared pool, 367

throwing the switch, 371-372

uniqueness conflicts, 373

updating conflicts, 372-373

stripe and mirror everything (SAME), 84-85

Summary Advisor, 46

switchover

performing a role transition using, 247-250

performing with logical standby, 250-251

---