Friday, June 20, 2008

How to cleanup the FGA log table?

SQL> truncate table fga_log$;

SQL> delete from fga_log$ where timestamp# < sysdate-14;