Optional database monitor SQL view format

 

The following examples show the different optional SQL view format that you can create with the SQL shown. The column descriptions are explained in the tables following each example. These views are not shipped with the server, and create them, if you choose to do so. These views are optional and are not required for analyzing monitor data.

Any rows that have a row identification number (QQRID) of 5000 or greater are for internal database use.

• Database monitor view 1000 - SQL Information
  

• Database monitor view 3000 - Table Scan
  

• Database monitor view 3001 - Index Used
  

• Database monitor view 3002 - Index Created
  

• Database monitor view 3003 - Query Sort
  

• Database monitor view 3004 - Temp Table
  

• Database monitor view 3005 - Table Locked
  

• Database monitor view 3006 - Access Plan Rebuilt
  

• Database monitor view 3007 - Optimizer Timed Out
  

• Database monitor view 3008 - Subquery Processing
  

• Database monitor view 3010 - HostVar & ODP Implementation
  

• Database monitor view 3014 - Generic QQ Information
  

• Database monitor view 3015 - Statistics Information
  

• Database monitor view 3018 - STRDBMON/ENDDBMON
  

• Database monitor view 3019 - Rows retrieved
  

• Database monitor view 3020 - Index advised (SQE)
  

• Database monitor view 3021 - Bitmap Created
  

• Database monitor view 3022 - Bitmap Merge
  

• Database monitor view 3023 - Temp Hash Table Created
  

• Database monitor view 3025 - Distinct Processing
  

• Database monitor view 3026 - Set operation
  

• Database monitor view 3027 - Subquery Merge
  

• Database monitor view 3028 - Grouping
  

• Database monitor view 3030 - Materialized query tables
  

• Database monitor view 3031 - Recursive common table expressions
  

 

Parent topic:

Database monitor: Formats