Re: SMON problem?

From: <posani_at_hotmail.com>
Date: 1998/02/24
Message-ID: <6cu722$2se$1@nnrp1.dejanews.com>#1/1

To solve this problem you have to set events and dump the error stack using alter system .. set events sql command (go through sql reference manual for syntax.Once you set events and dump the error stack. we can than look at the error stack for the actual problem. Hope this will solve the problem.

posani
In article <6cnk15$lmv_at_senator-bedfellow.MIT.EDU>, ronnie_at_space.mit.edu wrote:
>
>
> Hello. I am running Oracle 7.3.2 on Solaris/Sparc. Exactly every
> 12 hours, I get the following message in the SMON logfile (and
> alert file):
>
> Sat Feb 21 15:13:50 1998
> SMON: following errors trapped and ignored:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00942: table or view does not exist
>
> Can anyone help me get rid of it?
>
> Thanks in advance.
>
> Sincerely,
>
> #Ron
> ronnie_at_space.mit.edu
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Feb 24 1998 - 00:00:00 CST