i bet itz a bad query. find the session that is pegging the cpu and start a trace on it.

otherwize, which oracle proces is pegging the cpu? dbwr, smon, pmon, ckp ?