Trace Statemet
SELECT
SQL_TEXT,PARSING_SCHEMA_NAME, SERVICE, MODULE, CPU_TIME, ELAPSED_TIME, OBJECT_STATUS, LAST_LOAD_TIME, PHYSICAL_READ_BYTES, PHYSICAL_WRITE_BYTES
FROM V$SQL
WHERE MODULE like 'MIA APP ID'
ORDER BY LAST_LOAD_TIME DESC
Ferdinando Caprilli Directory