Re: Tuning the SQL Query

mamatha.lucas_at_gmail.com wrote:
> Joel,
>
> I'm not sure I understand your question. The process is not waiting on
> anything. This Procedure gets called from a Java Program and the OUT
> paramater is a REF CURSOR, so the output of this query is returned.
>

So you have no waits in your system? Not much you can do.

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14211/instance_tune.htm

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14211/sql_1016.htm#i30971

What did the profiler say about how long you took to run things? What was the unexpectedly slowest line?

> Thanks
> Mamatha

jg

--
@home.com is bogus.
A bogeyman behind every tree.
http://www.signonsandiego.com/uniontrib/20060530/news_1b30data.html