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

2002-08-30 Thread Yechiel Adar

In NT and win2000 you can set Os priorities to the different tasks.
If you have the sane facility on aix you can give this db a lower priority
so whenever the other databases will need CPU they will get it.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 3:48 PM


> Kevin,
> Thanks for your input.
> Just to clarify;  I only want to control this
> one database. I want to limit its resources
> so it does not impact the other 4 databases on
> the box. So, in that case would resource
> manager be beneficial ?
> Also, besides profiles, and resource manager,
> does anyone know of any other tools provided
> by Oracle which would limit resources ?
> Or, any 3rd party tools that my be beneficial ?
>
> I thank everyone for providing their input;
> it's much appreciated.
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 28, 2002 5:23 PM
>
>
> I don't think Resource Manager is going to do the trick here (I just read
> about it over the last week while preparing for OCP exam 4).  Resource
> Manager would work great for a single database but Ed is trying to divvy
up
> resources between 5 databases.
>
> I don't have any good solution.  I suppose if everything running on this
one
> database was less important than anything on the other 4 databases, you
> could renice the one database.  I think that would be ok provided all
> components of the one database were at the same nice level.
>
> Kevin Kennedy
> First Point Energy Corporation
>
> If you take RAC out of Oracle 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: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 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 effective queries, it's also important in this
> environment that these queries do not impact the other
> 4 databases.
> 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,
> 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.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ed Lewis
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



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 
  PM
  Subject: 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.  The net effect would be to throttle 
  the problem database by denying it the resources used by the 
others.
  How about using processor sets do achieve the same 
  thing.  I'm thinking along the lines of two sets, one with a very low 
  number of CPU's.  You would then bind your problem child to the small set 
  and the rest to the other.
  HTH Tony Aponte 



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.  The net effect would be to throttle the problem database by denying it the resources used by the others.

How about using processor sets do achieve the same thing.  I'm thinking along the lines of two sets, one with a very low number of CPU's.  You would then bind your problem child to the small set and the rest to the other.


HTH

Tony Aponte





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 all the
users who use this id. Wouldn't ORM be beneficial in that
situation ? thanks.

ed

> Dennis,
>
> You've got that right.  Damned PeopleSoft!  We were hoping we might be
able
> to leverage ORM to control PeopleSorft query users.  No such luck since
everyone
> is PeopleSoft.  Now on the other hand, if you've got the LUXURY of having
people
> logged in with their own usernames you certainly can throttle down those
you
> want, almost to a crawl.
>
dick goulet

> Dick - My understanding is that Oracle Resource Manager controls resources
> based on userid. In other words, if a third-party application or an
> application server uses the same Oracle userid for access, then Oracle
> Resource Manager wouldn't help much. Is that what you've seen?
> Dennis Williams
> DBA
> Lifetouch, Inc.
>
> Ed,
>
> The only way your going to do this is through Oracle Resource Manager.
> You'll need an 8.1.x Enterprise database.  Then you can setup your
resource
> plans and groups to manage who gets how much CPU at a time.  Any of the
> operating level tools out there cannot get down to the level of
granularity
> your
> asking for since all of the activity happens within Oracle.  All those
tools
> can
> do is control the amount of CPU that Oracle gets which has a global effect
> that
> hampers all users of the database.
>
> Dick Goulet

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ed Lewis
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



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 that right.  Damned PeopleSoft!  We were hoping we might be
able
> to leverage ORM to control PeopleSorft query users.  No such luck since
everyone
> is PeopleSoft.  Now on the other hand, if you've got the LUXURY of having
people
> logged in with their own usernames you certainly can throttle down those
you
> want, almost to a crawl.
>
dick goulet

> Dick - My understanding is that Oracle Resource Manager controls resources
> based on userid. In other words, if a third-party application or an
> application server uses the same Oracle userid for access, then Oracle
> Resource Manager wouldn't help much. Is that what you've seen?
> Dennis Williams
> DBA
> Lifetouch, Inc.
>
> Ed,
>
> The only way your going to do this is through Oracle Resource Manager.
> You'll need an 8.1.x Enterprise database.  Then you can setup your
resource
> plans and groups to manage who gets how much CPU at a time.  Any of the
> operating level tools out there cannot get down to the level of
granularity
> your
> asking for since all of the activity happens within Oracle.  All those
tools
> can
> do is control the amount of CPU that Oracle gets which has a global effect
> that
> hampers all users of the database.
>
> Dick Goulet

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ed Lewis
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



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

2002-08-29 Thread Ed Lewis

