Re: racgimon and ORA-25228
- From: "Alex Gorbachev" <ag@xxxxxxxxxxxx>
- To: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
- Date: Sun, 11 Nov 2007 21:52:45 -0500
Creating login trigger and enabling trace only for imon should focus
your search better. Proper scoping is one of the key areas of tracing.
Now, AQ has Java API and OCI API and AQ calls don't necessarily
produce SQL if I recall correctly.
Has anyone used 10046 on sessions that are using AQ API directly from
client programs? Anything in 10046?
On Nov 11, 2007 4:30 PM, Herring Dave - dherri <Dave.Herring@xxxxxxxxxx> wrote:
> I hope it is harmless, its just that I figured there's a possibility its
> causing other problems we haven't uncovered yet. I tried setting 10046
> database-wide, level 12, but nothing is getting generated matching the
> every 10 seconds error. You'd think there'd at least be a trace file
> with calls to my ON SERVERERROR trigger but nothing. And I am checking
> both node's udump / bdump directories.
>
> Dave
> ___________________________________
>
> David C. Herring, DBA | A c x i o m Delivery Center Organization
>
> 630-944-4762 office | 630-430-5988 wireless | 630-944-4989 fax
>
>
> > -----Original Message-----
> > From: gorbyx@xxxxxxxxx [mailto:gorbyx@xxxxxxxxx] On Behalf Of Alex
> > Gorbachev
> > Sent: Sunday, November 11, 2007 12:20 PM
> > To: Herring Dave - dherri
> > Cc: oracle-l
> > Subject: Re: racgimon and ORA-25228
> >
> > Hmm... Looking at the error - something has to do with advanced
> > queuing. Maybe related to workload balancing advisory and the way imon
> > gets notifications of service workload metrics. 10046 level 1 on these
> > sessions could be useful if you really want to know what's going on.
> >
> > It's probably harmless error simply indicating that no AQ messages to
> > consume and imon just expects this error and process appropriately.
>
> *************************************************************************
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be
> legally privileged.
>
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited.
>
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any copy
> of it from your computer system.
>
> Thank you.
> *************************************************************************
>
>
--
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://www.oracloid.com
BAAG party - www.BattleAgainstAnyGuess.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
