Re: Intresting Statistics -- DB FILE SEQUENTIAL READ waits

has anyone ever really benchmarked a case where this kind of update through a cursor is EVER faster than doing it in straight sql? It seems to take twice as long if not longer on large batch jobs.

ive seen somethings in books that claim it can be faster, but i have tested this every way i can possibly think of with as many cases as I can think and cannot find a case where its faster to use pl/sql?

anyone? ever? if so how did this get published?
>
> From: [EMAIL PROTECTED]
> Date: 2003/06/27 Fri PM 12:59:41 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Intresting Statistics -- DB FILE SEQUENTIAL READ waits
>
> We were running a serial update on a fact table (45 mill rows) using the
> old tech of
> declare
> cursor .......table a
> begin
> for c1rec in c1 loop
> update fact
> where period_key = c1rec.period_key and loan_key = c1rec.loan_key
> ----commit every 10,000 rows
> end loop;
> end;
>
> fACT table partitioned on period key (per month) and there was a unique
> local index on period_key and loan_key
> the update was going at a rate of 10,000 rows every 2 min. very slow...
> Myself and Madhavan(another avid reader of this list) thought of an idea.
> W
>
>
> --
> http://www.fastmail.fm - Does exactly what it says on the tin
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).