Re: Dropping Many Synonyms?

Jonathan,

I'm running Oracle 7.3.3.6 on DEC Alpha OpenVMS 7.1

My synonym dropping usually goes like this:

• drop many synonyms
• shutdown immediate (happens fast)
• startup restrict (happens fast)
• shutdown normal (taks a looong time, with lots of SMON activity)

Baed on you suggestion, I tried this:

• dropped 1000 synonyms
• shutdown immediate (no problem)
• startup restrict (no problem)
• (looked up the OS PID for SMON in another telnet session)
• oradebug setospid 0000E11F (took a minute for prompt to return)

ORA-03113: end-of-file on communication channel

...and inside the trace file, I see:

• SESSION ID:(8.1) 1999.11.26.09.58.38.052 ksedmp: internal or fatal error ORA-00075: process "pid: e11f, image: " not found in this instance

...I tried putting quotes around the PID on the oradebug command, but that didn't work either.

Would you happen to know what I'm doing wrong?

--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 Fri Nov 26 1999 - 09:21:51 CST