DBA HIST desc all

Contents

  1. 1  DBA_HIST_ACTIVE_SESS_HISTORY
  2. 2  DBA_HIST_ASH_SNAPSHOT
  3. 3  DBA_HIST_BASELINE
  4. 4  DBA_HIST_BASELINE_DETAILS
  5. 5  DBA_HIST_BASELINE_METADATA
  6. 6  DBA_HIST_BASELINE_TEMPLATE
  7. 7  DBA_HIST_BUFFERED_SUBSCRIBERS
  8. 8  DBA_HIST_BUFFER_POOL_STAT
  9. 9  DBA_HIST_CLUSTER_INTERCON
  10. 10  DBA_HIST_COLORED_SQL
  11. 11  DBA_HIST_COMP_IOSTAT
  12. 12  DBA_HIST_CR_BLOCK_SERVER
  13. 13  DBA_HIST_CURRENT_BLOCK_SERVER
  14. 14  DBA_HIST_DATABASE_INSTANCE
  15. 15  DBA_HIST_DATAFILE
  16. 16  DBA_HIST_DB_CACHE_ADVICE
  17. 17  DBA_HIST_DISPATCHER
  18. 18  DBA_HIST_DLM_MISC
  19. 19  DBA_HIST_ENQUEUE_STAT
  20. 20  DBA_HIST_EVENT_HISTOGRAM
  21. 21  DBA_HIST_EVENT_NAME
  22. 22  DBA_HIST_FILESTATXS
  23. 23  DBA_HIST_IC_CLIENT_STATS
  24. 24  DBA_HIST_IC_DEVICE_STATS
  25. 25  DBA_HIST_INSTANCE_RECOVERY
  26. 26  DBA_HIST_INST_CACHE_TRANSFER
  27. 27  DBA_HIST_INTERCONNECT_PINGS
  28. 28  DBA_HIST_IOSTAT_DETAIL
  29. 29  DBA_HIST_IOSTAT_FILETYPE
  30. 30  DBA_HIST_IOSTAT_FUNCTION
  31. 31  DBA_HIST_IOSTAT_FUNCTION_NAME
  32. 32  DBA_HIST_JAVA_POOL_ADVICE
  33. 33  DBA_HIST_LATCH
  34. 34  DBA_HIST_LATCH_CHILDREN
  35. 35  DBA_HIST_LATCH_NAME
  36. 36  DBA_HIST_LATCH_PARENT
  37. 37  DBA_HIST_LIBRARYCACHE
  38. 38  DBA_HIST_LOG
  39. 39  DBA_HIST_MEMORY_RESIZE_OPS
  40. 40  DBA_HIST_MEMORY_TARGET_ADVICE
  41. 41  DBA_HIST_MEM_DYNAMIC_COMP
  42. 42  DBA_HIST_METRIC_NAME
  43. 43  DBA_HIST_MTTR_TARGET_ADVICE
  44. 44  DBA_HIST_MUTEX_SLEEP
  45. 45  DBA_HIST_OSSTAT
  46. 46  DBA_HIST_OSSTAT_NAME
  47. 47  DBA_HIST_PARAMETER
  48. 48  DBA_HIST_PARAMETER_NAME
  49. 49  DBA_HIST_PERSISTENT_QUEUES
  50. 50  DBA_HIST_PERSISTENT_SUBS
  51. 51  DBA_HIST_PGA_TARGET_ADVICE
  52. 52  DBA_HIST_PLAN_OPERATION_NAME
  53. 53  DBA_HIST_PROCESS_MEM_SUMMARY
  54. 54  DBA_HIST_RESOURCE_LIMIT
  55. 55  DBA_HIST_ROWCACHE_SUMMARY
  56. 56  DBA_HIST_RSRC_CONSUMER_GROUP
  57. 57  DBA_HIST_RULE_SET
  58. 58  DBA_HIST_SEG_STAT
  59. 59  DBA_HIST_SEG_STAT_OBJ
  60. 60  DBA_HIST_SERVICE_NAME
  61. 61  DBA_HIST_SERVICE_STAT
  62. 62  DBA_HIST_SERVICE_WAIT_CLASS
  63. 63  DBA_HIST_SESSMETRIC_HISTORY
  64. 64  DBA_HIST_SESS_TIME_STATS
  65. 65  DBA_HIST_SGA
  66. 66  DBA_HIST_SGASTAT
  67. 67  DBA_HIST_SGA_TARGET_ADVICE
  68. 68  DBA_HIST_SHARED_POOL_ADVICE
  69. 69  DBA_HIST_SHARED_SERVER_SUMMARY
  70. 70  DBA_HIST_SNAPSHOT
  71. 71  DBA_HIST_SNAP_ERROR
  72. 72  DBA_HIST_SQLCOMMAND_NAME
  73. 73  DBA_HIST_SQLSTAT
  74. 74  DBA_HIST_SQLTEXT
  75. 75  DBA_HIST_SQL_BIND_METADATA
  76. 76  DBA_HIST_SQL_SUMMARY
  77. 77  DBA_HIST_SQL_WORKAREA_HSTGRM
  78. 78  DBA_HIST_STREAMS_APPLY_SUM
  79. 79  DBA_HIST_STREAMS_CAPTURE
  80. 80  DBA_HIST_STREAMS_POOL_ADVICE
  81. 81  DBA_HIST_SYSMETRIC_HISTORY
  82. 82  DBA_HIST_SYSMETRIC_SUMMARY
  83. 83  DBA_HIST_SYSTEM_EVENT
  84. 84  DBA_HIST_SYS_TIME_MODEL
  85. 85  DBA_HIST_TABLESPACE_STAT
  86. 86  DBA_HIST_TBSPC_SPACE_USAGE
  87. 87  DBA_HIST_TEMPSTATXS
  88. 88  DBA_HIST_TOPLEVELCALL_NAME
  89. 89  DBA_HIST_UNDOSTAT
  90. 90  DBA_HIST_WAITCLASSMET_HISTORY
  91. 91  DBA_HIST_WAITSTAT
  92. 92  DBA_HIST_WR_CONTROL



 DBA_HIST_ACTIVE_SESS_HISTORY

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 SAMPLE_ID                                 NOT NULL NUMBER
 SAMPLE_TIME                               NOT NULL TIMESTAMP(3)
 SESSION_ID                                NOT NULL NUMBER
 SESSION_SERIAL#                                    NUMBER
 SESSION_TYPE                                       VARCHAR2(10)
 FLAGS                                              NUMBER
 USER_ID                                            NUMBER
 SQL_ID                                             VARCHAR2(13)
 IS_SQLID_CURRENT                                   VARCHAR2(1)
 SQL_CHILD_NUMBER                                   NUMBER
 SQL_OPCODE                                         NUMBER
 SQL_OPNAME                                         VARCHAR2(64)
 FORCE_MATCHING_SIGNATURE                           NUMBER
 TOP_LEVEL_SQL_ID                                   VARCHAR2(13)
 TOP_LEVEL_SQL_OPCODE                               NUMBER
 SQL_PLAN_HASH_VALUE                                NUMBER
 SQL_PLAN_LINE_ID                                   NUMBER
 SQL_PLAN_OPERATION                                 VARCHAR2(64)
 SQL_PLAN_OPTIONS                                   VARCHAR2(64)
 SQL_EXEC_ID                                        NUMBER
 SQL_EXEC_START                                     DATE
 PLSQL_ENTRY_OBJECT_ID                              NUMBER
 PLSQL_ENTRY_SUBPROGRAM_ID                          NUMBER
 PLSQL_OBJECT_ID                                    NUMBER
 PLSQL_SUBPROGRAM_ID                                NUMBER
 QC_INSTANCE_ID                                     NUMBER
 QC_SESSION_ID                                      NUMBER
 QC_SESSION_SERIAL#                                 NUMBER
 EVENT                                              VARCHAR2(64)
 EVENT_ID                                           NUMBER
 SEQ#                                               NUMBER
 P1TEXT                                             VARCHAR2(64)
 P1                                                 NUMBER
 P2TEXT                                             VARCHAR2(64)
 P2                                                 NUMBER
 P3TEXT                                             VARCHAR2(64)
 P3                                                 NUMBER
 WAIT_CLASS                                         VARCHAR2(64)
 WAIT_CLASS_ID                                      NUMBER
 WAIT_TIME                                          NUMBER
 SESSION_STATE                                      VARCHAR2(7)
 TIME_WAITED                                        NUMBER
 BLOCKING_SESSION_STATUS                            VARCHAR2(11)
 BLOCKING_SESSION                                   NUMBER
 BLOCKING_SESSION_SERIAL#                           NUMBER
 BLOCKING_INST_ID                                   NUMBER
 BLOCKING_HANGCHAIN_INFO                            VARCHAR2(1)
 CURRENT_OBJ#                                       NUMBER
 CURRENT_FILE#                                      NUMBER
 CURRENT_BLOCK#                                     NUMBER
 CURRENT_ROW#                                       NUMBER
 TOP_LEVEL_CALL#                                    NUMBER
 TOP_LEVEL_CALL_NAME                                VARCHAR2(64)
 CONSUMER_GROUP_ID                                  NUMBER
 XID                                                RAW(8)
 REMOTE_INSTANCE#                                   NUMBER
 TIME_MODEL                                         NUMBER
 IN_CONNECTION_MGMT                                 VARCHAR2(1)
 IN_PARSE                                           VARCHAR2(1)
 IN_HARD_PARSE                                      VARCHAR2(1)
 IN_SQL_EXECUTION                                   VARCHAR2(1)
 IN_PLSQL_EXECUTION                                 VARCHAR2(1)
 IN_PLSQL_RPC                                       VARCHAR2(1)
 IN_PLSQL_COMPILATION                               VARCHAR2(1)
 IN_JAVA_EXECUTION                                  VARCHAR2(1)
 IN_BIND                                            VARCHAR2(1)
 IN_CURSOR_CLOSE                                    VARCHAR2(1)
 IN_SEQUENCE_LOAD                                   VARCHAR2(1)
 CAPTURE_OVERHEAD                                   VARCHAR2(1)
 REPLAY_OVERHEAD                                    VARCHAR2(1)
 IS_CAPTURED                                        VARCHAR2(1)
 IS_REPLAYED                                        VARCHAR2(1)
 SERVICE_HASH                                       NUMBER
 PROGRAM                                            VARCHAR2(64)
 MODULE                                             VARCHAR2(48)
 ACTION                                             VARCHAR2(32)
 CLIENT_ID                                          VARCHAR2(64)
 MACHINE                                            VARCHAR2(64)
 PORT                                               NUMBER
 ECID                                               VARCHAR2(64)
 TM_DELTA_TIME                                      NUMBER
 TM_DELTA_CPU_TIME                                  NUMBER
 TM_DELTA_DB_TIME                                   NUMBER
 DELTA_TIME                                         NUMBER
 DELTA_READ_IO_REQUESTS                             NUMBER
 DELTA_WRITE_IO_REQUESTS                            NUMBER
 DELTA_READ_IO_BYTES                                NUMBER
 DELTA_WRITE_IO_BYTES                               NUMBER
 DELTA_INTERCONNECT_IO_BYTES                        NUMBER
 PGA_ALLOCATED                                      NUMBER
 TEMP_SPACE_ALLOCATED                               NUMBER

 DBA_HIST_ASH_SNAPSHOT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 STARTUP_TIME                              NOT NULL TIMESTAMP(3)
 BEGIN_INTERVAL_TIME                       NOT NULL TIMESTAMP(3)
 END_INTERVAL_TIME                         NOT NULL TIMESTAMP(3)
 FLUSH_ELAPSED                                      INTERVAL DAY(5) TO SECOND(1)
 SNAP_LEVEL                                         NUMBER
 STATUS                                             NUMBER
 ERROR_COUNT                                        NUMBER
 BL_MOVED                                           NUMBER
 SNAP_FLAG                                          NUMBER

 DBA_HIST_BASELINE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                               NUMBER
 BASELINE_ID                                        NUMBER
 BASELINE_NAME                                      VARCHAR2(64)
 BASELINE_TYPE                                      VARCHAR2(13)
 START_SNAP_ID                                      NUMBER
 START_SNAP_TIME                                    TIMESTAMP(3)
 END_SNAP_ID                                        NUMBER
 END_SNAP_TIME                                      TIMESTAMP(3)
 MOVING_WINDOW_SIZE                                 NUMBER
 CREATION_TIME                                      DATE
 EXPIRATION                                         NUMBER
 TEMPLATE_NAME                                      VARCHAR2(64)
 LAST_TIME_COMPUTED                                 DATE

 DBA_HIST_BASELINE_DETAILS

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                               NUMBER
 INSTANCE_NUMBER                                    NUMBER
 BASELINE_ID                                        NUMBER
 BASELINE_NAME                                      VARCHAR2(64)
 BASELINE_TYPE                                      VARCHAR2(13)
 START_SNAP_ID                                      NUMBER
 START_SNAP_TIME                                    TIMESTAMP(3)
 END_SNAP_ID                                        NUMBER
 END_SNAP_TIME                                      TIMESTAMP(3)
 SHUTDOWN                                           VARCHAR2(3)
 ERROR_COUNT                                        NUMBER
 PCT_TOTAL_TIME                                     NUMBER
 LAST_TIME_COMPUTED                                 DATE
 MOVING_WINDOW_SIZE                                 NUMBER
 CREATION_TIME                                      DATE
 EXPIRATION                                         NUMBER
 TEMPLATE_NAME                                      VARCHAR2(64)

 DBA_HIST_BASELINE_METADATA

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 BASELINE_ID                               NOT NULL NUMBER
 BASELINE_NAME                                      VARCHAR2(64)
 BASELINE_TYPE                                      VARCHAR2(13)
 START_SNAP_ID                                      NUMBER
 END_SNAP_ID                                        NUMBER
 MOVING_WINDOW_SIZE                                 NUMBER
 CREATION_TIME                                      DATE
 EXPIRATION                                         NUMBER
 TEMPLATE_NAME                                      VARCHAR2(64)
 LAST_TIME_COMPUTED                                 DATE

 DBA_HIST_BASELINE_TEMPLATE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 TEMPLATE_ID                               NOT NULL NUMBER
 TEMPLATE_NAME                             NOT NULL VARCHAR2(30)
 TEMPLATE_TYPE                             NOT NULL VARCHAR2(9)
 BASELINE_NAME_PREFIX                      NOT NULL VARCHAR2(30)
 START_TIME                                NOT NULL DATE
 END_TIME                                  NOT NULL DATE
 DAY_OF_WEEK                                        VARCHAR2(9)
 HOUR_IN_DAY                                        NUMBER
 DURATION                                           NUMBER
 EXPIRATION                                         NUMBER
 REPEAT_INTERVAL                                    VARCHAR2(128)
 LAST_GENERATED                                     DATE

 DBA_HIST_BG_EVENT_SUMMARY
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 EVENT_ID                                  NOT NULL NUMBER
 EVENT_NAME                                NOT NULL VARCHAR2(64)
 WAIT_CLASS_ID                                      NUMBER
 WAIT_CLASS                                         VARCHAR2(64)
 TOTAL_WAITS                                        NUMBER
 TOTAL_TIMEOUTS                                     NUMBER
 TIME_WAITED_MICRO                                  NUMBER

 DBA_HIST_BUFFERED_QUEUES
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 QUEUE_SCHEMA                              NOT NULL VARCHAR2(30)
 QUEUE_NAME                                NOT NULL VARCHAR2(30)
 STARTUP_TIME                              NOT NULL DATE
 QUEUE_ID                                  NOT NULL NUMBER
 NUM_MSGS                                           NUMBER
 SPILL_MSGS                                         NUMBER
 CNUM_MSGS                                          NUMBER
 CSPILL_MSGS                                        NUMBER

 DBA_HIST_BUFFERED_SUBSCRIBERS

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 QUEUE_SCHEMA                              NOT NULL VARCHAR2(30)
 QUEUE_NAME                                NOT NULL VARCHAR2(30)
 SUBSCRIBER_ID                             NOT NULL NUMBER
 SUBSCRIBER_NAME                                    VARCHAR2(30)
 SUBSCRIBER_ADDRESS                                 VARCHAR2(1024)
 SUBSCRIBER_TYPE                                    VARCHAR2(30)
 STARTUP_TIME                              NOT NULL DATE
 NUM_MSGS                                           NUMBER
 CNUM_MSGS                                          NUMBER
 TOTAL_SPILLED_MSG                                  NUMBER

 DBA_HIST_BUFFER_POOL_STAT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 ID                                        NOT NULL NUMBER
 NAME                                               VARCHAR2(20)
 BLOCK_SIZE                                         NUMBER
 SET_MSIZE                                          NUMBER
 CNUM_REPL                                          NUMBER
 CNUM_WRITE                                         NUMBER
 CNUM_SET                                           NUMBER
 BUF_GOT                                            NUMBER
 SUM_WRITE                                          NUMBER
 SUM_SCAN                                           NUMBER
 FREE_BUFFER_WAIT                                   NUMBER
 WRITE_COMPLETE_WAIT                                NUMBER
 BUFFER_BUSY_WAIT                                   NUMBER
 FREE_BUFFER_INSPECTED                              NUMBER
 DIRTY_BUFFERS_INSPECTED                            NUMBER
 DB_BLOCK_CHANGE                                    NUMBER
 DB_BLOCK_GETS                                      NUMBER
 CONSISTENT_GETS                                    NUMBER
 PHYSICAL_READS                                     NUMBER
 PHYSICAL_WRITES                                    NUMBER

 DBA_HIST_CLUSTER_INTERCON

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 NAME                                      NOT NULL VARCHAR2(256)
 IP_ADDRESS                                         VARCHAR2(64)
 IS_PUBLIC                                          VARCHAR2(3)
 SOURCE                                             VARCHAR2(31)

 DBA_HIST_COLORED_SQL

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 SQL_ID                                    NOT NULL VARCHAR2(13)
 CREATE_TIME                               NOT NULL DATE

 DBA_HIST_COMP_IOSTAT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 COMPONENT                                 NOT NULL VARCHAR2(64)
 FILE_TYPE                                 NOT NULL VARCHAR2(64)
 IO_TYPE                                   NOT NULL CHAR(5)
 OPERATION                                 NOT NULL CHAR(5)
 BYTES                                     NOT NULL NUMBER
 IO_COUNT                                  NOT NULL NUMBER

 DBA_HIST_CR_BLOCK_SERVER

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 CR_REQUESTS                                        NUMBER
 CURRENT_REQUESTS                                   NUMBER
 DATA_REQUESTS                                      NUMBER
 UNDO_REQUESTS                                      NUMBER
 TX_REQUESTS                                        NUMBER
 CURRENT_RESULTS                                    NUMBER
 PRIVATE_RESULTS                                    NUMBER
 ZERO_RESULTS                                       NUMBER
 DISK_READ_RESULTS                                  NUMBER
 FAIL_RESULTS                                       NUMBER
 FAIRNESS_DOWN_CONVERTS                             NUMBER
 FAIRNESS_CLEARS                                    NUMBER
 FREE_GC_ELEMENTS                                   NUMBER
 FLUSHES                                            NUMBER
 FLUSHES_QUEUED                                     NUMBER
 FLUSH_QUEUE_FULL                                   NUMBER
 FLUSH_MAX_TIME                                     NUMBER
 LIGHT_WORKS                                        NUMBER
 ERRORS                                             NUMBER

 DBA_HIST_CURRENT_BLOCK_SERVER

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 PIN1                                               NUMBER
 PIN10                                              NUMBER
 PIN100                                             NUMBER
 PIN1000                                            NUMBER
 PIN10000                                           NUMBER
 FLUSH1                                             NUMBER
 FLUSH10                                            NUMBER
 FLUSH100                                           NUMBER
 FLUSH1000                                          NUMBER
 FLUSH10000                                         NUMBER
 WRITE1                                             NUMBER
 WRITE10                                            NUMBER
 WRITE100                                           NUMBER
 WRITE1000                                          NUMBER
 WRITE10000                                         NUMBER

 DBA_HIST_DATABASE_INSTANCE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 STARTUP_TIME                              NOT NULL TIMESTAMP(3)
 PARALLEL                                  NOT NULL VARCHAR2(3)
 VERSION                                   NOT NULL VARCHAR2(17)
 DB_NAME                                            VARCHAR2(9)
 INSTANCE_NAME                                      VARCHAR2(16)
 HOST_NAME                                          VARCHAR2(64)
 LAST_ASH_SAMPLE_ID                        NOT NULL NUMBER
 PLATFORM_NAME                                      VARCHAR2(101)

 DBA_HIST_DATAFILE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 FILE#                                     NOT NULL NUMBER
 CREATION_CHANGE#                          NOT NULL NUMBER
 FILENAME                                  NOT NULL VARCHAR2(513)
 TS#                                       NOT NULL NUMBER
 TSNAME                                    NOT NULL VARCHAR2(30)
 BLOCK_SIZE                                         NUMBER

 DBA_HIST_DB_CACHE_ADVICE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 BPID                                      NOT NULL NUMBER
 BUFFERS_FOR_ESTIMATE                      NOT NULL NUMBER
 NAME                                               VARCHAR2(20)
 BLOCK_SIZE                                         NUMBER
 ADVICE_STATUS                                      VARCHAR2(3)
 SIZE_FOR_ESTIMATE                                  NUMBER
 SIZE_FACTOR                                        NUMBER
 PHYSICAL_READS                                     NUMBER
 BASE_PHYSICAL_READS                                NUMBER
 ACTUAL_PHYSICAL_READS                              NUMBER
 ESTD_PHYSICAL_READ_TIME                            NUMBER

 DBA_HIST_DISPATCHER

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 NAME                                      NOT NULL VARCHAR2(4)
 SERIAL#                                            NUMBER
 IDLE                                               NUMBER
 BUSY                                               NUMBER
 WAIT                                               NUMBER
 TOTALQ                                             NUMBER
 SAMPLED_TOTAL_CONN                                 NUMBER

 DBA_HIST_DLM_MISC

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 STATISTIC#                                NOT NULL NUMBER
 NAME                                               VARCHAR2(38)
 VALUE                                              NUMBER

 DBA_HIST_DYN_REMASTER_STATS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 REMASTER_OPS                                       NUMBER
 REMASTER_TIME                                      NUMBER
 REMASTERED_OBJECTS                                 NUMBER
 QUIESCE_TIME                                       NUMBER
 FREEZE_TIME                                        NUMBER
 CLEANUP_TIME                                       NUMBER
 REPLAY_TIME                                        NUMBER
 FIXWRITE_TIME                                      NUMBER
 SYNC_TIME                                          NUMBER
 RESOURCES_CLEANED                                  NUMBER
 REPLAYED_LOCKS_SENT                                NUMBER
 REPLAYED_LOCKS_RECEIVED                            NUMBER
 CURRENT_OBJECTS                                    NUMBER

 DBA_HIST_ENQUEUE_STAT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 EQ_TYPE                                   NOT NULL VARCHAR2(2)
 REQ_REASON                                NOT NULL VARCHAR2(64)
 TOTAL_REQ#                                         NUMBER
 TOTAL_WAIT#                                        NUMBER
 SUCC_REQ#                                          NUMBER
 FAILED_REQ#                                        NUMBER
 CUM_WAIT_TIME                                      NUMBER
 EVENT#                                             NUMBER

 DBA_HIST_EVENT_HISTOGRAM

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 EVENT_ID                                  NOT NULL NUMBER
 EVENT_NAME                                NOT NULL VARCHAR2(64)
 WAIT_CLASS_ID                                      NUMBER
 WAIT_CLASS                                         VARCHAR2(64)
 WAIT_TIME_MILLI                           NOT NULL NUMBER
 WAIT_COUNT                                         NUMBER

 DBA_HIST_EVENT_NAME

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 EVENT_ID                                  NOT NULL NUMBER
 EVENT_NAME                                NOT NULL VARCHAR2(64)
 PARAMETER1                                         VARCHAR2(64)
 PARAMETER2                                         VARCHAR2(64)
 PARAMETER3                                         VARCHAR2(64)
 WAIT_CLASS_ID                                      NUMBER
 WAIT_CLASS                                         VARCHAR2(64)

 DBA_HIST_FILEMETRIC_HISTORY
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 FILEID                                    NOT NULL NUMBER
 CREATIONTIME                              NOT NULL NUMBER
 BEGIN_TIME                                NOT NULL DATE
 END_TIME                                  NOT NULL DATE
 INTSIZE                                   NOT NULL NUMBER
 GROUP_ID                                  NOT NULL NUMBER
 AVGREADTIME                               NOT NULL NUMBER
 AVGWRITETIME                              NOT NULL NUMBER
 PHYSICALREAD                              NOT NULL NUMBER
 PHYSICALWRITE                             NOT NULL NUMBER
 PHYBLKREAD                                NOT NULL NUMBER
 PHYBLKWRITE                               NOT NULL NUMBER

 DBA_HIST_FILESTATXS

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 FILE#                                     NOT NULL NUMBER
 CREATION_CHANGE#                          NOT NULL NUMBER
 FILENAME                                  NOT NULL VARCHAR2(513)
 TS#                                       NOT NULL NUMBER
 TSNAME                                    NOT NULL VARCHAR2(30)
 BLOCK_SIZE                                         NUMBER
 PHYRDS                                             NUMBER
 PHYWRTS                                            NUMBER
 SINGLEBLKRDS                                       NUMBER
 READTIM                                            NUMBER
 WRITETIM                                           NUMBER
 SINGLEBLKRDTIM                                     NUMBER
 PHYBLKRD                                           NUMBER
 PHYBLKWRT                                          NUMBER
 WAIT_COUNT                                         NUMBER
 TIME                                               NUMBER

 DBA_HIST_IC_CLIENT_STATS

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 NAME                                      NOT NULL VARCHAR2(9)
 BYTES_SENT                                         NUMBER
 BYTES_RECEIVED                                     NUMBER

 DBA_HIST_IC_DEVICE_STATS

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 IF_NAME                                   NOT NULL VARCHAR2(256)
 IP_ADDR                                   NOT NULL VARCHAR2(64)
 NET_MASK                                           VARCHAR2(16)
 FLAGS                                              VARCHAR2(32)
 MTU                                                NUMBER
 BYTES_RECEIVED                                     NUMBER
 PACKETS_RECEIVED                                   NUMBER
 RECEIVE_ERRORS                                     NUMBER
 RECEIVE_DROPPED                                    NUMBER
 RECEIVE_BUF_OR                                     NUMBER
 RECEIVE_FRAME_ERR                                  NUMBER
 BYTES_SENT                                         NUMBER
 PACKETS_SENT                                       NUMBER
 SEND_ERRORS                                        NUMBER
 SENDS_DROPPED                                      NUMBER
 SEND_BUF_OR                                        NUMBER
 SEND_CARRIER_LOST                                  NUMBER

 DBA_HIST_INSTANCE_RECOVERY

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 RECOVERY_ESTIMATED_IOS                             NUMBER
 ACTUAL_REDO_BLKS                                   NUMBER
 TARGET_REDO_BLKS                                   NUMBER
 LOG_FILE_SIZE_REDO_BLKS                            NUMBER
 LOG_CHKPT_TIMEOUT_REDO_BLKS                        NUMBER
 LOG_CHKPT_INTERVAL_REDO_BLKS                       NUMBER
 FAST_START_IO_TARGET_REDO_BLKS                     NUMBER
 TARGET_MTTR                                        NUMBER
 ESTIMATED_MTTR                                     NUMBER
 CKPT_BLOCK_WRITES                                  NUMBER
 OPTIMAL_LOGFILE_SIZE                               NUMBER
 ESTD_CLUSTER_AVAILABLE_TIME                        NUMBER
 WRITES_MTTR                                        NUMBER
 WRITES_LOGFILE_SIZE                                NUMBER
 WRITES_LOG_CHECKPOINT_SETTINGS                     NUMBER
 WRITES_OTHER_SETTINGS                              NUMBER
 WRITES_AUTOTUNE                                    NUMBER
 WRITES_FULL_THREAD_CKPT                            NUMBER

 DBA_HIST_INST_CACHE_TRANSFER

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 INSTANCE                                  NOT NULL NUMBER
 CLASS                                     NOT NULL VARCHAR2(18)
 CR_BLOCK                                           NUMBER
 CR_BUSY                                            NUMBER
 CR_CONGESTED                                       NUMBER
 CURRENT_BLOCK                                      NUMBER
 CURRENT_BUSY                                       NUMBER
 CURRENT_CONGESTED                                  NUMBER
 LOST                                               NUMBER
 CR_2HOP                                            NUMBER
 CR_3HOP                                            NUMBER
 CURRENT_2HOP                                       NUMBER
 CURRENT_3HOP                                       NUMBER
 CR_BLOCK_TIME                                      NUMBER
 CR_BUSY_TIME                                       NUMBER
 CR_CONGESTED_TIME                                  NUMBER
 CURRENT_BLOCK_TIME                                 NUMBER
 CURRENT_BUSY_TIME                                  NUMBER
 CURRENT_CONGESTED_TIME                             NUMBER
 LOST_TIME                                          NUMBER
 CR_2HOP_TIME                                       NUMBER
 CR_3HOP_TIME                                       NUMBER
 CURRENT_2HOP_TIME                                  NUMBER
 CURRENT_3HOP_TIME                                  NUMBER

 DBA_HIST_INTERCONNECT_PINGS

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 TARGET_INSTANCE                           NOT NULL NUMBER
 CNT_500B                                           NUMBER
 WAIT_500B                                          NUMBER
 WAITSQ_500B                                        NUMBER
 CNT_8K                                             NUMBER
 WAIT_8K                                            NUMBER
 WAITSQ_8K                                          NUMBER

 DBA_HIST_IOSTAT_DETAIL

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 FUNCTION_ID                               NOT NULL NUMBER
 FUNCTION_NAME                             NOT NULL VARCHAR2(30)
 FILETYPE_ID                               NOT NULL NUMBER
 FILETYPE_NAME                             NOT NULL VARCHAR2(30)
 SMALL_READ_MEGABYTES                      NOT NULL NUMBER
 SMALL_WRITE_MEGABYTES                     NOT NULL NUMBER
 LARGE_READ_MEGABYTES                      NOT NULL NUMBER
 LARGE_WRITE_MEGABYTES                     NOT NULL NUMBER
 SMALL_READ_REQS                           NOT NULL NUMBER
 SMALL_WRITE_REQS                          NOT NULL NUMBER
 LARGE_READ_REQS                           NOT NULL NUMBER
 LARGE_WRITE_REQS                          NOT NULL NUMBER
 NUMBER_OF_WAITS                           NOT NULL NUMBER
 WAIT_TIME                                 NOT NULL NUMBER

 DBA_HIST_IOSTAT_FILETYPE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 FILETYPE_ID                               NOT NULL NUMBER
 FILETYPE_NAME                             NOT NULL VARCHAR2(30)
 SMALL_READ_MEGABYTES                      NOT NULL NUMBER
 SMALL_WRITE_MEGABYTES                     NOT NULL NUMBER
 LARGE_READ_MEGABYTES                      NOT NULL NUMBER
 LARGE_WRITE_MEGABYTES                     NOT NULL NUMBER
 SMALL_READ_REQS                           NOT NULL NUMBER
 SMALL_WRITE_REQS                          NOT NULL NUMBER
 SMALL_SYNC_READ_REQS                      NOT NULL NUMBER
 LARGE_READ_REQS                           NOT NULL NUMBER
 LARGE_WRITE_REQS                          NOT NULL NUMBER
 SMALL_READ_SERVICETIME                    NOT NULL NUMBER
 SMALL_WRITE_SERVICETIME                   NOT NULL NUMBER
 SMALL_SYNC_READ_LATENCY                   NOT NULL NUMBER
 LARGE_READ_SERVICETIME                    NOT NULL NUMBER
 LARGE_WRITE_SERVICETIME                   NOT NULL NUMBER
 RETRIES_ON_ERROR                          NOT NULL NUMBER

 DBA_HIST_IOSTAT_FILETYPE_NAME
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 FILETYPE_ID                               NOT NULL NUMBER
 FILETYPE_NAME                             NOT NULL VARCHAR2(30)

 DBA_HIST_IOSTAT_FUNCTION

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 FUNCTION_ID                               NOT NULL NUMBER
 FUNCTION_NAME                             NOT NULL VARCHAR2(30)
 SMALL_READ_MEGABYTES                      NOT NULL NUMBER
 SMALL_WRITE_MEGABYTES                     NOT NULL NUMBER
 LARGE_READ_MEGABYTES                      NOT NULL NUMBER
 LARGE_WRITE_MEGABYTES                     NOT NULL NUMBER
 SMALL_READ_REQS                           NOT NULL NUMBER
 SMALL_WRITE_REQS                          NOT NULL NUMBER
 LARGE_READ_REQS                           NOT NULL NUMBER
 LARGE_WRITE_REQS                          NOT NULL NUMBER
 NUMBER_OF_WAITS                           NOT NULL NUMBER
 WAIT_TIME                                 NOT NULL NUMBER

 DBA_HIST_IOSTAT_FUNCTION_NAME

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 FUNCTION_ID                               NOT NULL NUMBER
 FUNCTION_NAME                             NOT NULL VARCHAR2(30)

 DBA_HIST_JAVA_POOL_ADVICE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 JAVA_POOL_SIZE_FOR_ESTIMATE               NOT NULL NUMBER
 JAVA_POOL_SIZE_FACTOR                              NUMBER
 ESTD_LC_SIZE                                       NUMBER
 ESTD_LC_MEMORY_OBJECTS                             NUMBER
 ESTD_LC_TIME_SAVED                                 NUMBER
 ESTD_LC_TIME_SAVED_FACTOR                          NUMBER
 ESTD_LC_LOAD_TIME                                  NUMBER
 ESTD_LC_LOAD_TIME_FACTOR                           NUMBER
 ESTD_LC_MEMORY_OBJECT_HITS                         NUMBER

 DBA_HIST_LATCH

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 LATCH_HASH                                NOT NULL NUMBER
 LATCH_NAME                                NOT NULL VARCHAR2(64)
 LEVEL#                                             NUMBER
 GETS                                               NUMBER
 MISSES                                             NUMBER
 SLEEPS                                             NUMBER
 IMMEDIATE_GETS                                     NUMBER
 IMMEDIATE_MISSES                                   NUMBER
 SPIN_GETS                                          NUMBER
 SLEEP1                                             NUMBER
 SLEEP2                                             NUMBER
 SLEEP3                                             NUMBER
 SLEEP4                                             NUMBER
 WAIT_TIME                                          NUMBER

 DBA_HIST_LATCH_CHILDREN

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 LATCH_HASH                                NOT NULL NUMBER
 LATCH_NAME                                NOT NULL VARCHAR2(64)
 CHILD#                                    NOT NULL NUMBER
 GETS                                               NUMBER
 MISSES                                             NUMBER
 SLEEPS                                             NUMBER
 IMMEDIATE_GETS                                     NUMBER
 IMMEDIATE_MISSES                                   NUMBER
 SPIN_GETS                                          NUMBER
 SLEEP1                                             NUMBER
 SLEEP2                                             NUMBER
 SLEEP3                                             NUMBER
 SLEEP4                                             NUMBER
 WAIT_TIME                                          NUMBER

 DBA_HIST_LATCH_MISSES_SUMMARY
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 PARENT_NAME                               NOT NULL VARCHAR2(50)
 WHERE_IN_CODE                             NOT NULL VARCHAR2(64)
 NWFAIL_COUNT                                       NUMBER
 SLEEP_COUNT                                        NUMBER
 WTR_SLP_COUNT                                      NUMBER

 DBA_HIST_LATCH_NAME

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 LATCH_HASH                                NOT NULL NUMBER
 LATCH_NAME                                NOT NULL VARCHAR2(64)

 DBA_HIST_LATCH_PARENT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 LATCH_HASH                                NOT NULL NUMBER
 LATCH_NAME                                NOT NULL VARCHAR2(64)
 LEVEL#                                    NOT NULL NUMBER
 GETS                                               NUMBER
 MISSES                                             NUMBER
 SLEEPS                                             NUMBER
 IMMEDIATE_GETS                                     NUMBER
 IMMEDIATE_MISSES                                   NUMBER
 SPIN_GETS                                          NUMBER
 SLEEP1                                             NUMBER
 SLEEP2                                             NUMBER
 SLEEP3                                             NUMBER
 SLEEP4                                             NUMBER
 WAIT_TIME                                          NUMBER

 DBA_HIST_LIBRARYCACHE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 NAMESPACE                                 NOT NULL VARCHAR2(15)
 GETS                                               NUMBER
 GETHITS                                            NUMBER
 PINS                                               NUMBER
 PINHITS                                            NUMBER
 RELOADS                                            NUMBER
 INVALIDATIONS                                      NUMBER
 DLM_LOCK_REQUESTS                                  NUMBER
 DLM_PIN_REQUESTS                                   NUMBER
 DLM_PIN_RELEASES                                   NUMBER
 DLM_INVALIDATION_REQUESTS                          NUMBER
 DLM_INVALIDATIONS                                  NUMBER

 DBA_HIST_LOG

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 GROUP#                                    NOT NULL NUMBER
 THREAD#                                   NOT NULL NUMBER
 SEQUENCE#                                 NOT NULL NUMBER
 BYTES                                              NUMBER
 MEMBERS                                            NUMBER
 ARCHIVED                                           VARCHAR2(3)
 STATUS                                             VARCHAR2(16)
 FIRST_CHANGE#                                      NUMBER
 FIRST_TIME                                         DATE

 DBA_HIST_MEMORY_RESIZE_OPS

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 COMPONENT                                 NOT NULL VARCHAR2(64)
 OPER_TYPE                                 NOT NULL VARCHAR2(13)
 START_TIME                                NOT NULL DATE
 END_TIME                                  NOT NULL DATE
 TARGET_SIZE                               NOT NULL NUMBER
 OPER_MODE                                          VARCHAR2(9)
 PARAMETER                                          VARCHAR2(80)
 INITIAL_SIZE                                       NUMBER
 FINAL_SIZE                                         NUMBER
 STATUS                                             VARCHAR2(9)

 DBA_HIST_MEMORY_TARGET_ADVICE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 MEMORY_SIZE                               NOT NULL NUMBER
 MEMORY_SIZE_FACTOR                                 NUMBER
 ESTD_DB_TIME                                       NUMBER
 ESTD_DB_TIME_FACTOR                                NUMBER
 VERSION                                            NUMBER

 DBA_HIST_MEM_DYNAMIC_COMP

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 COMPONENT                                 NOT NULL VARCHAR2(64)
 CURRENT_SIZE                                       NUMBER
 MIN_SIZE                                           NUMBER
 MAX_SIZE                                           NUMBER
 USER_SPECIFIED_SIZE                                NUMBER
 OPER_COUNT                                         NUMBER
 LAST_OPER_TYPE                                     VARCHAR2(13)
 LAST_OPER_MODE                                     VARCHAR2(9)
 LAST_OPER_TIME                                     DATE
 GRANULE_SIZE                                       NUMBER

 DBA_HIST_METRIC_NAME

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 GROUP_ID                                  NOT NULL NUMBER
 GROUP_NAME                                         VARCHAR2(64)
 METRIC_ID                                 NOT NULL NUMBER
 METRIC_NAME                               NOT NULL VARCHAR2(64)
 METRIC_UNIT                               NOT NULL VARCHAR2(64)

 DBA_HIST_MTTR_TARGET_ADVICE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 MTTR_TARGET_FOR_ESTIMATE                           NUMBER
 ADVICE_STATUS                                      VARCHAR2(5)
 DIRTY_LIMIT                                        NUMBER
 ESTD_CACHE_WRITES                                  NUMBER
 ESTD_CACHE_WRITE_FACTOR                            NUMBER
 ESTD_TOTAL_WRITES                                  NUMBER
 ESTD_TOTAL_WRITE_FACTOR                            NUMBER
 ESTD_TOTAL_IOS                                     NUMBER
 ESTD_TOTAL_IO_FACTOR                               NUMBER

 DBA_HIST_MUTEX_SLEEP

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 MUTEX_TYPE                                NOT NULL VARCHAR2(32)
 LOCATION                                  NOT NULL VARCHAR2(40)
 SLEEPS                                             NUMBER
 WAIT_TIME                                          NUMBER

 DBA_HIST_OPTIMIZER_ENV
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 OPTIMIZER_ENV_HASH_VALUE                  NOT NULL NUMBER
 OPTIMIZER_ENV                                      RAW(2000)

 DBA_HIST_OSSTAT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 STAT_ID                                   NOT NULL NUMBER
 STAT_NAME                                 NOT NULL VARCHAR2(64)
 VALUE                                              NUMBER

 DBA_HIST_OSSTAT_NAME

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 STAT_ID                                   NOT NULL NUMBER
 STAT_NAME                                 NOT NULL VARCHAR2(64)

 DBA_HIST_PARAMETER

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 PARAMETER_HASH                            NOT NULL NUMBER
 PARAMETER_NAME                            NOT NULL VARCHAR2(64)
 VALUE                                              VARCHAR2(512)
 ISDEFAULT                                          VARCHAR2(9)
 ISMODIFIED                                         VARCHAR2(10)

 DBA_HIST_PARAMETER_NAME

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 PARAMETER_HASH                            NOT NULL NUMBER
 PARAMETER_NAME                            NOT NULL VARCHAR2(64)

 DBA_HIST_PERSISTENT_QUEUES

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 QUEUE_SCHEMA                              NOT NULL VARCHAR2(30)
 QUEUE_NAME                                NOT NULL VARCHAR2(30)
 QUEUE_ID                                  NOT NULL NUMBER
 FIRST_ACTIVITY_TIME                                TIMESTAMP(6)
 ENQUEUED_MSGS                                      NUMBER
 DEQUEUED_MSGS                                      NUMBER
 ELAPSED_ENQUEUE_TIME                               NUMBER
 ELAPSED_DEQUEUE_TIME                               NUMBER
 ELAPSED_TRANSFORMATION_TIME                        NUMBER
 ELAPSED_RULE_EVALUATION_TIME                       NUMBER
 ENQUEUED_EXPIRY_MSGS                               NUMBER
 ENQUEUED_DELAY_MSGS                                NUMBER
 MSGS_MADE_EXPIRED                                  NUMBER
 MSGS_MADE_READY                                    NUMBER
 LAST_ENQUEUE_TIME                                  TIMESTAMP(6)
 LAST_DEQUEUE_TIME                                  TIMESTAMP(6)
 LAST_TM_EXPIRY_TIME                                TIMESTAMP(6)
 LAST_TM_READY_TIME                                 TIMESTAMP(6)

 DBA_HIST_PERSISTENT_SUBS

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 QUEUE_SCHEMA                              NOT NULL VARCHAR2(30)
 QUEUE_NAME                                NOT NULL VARCHAR2(30)
 SUBSCRIBER_ID                             NOT NULL NUMBER
 SUBSCRIBER_NAME                                    VARCHAR2(30)
 SUBSCRIBER_ADDRESS                                 VARCHAR2(1024)
 SUBSCRIBER_TYPE                                    VARCHAR2(30)
 FIRST_ACTIVITY_TIME                                TIMESTAMP(6)
 ENQUEUED_MSGS                                      NUMBER
 DEQUEUED_MSGS                                      NUMBER
 EXPIRED_MSGS                                       NUMBER
 DEQUEUED_MSG_LATENCY                               NUMBER
 LAST_ENQUEUE_TIME                                  TIMESTAMP(6)
 LAST_DEQUEUE_TIME                                  TIMESTAMP(6)

 DBA_HIST_PGASTAT
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 NAME                                      NOT NULL VARCHAR2(64)
 VALUE                                              NUMBER

 DBA_HIST_PGA_TARGET_ADVICE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 PGA_TARGET_FOR_ESTIMATE                   NOT NULL NUMBER
 PGA_TARGET_FACTOR                                  NUMBER
 ADVICE_STATUS                                      VARCHAR2(3)
 BYTES_PROCESSED                                    NUMBER
 ESTD_TIME                                          NUMBER
 ESTD_EXTRA_BYTES_RW                                NUMBER
 ESTD_PGA_CACHE_HIT_PERCENTAGE                      NUMBER
 ESTD_OVERALLOC_COUNT                               NUMBER

 DBA_HIST_PLAN_OPERATION_NAME

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 OPERATION_ID                              NOT NULL NUMBER
 OPERATION_NAME                                     VARCHAR2(64)

 DBA_HIST_PLAN_OPTION_NAME
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 OPTION_ID                                 NOT NULL NUMBER
 OPTION_NAME                                        VARCHAR2(64)

 DBA_HIST_PROCESS_MEM_SUMMARY

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 CATEGORY                                  NOT NULL VARCHAR2(15)
 NUM_PROCESSES                                      NUMBER
 NON_ZERO_ALLOCS                                    NUMBER
 USED_TOTAL                                         NUMBER
 ALLOCATED_TOTAL                                    NUMBER
 ALLOCATED_AVG                                      NUMBER
 ALLOCATED_STDDEV                                   NUMBER
 ALLOCATED_MAX                                      NUMBER
 MAX_ALLOCATED_MAX                                  NUMBER

 DBA_HIST_RESOURCE_LIMIT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 RESOURCE_NAME                             NOT NULL VARCHAR2(30)
 CURRENT_UTILIZATION                                NUMBER
 MAX_UTILIZATION                                    NUMBER
 INITIAL_ALLOCATION                                 VARCHAR2(10)
 LIMIT_VALUE                                        VARCHAR2(10)

 DBA_HIST_ROWCACHE_SUMMARY

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 PARAMETER                                 NOT NULL VARCHAR2(32)
 TOTAL_USAGE                                        NUMBER
 USAGE                                              NUMBER
 GETS                                               NUMBER
 GETMISSES                                          NUMBER
 SCANS                                              NUMBER
 SCANMISSES                                         NUMBER
 SCANCOMPLETES                                      NUMBER
 MODIFICATIONS                                      NUMBER
 FLUSHES                                            NUMBER
 DLM_REQUESTS                                       NUMBER
 DLM_CONFLICTS                                      NUMBER
 DLM_RELEASES                                       NUMBER

 DBA_HIST_RSRC_CONSUMER_GROUP

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 SEQUENCE#                                 NOT NULL NUMBER
 CONSUMER_GROUP_ID                         NOT NULL NUMBER
 CONSUMER_GROUP_NAME                       NOT NULL VARCHAR2(30)
 REQUESTS                                  NOT NULL NUMBER
 CPU_WAIT_TIME                             NOT NULL NUMBER
 CPU_WAITS                                 NOT NULL NUMBER
 CONSUMED_CPU_TIME                         NOT NULL NUMBER
 YIELDS                                    NOT NULL NUMBER
 ACTIVE_SESS_LIMIT_HIT                     NOT NULL NUMBER
 UNDO_LIMIT_HIT                            NOT NULL NUMBER
 SWITCHES_IN_CPU_TIME                      NOT NULL NUMBER
 SWITCHES_OUT_CPU_TIME                     NOT NULL NUMBER
 SWITCHES_IN_IO_MEGABYTES                  NOT NULL NUMBER
 SWITCHES_OUT_IO_MEGABYTES                 NOT NULL NUMBER
 SWITCHES_IN_IO_REQUESTS                   NOT NULL NUMBER
 SWITCHES_OUT_IO_REQUESTS                  NOT NULL NUMBER
 SQL_CANCELED                              NOT NULL NUMBER
 ACTIVE_SESS_KILLED                        NOT NULL NUMBER
 IDLE_SESS_KILLED                          NOT NULL NUMBER
 IDLE_BLKR_SESS_KILLED                     NOT NULL NUMBER
 QUEUED_TIME                               NOT NULL NUMBER
 QUEUE_TIME_OUTS                           NOT NULL NUMBER
 IO_SERVICE_TIME                           NOT NULL NUMBER
 IO_SERVICE_WAITS                          NOT NULL NUMBER
 SMALL_READ_MEGABYTES                      NOT NULL NUMBER
 SMALL_WRITE_MEGABYTES                     NOT NULL NUMBER
 LARGE_READ_MEGABYTES                      NOT NULL NUMBER
 LARGE_WRITE_MEGABYTES                     NOT NULL NUMBER
 SMALL_READ_REQUESTS                       NOT NULL NUMBER
 SMALL_WRITE_REQUESTS                      NOT NULL NUMBER
 LARGE_READ_REQUESTS                       NOT NULL NUMBER
 LARGE_WRITE_REQUESTS                      NOT NULL NUMBER

 DBA_HIST_RSRC_PLAN
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 SEQUENCE#                                 NOT NULL NUMBER
 START_TIME                                NOT NULL DATE
 END_TIME                                  NOT NULL DATE
 PLAN_ID                                   NOT NULL NUMBER
 PLAN_NAME                                 NOT NULL VARCHAR2(30)
 CPU_MANAGED                               NOT NULL VARCHAR2(4)

 DBA_HIST_RULE_SET

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 OWNER                                     NOT NULL VARCHAR2(30)
 NAME                                      NOT NULL VARCHAR2(30)
 STARTUP_TIME                              NOT NULL DATE
 CPU_TIME                                           NUMBER
 ELAPSED_TIME                                       NUMBER
 EVALUATIONS                                        NUMBER
 SQL_FREE_EVALUATIONS                               NUMBER
 SQL_EXECUTIONS                                     NUMBER
 RELOADS                                            NUMBER

 DBA_HIST_SEG_STAT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 TS#                                       NOT NULL NUMBER
 OBJ#                                      NOT NULL NUMBER
 DATAOBJ#                                  NOT NULL NUMBER
 LOGICAL_READS_TOTAL                                NUMBER
 LOGICAL_READS_DELTA                                NUMBER
 BUFFER_BUSY_WAITS_TOTAL                            NUMBER
 BUFFER_BUSY_WAITS_DELTA                            NUMBER
 DB_BLOCK_CHANGES_TOTAL                             NUMBER
 DB_BLOCK_CHANGES_DELTA                             NUMBER
 PHYSICAL_READS_TOTAL                               NUMBER
 PHYSICAL_READS_DELTA                               NUMBER
 PHYSICAL_WRITES_TOTAL                              NUMBER
 PHYSICAL_WRITES_DELTA                              NUMBER
 PHYSICAL_READS_DIRECT_TOTAL                        NUMBER
 PHYSICAL_READS_DIRECT_DELTA                        NUMBER
 PHYSICAL_WRITES_DIRECT_TOTAL                       NUMBER
 PHYSICAL_WRITES_DIRECT_DELTA                       NUMBER
 ITL_WAITS_TOTAL                                    NUMBER
 ITL_WAITS_DELTA                                    NUMBER
 ROW_LOCK_WAITS_TOTAL                               NUMBER
 ROW_LOCK_WAITS_DELTA                               NUMBER
 GC_CR_BLOCKS_SERVED_TOTAL                          NUMBER
 GC_CR_BLOCKS_SERVED_DELTA                          NUMBER
 GC_CU_BLOCKS_SERVED_TOTAL                          NUMBER
 GC_CU_BLOCKS_SERVED_DELTA                          NUMBER
 GC_BUFFER_BUSY_TOTAL                               NUMBER
 GC_BUFFER_BUSY_DELTA                               NUMBER
 GC_CR_BLOCKS_RECEIVED_TOTAL                        NUMBER
 GC_CR_BLOCKS_RECEIVED_DELTA                        NUMBER
 GC_CU_BLOCKS_RECEIVED_TOTAL                        NUMBER
 GC_CU_BLOCKS_RECEIVED_DELTA                        NUMBER
 SPACE_USED_TOTAL                                   NUMBER
 SPACE_USED_DELTA                                   NUMBER
 SPACE_ALLOCATED_TOTAL                              NUMBER
 SPACE_ALLOCATED_DELTA                              NUMBER
 TABLE_SCANS_TOTAL                                  NUMBER
 TABLE_SCANS_DELTA                                  NUMBER
 CHAIN_ROW_EXCESS_TOTAL                             NUMBER
 CHAIN_ROW_EXCESS_DELTA                             NUMBER
 PHYSICAL_READ_REQUESTS_TOTAL                       NUMBER
 PHYSICAL_READ_REQUESTS_DELTA                       NUMBER
 PHYSICAL_WRITE_REQUESTS_TOTAL                      NUMBER
 PHYSICAL_WRITE_REQUESTS_DELTA                      NUMBER
 OPTIMIZED_PHYSICAL_READS_TOTAL                     NUMBER
 OPTIMIZED_PHYSICAL_READS_DELTA                     NUMBER

 DBA_HIST_SEG_STAT_OBJ

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 TS#                                       NOT NULL NUMBER
 OBJ#                                      NOT NULL NUMBER
 DATAOBJ#                                  NOT NULL NUMBER
 OWNER                                     NOT NULL VARCHAR2(30)
 OBJECT_NAME                               NOT NULL VARCHAR2(30)
 SUBOBJECT_NAME                                     VARCHAR2(30)
 OBJECT_TYPE                                        VARCHAR2(18)
 TABLESPACE_NAME                           NOT NULL VARCHAR2(30)
 PARTITION_TYPE                                     VARCHAR2(8)

 DBA_HIST_SERVICE_NAME

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 SERVICE_NAME_HASH                         NOT NULL NUMBER
 SERVICE_NAME                              NOT NULL VARCHAR2(64)

 DBA_HIST_SERVICE_STAT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 SERVICE_NAME_HASH                         NOT NULL NUMBER
 SERVICE_NAME                              NOT NULL VARCHAR2(64)
 STAT_ID                                   NOT NULL NUMBER
 STAT_NAME                                 NOT NULL VARCHAR2(64)
 VALUE                                              NUMBER

 DBA_HIST_SERVICE_WAIT_CLASS

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 SERVICE_NAME_HASH                         NOT NULL NUMBER
 SERVICE_NAME                              NOT NULL VARCHAR2(64)
 WAIT_CLASS_ID                             NOT NULL NUMBER
 WAIT_CLASS                                         VARCHAR2(64)
 TOTAL_WAITS                                        NUMBER
 TIME_WAITED                                        NUMBER

 DBA_HIST_SESSMETRIC_HISTORY

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 BEGIN_TIME                                NOT NULL DATE
 END_TIME                                  NOT NULL DATE
 SESSID                                    NOT NULL NUMBER
 SERIAL#                                   NOT NULL NUMBER
 INTSIZE                                   NOT NULL NUMBER
 GROUP_ID                                  NOT NULL NUMBER
 METRIC_ID                                 NOT NULL NUMBER
 METRIC_NAME                               NOT NULL VARCHAR2(64)
 VALUE                                     NOT NULL NUMBER
 METRIC_UNIT                               NOT NULL VARCHAR2(64)

 DBA_HIST_SESS_TIME_STATS

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 SESSION_TYPE                              NOT NULL VARCHAR2(64)
 MIN_LOGON_TIME                                     DATE
 SUM_CPU_TIME                                       NUMBER
 SUM_SYS_IO_WAIT                                    NUMBER
 SUM_USER_IO_WAIT                                   NUMBER

 DBA_HIST_SGA

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 NAME                                      NOT NULL VARCHAR2(64)
 VALUE                                     NOT NULL NUMBER

 DBA_HIST_SGASTAT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 NAME                                               VARCHAR2(64)
 POOL                                               VARCHAR2(12)
 BYTES                                              NUMBER

 DBA_HIST_SGA_TARGET_ADVICE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 SGA_SIZE                                  NOT NULL NUMBER
 SGA_SIZE_FACTOR                           NOT NULL NUMBER
 ESTD_DB_TIME                              NOT NULL NUMBER
 ESTD_PHYSICAL_READS                                NUMBER

 DBA_HIST_SHARED_POOL_ADVICE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 SHARED_POOL_SIZE_FOR_ESTIMATE             NOT NULL NUMBER
 SHARED_POOL_SIZE_FACTOR                            NUMBER
 ESTD_LC_SIZE                                       NUMBER
 ESTD_LC_MEMORY_OBJECTS                             NUMBER
 ESTD_LC_TIME_SAVED                                 NUMBER
 ESTD_LC_TIME_SAVED_FACTOR                          NUMBER
 ESTD_LC_LOAD_TIME                                  NUMBER
 ESTD_LC_LOAD_TIME_FACTOR                           NUMBER
 ESTD_LC_MEMORY_OBJECT_HITS                         NUMBER

 DBA_HIST_SHARED_SERVER_SUMMARY

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 NUM_SAMPLES                                        NUMBER
 SAMPLE_TIME                                        NUMBER
 SAMPLED_TOTAL_CONN                                 NUMBER
 SAMPLED_ACTIVE_CONN                                NUMBER
 SAMPLED_TOTAL_SRV                                  NUMBER
 SAMPLED_ACTIVE_SRV                                 NUMBER
 SAMPLED_TOTAL_DISP                                 NUMBER
 SAMPLED_ACTIVE_DISP                                NUMBER
 SRV_BUSY                                           NUMBER
 SRV_IDLE                                           NUMBER
 SRV_IN_NET                                         NUMBER
 SRV_OUT_NET                                        NUMBER
 SRV_MESSAGES                                       NUMBER
 SRV_BYTES                                          NUMBER
 CQ_WAIT                                            NUMBER
 CQ_TOTALQ                                          NUMBER
 DQ_TOTALQ                                          NUMBER

 DBA_HIST_SNAPSHOT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 STARTUP_TIME                              NOT NULL TIMESTAMP(3)
 BEGIN_INTERVAL_TIME                       NOT NULL TIMESTAMP(3)
 END_INTERVAL_TIME                         NOT NULL TIMESTAMP(3)
 FLUSH_ELAPSED                                      INTERVAL DAY(5) TO SECOND(1)
 SNAP_LEVEL                                         NUMBER
 ERROR_COUNT                                        NUMBER
 SNAP_FLAG                                          NUMBER

 DBA_HIST_SNAP_ERROR

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 TABLE_NAME                                NOT NULL VARCHAR2(30)
 ERROR_NUMBER                              NOT NULL NUMBER

 DBA_HIST_SQLBIND
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 SQL_ID                                    NOT NULL VARCHAR2(13)
 NAME                                               VARCHAR2(30)
 POSITION                                  NOT NULL NUMBER
 DUP_POSITION                                       NUMBER
 DATATYPE                                           NUMBER
 DATATYPE_STRING                                    VARCHAR2(15)
 CHARACTER_SID                                      NUMBER
 PRECISION                                          NUMBER
 SCALE                                              NUMBER
 MAX_LENGTH                                         NUMBER
 WAS_CAPTURED                                       VARCHAR2(3)
 LAST_CAPTURED                                      DATE
 VALUE_STRING                                       VARCHAR2(4000)
 VALUE_ANYDATA                                      ANYDATA

 DBA_HIST_SQLCOMMAND_NAME

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 COMMAND_TYPE                              NOT NULL NUMBER
 COMMAND_NAME                                       VARCHAR2(64)

 DBA_HIST_SQLSTAT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 SQL_ID                                    NOT NULL VARCHAR2(13)
 PLAN_HASH_VALUE                           NOT NULL NUMBER
 OPTIMIZER_COST                                     NUMBER
 OPTIMIZER_MODE                                     VARCHAR2(10)
 OPTIMIZER_ENV_HASH_VALUE                           NUMBER
 SHARABLE_MEM                                       NUMBER
 LOADED_VERSIONS                                    NUMBER
 VERSION_COUNT                                      NUMBER
 MODULE                                             VARCHAR2(64)
 ACTION                                             VARCHAR2(64)
 SQL_PROFILE                                        VARCHAR2(64)
 FORCE_MATCHING_SIGNATURE                           NUMBER
 PARSING_SCHEMA_ID                                  NUMBER
 PARSING_SCHEMA_NAME                                VARCHAR2(30)
 PARSING_USER_ID                                    NUMBER
 FETCHES_TOTAL                                      NUMBER
 FETCHES_DELTA                                      NUMBER
 END_OF_FETCH_COUNT_TOTAL                           NUMBER
 END_OF_FETCH_COUNT_DELTA                           NUMBER
 SORTS_TOTAL                                        NUMBER
 SORTS_DELTA                                        NUMBER
 EXECUTIONS_TOTAL                                   NUMBER
 EXECUTIONS_DELTA                                   NUMBER
 PX_SERVERS_EXECS_TOTAL                             NUMBER
 PX_SERVERS_EXECS_DELTA                             NUMBER
 LOADS_TOTAL                                        NUMBER
 LOADS_DELTA                                        NUMBER
 INVALIDATIONS_TOTAL                                NUMBER
 INVALIDATIONS_DELTA                                NUMBER
 PARSE_CALLS_TOTAL                                  NUMBER
 PARSE_CALLS_DELTA                                  NUMBER
 DISK_READS_TOTAL                                   NUMBER
 DISK_READS_DELTA                                   NUMBER
 BUFFER_GETS_TOTAL                                  NUMBER
 BUFFER_GETS_DELTA                                  NUMBER
 ROWS_PROCESSED_TOTAL                               NUMBER
 ROWS_PROCESSED_DELTA                               NUMBER
 CPU_TIME_TOTAL                                     NUMBER
 CPU_TIME_DELTA                                     NUMBER
 ELAPSED_TIME_TOTAL                                 NUMBER
 ELAPSED_TIME_DELTA                                 NUMBER
 IOWAIT_TOTAL                                       NUMBER
 IOWAIT_DELTA                                       NUMBER
 CLWAIT_TOTAL                                       NUMBER
 CLWAIT_DELTA                                       NUMBER
 APWAIT_TOTAL                                       NUMBER
 APWAIT_DELTA                                       NUMBER
 CCWAIT_TOTAL                                       NUMBER
 CCWAIT_DELTA                                       NUMBER
 DIRECT_WRITES_TOTAL                                NUMBER
 DIRECT_WRITES_DELTA                                NUMBER
 PLSEXEC_TIME_TOTAL                                 NUMBER
 PLSEXEC_TIME_DELTA                                 NUMBER
 JAVEXEC_TIME_TOTAL                                 NUMBER
 JAVEXEC_TIME_DELTA                                 NUMBER
 IO_OFFLOAD_ELIG_BYTES_TOTAL                        NUMBER
 IO_OFFLOAD_ELIG_BYTES_DELTA                        NUMBER
 IO_INTERCONNECT_BYTES_TOTAL                        NUMBER
 IO_INTERCONNECT_BYTES_DELTA                        NUMBER
 PHYSICAL_READ_REQUESTS_TOTAL                       NUMBER
 PHYSICAL_READ_REQUESTS_DELTA                       NUMBER
 PHYSICAL_READ_BYTES_TOTAL                          NUMBER
 PHYSICAL_READ_BYTES_DELTA                          NUMBER
 PHYSICAL_WRITE_REQUESTS_TOTAL                      NUMBER
 PHYSICAL_WRITE_REQUESTS_DELTA                      NUMBER
 PHYSICAL_WRITE_BYTES_TOTAL                         NUMBER
 PHYSICAL_WRITE_BYTES_DELTA                         NUMBER
 OPTIMIZED_PHYSICAL_READS_TOTAL                     NUMBER
 OPTIMIZED_PHYSICAL_READS_DELTA                     NUMBER
 CELL_UNCOMPRESSED_BYTES_TOTAL                      NUMBER
 CELL_UNCOMPRESSED_BYTES_DELTA                      NUMBER
 IO_OFFLOAD_RETURN_BYTES_TOTAL                      NUMBER
 IO_OFFLOAD_RETURN_BYTES_DELTA                      NUMBER
 BIND_DATA                                          RAW(2000)
 FLAG                                               NUMBER

 DBA_HIST_SQLTEXT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 SQL_ID                                    NOT NULL VARCHAR2(13)
 SQL_TEXT                                           CLOB
 COMMAND_TYPE                                       NUMBER

 DBA_HIST_SQL_BIND_METADATA

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 SQL_ID                                    NOT NULL VARCHAR2(13)
 NAME                                               VARCHAR2(30)
 POSITION                                  NOT NULL NUMBER
 DUP_POSITION                                       NUMBER
 DATATYPE                                           NUMBER
 DATATYPE_STRING                                    VARCHAR2(15)
 CHARACTER_SID                                      NUMBER
 PRECISION                                          NUMBER
 SCALE                                              NUMBER
 MAX_LENGTH                                         NUMBER

 DBA_HIST_SQL_PLAN
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 SQL_ID                                    NOT NULL VARCHAR2(13)
 PLAN_HASH_VALUE                           NOT NULL NUMBER
 ID                                        NOT NULL NUMBER
 OPERATION                                          VARCHAR2(30)
 OPTIONS                                            VARCHAR2(30)
 OBJECT_NODE                                        VARCHAR2(128)
 OBJECT#                                            NUMBER
 OBJECT_OWNER                                       VARCHAR2(30)
 OBJECT_NAME                                        VARCHAR2(31)
 OBJECT_ALIAS                                       VARCHAR2(65)
 OBJECT_TYPE                                        VARCHAR2(20)
 OPTIMIZER                                          VARCHAR2(20)
 PARENT_ID                                          NUMBER
 DEPTH                                              NUMBER
 POSITION                                           NUMBER
 SEARCH_COLUMNS                                     NUMBER
 COST                                               NUMBER
 CARDINALITY                                        NUMBER
 BYTES                                              NUMBER
 OTHER_TAG                                          VARCHAR2(35)
 PARTITION_START                                    VARCHAR2(64)
 PARTITION_STOP                                     VARCHAR2(64)
 PARTITION_ID                                       NUMBER
 OTHER                                              VARCHAR2(4000)
 DISTRIBUTION                                       VARCHAR2(20)
 CPU_COST                                           NUMBER
 IO_COST                                            NUMBER
 TEMP_SPACE                                         NUMBER
 ACCESS_PREDICATES                                  VARCHAR2(4000)
 FILTER_PREDICATES                                  VARCHAR2(4000)
 PROJECTION                                         VARCHAR2(4000)
 TIME                                               NUMBER
 QBLOCK_NAME                                        VARCHAR2(31)
 REMARKS                                            VARCHAR2(4000)
 TIMESTAMP                                          DATE
 OTHER_XML                                          CLOB

 DBA_HIST_SQL_SUMMARY

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 TOTAL_SQL                                 NOT NULL NUMBER
 TOTAL_SQL_MEM                             NOT NULL NUMBER
 SINGLE_USE_SQL                            NOT NULL NUMBER
 SINGLE_USE_SQL_MEM                        NOT NULL NUMBER

 DBA_HIST_SQL_WORKAREA_HSTGRM

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 LOW_OPTIMAL_SIZE                          NOT NULL NUMBER
 HIGH_OPTIMAL_SIZE                         NOT NULL NUMBER
 OPTIMAL_EXECUTIONS                                 NUMBER
 ONEPASS_EXECUTIONS                                 NUMBER
 MULTIPASSES_EXECUTIONS                             NUMBER
 TOTAL_EXECUTIONS                                   NUMBER

 DBA_HIST_STAT_NAME
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 STAT_ID                                   NOT NULL NUMBER
 STAT_NAME                                 NOT NULL VARCHAR2(64)

 DBA_HIST_STREAMS_APPLY_SUM

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 APPLY_NAME                                NOT NULL VARCHAR2(30)
 STARTUP_TIME                              NOT NULL DATE
 READER_TOTAL_MESSAGES_DEQUEUED                     NUMBER
 READER_LAG                                         NUMBER
 COORD_TOTAL_RECEIVED                               NUMBER
 COORD_TOTAL_APPLIED                                NUMBER
 COORD_TOTAL_ROLLBACKS                              NUMBER
 COORD_TOTAL_WAIT_DEPS                              NUMBER
 COORD_TOTAL_WAIT_CMTS                              NUMBER
 COORD_LWM_LAG                                      NUMBER
 SERVER_TOTAL_MESSAGES_APPLIED                      NUMBER
 SERVER_ELAPSED_DEQUEUE_TIME                        NUMBER
 SERVER_ELAPSED_APPLY_TIME                          NUMBER

 DBA_HIST_STREAMS_CAPTURE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 CAPTURE_NAME                              NOT NULL VARCHAR2(30)
 STARTUP_TIME                              NOT NULL DATE
 LAG                                                NUMBER
 TOTAL_MESSAGES_CAPTURED                            NUMBER
 TOTAL_MESSAGES_ENQUEUED                            NUMBER
 ELAPSED_RULE_TIME                                  NUMBER
 ELAPSED_ENQUEUE_TIME                               NUMBER
 ELAPSED_REDO_WAIT_TIME                             NUMBER
 ELAPSED_PAUSE_TIME                                 NUMBER

 DBA_HIST_STREAMS_POOL_ADVICE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 SIZE_FOR_ESTIMATE                         NOT NULL NUMBER
 SIZE_FACTOR                                        NUMBER
 ESTD_SPILL_COUNT                                   NUMBER
 ESTD_SPILL_TIME                                    NUMBER
 ESTD_UNSPILL_COUNT                                 NUMBER
 ESTD_UNSPILL_TIME                                  NUMBER

 DBA_HIST_SYSMETRIC_HISTORY

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 BEGIN_TIME                                NOT NULL DATE
 END_TIME                                  NOT NULL DATE
 INTSIZE                                   NOT NULL NUMBER
 GROUP_ID                                  NOT NULL NUMBER
 METRIC_ID                                 NOT NULL NUMBER
 METRIC_NAME                               NOT NULL VARCHAR2(64)
 VALUE                                     NOT NULL NUMBER
 METRIC_UNIT                               NOT NULL VARCHAR2(64)

 DBA_HIST_SYSMETRIC_SUMMARY

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 BEGIN_TIME                                NOT NULL DATE
 END_TIME                                  NOT NULL DATE
 INTSIZE                                   NOT NULL NUMBER
 GROUP_ID                                  NOT NULL NUMBER
 METRIC_ID                                 NOT NULL NUMBER
 METRIC_NAME                               NOT NULL VARCHAR2(64)
 METRIC_UNIT                               NOT NULL VARCHAR2(64)
 NUM_INTERVAL                              NOT NULL NUMBER
 MINVAL                                    NOT NULL NUMBER
 MAXVAL                                    NOT NULL NUMBER
 AVERAGE                                   NOT NULL NUMBER
 STANDARD_DEVIATION                        NOT NULL NUMBER
 SUM_SQUARES                                        NUMBER

 DBA_HIST_SYSSTAT
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 STAT_ID                                   NOT NULL NUMBER
 STAT_NAME                                 NOT NULL VARCHAR2(64)
 VALUE                                              NUMBER

 DBA_HIST_SYSTEM_EVENT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 EVENT_ID                                  NOT NULL NUMBER
 EVENT_NAME                                NOT NULL VARCHAR2(64)
 WAIT_CLASS_ID                                      NUMBER
 WAIT_CLASS                                         VARCHAR2(64)
 TOTAL_WAITS                                        NUMBER
 TOTAL_TIMEOUTS                                     NUMBER
 TIME_WAITED_MICRO                                  NUMBER
 TOTAL_WAITS_FG                                     NUMBER
 TOTAL_TIMEOUTS_FG                                  NUMBER
 TIME_WAITED_MICRO_FG                               NUMBER

 DBA_HIST_SYS_TIME_MODEL

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 STAT_ID                                   NOT NULL NUMBER
 STAT_NAME                                 NOT NULL VARCHAR2(64)
 VALUE                                              NUMBER

 DBA_HIST_TABLESPACE_STAT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 TS#                                       NOT NULL NUMBER
 TSNAME                                             VARCHAR2(30)
 CONTENTS                                           VARCHAR2(9)
 STATUS                                             VARCHAR2(9)
 SEGMENT_SPACE_MANAGEMENT                           VARCHAR2(6)
 EXTENT_MANAGEMENT                                  VARCHAR2(10)
 IS_BACKUP                                          VARCHAR2(5)

 DBA_HIST_TBSPC_SPACE_USAGE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                            NUMBER
 DBID                                      NOT NULL NUMBER
 TABLESPACE_ID                                      NUMBER
 TABLESPACE_SIZE                                    NUMBER
 TABLESPACE_MAXSIZE                                 NUMBER
 TABLESPACE_USEDSIZE                                NUMBER
 RTIME                                              VARCHAR2(25)

 DBA_HIST_TEMPFILE
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 FILE#                                     NOT NULL NUMBER
 CREATION_CHANGE#                          NOT NULL NUMBER
 FILENAME                                  NOT NULL VARCHAR2(513)
 TS#                                       NOT NULL NUMBER
 TSNAME                                    NOT NULL VARCHAR2(30)
 BLOCK_SIZE                                         NUMBER

 DBA_HIST_TEMPSTATXS

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 FILE#                                     NOT NULL NUMBER
 CREATION_CHANGE#                          NOT NULL NUMBER
 FILENAME                                  NOT NULL VARCHAR2(513)
 TS#                                       NOT NULL NUMBER
 TSNAME                                    NOT NULL VARCHAR2(30)
 BLOCK_SIZE                                         NUMBER
 PHYRDS                                             NUMBER
 PHYWRTS                                            NUMBER
 SINGLEBLKRDS                                       NUMBER
 READTIM                                            NUMBER
 WRITETIM                                           NUMBER
 SINGLEBLKRDTIM                                     NUMBER
 PHYBLKRD                                           NUMBER
 PHYBLKWRT                                          NUMBER
 WAIT_COUNT                                         NUMBER
 TIME                                               NUMBER

 DBA_HIST_THREAD
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 THREAD#                                   NOT NULL NUMBER
 THREAD_INSTANCE_NUMBER                             NUMBER
 STATUS                                             VARCHAR2(6)
 OPEN_TIME                                          DATE
 CURRENT_GROUP#                                     NUMBER
 SEQUENCE#                                          NUMBER

 DBA_HIST_TOPLEVELCALL_NAME

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 TOP_LEVEL_CALL#                           NOT NULL NUMBER
 TOP_LEVEL_CALL_NAME                                VARCHAR2(64)

 DBA_HIST_UNDOSTAT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 BEGIN_TIME                                NOT NULL DATE
 END_TIME                                  NOT NULL DATE
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 SNAP_ID                                   NOT NULL NUMBER
 UNDOTSN                                   NOT NULL NUMBER
 UNDOBLKS                                           NUMBER
 TXNCOUNT                                           NUMBER
 MAXQUERYLEN                                        NUMBER
 MAXQUERYSQLID                                      VARCHAR2(13)
 MAXCONCURRENCY                                     NUMBER
 UNXPSTEALCNT                                       NUMBER
 UNXPBLKRELCNT                                      NUMBER
 UNXPBLKREUCNT                                      NUMBER
 EXPSTEALCNT                                        NUMBER
 EXPBLKRELCNT                                       NUMBER
 EXPBLKREUCNT                                       NUMBER
 SSOLDERRCNT                                        NUMBER
 NOSPACEERRCNT                                      NUMBER
 ACTIVEBLKS                                         NUMBER
 UNEXPIREDBLKS                                      NUMBER
 EXPIREDBLKS                                        NUMBER
 TUNED_UNDORETENTION                                NUMBER

 DBA_HIST_WAITCLASSMET_HISTORY

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 WAIT_CLASS_ID                             NOT NULL NUMBER
 WAIT_CLASS                                         VARCHAR2(64)
 BEGIN_TIME                                NOT NULL DATE
 END_TIME                                  NOT NULL DATE
 INTSIZE                                   NOT NULL NUMBER
 GROUP_ID                                  NOT NULL NUMBER
 AVERAGE_WAITER_COUNT                      NOT NULL NUMBER
 DBTIME_IN_WAIT                            NOT NULL NUMBER
 TIME_WAITED                               NOT NULL NUMBER
 WAIT_COUNT                                NOT NULL NUMBER
 TIME_WAITED_FG                                     NUMBER
 WAIT_COUNT_FG                                      NUMBER

 DBA_HIST_WAITSTAT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 CLASS                                     NOT NULL VARCHAR2(18)
 WAIT_COUNT                                         NUMBER
 TIME                                               NUMBER

 DBA_HIST_WR_CONTROL

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                      NOT NULL NUMBER
 SNAP_INTERVAL                             NOT NULL INTERVAL DAY(5) TO SECOND(1)
 RETENTION                                 NOT NULL INTERVAL DAY(5) TO SECOND(1)
 TOPNSQL                                            VARCHAR2(10)




Comments