dba_hist_resource_limit Tips

Oracle Database Tips by Donald BurlesonNovember 28, 2015

Question:I want to be able to track the high water
mark of session and Oracle processes and I hear that the
dba_hist_resource_limit table can hold the limits for
various resources. Can you show an example of using
dba_hist_resource_limit?

Answer:Yes,
dba_hist_resource_limit is a great way to see the
high water-mark values of various metrics within Oracle
including the high-water marks for sessions and processes.
Also see
v$resource_limit.

Here is an example query using dba_hist_resource_limit:
It reports only on these metrics

Note:This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.

Verify
experience!Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.

Errata? Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just e-mail: