how to check for a particular SQL query how many cpu/cpu-cycles that it is consuming?

hi,

was wondering if there's a way to achive the above? does those parameters in the v$sqlarea helps?? any guru can enlighten?

thank in advance.

Have a look at trace & tkprof here:
http://download-west.oracle.com/docs...4_str.htm#1018

if you want quick glimpse of CPU utilization, in O.S. level,
in SOLARIS issue
/usr/ucb/ps -aux|head