query deosn't work

Posted on 2011-05-11
Medium Priority
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 78

Expert Comment

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

Author Comment

ID: 35740887
"doesn't work" mean no output or run very slow
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 132 total points
ID: 35740908
try to get the explain plan of the query, and see if possibly (likely) you are missing indexes
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 132 total points
ID: 35740909
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

David Todd earned 136 total points
ID: 35740971

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


Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

850 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