Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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.htmlReceived on Tue May 30 2006 - 15:49:05 CDT
![]() |
![]() |