Re: enable sql trace on users

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 17 Oct 2002 00:38:17 -0700
Message-ID: <a20d28ee.0210162338.28bab85d@posting.google.com>

tpreto7_at_sapo.pt (Teresa) wrote in message news:<6dabc692.0210161531.5781fc30_at_posting.google.com>...
> I would liek to set up sql tracing on some users, can someone please
> tell me how can I do it. I needed in order to view how many times some
> users are connecting to the database then I need to set up user
> profiles for that specific users that are taking to many connections.
> Any ideias would be great
> Thanks
> Teresa

You are describing auditing, not tracing. To enable auditing
- change /add the audit_trail parameter to db audit_trail = db
in init<sid>.ora and bounce the database - issue
audit connect
in sql*plus
Now you can use select * from dba_audit_session to how many times an user connects.

Hth
Sybrand Bakker
Senior Oracle DBA Received on Thu Oct 17 2002 - 02:38:17 CDT