S

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

Safely Navigating the RBO to CBO Minefield' (paper)
SAMPLE_ID colummn (V$ACTIVE_SESSION_HISTORY)
SAMPLE_TIME colummn (V$ACTIVE_SESSION_HISTORY)
sampling, dynamic 2nd 3rd 4th
scaling for database expansion 2nd
Schedule Backup screen (OEM)
scheduler 2nd
scheduling constraints
scheduling jobs 2nd
schema-export mode (expdp)
schema-import mode (impdp)
scripts
     addmrpt.sql 2nd 3rd 4th
     awrddrpt.sql 2nd 3rd 4th 5th
     awrinfo.sql
     awrinput.sql
     awrrpt.sql 2nd 3rd 4th 5th 6th 7th 8th
     awrrpti.sql 2nd 3rd 4th
     awrsqrpi.sql 2nd 3rd 4th
     catnoqm.sql
     catqm.sql
     dr0inst.sql
     EMCA (Enterprise Manager Configuration Assistant) 2nd
     initxqry.sql
     ordinst.sql
     wk0deinst.sql
     wk0install.sql 2nd
SDP (Sockets Direct Protocol)
searching
     Oracle Text
SECONDS_IN_WAIT column (V$SESSION_WAIT)
security [See also backups]
     access control 2nd
    administrator privileges
         granting 2nd
         revoking
     Data Guard 2nd
         archiving 2nd
         Broker improvements 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th
         configuration management 2nd
         DB_UNIQUE_NAME initialization parameter 2nd
         Flashback Database 2nd 3rd 4th 5th 6th
         flashback database support 2nd
         goals of
         logical databases, patching 2nd 3rd 4th 5th 6th
         logical standby improvements 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th
         new features 2nd 3rd 4th 5th 6th 7th 8th
         physical databases, patching 2nd 3rd 4th 5th
         Real Time Apply 2nd 3rd
         redo transmission authentication and encryption 2nd
         role-based destinations 2nd 3rd 4th
         STARTUP command 2nd
     encryption
     FGA (fine-grained auditing)
     managing
     new features 2nd
     Oracle Label Security
     user authentication
     Virtual Private Database
Segment Advisor 2nd 3rd
     invoking from OEM 2nd 3rd
     invoking from PL/SQL 2nd
     reviewing results of 2nd
segment management 2nd
     data blocks
     data segments
     dictionary-managed tablespaces 2nd
     disabling
     enabling
     extents
     HWM (high-water mark)
     index segments
     LMT (locally managed tablespaces)
     new features 2nd
     Segment Advisor 2nd
         invoking from OEM 2nd 3rd
         invoking from PL/SQL 2nd
         reviewing results of 2nd
     segment resource allocation 2nd 3rd
     segment-shrink operations 2nd 3rd 4th
     temporary segments 2nd 3rd
SEGMENT SPACE MANAGEMENT AUTO clause
SEGMENT SPACE MANAGEMENT MANUAL clause
SELECT statements
     remote stored functions
SELECT_SQLSET function
SELECT_WORKLOAD_REPOSITORY function
selectivity
     CBO (Cost Based Optimizer) 2nd
self-healing (computing grid)
sending
     metrics to third-party tools 2nd
SEQ# column (V$SESSION_WAIT)
Server Control (SRVCTL)
server-generated alerts
servers
     OiD (Oracle internet Directory) Server
     Oracle Name Server
service time 2nd 3rd
service workload management 2nd 3rd
SERVICE_HASH colummn (V$ACTIVE_SESSION_HISTORY)
services
     Cluster Ready Services (CRS)
     CRS (Cluster Ready Services) 2nd
         CRSD daemon
         database-specific resources
         EVMD daemon
         Fujitsu clustering
         installing 2nd 3rd 4th 5th 6th 7th 8th 9th
         OCR (Oracle Cluster Registry)
         OCSSD daemon 2nd
         troubleshooting 2nd
         Veritas
session management
     ADDM (Automatic Database Diagnostic Monitor) 2nd
session statistics 2nd
session-state information 2nd 3rd 4th
     displaying 2nd
     V$ACTIVE_SESSION_HISTORY 2nd 3rd
     V$ACTIVE_WAIT_HISTORY
     V$SESSION_WAIT 2nd
     WRH$_ACTIVE_SESSION_HISTORY 2nd
SESSION_STATE colummn (V$ACTIVE_SESSION_HISTORY)
SESSION_TYPE colummn (V$ACTIVE_SESSION_HISTORY)
sessions
     session-state information 2nd 3rd 4th
         displaying 2nd
         V$ACTIVE_SESSION_HISTORY 2nd 3rd
         V$ACTIVE_WAIT_HISTORY
         V$SESSION_WAIT 2nd
         WRH$_ACTIVE_SESSION_HISTORY 2nd
