Re: HELP -- Insert's Take Forever! (code attached)

Have you explain planned all your SQL statements? Are any full tablescans going on? Can you make use of any indexes on there? What primary keys/foreign keys indexes are there?

What does the v$session_wait say for each session when you are inserting?

Alun

"contrapositive" <contrapositive_at_hotmail.com> wrote in message news:3cedaeb5_5_at_nopics.sjc...
> Hi.
>
> HELP! I'm working with a PL/SQL program that combines or consolidates
orders
> from a database. My problem is that the inserts are SLOW AS DEATH!
>
> I've attached the code, but I've had to "mask" it and simplify it in order
> to post it, so there may be some syntactical "bugs". Still the framework
and
> all the elements are the same. In the code, I've identified THREE
potential
> problem inserts and what they do. (I believe No. 2 is the culprit, but I'm
> not sure.) I've tried these with and without the append hint. No
difference.
> I wonder, since the query in my cursor is kind of slow, if it's not
running
> the query each time through the loop. It's not a speedy query. Really, I'm
> not sure where the bottleneck lies, but it takes about 30 seconds to
process
> each iteration.
>
Received on Sun May 26 2002 - 06:32:21 CDT