poor clob performance with very high CPU

All,

I have a CTAS that involves a CLOB. The expected duration of this process is 180 minutes. Recently it started taking > 5 hours. The data and rowcounts are very similar, the trace shows only CPU consumption and very little else. I am wondering if you guys have any insight into how to diagnose a clob performance issue where the only information I have is excessive CPU consumption.

The execution paths have not changed. These are staging tables and they never have statistics as we always want full tablescans. The tablespaces underlying the tables/clobs have not changed. They are local ASSM with uniform extent sizes of 128k.

Thanks for your time,

Josh C.

--
http://www.freelists.org/webpage/oracle-l