用 as of timestamp 可以获取该表格某个时间的flashback,例如 select * from TABLE_A as of timestamp (Sysdate -1)具体可以查看 http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28424/adfns_flashback.htm#i1007455
alter table XXX monitoring;
select * from v$sql select * from v$sqlarea select * from v$sqltext 不知道会保留多少sql
from TABLE_A as of timestamp (Sysdate -1)具体可以查看
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28424/adfns_flashback.htm#i1007455
select * from v$sqlarea
select * from v$sqltext
不知道会保留多少sql