saving all action in database
Flashback Data Archive (formerly known as Oracle Total Recall) let you store history for all the changes to one or more tables automatically.  If you have the Advanced Compression option, Oracle will apply a number of optimizations to the history table that will significantly decrease the amount of space that is required and that will generally make queries against history more efficient.