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

Home -> Community -> Usenet -> c.d.o.server -> Re: ref cursor slow compared to sql query

Re: ref cursor slow compared to sql query

From: Allan Streib <streib_at_cs.indiana.edu>
Date: 24 Jun 2004 06:54:21 -0700
Message-ID: <e334e4a7.0406240554.50eac03f@posting.google.com>


"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<cbcrbm$i57$1_at_sparta.btinternet.com>...

> "Allan Streib" <streib_at_cs.indiana.edu> wrote in message
> news:e334e4a7.0406221231.1da87dad_at_posting.google.com...
> >

[...]
> > Can I view the query plan for a stored proc? I'd like to compare it
> > to the one for my static query.
> >
>
> Alter session set sql_trace = true;
> Call the proc
> Run the straight sql
> exit from SQL*Plus
>
> Check the trace file (which will be in the
> user_dump_dest directory). Use tkprof
> to format the trace file, and you will probably
> find that the two executions of the SQL
> used different execution plans.

Many thanks -- I will try this.

Allan Received on Thu Jun 24 2004 - 08:54:21 CDT

Original text of this message

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