ORA-007445 issue in HP/UX
Date: Wed, 16 Sep 2009 14:18:22 -0500
If you ever run into this issue, can you share the work around?
Oracle 9iR2 18.104.22.168.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.)
Roger XuReceived on Wed Sep 16 2009 - 14:18:22 CDT