COLUMN statname FORMAT A35 HEADING 'Statistic' TRUNCATE COLUMN value FORMAT 999,999,999,999 HEADING 'Value' SELECT sn.name statname, st.value value FROM v$sesstat st, v$statname sn WHERE st.sid = &&user_sid AND sn.name IN ('CPU used by this session', 'OS Wait-cpu (latency) time', 'session logical reads', 'physical reads') AND sn.statistic# = st.statistic# ORDER BY value DESC /