Re: Tracing query inside procedure without 10046

Dear All,

Thanks for your response .

Hi Mladen,
currently working on job which executes in night only and issue was reported on next morning , so for tracing we need to hold it till night again and do analysis , so our intention was to find out the sql which was related to subprocedure instantly .

so we were looking for any alternative for figuring out those sql , we checked dba_hist_act* views for not much luck . Hope this clear the need .

Regards,
Krishna

On Sat, 5 Aug 2023 at 05:47, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> On 8/4/23 14:59, Clay Jackson (Clay.Jackson) wrote:
>
> And what’s the reasoning behind at least not trying trace/Method-R?
>
> I'd ask the original poster. I have no idea why is the OP trying to do
> without tracing.
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>
>

--
http://www.freelists.org/webpage/oracle-l