select vs.SQL_TEXT,vs.DISK_READS,Executions from V$SQLAREA vs,v$session s where vs.ADDRESS=s.SQL_ADDRESS and vs.HASH_VALUE=s.SQL_HASH_VALUE and s.sid in (select s.sid from V$SESSION s,V$Process p where s.PADDR=p.addr and p.BACKGROUND is null );
性能有问题时可以查一下分析下问题在哪儿
