SQL

• MDA_BLOCKTREE
  Blocked processes
• MDA_CACHEDSQLTEXT
  SQL text of cached statements
• MDA_CACHEDSTMT
  Cached statement statistics
• MDA_PROCBATCH
  Current executing batches
• MDA_PROCSQLPLAN
  Parsed SQL plans for current executing statements
• MDA_PROCSQLPLANTEXT
  SQL plan text for current executing statements
• MDA_PROCSQLTEXT
  SQL text of current executing statements
• MDA_PROCSTACK
  Procedure stack for current executing statements
• MDA_PROCSTMT
  Current executing statements
• MDA_RECENTSQLTEXT_PIPE
  SQL text of recently executed statements
• MDA_RECENTSTMT_PIPE
  Recently executed statements
• MDA_STMTCACHE
  Summary statistics about the statement cache
• MDA_SYSPROCS
  Procedure activity