Re: Slow insert

From: David Sisk <davesisk_at_ipass.net>
Date: Mon, 14 Dec 1998 13:29:30 -0500
Message-ID: <TCTc2.1003$kx1.1531@news.ipass.net>

I agree with all of the above posts. You might want to check for freelist contention, check the pct_used settings on the table (the higher pct_used, the more dense the storage, but the slower inserts will be), and possibly redo logging bottlenecks. There's a script on the site below to check most of these.

Regards,

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

Lito Dizon wrote in message <36706de7.154166_at_news.us.net>...
>Why is this so slow? Slow meaning 10 hours. Ans the
>further it gets, the slower it gets.
>
>insert into TABLEA
>select * from TABLEB
>where KEY not in (select KEY from TABLEA )
>
>Both tables are indexed on KEY. TABLEA has 9000 rows
>while TABLE B has 12000 rows.
Received on Mon Dec 14 1998 - 12:29:30 CST