Re: Audit user conections
From: (wrong string) éphane DEJARDIN <100433.3012.,_at_compuserve.com>
Date: 1996/04/16
Message-ID: <4kvlpf$pk9_at_arl-news-svc-2.compuserve.com>#1/1
Date: 1996/04/16
Message-ID: <4kvlpf$pk9_at_arl-news-svc-2.compuserve.com>#1/1
In article <316DCE2D.7CF2_at_ix.netcom.com>,
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...
>
>
> Thank you.
> Artur Akerman
> akermana_at_ix.netcom.com
>
You can use the auditing facilities to see all the connections to the database
- activate the audit_trail parameter in the init.ora
- enter the sql statement : audit session ;
- perform the sql statement to see all the connections select * from user_audit_session