Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Resource Manager - general questions
We just fired up the resource manager under 9i last week and I have
some general questions. Any feedback would be appreciated.
For instance...with consumer group 1 getting 99% of the CPU and group 2 getting 1%...I expect significant difference in actual response time. I'm seeing 20-21 seconds for the first group and 22-23 seconds for the other. Again, the CPU is 100% while these processes are running. Any explanation is to why RM isn't having a bigger impact?
2) Does the 'max_est_exec_time' work with PL/SQL? I can set it down to "1", but the PL/SQL process I'm using will still run to completion.
Thanks,
Ron Boggs
St. Louis
Received on Mon Jan 27 2003 - 11:14:07 CST