查找表的历史操作记录

select  * from  v$sqlarea a where a.SQL_TEXT like '%chen_table_name%'
从查询记录中获取update语句对应sql_id值
select  * from  v$sqltext a,v$sqlarea b where a.SQL_ID=b.SQL_ID and a.SQL_ID in('2c3b53b0tmndu') order by b.LAST_ACTIVE_TIME desc
从第二步查询记录找到最新的sql执行信息，找到用户名和主机信息
 
select  * from  sys.v_$session l,sys.v_sql s where s.SQL_ID='2c3b53b0tmndu' and l.USERNAME is not null