2 Replies Latest reply: Oct 23, 2013 8:46 AM by Dan A RSS

    current action vs action in

    Dan A

      Application

      Current SQLhttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifbxaptxn8wf54j
      Current SQL Commandhttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifSELECT
      Last Call Durationhttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gif26:7 (mm:ss)
      SQL Tracehttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifDISABLED
      Current SQL Trace Levelhttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gif1
      Trace With Wait Informationhttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifDISABLED
      Trace With Bind Informationhttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifDISABLED
      Open Cursorshttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gif71
      Programhttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifUnavailable
      Servicehttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifPROD
      Current Modulehttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifIEUSEUWQ
      Current Actionhttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifFRM:JOSONC1:RBI Collections Ag

      The above is from dbconsole - it shows the "current module" and the "current action".

       

      General

      Modulehttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifIEUSEUWQ
      Actionhttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifFRM:VICKERYJ:RBI Collections Age
      Parsing Schemahttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifAPPS
      PL/SQL Source (Line Number)https://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifNot Applicable
      SQL Profilehttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifn/a
      SQL Plan Baselinehttps://rbiqhsclup06.b2b.regn.net:1158/em/cabo/images/t.gifn/a

       

       

      The above is also from the same module, but this time we have "action".

       

      Please, what would be the difference between "action" and "current action"??

       

      I have checked several documents, such as http://docs.oracle.com/cd/B28359_01/server.111/b28275/tdppt_sqltune.htm

      which deal with "action", but nothing to reference "current action"

       

      11.2.0.3

      RHEL 5.5