hi, if in oracle 9i,
there is cpu_time in v$sql, and cpu% in statspack report.

Also you can monitor it from unix, like prstat/top/ps find the spid and check the sql.