how to reduce 'resmgr:waiting in check' wait event in Oracle 9i Database
Posted on 2010-01-11
We have in our Oracle 22.214.171.124 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.