Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dropping Many Synonyms?
Jonathan,
Thank you so much for the response.
You do realize that the long wait is happening during a shutdown. Are you saying that I can open up an additional SVRMGRL session while that shutdown is going on and issue those oradebug commands?
--Jon
On Tue, 23 Nov 1999 16:29:20 -0000, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
>svrmgrl
>> oradebug setospid {Unix pid for smon}
>> oradebug event 10046 trace name context forever, level 4
>
> wait a bit
>
>> oradebug event 10046 trace name context off
>
>
>This will give you a trace file with bind variable
>values of smon's activity. Let us know the results.
>(NB change level 4 to level 8 to get a list of
>wait events, or level 12 to get bind values and
>wait events).
Received on Wed Nov 24 1999 - 08:54:30 CST