SUSE LINUX Enterprise Server 9 Administrators Handbook
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 |