SQL Language Guide : B. System Catalogs : X100 Query Profiling System Catalogs
 
Share this page                  
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.