ORA-007445 issue in HP/UX

  • From: Roger Xu <wellmetus@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 16 Sep 2009 14:18:22 -0500

Hi List,

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

Oracle 9iR2  9.2.0.8.0

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.)

Thanks,

Roger Xu

Other related posts:

  • » ORA-007445 issue in HP/UX - Roger Xu