makk2010
asked on
how to reduce 'resmgr:waiting in check' wait event in Oracle 9i Database
We have in our Oracle 9.2.0.8 Database a user which opens upto 10 sessions at a time
from a certain Application and each session have same SQL script. The scripts finishes
fast but the thing is that the sessions are always running on the DB server and consuming CPU resources.
There are many 'resmgr:waiting in check' active wait events(from this user) on the Database most of the times, eventhough this particular DB user has unlimited
CPU_PER_SESSION, CPU_PER_CALL and SESSIONS_PER_USER set for his profile.
I changed the resource_manager_plan,
> alter system set resource_manager_plan=' ' ; scope=both;
the waiting event does not appear now but the load is still high on the Database Server.
So how do I change the resource plan to allocate more resources to this user
in order to reduce this wait event.
from a certain Application and each session have same SQL script. The scripts finishes
fast but the thing is that the sessions are always running on the DB server and consuming CPU resources.
There are many 'resmgr:waiting in check' active wait events(from this user) on the Database most of the times, eventhough this particular DB user has unlimited
CPU_PER_SESSION, CPU_PER_CALL and SESSIONS_PER_USER set for his profile.
I changed the resource_manager_plan,
> alter system set resource_manager_plan=' ' ; scope=both;
the waiting event does not appear now but the load is still high on the Database Server.
So how do I change the resource plan to allocate more resources to this user
in order to reduce this wait event.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
and this wait event is gone;
what exactly do you have in statspack?