| Column Name | Column Datatype | Column Null Option | Column Comment |
| sql_id | decimal(8) | not null | |
| capture_id | decimal(8) | with null | |
| snapshot_timestamp | date | not null | |
| sql_owner | varchar(256) | with null | |
| sql_parser | varchar(256) | with null | |
| agent_id | decimal(12) | not null | |
| appl_id | varchar(32) | not null | |
| appl_name | varchar(256) | with null | |
| os_user | varchar(256) | with null | |
| agent_rows_read | decimal(12) | with null | |
| agent_rows_written | decimal(12) | with null | |
| agent_usr_cpu | decimal(16,6) | with null | |
| agent_sys_cpu | decimal(16,6) | with null | |
| stmt_rows_read | decimal(12) | with null | |
| stmt_rows_written | decimal(12) | with null | |
| stmt_rows_accessed | decimal(12) | with null | |
| num_agents | decimal(12) | with null | |
| agents_top | decimal(12) | with null | |
| stmt_type | decimal(4) | with null | |
| stmt_operation | decimal(4) | with null | |
| section_number | decimal(12) | with null | |
| query_cost_estimate | decimal(12) | with null | |
| query_card_estimate | decimal(12) | with null | |
| degree_parallelism | decimal(12) | with null | |
| stmt_sorts | decimal(12) | with null | |
| total_sort_time | decimal(16,6) | with null | |
| sort_overflows | decimal(12) | with null | |
| int_rows_deleted | decimal(12) | with null | |
| int_rows_updated | decimal(12) | with null | |
| int_rows_inserted | decimal(12) | with null | |
| fetch_count | decimal(12) | with null | |
| stmt_start | date | with null | |
| stmt_stop | date | with null | |
| stmt_usr_cpu | decimal(16,6) | with null | |
| stmt_sys_cpu | decimal(16,6) | with null | |
| stmt_elapsed_time | decimal(16,6) | with null | |
| blocking_cursor | decimal(12) | with null | |
| stmt_partition_number | decimal(12) | with null | |
| cursor_name | varchar(256) | with null | |
| creator | varchar(256) | with null | |
| package_name | varchar(30) | with null | |
| diff_rows_read | decimal(12) | with null | |
| diff_rows_written | decimal(12) | with null | |
| diff_rows_accessed | decimal(12) | with null | |
| diff_cpu | decimal(16,6) | with null | |
| stmt_text | long varchar | with null | |
| tag | varchar(50) | with null | |
| folder | varchar(50) | with null | |
| desc | varchar(2000) | with null | |
| plan_owner | varchar(30) | with null | |
| db_connect_string | varchar(400) | with null | |
| db_name | varchar(50) | with null | |
| db_version | varchar(30) | with null | |
| create_date | date | with null | |
| verify_date | date | with null | |
| start_capture_time | date | with null | |
| end_capture_time | date | with null | |
| capture_interval | decimal(12,2) | with null | |
| var1 | varchar(400) | with null | |
| var2 | varchar(400) | with null | |
| var3 | varchar(400) | with null | |
| var4 | varchar(400) | with null | |
| var5 | varchar(400) | with null | |
| text1 | text(1) | with null | |
| dec1 | decimal(12,2) | with null | |
| dec2 | decimal(12,2) | with null | |
| dec3 | decimal(12,2) | with null | |
| dec4 | decimal(16,6) | with null | |
| dec5 | decimal(16,6) | with null | |
| float1 | float | with null | |
| float2 | float | with null | |
| float3 | float | with null | |
| date1 | date | with null | |
| date2 | date | with null | |
| date3 | date | with null |
Product Name: Unicenter Database Management
Table Type: Table