ora-600 The way to find out the query.

Posted on 2011-10-31
Last Modified: 2013-01-21
Hi Guys,
There is any way to find out the query which is causing ora-600 in 11gr1.
Question by:nirvairghuman
    LVL 73

    Accepted Solution

    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.

    Author Comment

    I found in the the incidents.
    LVL 73

    Expert Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    how to tune this sql query 61 74
    oracle global variables 4 36
    Invalid Identifier Error 3 47
    oracle query 15 56
    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now