Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g7RJets18513 for ; Tue, 27 Aug 2002 15:40:55 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id MAA33565; Tue, 27 Aug 2002 12:38:53 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004C0A04; Tue, 27 Aug 2002 12:18:19 -0800 Message-ID: Date: Tue, 27 Aug 2002 12:18:19 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Ed Lewis" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Ed Lewis" Subject: controlling CPU usage through Oracle Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_02D8_01C24DDC.4D743340" ------=_NextPart_000_02D8_01C24DDC.4D743340 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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. =20 This database is 1 of 5 on this box. So, although it's important to build effective queries, it's also important in this=20 environment that these queries do not impact the other 4 databases.=20 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,=20 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. ------=_NextPart_000_02D8_01C24DDC.4D743340 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

I'm looking for a = way to control=20 CPU usage of

particular queries on a = database.

After exploring, and = implementing ways of optimizing the code,

these queries can run anywhere from 45=20 seconds

to 2 minutes.

This database is 1 = of 5 on this=20 box. So, although it's important

to build effective queries, it's also = important in=20 this

environment that these queries do not = impact the=20 other

4 databases.

What I want to do is = place a=20 limit on CPU usage

without terminating the query. I've = looked at=20 profiles

with the "cpu_per_call" and = "cpu_per_session"=20 settings.

I have never used profiles, but from = what I=20 understand,

these will kill the session once they = reach a=20 threshold.

I'm also looking at = database=20 resource management.

This may be more appropriate for this=20 situation.

Has anyone used = this, and if so=20 what are you

experiences ? Would you recommend it = ?

Would the only = way to=20 control CPU usage on this

box, be through the operating system = ?

I welcome any suggestions. I appreciate = your=20 time.

The environment is Oracle 8.1.7.2, AIX=20 4.3.3.

------=_NextPart_000_02D8_01C24DDC.4D743340-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Lewis INET: eglewis@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@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).