Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: racgimon and ORA-25228

RE: racgimon and ORA-25228

From: Herring Dave - dherri <>
Date: Mon, 12 Nov 2007 22:44:09 -0600
Message-ID: <>

I originally set 10046 directly on the racg sessions using DBMS_SYSTEM.SET_EV, thinking that'd be the best way to track down this issue. When nothing came up, I went with the brute force method of "ALTER SYSTEM ...". Sorry, I've left a number of things out that I've tested and just listed the ones that should have come up with results.

I dumped entries from GV$SQL into a temporary table and could see that there weren't any statements being run on 10 second intervals, using:

insert into dherri.aud_sql_statements_tb select loads, executions, last_active_time, parsing_schema_name, inst_id, sql_text, sql_id
  from gv$sql
 where last_active_time >= sysdate - 12/86400; exec dbms_lock.sleep(10);

... which I ran the above a number of times.

Oracle insists this isn't an issue. I'm just frustrated that I can't find out exactly what's going on. I'm contemplating getting a copy of "truss" and running it on the racgimon processes to at least see what's going on. Guess I'm getting stubborn. :-)


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: [] On Behalf Of Alex
> Gorbachev
> Sent: Sunday, November 11, 2007 8:53 PM
> To: Herring Dave - dherri
> Cc: oracle-l
> Subject: Re: racgimon and ORA-25228
> 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?

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.

Received on Mon Nov 12 2007 - 22:44:09 CST

Original text of this message