What is your shared pool size? It could be that your shared pool is too
small for the amount of statements that you process...

Best regards,

Paul Tabashov
Pontis Corporation
http://www.pontis.biz


-----Original Message-----
From: Rana rana [mailto:[Email Address Removed]
Sent: Friday, October 31, 2003 1:01 PM
To: LazyDBA.com Discussion
Subject: Urgent Ora-00604,Ora-00477


Friends
I have got a error of Ora-00604,Ora-00477 in my trace
file.Also Iam getting very slow performance from my DB.My Parse to
Execute Ratio shows itself in the red light in Toad.Can anyone help me
out in detecting the problem and solution.

Thanx

Yahoo! India Matrimony: Find your partner online.Post your profile.
Oracle LazyDBA home page