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