²é¿´oracleÓû§Ö´ÐеÄsqlÓï¾äÀúÊ·¼Ç¼

select PARSING_SCHEMA_NAME,COUNT(DISTINCT T.SQL_TEXT) from v$sqlarea t 
WHERE T.LAST_ACTIVE_TIME >= TRUNC(SYSDATE)
GROUP BY PARSING_SCHEMA_NAME