controlling CPU usage through Oracle

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.

Reply via email to