背景:ORACLE
语句:select * from v$sqlarea where instr(upper(sql_text),'想要查询的表名')>0
order by first_load_time desc;
补充解释:order by first_load_time desc 根据调用时间排序
举例:我想查询最近都对数据表 TEMPTABLE进行了什么操作,则写成:select * from v$sqlarea where instr(upper(sql_text),'TEMPTABLE')>0
order by first_load_time desc;
END