i've 11.2 Database with Apex.
I've many Virtual Circuit Wait events and i probably hit this problem Doc.id 1136313.1
Looking Anonymous session i see the initially it uses Shared session (with high network usage in ash Viewer)
After 60s it changes to Dedicated (in v$session) without a process in v$process.
Looking ASH viewer it show me very high cpu usage, with description "Not waiting, currently on CPU. Time on CPU = -16 seconds, so far"
We use Embedded PL/SQL Gateway.
>I've many Virtual Circuit Wait events
please quantify at what value does count become "many".
>Looking ASH viewer it show me very high cpu usage
please quantify at what value does CPU usage become high.
exactly what problem needs to be solved?
how will you, I, or anyone recognize which post contains correct solution for you?