How do I find the timestamp associated with HWM of processes/sessions in Oracle 10g on AIX

15 pts.
Tags:
AIX
HWM
Oracle 10g
Oracle High Water Mark
SQL
SQLPlus
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    I don't think you could modify your current query to get that information, because the resource_limit tables/views don't contain that information, so probably a totally different approach will be needed.
    68,430 pointsBadges:
    report
  • Csybjf
    Carlosdl, You confirmed what I suspected. I am afraid that I am stuck. What 'different approach' do you suggest? Thanks, csybjf
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following