1 Reply Latest reply: Sep 6, 2013 9:20 AM by sb92075 RSS

    Anonymous session question in 11.2

    Mr.D.

      Hi,

      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.

       

      Any ideas?

        • 1. Re: Anonymous session question in 11.2
          sb92075

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