1. Index

Index

A  B  C  D  E  H  I  J  L  M  N  O  P  R  S  T  U  W  

A

  • about 13
  • actions
  • Active Session History
  • active sessions 2.1.1
    • captured in Active Session History 2.1.4
  • ADDM
    • See: Automatic Database Diagnostic Monitor
  • Agent-to-Agent file transfer 10.6.2.4
  • alerts
    • clearing 6.3
    • default 6
    • performance 6.1
    • responding to 6.2
  • ASH
    • See: Active Session History
  • ASH Analytics 4.4
  • Automatic Database Diagnostic Monitor
    • about 3.1
    • accessing results 7.3
    • analysis 3.1.1
    • configuring 3.2
    • findings
    • for a multitenant environment 3.1.4
    • for Oracle RAC 3.1.3
    • identifying high-load SQL 11.1
    • Real-Time 8.4
    • recommendations
    • report 3.3
    • reviewing results 3.3
    • running manually
      • analyzing current database performance 7.1
      • analyzing historical database performance 7.2
  • Automatic Memory Management 10.6.1.1
  • Automatic SQL Tuning
  • Automatic Storage Management 10.6.1.2
  • Automatic Workload Repository
  • average active sessions
  • AWR
    • See: Automatic Workload Repository
  • awrinfo.sql script 10.6.1.2
  • AWR Warehouse

B

C

  • clients
  • CONTROL_MANAGEMENT_PACK_ASSESS parameter 2.2.1
  • CPU
  • customizing the Performance page 4.5

D

  • data access paths, optimizing 13
  • Database Home page
    • accessing 1.4
  • database operations
    • composite operations, defined 5.1.1
    • creating 5.2
    • enabling monitoring with initialization parameters 5.1.3
    • identifying an operation 5.1.4
    • monitoring 5.1
    • simple operations, defined 5.1.1
    • viewing on Monitored SQL Executions page 5.3
  • database operations, monitoring
  • database performance
    • alerts 6.1
    • automatic monitoring 3
    • comparing 9
    • current analysis 7.1
    • degradation over time 9
    • historical analysis 7.2
    • manual monitoring 7
    • overview 2
  • Database Resource Manager
  • database statistics
  • database time
    • about 2.1.1
    • and ADDM findings 3.4
    • in calculating average active sessions 4.1
  • database tuning
    • performance degradation over time 9
    • preparing the database 2.2.1
    • proactive tuning 2.2.2
    • reactive tuning 2.2.3
    • real-time performance problems 4
    • SQL tuning 2.2.4
    • tools 1.3
    • transient performance problems 8
    • using the Performance page 4
  • Data Guard 10.6.1.3
  • DBIO_EXPECTED parameter
  • DBMS_ADVISOR package
    • configuring ADDM 3.2.2
    • setting DBIO_EXPECTED 3.2.2
  • DBMS_SQL_MONITOR package 5.2
  • DB time
    • See: database time
  • disk
    • performance problems 4.3.3
    • utilization, monitoring 4.3.3

E

  • Emergency Performance page 8.4
  • ETL 10.3
  • events 6
  • execution plans
  • extract errors, AWR Warehouse 10.5

H

I

  • I/O wait times, monitoring 4.2.2
  • incidents 6
  • index
  • indexes
  • initialization parameter 10.6.1.1
  • In-Memory Column Store (IM column store)
  • instance activity, monitoring 4.2

J

  • job_queue_processes parameter 10.6.1.6

L

  • load errors, AWR Warehouse 10.5

M

N

O

  • Oracle Diagnostics Pack 1.3
  • Oracle performance method
    • about 2
    • pretuning tasks 2.2.1
    • proactive database tuning tasks 2.2.2
    • reactive database tuning tasks 2.2.3
    • SQL tuning tasks 2.2.4
    • using 2.2
  • Oracle Tuning Pack 1.3

P

  • parallel execution, monitoring 4.2.3
  • parameters
  • Performance page
    • about 4
    • customization 4.5
  • performance problems
  • problems, as a type of incident 6

R

S

T

  • throughput, monitoring 4.2.1
  • top actions, monitoring 4.1.5
  • top activity
  • Top Activity page
  • top clients, monitoring 4.1.6
  • top files, monitoring 4.1.8
  • top modules, monitoring 4.1.4
  • top objects, monitoring 4.1.9
  • top PL/SQL, monitoring 4.1.7
  • top services, monitoring 4.1.3
  • top SQL
    • by wait class 11.2.1
    • identifying high-load SQL 11.2
    • in Active Session History report 8.3.3
    • monitoring 4.1.1
  • top working sessions, monitoring 4.1.2
  • transfer errors, AWR Warehouse 10.5
  • troubleshooting, AWR Warehouse 10.5

U

W

  • wait classes
    • grouped wait events 2.1.2
    • viewing high-load SQL by 11.2.1
  • wait events
  • wait time 2.1.1