ora-600 The way to find out the query.

Hi Guys,
There is any way to find out the query which is causing ora-600 in 11gr1.
Who is Participating?
sdstuberConnect With a Mentor Commented:
check the trace file,  if it doesn't have it,  then no

if you don't know which trace file, check your alert log, it will tell you.
nirvairghumanAuthor Commented:
I found in the the incidents.
like any other trace file.  If the incident trace file has it, then you can use it.  If the incident trace file doesn't have it (or doesn't exist) then no.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.