Newsgroups: comp.databases.oracle.misc
Subject: Re: core dump while querying large tables
References: <01bc27b5$5049a9e0$7c002f96@CV>
"Spatial Knowledge Systems" 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: www.arikaplan.com <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page