Internal query on CDEF$ and CON$ very CPU bound
Browse My Oracle Support for the possible causes. For example quick search revealed a bug about your Oracle internal SQL. Workaround for it is:


Set optimizer_mode=rule for the affected DMLs


The bug is registered against version 11g but of course it is possible that it exists also in 10g.