Call: 080-42275527 / +91-9916056387

Monitoring oracle

This section explores the methods used for monitoring all active components of the Oracle database.

 

4-1: DICTIONARY AND V$ VIEWS

  • The dba_, all_ and user_ structures
  • Querying the tables, indexes, and segments views
  • Querying the AWR (STATSPACK) tables

 

4-2: TABLE & INDEX MONITORING

  • Monitoring table extents and fragmentation
  • Using the dba_tables and dba_segments views
  • Monitoring table CBO statistics
  • Monitoring table extents and fragmentation
  • Locating chained rows
  • Monitoring table & index growth
  • Monitoring index usage
  • Monitoring index fragmentation
  • Locating un-used indexes
  • Identifying IOT candidates
  • Reorganizing Indexes with alter index rebuild
  • Dropping Indexes
  • Getting Index Information from the Data Dictionary

 

4-3: WORKLOAD & TREND MONITORING

  • Oracle automated workload tools
  • Using v$bh to monitor buffer activity
  • Using v$sql and v$sql_plan

 

4-4: INSTANCE MONITORING

  • Monitoring with the AWR and STATSPACK
  • Creating a time-series performance report
  • Using www.statspackanalyzer.com
  • Scripts for AWR and STATSPACK
  • Plotting performance data (Ion, Excel)
  • Finding performance trends and signatures

 

4-5: ORACLE ENVIRONMENT MONITORING

  • Displaying and managing Oracle sessions (v$session, v$process)
  • Using AWR to monitor disk, network and CPU consumption
  • Monitoring the alert log
  • Oracle trace/dump files

 

4-6: STATSPACK AND AWR PERFORMANCE MANAGEMENT

  • Installing STATSPACK
  • Running STATSPACK reports
  • Interpreting a STATSPACK report
  • Getting time series reports with STATSPACK
  • Finding performance signatures with STATSPACK
Scroll Up