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

.