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
L
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
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