ORA-007445 issue in HP/UX

From: Roger Xu <wellmetus_at_gmail.com>
Date: Wed, 16 Sep 2009 14:18:22 -0500
Message-ID: <eb64345d0909161218u3b658b94w7ceba63e284911b8_at_mail.gmail.com>

Hi List,

If you ever run into this issue, can you share the work around?

Oracle 9iR2

Symtom: select count(*) from table_name returns 0; but if SGA buffer is flushed, it returns number of records.

Sorry, other than this, I do not have any detail info. (I am trying to help someone out.)

Currently, they have a script to scan alert log. Whenever it sees ORA-007445, it flushes the buffer.
Is there any other better work around. (Oracle supports say it's a bug but they do not fix it anymore in 9i.)


Roger Xu

Received on Wed Sep 16 2009 - 14:18:22 CDT

Original text of this message