Re: core dump while querying large tables

"Spatial Knowledge Systems" <sksmail_at_sks.nl> writes:

>When I do a select with some clauses on a large table, Oracle generates a
>core dump and the proces is stopped.
>Can anyone explain what the problem is here ? ( I am using Oracle 7 on IRIX
>5.3)
 

>Manon

Manon,

Look in your bdump, cdump, and udump directories for trace files. Also check the alert_{SID}.log file. These should contain further information for you to use in debugging.

If you get a core dump, it sounds likely that there is an ORA-600 internal error. Perhaps a corrupt data block or db_writer problem. Regardless, the files described above should give you guidance.

Good luck,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> Visit my Web Page: http://homepage.interaccess.com/~akaplan   <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->