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] P1-P3 colummn (V$ACTIVE_SESSION_HISTORY) P1-P3 columns (V$SESSION_WAIT) P1RAW column (V$SESSION_WAIT) P1TEXT column (V$SESSION_WAIT) P2RAW column (V$SESSION_WAIT) P2TEXT column (V$SESSION_WAIT) P3RRAW column (V$SESSION_WAIT) packages DBMS_ADVISOR 2nd 3rd 4th 5th cross-checking results 2nd functions and procedures 2nd implementation scripts 2nd sample code listing 2nd DBMS_DATAPUMP [See Data Pump] DBMS_FILE_TRANSFER DBMS_RESOURCE_MANAGER 2nd DBMS_SCHEDULER 2nd DBMS_SQLTUNE 2nd 3rd 4th 5th errors 2nd functions and procedures 2nd sample code listing 2nd DBMS_STREAMS_AUTH 2nd 3rd DBMS_WORKLOAD_REPOSITORY 2nd creating snapshots 2nd deleting snapshots modifying AWR settings 2nd e DBMS_ADVISOR 2nd partitioning application partitioning object partitioning Patch Cache 2nd 3rd patch mangement patch sets applying 2nd obtaining 2nd patch sets, applying 2nd logical databases 2nd 3rd 4th 5th 6th physical databases 2nd 3rd 4th 5th patches Patch Cache 2nd 3rd patching databases 2nd logical databases 2nd 3rd 4th 5th 6th physical databases 2nd 3rd 4th 5th PENDING OFFLINE mode (tablespaces) Perform Recovery screen (OEM) performance computing grid performance analysts performance management ASH (Active Session History) buffer contents, dumping 2nd 3rd documentation fixed-size circular buffers 2nd hidden parameters limitations 2nd OEM Database Control 2nd session-state information 2nd 3rd 4th 5th 6th spot analysis example 2nd 3rd 4th 5th V$ACTIVE_SESSION_HISTORY 2nd 3rd V$ACTIVE_WAIT_HISTORY V$SESSION_WAIT 2nd WRH$_ACTIVE_SESSION_HISTORY 2nd AWR (Automatic Workload Repository) 2nd 3rd baselines 2nd 3rd 4th 5th 6th 7th buffers collections 2nd 3rd compared to STATSPACK 2nd customizing with OEM 2nd DBMS_WORKLOAD_REPOSITORY package 2nd 3rd 4th 5th 6th 7th dependencies 2nd 3rd emergency purging licensing information memory requirements new features 2nd overheads snapshots 2nd 3rd 4th 5th 6th storage and reporting 2nd 3rd 4th 5th suggested settings 2nd views 2nd 3rd WRH$ tables WRI$ tables WRM$ tables performance tuning EXPLAIN PLAN command individual session tuning new features 2nd OEM (Oracle Enterprise Manager) 2nd 3rd advisors 2nd alerts 2nd configuration changes metrics 2nd OEM Database Control 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th Oracle Wait Interface 2nd 3rd 4th performance analysts RMAN (Recovery Manager) 2nd 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 STATSPACK 2nd 3rd 4th 5th 6th extending limitations of 2nd service time 2nd 3rd snapshots wait time Time and Wait model 2nd 3rd 4th 5th 6th 7th views 2nd 3rd ALL_ views DBA_ views STATISTICS_LEVEL initialization parameter 2nd V$ENQUEUE_STATISTICS 2nd V$EVENT_HISTOGRAM 2nd 3rd 4th V$EVENTMETRIC V$FILE_HISTOGRAM 2nd 3rd 4th V$FILEMETRIC V$FILEMETRIC_HISTORY V$METRIC 2nd V$METRIC_HISTORY 2nd V$METRICGROUP 2nd V$METRICNAME 2nd V$OSSTAT 2nd V$SERVICE_EVENT 2nd 3rd V$SERVICE_STATS 2nd V$SERVICE_WAIT_CLASS 2nd V$SERVICEMETRIC V$SERVICEMETRIC_HISTORY V$SERVICES V$SESSION 2nd V$SQL 2nd V$SQLAREA 2nd V$SYS_TIME_MODEL 2nd V$SYSTEM_WAIT_CLASS 2nd V$TEMP_HISTOGRAM performancing tuning ADDM (Automatic Database Diagnostic Monitor) 2nd accessing from OEM 2nd 3rd 4th 5th 6th 7th 8th 9th 10th Additional Information findings 2nd addmrpt.sql script 2nd 3rd 4th ASH data 2nd cases when ADDM analysis is not done cross-verification from advisor views 2nd DBMS_ADVISOR package 2nd 3rd 4th expected I/O response time goal of 2nd idle events 2nd 3rd new features 2nd non-problematic areas 2nd problem areas handled by 2nd recommendations 2nd 3rd rules session management 2nd SQL statements consuming significant time 2nd 3rd 4th 5th SQL statements waiting for locks 2nd views 2nd 3rd 4th PGA (Progam Global Area) PGA Advisor physical backups [See backups] physical databases patching 2nd 3rd 4th 5th PL/SQL Segment Advisor, invoking 2nd platform-independent database installation questions 2nd 3rd 4th 5th PLSQL_CODE_TYPE initialization parameter PLSQL_DEBUG initialization parameter PLSQL_WARNINGS initialization parameter plus (+) sign PMON (Process Monitor process) pools Java pool 2nd large pool 2nd shared pool Streams pool precedence Data Pump operations 2nd PREPARE TO SWITCHOVER command 2nd PRIMARY_ROLE keyword procedures [See DBMS_SQLTUNE package;functions and procedures] Process Monitor process (PMON) processes 2nd background processes Archiver processes (ARCn) ASMB Change Tracking Writer processes (CTWR) Checkpoint process (CKPT) Database Writer process (DBWn) Job Queue processes (Jnnn) Log Writer process (LGWR) Memory Monitor Light process (MMNL) Memory Monitor processes (MMON) ORBn Process Monitor process (PMON) Queue Monitor processes (QMNn) RBAL Recovery Writer process (RVWR) System Monitor process (SMON) centralized job control definition of Oracle processes scheduling 2nd user processes profiled resource usage profiles SQL Tuning Advisor profiles (SQL) 2nd 3rd 4th 5th compared to outlines tracing 2nd 3rd 4th Progam Global Area (PGA) PROGRAM colummn (V$ACTIVE_SESSION_HISTORY) protocols SDP (Sockets Direct Protocol) provisioning PURGE command purging recycle bin |