select sql_text, sharable_mem, executions from v$sqlarea 
where sql_text like 'SELECT COUNT(1) FROM GY_SHOPORDER A, GY_SHOPPRODUCT B, GY_SHOPORDERSHIPINFO C%' order by first_load_time desc