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