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 bu

RE: controlling CPU usage through Oracle

2002-08-27 Thread Jamadagni, Rajendra
that of ESPN Inc. 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,   

Re:RE: controlling CPU usage through Oracle

2002-08-27 Thread dgoulet
eflect that of ESPN Inc. 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

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.

Re: controlling CPU usage through Oracle

2002-08-28 Thread Ed Lewis
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 at ESPN

RE: controlling CPU usage through Oracle

2002-08-28 Thread Cary Millsap
Forum, Sep 20–22 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

RE: controlling CPU usage through Oracle

2002-08-28 Thread Jeff Holt
, Aug 28, 2002 08:13 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

Re[2]: controlling CPU usage through Oracle

2002-08-28 Thread dgoulet
RACLE-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, ESPN Inc.

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

2002-08-28 Thread kkennedy
ed 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 Oracle You could use profiles

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

2002-08-28 Thread DENNIS WILLIAMS
ed 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 Oracle You could use profiles to control

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

2002-08-29 Thread dgoulet
- 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. Raj _

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

2002-08-29 Thread Ed Lewis
uesday, 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. After exploring, and implementing ways of optimizing

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

2002-08-30 Thread Yechiel Adar
you get OLE! What can this mean? > > -Original Message- > Sent: Wednesday, August 28, 2002 9:52 AM > To: Multiple recipients of list ORACLE-L > > -Original Message- > From: Ed Lewis [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 27, 2002 4

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 t

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 pro

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

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 throttl