sanjay's script is very useful
if you dont see CPU usage you have to set timed_statistics=true

many times v$session_wait also tells you why you CPU is spinning 100%