Re: Logging all users' activity (newbie alert)

On Sat, 14 Sep 2002 00:27:00 GMT, in comp.databases.oracle.misc, Andrew Allen <ajallen_at_mailhost.det.ameritech.net> scribbled:

>pixelmeow wrote:
>>
>> Hello all,
>>
>> I am a newbie to this end of Oracle. Until last week I was using Java
>> to access Oracle, or VB, but now I need to learn the other side of
>> Oracle, using OEM (DBA Studio) or SQL*Plus.
>>
>> The first thing I need to do is set up a log that keeps a record of
>> all users who sign on, when they sign on, when they sign off, maybe
>> even what they do while in the DB.
>>
>> I have looked all over OTN, on an Orafaq web site, and would be very
>> glad to RTFM or RTFB if I only knew which manual or book to look in.
>> Or where to start...
>>
>Check the fm for audit. You can audit most anything in the
>database, including such activites as login/logout, dml, ddl,
>specific tables, specific users, etc. A couple of notes about
>auditing that many experienced DBAs do.
>1. clean our v_$aud regulary, storing the required information
>elsewhere. I have a package that does this and cleans out my
>archived audit records, only keeping those for the last year. This
>runs weekly using an oracle job.
>2. move the v_$aud to a different tablespace -- this way you do not
>run the risk of overruning the system tablespace. There is a note
>on how to do this on metalink.
>- WARNING -- WARNING -- WARNING -- WARNING ---- WARNING -- WARNING
>- WARNING -- WARNING --
>- WARNING -- WARNING -- This is not offically supported by Oracle.
>- WARNING -- WARNING -- The metalink note warns you of this.
>- WARNING -- WARNING --
>- WARNING -- WARNING -- WARNING -- WARNING ---- WARNING -- WARNING
Thanks to you and Mr Bakker for your help. I knew there had to be a way to do this, just didn't know where to find the "how-to".

And apologies for the double sig... Received on Mon Sep 16 2002 - 08:16:53 CDT