Re: How to Determine if Table Modified

From: William Dangren <wdangren_at_navisent.com>
Date: Sun, 03 Sep 2000 18:40:17 GMT
Message-ID: <39B29B7B.61F6A106@navisent.com>

You may want to turn on auditing in the database. You select what level you want to trace( Full db, table..). You also choose the events you want to trace (Insert, update...). Get an Oracle DBA book and it will tell you the steps. When full auditing is on you may see a performance problem. This is because Oracle has to insert records into the audit tables on any DML. Make sure you don't audit everything unless you need to.

Bill

--
William Dangren
Navis Enterprises
407.348.6401
800.219.0207

Received on Sun Sep 03 2000 - 13:40:17 CDT