Re: Re[2]: controlling CPU usage through Oracle

2002-08-30 Thread Yechiel Adar
- From: Ed Lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 4:18 PM To: Multiple recipients of list ORACLE-L Subject: controlling CPU usage through Oracle Hi, I'm looking for a way to control CPU usage of particular queries on a database

Re:RE: Re[2]: controlling CPU usage through Oracle

2002-08-29 Thread dgoulet
of list ORACLE-L Sent: Tuesday, August 27, 2002 4:48 PM Subject: RE: controlling CPU usage through Oracle You could use profiles to control CPU usage as well, more info is in manuals. Raj __ Rajendra Jamadagni MIS

Re: Re[2]: controlling CPU usage through Oracle

2002-08-29 Thread Ed Lewis
To: Multiple recipients of list ORACLE-L Subject: 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

Re: Re:RE: Re[2]: controlling CPU usage through Oracle

2002-08-29 Thread Ed Lewis
Dick and Dennis, The application here is the same, where all users are logged in as the same user via the application server. But in my case, I want to throttle all the users who use this id. Wouldn't ORM be beneficial in that situation ? thanks. ed Dennis, You've got

Re[2]: Re:RE: Re[2]: controlling CPU usage through Oracle

2002-08-29 Thread dgoulet
YES Reply Separator Author: Ed Lewis [EMAIL PROTECTED] Date: 8/29/2002 7:23 AM Dick and Dennis, The application here is the same, where all users are logged in as the same user via the application server. But in my case, I want to throttle

RE: Re:RE: Re[2]: controlling CPU usage through Oracle

2002-08-29 Thread Aponte, Tony
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle Just some thoughts. Does your OS have any domain partitioning features that you can use to create separate servers? You could carve out a portion of the CPU resources into a small domain and dedicate it to your problem child

Re: Re:RE: Re[2]: controlling CPU usage through Oracle

2002-08-29 Thread Ed Lewis
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle Tony, No, as of now it does not have that functionality. Thanks for your input. ed - Original Message - From: Aponte, Tony To: Multiple recipients of list ORACLE-L Sent: Thursday, August 29, 2002 1:33

Re: controlling CPU usage through Oracle

2002-08-28 Thread Ed Lewis
within Oracle, then maybe it can be accomplished through the OS. thanks. ed - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 27, 2002 4:48 PM Subject: RE: controlling CPU usage through

RE: controlling CPU usage through Oracle

2002-08-28 Thread Cary Millsap
, Sep 2022 Middlefart Denmark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ed Lewis Sent: Wednesday, August 28, 2002 8:13 AM To: Multiple recipients of list ORACLE-L Subject: Re: controlling CPU usage through Oracle Raj, Thanks for your input

RE: controlling CPU usage through Oracle

2002-08-28 Thread Jeff Holt
To: Multiple recipients of list ORACLE-L Subject: Re: controlling CPU usage through Oracle Raj, Thanks for your input. From what I understand with profiles, the session will be terminated once a threshold is reached. In this particular case, I cannot terminate

Re[2]: controlling CPU usage through Oracle

2002-08-28 Thread dgoulet
, August 27, 2002 4:48 PM Subject: RE: controlling CPU usage through Oracle You could use profiles to control CPU usage as well, more info is in manuals. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni

RE: Re[2]: controlling CPU usage through Oracle

2002-08-28 Thread kkennedy
. ed - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 27, 2002 4:48 PM Subject: RE: controlling CPU usage through Oracle You could use profiles to control CPU usage as well, more info

RE: Re[2]: controlling CPU usage through Oracle

2002-08-28 Thread DENNIS WILLIAMS
- Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 27, 2002 4:48 PM Subject: RE: controlling CPU usage through Oracle You could use profiles to control CPU usage as well, more info is in manuals

controlling CPU usage through Oracle

2002-08-27 Thread Ed Lewis
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

RE: controlling CPU usage through Oracle

2002-08-27 Thread Jamadagni, Rajendra
. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Ed Lewis [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 27, 2002 4:18 PMTo: Multiple recipients of list ORACLE-LSubject: controlling CPU usage through Oracle Hi, I'm looking for a way

Re:RE: controlling CPU usage through Oracle

2002-08-27 Thread dgoulet
Look into Oracle Resource Manager. Reply Separator Author: Jamadagni; Rajendra [EMAIL PROTECTED] Date: 8/27/2002 12:48 PM You could use profiles to control CPU usage as well, more info is in manuals. Raj

RE: controlling CPU usage through Oracle

2002-08-27 Thread DENNIS WILLIAMS
Ed - Have you looked at Oracle's Database Resource Manager feature? It may have had another name in 8i. The idea is that if you can segregate the queries and let Oracle allocate the resources, a lot more can be done, in theory, than the O.S. scheduler can. Dennis Williams DBA Lifetouch, Inc.