ora-7445 Oracle dump

I get oracle dump (ora-7445) several times. Every time if oracle dumping, it exactly is on runing the cursor for the following query:

delete from A where rowid in
  (select t.rowid from A t, B s where t.transaction_id=u.transaction_id    and ....
  )

which is included in a PL/SQL procedur.

Table A and B have been inserted and deleted a lot frequently, and B has a freign key for A, i.e. if a record of A is deleted, the cascade records of B will be deleted. Moreover, the process prgram broke down for the extent spaces for A or B or their indexes, and the analysis was done for A and B. After the oracle dump, the oracle instance was also restarted. (After restarting, the oracle dump still ocurred.)

I doubt that oracle may have a bug in holding a view of rowids (actually the addresses for rows) that are to be deleted. In some weired circumstance, the memory for the view of rowids may have been changed or eroded by other processes, and thus the oracle dump is caused.

If anyone knows this problem or can give some advices, please not hesitate to tell me. The oracle version is version 7.2.3.

Thanks

TAN

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet