Is their any combination of fields from the V$SQL or V$SQLAREA tables, which can give you any ideas as to whether sql is performing badly or must you use SQL_TRACE and then run TKPROF to give an accurate picture of SQL which consumes a high amount of resources