Re: Audit user conections

Artur Akerman <akermana_at_ix.netcom.com> wrote:
>Is there any way to keep a log of all the users connectiong to the
>database ? We want to monitor database usage...
>
Include following parameters in your ora_sid_init.ora file: audit_trail = db
Recycle the ORACLE instance:

Run following sql :

SQL> set pagesize 0;
SQL> set feedback off;
SQL> spool audit_all.sql
SQL>select 'audit session by '||username||';' from dba_users;
SQL> spool off;
SQL> start audit_all.sql
SQL>

You just turned on audit on all the users by session.  

Sanjay D.S.
Oracle Consultant
Prudential Securities, Inc. Received on Mon Apr 15 1996 - 00:00:00 CEST