SELECT EVENT, AVERAGE_WAIT FROM V$SYSTEM_EVENT WHERE EVENT LIKE 'db file s%'
Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop SELECT STATEMENT Optimizer Mode=CHOOSE 1 17605 SORT AGGREGATE 1 22 VIEW 257 K 5 M 17605 UNION-ALL TABLE ACCESS BY INDEX ROWID SUPERMAG.FFMAPREP 257 K 2 M 17604 INDEX RANGE SCAN SUPERMAG.FFMAPREP_SALEDATE 257 K 687 TABLE ACCESS BY INDEX ROWID SUPERMAG.FFMAPREP_ 1 22 1 INDEX RANGE SCAN SUPERMAG.FFMAPREP_SALEDATE_ 1