Hi,
I'm looking for a way to control
CPU usage of
particular queries on a database.
After exploring, and
implementing ways of optimizing the code,
these queries can run anywhere from 45
seconds
to 2 minutes.
This database is 1 of 5 on this
box. So, although it's important
to build effective queries, it's also important in
this
environment that these queries do not impact the
other
4 databases.
What I want to do is place a
limit on CPU usage
without terminating the query. I've looked at
profiles
with the "cpu_per_call" and "cpu_per_session"
settings.
I have never used profiles, but from what I
understand,
these will kill the session once they reach a
threshold.
I'm also looking at database
resource management.
This may be more appropriate for this
situation.
Has anyone used this, and if so
what are you
experiences ? Would you recommend it ?
Would the only way to
control CPU usage on this
box, be through the operating system ?
I welcome any suggestions. I appreciate your
time.
The environment is Oracle 8.1.7.2, AIX
4.3.3.
|
- RE: controlling CPU usage through Oracle Ed Lewis
- RE: controlling CPU usage through Oracle Jamadagni, Rajendra
- Re:RE: controlling CPU usage through Oracle dgoulet
- RE: controlling CPU usage through Oracle DENNIS WILLIAMS
- Re: controlling CPU usage through Oracle Ed Lewis
- RE: controlling CPU usage through Oracle Cary Millsap
- RE: controlling CPU usage through Oracle Jeff Holt
- Re[2]: controlling CPU usage through Oracle dgoulet
- RE: Re[2]: controlling CPU usage through Oracle kkennedy
- RE: Re[2]: controlling CPU usage through Oracle DENNIS WILLIAMS
- Re:RE: Re[2]: controlling CPU usage through Oracl... dgoulet