look up database's sql codition and pga/event's condition for a period of time

由于工作需求经常需要查看一个库的sql执行消耗情况，为了方便查询写了一个小查询sql与大家分享一下：

select cast(buffer_gets/decode(EXECUTions,0,10000,EXECUTions) as int) avg_IO ,
EXECUTions execs,buffer_gets logical_IO,disk_reads physical_io,
sql_text from v$sqlarea
where parsing_schema_name='schema_name'
order by buffer_gets desc

Look up db's event and pga_useing for a period time

SELECT A.SESSION_ID,
       A.SESSION_SERIAL#,
       A.EVENT,
       A.SESSION_STATE,
       A.WAIT_CLASS,
       A.WAIT_TIME,
       A.USER_ID,
       A.PGA_ALLOCATED
  FROM DBA_HIST_ACTIVE_SESS_HISTORY A
  WHERE A.SAMPLE_TIME <
       TO_DATE( '2013-06-17 17:20:00' , 'YYYY-MM-DD HH24:MI:SS' )
   AND A.SAMPLE_TIME >
       TO_DATE( '2013-06-07 15:30:00' , 'YYYY-MM-DD HH24:MI:SS' )
  ORDER BY A.PGA_ALLOCATED