Insert-Select much slower than same select on its own

Hi,

I'm doing an insert into a table like so:

Insert into table
(field1, field2...)
Select value1, value2...
from view

The select on its own runs in under a second. The insert select takes ~50 seconds. The explain plans differ greatly. The stats on the tables are up-to-date.

I've tried the all_rows and append hints to no avail.

Can somebody please advise why this drastic deterioration in performance may be happening?

The db version is Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production

Thanks,
Mark Received on Thu Aug 31 2006 - 08:38:52 CDT