text: -- the final table, get col names from the script 
  drop table dump_dba_ash purge;
    CREATE TABLE dump_dba_ash
     (
  INSTNAME                             CHAR(255),
  INST_ID                      CHAR(255),
  SAMPLE_ID                            CHAR(255),
  TM                                   TIMESTAMP(3),
  TMS                                  TIMESTAMP(3),
  SAMPLE_TIME                          CHAR(255),
  SESSION_ID                           CHAR(255),
  SESSION_SERIAL#                      CHAR(255),
  SESSION_TYPE                         CHAR(255),
  FLAGS                                CHAR(255),
  USER_ID                              CHAR(255),
  SQL_ID                               CHAR(255),
  IS_SQLID_CURRENT                     CHAR(255),
  SQL_CHILD_NUMBER                     CHAR(255),
  SQL_OPCODE                           CHAR(255),
  SQL_OPNAME                           CHAR(255),
  FORCE_MATCHING_SIGNATURE             CHAR(255),
  TOP_LEVEL_SQL_ID                     CHAR(255),
  TOP_LEVEL_SQL_OPCODE                 CHAR(255),
   SQL_PLAN_HASH_VALUE                 CHAR(255),
  SQL_PLAN_LINE_ID                     CHAR(255),
  SQL_PLAN_OPERATION                   CHAR(255),
  SQL_PLAN_OPTIONS                     CHAR(255),
  SQL_EXEC_ID                          CHAR(255),
  SQL_EXEC_START                       CHAR(255),
  PLSQL_ENTRY_OBJECT_ID                CHAR(255),
  PLSQL_ENTRY_SUBPROGRAM_ID            CHAR(255),
  PLSQL_OBJECT_ID                      CHAR(255),
  PLSQL_SUBPROGRAM_ID                  CHAR(255),
  QC_INSTANCE_ID                       CHAR(255),
  QC_SESSION_ID                        CHAR(255),
  QC_SESSION_SERIAL#                   CHAR(255),
  PX_FLAGS                             CHAR(255),
  EVENT                                CHAR(255),
   EVENT_ID                            CHAR(255),
  SEQ#                                 CHAR(255),
  P1TEXT                               CHAR(255),
  P1                                   CHAR(255),
  P2TEXT                               CHAR(255),
  P2                                   CHAR(255),
  P3TEXT                               CHAR(255),
  P3                                   CHAR(255),
  WAIT_CLASS                           CHAR(255),
  WAIT_CLASS_ID                        CHAR(255),
  WAIT_TIME                            CHAR(255),
  SESSION_STATE                        CHAR(255),
  TIME_WAITED                          CHAR(255),
  BLOCKING_SESSION_STATUS              CHAR(255),
  BLOCKING_SESSION                     CHAR(255),
  BLOCKING_SESSION_SERIAL#             CHAR(255),
  BLOCKING_INST_ID                     CHAR(255),
  BLOCKING_HANGCHAIN_INFO              CHAR(255),
  CURRENT_OBJ#                         CHAR(255),
   CURRENT_FILE#                       CHAR(255),
  CURRENT_BLOCK#                       CHAR(255),
  CURRENT_ROW#                         CHAR(255),
  TOP_LEVEL_CALL#                      CHAR(255),
  TOP_LEVEL_CALL_NAME                  CHAR(255),
  CONSUMER_GROUP_ID                    CHAR(255),
  XID                                  CHAR(255),
  REMOTE_INSTANCE#                     CHAR(255),
  TIME_MODEL                           CHAR(255),
  IN_CONNECTION_MGMT                   CHAR(255),
  IN_PARSE                             CHAR(255),
  IN_HARD_PARSE                        CHAR(255),
  IN_SQL_EXECUTION                     CHAR(255),
  IN_PLSQL_EXECUTION                   CHAR(255),
  IN_PLSQL_RPC                         CHAR(255),
  IN_PLSQL_COMPILATION                 CHAR(255),
  IN_JAVA_EXECUTION                    CHAR(255),
   IN_BIND                             CHAR(255),
  IN_CURSOR_CLOSE                      CHAR(255),
  IN_SEQUENCE_LOAD                     CHAR(255),
  CAPTURE_OVERHEAD                     CHAR(255),
  REPLAY_OVERHEAD                      CHAR(255),
  IS_CAPTURED                          CHAR(255),
  IS_REPLAYED                          CHAR(255),
  SERVICE_HASH                         CHAR(255),
  PROGRAM                              CHAR(255),
  MODULE                               CHAR(255),
   ACTION                              CHAR(255),
  CLIENT_ID                            CHAR(255),
  MACHINE                              CHAR(255),
  PORT                                 CHAR(255),
  ECID                                 CHAR(255),
  DBREPLAY_FILE_ID                     CHAR(255),
  DBREPLAY_CALL_COUNTER                CHAR(255),
  TM_DELTA_TIME                        CHAR(255),
  TM_DELTA_CPU_TIME                    CHAR(255),
  TM_DELTA_DB_TIME                     CHAR(255),
   DELTA_TIME                          CHAR(255),
  DELTA_READ_IO_REQUESTS               CHAR(255),
  DELTA_WRITE_IO_REQUESTS              CHAR(255),
  DELTA_READ_IO_BYTES                  CHAR(255),
  DELTA_WRITE_IO_BYTES                 CHAR(255),
  DELTA_INTERCONNECT_IO_BYTES          CHAR(255),
   PGA_ALLOCATED                       CHAR(255),
  TEMP_SPACE_ALLOCATED                 CHAR(255)
     );
  
  