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
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
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
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
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
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
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
10 matches
Mail list logo
