The following SQL produces a very useful report of current resource utilization at the time of the query and the HWM since the database was started. What SQL can I add to list the time of the HWM? Database & ‘OS = Oracle 10.2.0.4 running on AIX 5.3.0.0 5300-09 64-bit. Thanks, Bruce

col resource_name format a25 head "Resource"

col current_utilization format 999,999,999,999 head "Current"

col max_utilization format 999,999,999,999 head "HWM"

col intl format a15 head "Setting"

 select resource_name, current_utilization, max_utilization, initial_allocation intl from v$resource_limit where resource_name in ('processes', 'sessions','enqueue_locks','enqueue_resources', 'ges_procs','ges_ress','ges_locks','ges_cache_ress','ges_reg_msgs', 'ges_big_msgs','ges_rsv_msgs','gcs_resources','dml_locks','max_shared_servers')

Resource                   Current            HWM             Setting             ------------------------- ---------------- ---------------- --------------- processes                  21                  26                      150              sessions                    26                  34                      170 enqueue_locks           12                  23                     2380 enqueue_resources     12                  40                     968                  g es_procs                   0                    0                         0      ges_ress                      0                    0                         0   ges_locks                     0                    0                         0 ges_cache_ress             0                    0                         0 ges_reg_msgs              0                     0                        0 ges_big_msgs               0                     0                        0 ges_rsv_msgs               0                      0                       0   

Resource                      Current          HWM                   Setting          ------------------------- ---------------- ---------------- --------------- gcs_resources                    0               0                           0 dml_locks                         0               72                       748 max_shared_servers          1                1                       UNLIMITED



Software/Hardware used:
Database & ‘OS = Oracle 10.2.0.4 running on AIX 5.3.0.0 5300-09 64-bit.