[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

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.
0
nirvairghuman
Asked:
nirvairghuman
  • 2
1 Solution
 
sdstuberCommented:
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now