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.
nirvairghumanAsked:
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.
0
 
nirvairghumanAuthor Commented:
Thanks
I found in the the incidents.
0
 
sdstuberCommented:
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.
0
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.