X100 Query Profiling System Catalogs
The predefined views (iivwquery, iivwprof, iivwprof_last) that provide profiling information on X100 queries are based on the following system catalogs:
• iivwprof_query
• iivwprof_op
• iivwprof_io
• iivwprof_stage
• iivwprof_expr
• iivwprof_parse_tree
Note: System catalogs with the name iivwprof_*_global (for example iivwprof_query_global) contain information on all sessions (rather than just the current session). These tables have an additional attribute “session_id”, which is an 8-byte integer.