What you need to do instead is look at what is happening. It might be time for you to run Statspack or AWR and analyze what is happening to your statement. Are there waits? Is there a large disk read? So I would say that there is no silver bullet on this one. It will be necessary for you to investigate the symptoms and make a diagnosis.
Dig Deeper on Oracle database administration
Related Q&A from Ian Abramson
We are working on the development of a datamart (in 9i) which takes data from two source systems. Since this is a transaction system, there is a lot ... Continue Reading
I am new to Oracle's ETL tool and I need information on data migration using Oracle ETL. Continue Reading
How can PL/SQL be best used for the ETL process? Continue Reading