<div>
It looks like oracle internal error raise and SR with oracle support... if you and metalink account.<br />
<br />
please post your alert log file details when that error occurred and related trace file..<br />
<br />

</div>


<div>
Thank you for suggesting notes to check in MetaLink. &nbsp;<br />
I have submitted this error as an SR to Oracle, now I just have to wait for a reply.
</div>


<div>
<div class="content wysiwyg-content">
We recently upgraded our Oracle Database from Oracle 10g to 11g. &nbsp;Now we see Oracle errors, specifically ORA-0600 and ORA-3137 errors. <br />
<br />
When we find an ORA-0600 error, we can find the query in the log which causes the error, and by using the command <br />
ANALYSE TABLE &lt;&lt;tabl;e name here&gt;&gt; DELETE STATISTICS<br />
this clears the error.<br />
<br />
When we find an ORA-3137 error, we can not identify the exact query which causes the error.<br />
<br />
Both errors are happening a few times per week.<br />
<br />
I need suggestions on how to solve this problem, or at least hints on what additional places I should look for information about these errors and what else I should be doing proactively.<br />

</div>
</div>


We recently upgraded our Oracle Database from Oracle 10g to 11g.  Now we see Oracle errors, specifically ORA-0600 and ORA-3137 errors. 

When we find an ORA-0600 error, we can find the query in the log which causes the error, and by using the command 
ANALYSE TABLE <<tabl;e name here>> DELETE STATISTICS
this clears the error.

When we find an ORA-3137 error, we can not identify the exact query which causes the error.

Both errors are happening a few times per week.

I need suggestions on how to solve this problem, or at least hints on what additional places I should look for information about these errors and what else I should be doing proactively.


It looks like oracle internal error raise and SR with oracle support... if you and metalink account.

please post your alert log file details when that error occurred and related trace file..



Thank you for suggesting notes to check in MetaLink.  
I have submitted this error as an SR to Oracle, now I just have to wait for a reply.

ORA 600 and ORA 3137 errors after upgrading to Oracle 11g

We recently upgraded our Oracle Database from Oracle 10g to 11g.  Now we see Oracle errors, specifically ORA-0600 and ORA-3137 errors. 

When we find an ORA-0600 error, we can find the query in the log which causes the error, and by using the command 
ANALYSE TABLE &lt;&lt;tabl;e name here&gt;&gt; DELETE STATISTICS
this clears the error.

When we find an ORA-3137 error, we can not identify the exact query which causes the error.

Both errors are happening a few times per week.

I need suggestions on how to solve this problem, or at least hints on what additional places I should look for information about these errors and what else I should be doing proactively.


Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.

Enterprise Software

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.