I am wondering if Oracle logs all activities in the database to a file or even to a table in the database (i.e. inserts, deletes, updates) and information on the user that did the modifications?
All I have been able to find so far was a little information on Triggers set up to log such activities. Is this the only way to log all activities on the database? At the moment I am not concered with the memory and/or overhead of large log files as I am working with a very small database.