query deosn't work

Posted on 2011-05-11
Last Modified: 2012-05-11

I have a question for you.

I have a query working fine few days ago in oracle database. But today all the sudden the query doesn't work when I ran it.

I want to know what approach we should do usually for this kind situation. Can you tell me the steps I should go and diagnose it.
Question by:wasabi3689
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    Define 'doesn't work'.

    Author Comment

    "doesn't work" mean no output or run very slow
    LVL 142

    Assisted Solution

    by:Guy Hengel [angelIII / a3]
    try to get the explain plan of the query, and see if possibly (likely) you are missing indexes
    LVL 76

    Assisted Solution

    by:slightwv (䄆 Netminder)
    What changed?  Please don't say nothing...

    Did a large batch load happen?  Maybe all you need to do is refresh statistics.

    Is the query waiting on some table/object lock?

    Is the database actually doing work?

    I've actually had this happen to me many times:  in sqlplus did you 'set pause on' and the query is waiting for you to hit 'enter'?

    LVL 35

    Accepted Solution


    Are you running your standard maintenance for this database - whatever your best practice is?


    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    729 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

    17 Experts available now in Live!

    Get 1:1 Help Now