Kevin,
Thanks for your input.
Just to clarify;  I only want to control this
one database. I want to limit its resources
so it does not impact the other 4 databases on
the box. So, in that case would resource
manager be beneficial ?
Also, besides profiles, and resource manager,
does anyone know of any other tools provided
by Oracle which would limit resources ?
Or, any 3rd party tools that my be beneficial ?

I thank everyone for providing their input;
it's much appreciated.


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 28, 2002 5:23 PM


I don't think Resource Manager is going to do the trick here (I just read
about it over the last week while preparing for OCP exam 4).  Resource
Manager would work great for a single database but Ed is trying to divvy up
resources between 5 databases.

I don't have any good solution.  I suppose if everything running on this one
database was less important than anything on the other 4 databases, you
could renice the one database.  I think that would be ok provided all
components of the one database were at the same nice level.

Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle 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: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 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 effective queries, it's also important in this
environment that these queries do not impact the other
4 databases.
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,
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.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ed Lewis
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



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

2002-08-29 Thread dgoulet

Dennis,

You've got that right.  Damned PeopleSoft!  We were hoping we might be able
to leverage ORM to control PeopleSorft query users.  No such luck since everyone
is PeopleSoft.  Now on the other hand, if you've got the LUXURY of having people
logged in with their own usernames you certainly can throttle down those you
want, almost to a crawl.

Dick Goulet

Reply Separator
Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Date:   8/28/2002 1:53 PM

Dick - My understanding is that Oracle Resource Manager controls resources
based on userid. In other words, if a third-party application or an
application server uses the same Oracle userid for access, then Oracle
Resource Manager wouldn't help much. Is that what you've seen?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 28, 2002 11:52 AM
To: Multiple recipients of list ORACLE-L


Ed,

The only way your going to do this is through Oracle Resource Manager. 
You'll need an 8.1.x Enterprise database.  Then you can setup your resource
plans and groups to manage who gets how much CPU at a time.  Any of the
operating level tools out there cannot get down to the level of granularity
your
asking for since all of the activity happens within Oracle.  All those tools
can
do is control the amount of CPU that Oracle gets which has a global effect
that
hampers all users of the database.

Dick Goulet

Reply Separator
Author: "Ed Lewis" <[EMAIL PROTECTED]>
Date:   8/28/2002 5:13 AM

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 the session. I need to be able
to control the CPU usage of a session, without
ending it. 
 If this cannot be done 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 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 dot com

  Any opinion expressed here is personal and doesn't reflect 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 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 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 effective queries, it's also important in this 
environment that these queries do not impact the other
4 databases. 
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, 
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.









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 the session. I need to be 
able
to control the CPU usage of a session, 
without
ending it. 
 If this cannot be done

within Oracle, then
maybe it can be accomplished through the 
OS.
 
        
thanks.
        
                
ed
 
 
        
         

  - Original Message - 
  From: 
  mailto:[EMAIL PROTECTED]"; 
  [EMAIL PROTECTED]>Jamadagni, Rajendra 
  To: mailto:[EMAIL PROTECTED]";

  [EMAIL PROTECTED]>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
  __
  Rajendra 
  Jamadagni  
      MIS, ESPN Inc.
  Rajendra dot Jamadagni at
ESPN 
  dot com
  Any o

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

2002-08-28 Thread DENNIS WILLIAMS

Dick - My understanding is that Oracle Resource Manager controls resources
based on userid. In other words, if a third-party application or an
application server uses the same Oracle userid for access, then Oracle
Resource Manager wouldn't help much. Is that what you've seen?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 28, 2002 11:52 AM
To: Multiple recipients of list ORACLE-L


Ed,

The only way your going to do this is through Oracle Resource Manager. 
You'll need an 8.1.x Enterprise database.  Then you can setup your resource
plans and groups to manage who gets how much CPU at a time.  Any of the
operating level tools out there cannot get down to the level of granularity
your
asking for since all of the activity happens within Oracle.  All those tools
can
do is control the amount of CPU that Oracle gets which has a global effect
that
hampers all users of the database.

Dick Goulet

Reply Separator
Author: "Ed Lewis" <[EMAIL PROTECTED]>
Date:   8/28/2002 5:13 AM

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 the session. I need to be able
to control the CPU usage of a session, without
ending it. 
 If this cannot be done 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 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 dot com

  Any opinion expressed here is personal and doesn't reflect 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 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 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 effective queries, it's also important in this 
environment that these queries do not impact the other
4 databases. 
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, 
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.









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 the session. I need to be 
able
to control the CPU usage of a session, 
without
ending it. 
 If this cannot be done

