Oracle-L: controlling CPU usage through Oracle

From: Ed Lewis <eglewis_at_hotmail.com>
Date: Tue, 27 Aug 2002 12:18:19 -0800
Message-ID: <F001.004C0A04.20020827121819@fatcity.com>

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.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ed Lewis
INET: eglewis_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 27 2002 - 15:18:19 CDT