This discussion is archived
2 Replies Latest reply: Oct 23, 2013 6:46 AM by Dan A RSS

current action vs action in

Dan A Explorer
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points