Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> current procedure that is executing
<span style='font-size:10.0pt;
font-family:Arial'>List,
<span style='font-size:10.0pt;
font-family:Arial'>
<span style='font-size:10.0pt;
font-family:Arial'>Is there any way to tell what procedure rather than <span
class=SpellE>sql_text that is currently executing?
<span style='font-size:10.0pt;
font-family:Arial'>We are trying to develop a knowledge base were we require
this information.
<span style='font-size:10.0pt;
font-family:Arial'>
<span style='font-size:10.0pt;
font-family:Arial'>I tried to check v$sqlarea, <span
class=SpellE>v$sqltext but could not find the relevant information in
the shared pool.
<span style='font-size:10.0pt;
font-family:Arial'>
<span style='font-size:10.0pt;
font-family:Arial'>Any help or pointer will be greatly appreciated.
<span style='font-size:10.0pt;
font-family:Arial'>
<span style='font-size:10.0pt;
font-family:Arial'>TIA
Suhen
<span style='font-size:10.0pt;
font-family:Arial'>
<span style='font-size:10.0pt;
font-family:Arial'>
Received on Sun Sep 09 2001 - 20:18:35 CDT