SET DBID command
SET SERVEROUTPUT command
SET SQLROMPT command 2nd
SET UNTIL command
SET XQUERY command
SET_TASK_PARAMETER function
SGA
     auto-tuned SGA parameters
     sizing 2nd
SGA (System Global Area) 2nd 3rd 4th
     data dictionary cache
     database buffer cache
     Java pool
     large pool
     redo log buffer
     shared pool
     size of 2nd
     Streams pool
SGA Advisor
SGA components
SGA_MAX_SIZE
     tuning 2nd
SGA_TARGET
     tuning 2nd
SGA_TARGET initialization parameter 2nd
shared pool
shared versus local install (RAC) 2nd
SHARED_POOL_SIZE parameter
SHOW command
showbackup option (ocrconfig command)
shrink operations (segments) 2nd 3rd 4th
SHUTDOWN ABORT command
SHUTDOWN IMMEDIATE command
SHUTDOWN NORMAL command
SHUTDOWN TRANSACTIONAL command
shutting down
     ASM (Automatic Storage Management) 2nd
silent installation 2nd 3rd
silent mode (DBUA)
sizing
     redo log files 2nd
     SGA 2nd
SKIP FAILED TRANSACTION clause (ALTER DATABASE START LOGICAL STANDBY APPLY command)
SMON (System Monitor process)
SNAP_IDs
snapshots
snapshots (AWR
snapshots (AWR)
     accessing 2nd 3rd
     creating 2nd 3rd
     deleting
     dropping
     frequency of 2nd
     retention period
snapshots (STATSPACK) 2nd
Sockets Direct Protocol (SDP)
Spatial option (Oracle)
     installation 2nd
SPOOL command 2nd 3rd
spot analysis with ASH (Active Session History) 2nd 3rd 4th 5th
SQL (Standard Query Language)
    accesssing ADDM (Automatic Database Diagnostic Monitor) from
         addmrpt.sql script 2nd 3rd 4th
         DBMS_ADVISOR package 2nd 3rd 4th
SQL (Standard Query Language) tuning
    ADDM report findings
         SQL statements consuming significant time 2nd 3rd 4th 5th
         SQL statements waiting for locks 2nd
     recursive SQL
SQL Access Advisor 2nd 3rd 4th 5th
     APIs 2nd 3rd 4th 5th
     DBMS_ADVISOR package 2nd 3rd 4th 5th
         cross-checking results 2nd
         functions and procedures 2nd
         implementation scripts 2nd
         sample code listing 2nd
     inputs 2nd
     materialized views
     new features
     OEM interface 2nd 3rd 4th 5th 6th 7th 8th
         input screen 2nd 3rd 4th 5th
         recommendation details 2nd
         results screen 2nd
     potential pitfalls 2nd
     steps for use
SQL advisors
     SQL Access Advisor 2nd 3rd
         APIs 2nd 3rd 4th 5th
         DBMS_ADVISOR package 2nd 3rd 4th 5th
         inputs 2nd
         materialized views
         new features
         OEM interface 2nd 3rd 4th 5th 6th 7th 8th
         potential pitfalls 2nd
         steps for use
     SQL Tuning Advisor 2nd
         access path analysis
         APIs 2nd 3rd 4th 5th 6th 7th
         Automatic Tuning Optimizer 2nd 3rd 4th
         DBMS_SQLTUNE package 2nd 3rd 4th 5th
         inputs 2nd
         OEM interface 2nd 3rd 4th
         potential pitfalls 2nd
         SQL profiling
         SQL structure analysis
         statistics analysis
         STS (SQL tuning sets) 2nd 3rd
SQL Apply
     new features 2nd
     RESETLOGS command
     rolling database upgrades 2nd
     support for 2nd
SQL commands [See commands]
SQL Loader client
SQL profiles 2nd 3rd 4th 5th
     compared to outlines
     tracing 2nd 3rd 4th
SQL profiling
     SQL Tuning Advisor
SQL structure analysis
     SQL Tuning Advisor
SQL Tuning Advisor 2nd 3rd 4th 5th 6th 7th
     access path analysis
     APIs 2nd 3rd 4th 5th 6th 7th
     Automatic Tuning Optimizer 2nd 3rd 4th
     DBMS_SQLTUNE package 2nd 3rd 4th 5th
         errors 2nd
         functions and procedures 2nd
         sample code listing 2nd
     inputs 2nd
     OEM interface 2nd 3rd 4th
         Preserved Snapshot Sets
         results screen 2nd
         Schedule Advisor 2nd
         Snapshots
         SQL Tuning Sets
         Top SQL
     potential pitfalls 2nd
     SQL profiling
     SQL structure analysis
     statistics analysis
     STS (SQL tuning sets) 2nd 3rd
SQL tuning sets (STS) 2nd 3rd
SQL*Plus enhancements
     DEFINE command 2nd 3rd
     SET SERVEROUTPUT command
     SET XQUERY command
     SPOOL command 2nd 3rd
     XQUERY command
SQL_CHILD_NUMBER colummn (V$ACTIVE_SESSION_HISTORY)
SQL_ID colummn (V$ACTIVE_SESSION_HISTORY)
SQL_OPCODE colummn (V$ACTIVE_SESSION_HISTORY)
SQL_PLAN_HASH_VALUE colummn (V$ACTIVE_SESSION_HISTORY)
SRVCTL (Server Control)
Standard Edition RAC (Real Application Clusters)
Standby Database Creation Wizard 2nd 3rd 4th 5th
standby databases
     upgrade paths 2nd
STANDBY_LOGFILE keyword
STANDBY_ROLE keyword
START_JOB method
starting up
     ASM (Automatic Storage Management) 2nd
STARTUP command 2nd
STARTUP FORCE command
STARTUP MOUNT command 2nd
STARTUP NOMOUNT command
STARTUP OPEN command
state
     session-state information 2nd 3rd 4th
         displaying 2nd
         V$ACTIVE_SESSION_HISTORY 2nd 3rd
         V$ACTIVE_WAIT_HISTORY
         V$SESSION_WAIT 2nd
         WRH$_ACTIVE_SESSION_HISTORY 2nd
STATE column (V$SESSION_WAIT)
stateless alerts
statements [See commands]
statistics 2nd
     analyzing 2nd
     AWR reports, generating
         awrddrpt.sql script 2nd 3rd 4th 5th
         awrrpt.sql script 2nd 3rd 4th 5th 6th
         awrrpti.sql script 2nd 3rd
         awrsqrpi.sql script 2nd 3rd 4th
    AWR snapshots
         creating
         dropping
         frequency of 2nd
         retention period
     base statistics
     baselines
         creating
         dropping
     collecting 2nd 3rd
         during database upgrades
         recommendations 2nd
         timeouts, preventing
     collecting with AWR
     column statistics
     COMPUTE option 2nd
     cross-checking 2nd
     dictionary statistics
     dynamic sampling 2nd 3rd 4th
     ESTIMATE option 2nd
     frequency of collection
     locking down
     metrics 2nd
         alerts 2nd 3rd
         monitoring and customization 2nd
         thresholds
     new features 2nd
     operating-system statistics
     session statistics 2nd
     statistics levels 2nd
     system statistics 2nd 3rd 4th 5th 6th 7th 8th
         AUX_STATS$ table 2nd
         RAC environments
     table statistics
     time-model statistics 2nd
     wait events 2nd
statistics analysis
     SQL Tuning Advisor
Statistics Workload Repository Facilities (SWRF)
STATISTICS_LEVEL initialization parameter 2nd 3rd 4th 5th 6th 7th 8th
STATSPACK 2nd 3rd 4th 5th 6th
     compared to AWR (Automatic Workload Repository) 2nd
     extending
     limitations of 2nd
     service time 2nd 3rd
     snapshots
     wait time
STOP_ON_WINDOW_CLOSE parameter (GATHER_STATS_JOB command)
storage
     AWR (Automatic Workload Repository) 2nd 3rd 4th 5th
streams
     architecture 2nd
     DBMS_STREAMS_AUTH package 2nd 3rd
     downstream capture 2nd
     stream propagation enhancements 2nd
     streams administrator 2nd 3rd
     streams pool 2nd
     streams-enhanced RAC support 2nd
Streams pool
streams pool 2nd
STREAMS_POOL_SIZE initialization parameter 2nd
STS (SQL tuning sets) 2nd 3rd
SWITCHOVER command
switchovers
     Flashback Database across switchovers
SWRF (Statistics Workload Repository Facilities)
SYS.AQ$KUPC$DATAPUMP_QUETAB view
SYS.KUPC$DATAPUMP_QUETAB view
SYS_TEMP_FBT table
SYSAUX tablespace 2nd 3rd
     creating
System Configuration screen (10g iSQL*Plus workspace)
System Global Area (SGA) 2nd 3rd 4th
     data dictionary cache
     database buffer cache
     Java pool
     large pool
     redo log buffer
     shared pool
     size of 2nd
     Streams pool
System Monitor process (SMON)
system statistics 2nd 3rd 4th 5th 6th 7th 8th
     AUX_STATS$ table 2nd
     RAC environments