within Oracle, then
maybe it can be accomplished through the 
OS.
 
        
thanks.
        
                
ed
 
 
        
         

  - Original Message - 
  From: 
  mailto:[EMAIL PROTECTED]"; 
  [EMAIL PROTECTED]>Jamadagni, Rajendra 
  To: mailto:[EMAIL PROTECTED]";

  [EMAIL PROTECTED]>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
  __
  Rajendra 
  Jamadagni  
      MIS, ESPN Inc.
  Rajendra dot Jamadagni at
ESPN 
  dot com
  Any opinion expressed here
is 
  personal and doesn't reflect 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,
    I'm looking for a way to

control CPU usage of
particular queries on a
database.
    After exploring, and 
  

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

2002-08-28 Thread kkennedy

I don't think Resource Manager is going to do the trick here (I just read about it 
over the last week while preparing for OCP exam 4).  Resource Manager would work great 
for a single database but Ed is trying to divvy up resources between 5 databases.

I don't have any good solution.  I suppose if everything running on this one database 
was less important than anything on the other 4 databases, you could renice the one 
database.  I think that would be ok provided all components of the one database were 
at the same nice level.

Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE!  What can this mean?

-Original Message-
Sent: Wednesday, August 28, 2002 9:52 AM
To: Multiple recipients of list ORACLE-L


Ed,

The only way your going to do this is through Oracle Resource Manager. 
You'll need an 8.1.x Enterprise database.  Then you can setup your resource
plans and groups to manage who gets how much CPU at a time.  Any of the
operating level tools out there cannot get down to the level of granularity your
asking for since all of the activity happens within Oracle.  All those tools can
do is control the amount of CPU that Oracle gets which has a global effect that
hampers all users of the database.

Dick Goulet

Reply Separator
Author: "Ed Lewis" <[EMAIL PROTECTED]>
Date:   8/28/2002 5:13 AM

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 the session. I need to be able
to control the CPU usage of a session, without
ending it. 
 If this cannot be done 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 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 dot com

  Any opinion expressed here is personal and doesn't reflect 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 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 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 effective queries, it's also important in this 
environment that these queries do not impact the other
4 databases. 
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, 
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.









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 the session. I need to be 
able
to control the CPU usage of a session, 
without
ending it. 
 If this cannot be done 
within Oracle, then
maybe it can be accomplished through the 
OS.
 
        
thanks.
        
                
ed
 
 
        
         

  - Original Message - 
  From: 
  mailto:[EMAIL PROTECTED]"; 
  [EMAIL PROTECTED]>Jamadagni, Rajendra 
  To: mailto:[EMAIL PROTECTED]";

  [EMAIL PROTECTED]>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
  __
  Rajendra 
  Jamadagni  
      MIS, ESPN Inc.
  Rajendra dot Jamadagni at ESPN 
  dot com
  Any opinion expressed here is 
  personal and doesn't reflect that of ESPN Inc. 
  QOTD: Any clod can have facts, 
  but having an opinion is an 
  art!
  
-Original Message-Fr

Re[2]: controlling CPU usage through Oracle

2002-08-28 Thread dgoulet

Ed,

The only way your going to do this is through Oracle Resource Manager. 
You'll need an 8.1.x Enterprise database.  Then you can setup your resource
plans and groups to manage who gets how much CPU at a time.  Any of the
operating level tools out there cannot get down to the level of granularity your
asking for since all of the activity happens within Oracle.  All those tools can
do is control the amount of CPU that Oracle gets which has a global effect that
hampers all users of the database.

Dick Goulet

Reply Separator
Author: "Ed Lewis" <[EMAIL PROTECTED]>
Date:   8/28/2002 5:13 AM

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 the session. I need to be able
to control the CPU usage of a session, without
ending it. 
 If this cannot be done 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 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 dot com

  Any opinion expressed here is personal and doesn't reflect 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 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 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 effective queries, it's also important in this 
environment that these queries do not impact the other
4 databases. 
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, 
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.









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 the session. I need to be 
able
to control the CPU usage of a session, 
without
ending it. 
 If this cannot be done 
within Oracle, then
maybe it can be accomplished through the 
OS.
 
        
thanks.
        
                
ed
 
 
        
         

  - Original Message - 
  From: 
  mailto:[EMAIL PROTECTED]"; 
  [EMAIL PROTECTED]>Jamadagni, Rajendra 
  To: mailto:[EMAIL PROTECTED]";

  [EMAIL PROTECTED]>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
  __
  Rajendra 
  Jamadagni  
      MIS, ESPN Inc.
  Rajendra dot Jamadagni at ESPN 
  dot com
  Any opinion expressed here is 
  personal and doesn't reflect 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,
    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 effective queries, it's also important

in this 
environment that these queries do not impact 
the other
4 databases. 
    What I want to do is place a

limit on CPU usage
without terminating the query. I'v