Home » RDBMS Server » Performance Tuning » Oracle - Info Log
Oracle - Info Log [message #65164] Wed, 26 May 2004 05:43 Go to next message
Angie
Messages: 12
Registered: April 2002
Junior Member
Hi guys.. I'm new to this board and have really enjoyed/learned lots from all your advice/tips.

I am a university studend working on a summer research project on Oracle and DB2. 

My Question - Does Oracle have a log file where it logs all activities in the database (inserts, updates, deletes etc...)?  All I was able to find was a little information on triggers... is this the only way to do it?

I am not concerned with the overhead of logging ALL the info for the moment as I am working on a really small database for now. 

Any help would be greatly appreciated.  Thanks!

Angie
Re: Oracle - Info Log [message #65206 is a reply to message #65164] Fri, 11 June 2004 06:18 Go to previous message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member
Hi,

Also look at Oracle's Auditing facility. Lookup the AUDIT and NOAUDIT commands in the SQL Reference Guide.

Best regards.

Frank
Previous Topic: DBMS_PROFILER at instance Level
Next Topic: SQL Taking ForEver
Goto Forum:
  


Current Time: Wed Feb 21 11:26:26 CST 2024