Re: ora-7445 Oracle dump

Hi,

ever looked into your oracl_alert file and the trace-files related to your error?

qtan_at_clrmnt.com wrote:
>
> 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
 

-- 
Regards

Matthias Gresz    :-)