Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Tuning the SQL Query

Re: Tuning the SQL Query

From: joel garry <joel-garry_at_home.com>
Date: 30 May 2006 13:49:05 -0700
Message-ID: <1149022145.737182.24620@j73g2000cwa.googlegroups.com>

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
Received on Tue May 30 2006 - 15:49:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US