How to detect when did ocurre ORA-00604?
From: <jbeteta_at_gmail.com>
Date: Mon, 15 Oct 2012 16:11:06 -0700 (PDT)
Message-ID: <de06ea7d-38d6-4390-a924-52a921532345_at_googlegroups.com>
Today, between 3:00pm-3:30pm, my Oracle 10g database on Windows hanged on twice. Error messages were related to ORA-00604. I'm pretty sure it was some query or queries that some user run as owner of some schema.
Date: Mon, 15 Oct 2012 16:11:06 -0700 (PDT)
Message-ID: <de06ea7d-38d6-4390-a924-52a921532345_at_googlegroups.com>
Today, between 3:00pm-3:30pm, my Oracle 10g database on Windows hanged on twice. Error messages were related to ORA-00604. I'm pretty sure it was some query or queries that some user run as owner of some schema.
I'm checking listener.log, archived redo logs from that time (about 20 million records) and alert.instance-name.log on C:\oracle\product\10.2.0\admin\instance-name\bdump, but I don't find any anormal related to ORA-00604.
Would you suggest how or what else to search? Received on Tue Oct 16 2012 - 01:11:06 CEST