| 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(30) | with null | |
| sql_parser | varchar(30) | not null | |
| appl_name | varchar(256) | with null | |
| os_user | varchar(256) | with null | |
| option_defer_parse | char(1) | with null | |
| option_describes_y_n | char(1) | with null | |
| option_combine_fetch | char(1) | with null | |
| option_min_sorting | char(1) | with null | |
| option_array_size | decimal(12) | with null | |
| option_n_fetches | decimal(12) | with null | |
| option_long_piece_size | decimal(12) | with null | |
| option_n_long_peices | decimal(12) | with null | |
| option_roll_segment | varchar(30) | with null | |
| bind_carnality | decimal(12) | with null | |
| prod_plan | varchar(1) | with null | |
| do_elapsed_time_last | decimal(12) | with null | |
| do_total_cpu_last | decimal(16,6) | with null | |
| do_db_calls | decimal(12) | with null | |
| row_num_limit | decimal(12) | with null | |
| sql_type | varchar(1) | not null | |
| c_sharable_mem | decimal(12) | with null | |
| c_sorts | decimal(12) | with null | |
| c_loaded_versions | decimal(12) | with null | |
| c_executions | decimal(12) | with null | |
| c_parse_calls | decimal(12) | with null | |
| c_disk_reads | decimal(12) | with null | |
| c_buffer_gets | decimal(12) | with null | |
| c_users_opening | decimal(12) | with null | |
| c_first_load_time | date | with null | |
| c_last_load_time | date | with null | |
| c_rows_processed | decimal(12) | with null | |
| c_cpu_time | decimal(16,6) | with null | |
| c_elapsed_time | decimal(12) | with null | |
| c_log_write | decimal(12) | with null | |
| c_log_io | decimal(12) | with null | |
| c_optimizer_mode | varchar(30) | with null | |
| aud_sid | decimal(12) | with null | |
| sid | decimal(12) | with null | |
| serial_num | decimal(12) | with null | |
| sql_address | varchar(50) | with null | |
| sql_hash_value | decimal(12) | with null | |
| child_number | decimal(12) | with null | |
| diff_log_read | decimal(12) | with null | |
| diff_log_write | decimal(12) | with null | |
| diff_phy_read | decimal(12) | with null | |
| diff_io | decimal(12) | with null | |
| diff_cpu | decimal(16,6) | with null | |
| stmt_text | long varchar | not 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