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 22.214.171.124 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')
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: