2 Replies Latest reply: Jan 13, 2013 11:47 PM by Osama_Mustafa RSS

    oracle database 11g daily changes

    984509
      Hi,

      whats the best way to see the daily changes(dml&ddl) with out impact the the database performance?
      is the logminer the best tool?

      Thanks
        • 1. Re: oracle database 11g daily changes
          Aman....
          user12076703 wrote:
          Hi,

          whats the best way to see the daily changes(dml&ddl) with out impact the the database performance?
          is the logminer the best tool?
          Logminer is okay but doesn't work on it's own. If you want a simple setup, Auditing is going to be the best way IMO. Since you haven't bothered to mention your db version so I am giving the link fro 11.2 docs about the same. Please see,
          http://docs.oracle.com/cd/E11882_01/network.112/e16543/auditing.htm#BCGHGJJH

          Aman....
          • 2. Re: oracle database 11g daily changes
            Osama_Mustafa
            you can enable audit
            Refer to
            http://docs.oracle.com/cd/B19306_01/network.102/b14266/cfgaudit.htm