Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL call stack

Re: PL/SQL call stack

From: William Robertson <williamr2019_at_googlemail.com>
Date: 14 Jan 2007 01:54:12 -0800
Message-ID: <1168768452.134823.227660@s34g2000cwa.googlegroups.com>


cpiodumpv_at_gmail.com wrote:
> > What functionality is it that you think doesn't exist? Now you've got
> > me confused.
> > --
> > Daniel A. Morgan
> > University of Washington
> > damorgan_at_x.washington.edu
> > (replace x with u to respond)
> > Puget Sound Oracle Users Group
> > www.psoug.org
>
> I want the instrumentation Package to derive the calling
> package_name.procedure_name as opposed to the function
> package_name.procedure doing a set to identify it's self to the
> instrumentation utility.

This information is also shown in v$session (10.2.0.2 I think - I couldn't see your version in your post, apologies if I've missed it). I'm not sure if I should be recommending having every process constantly hammering v$session though. Received on Sun Jan 14 2007 - 03:54:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US