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
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,
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
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.
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
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
, 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
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.
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
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
-
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
_
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
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
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
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
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
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
17 matches
Mail list logo