Re: Oracle 9i and request log

On Tue, 21 Mar 2006 17:12:14 +0100, Laurent Rahuel <lrahuel.notgood_at_voila.fr> wrote:

>Hi,
>
>Is there any place I could find a logfile user requests to the database ??
>
>Regards,
>
>Laurent

Depends on what "requests" means.

AUDITING is the tool of....surprise... auditing an Oracle database. Check the manual about this. You can audit about any user action with it.

Logminer, as suggested by Daniel, is only capabale of tracking changes in the DB, it does not record queries. It also has the drawback of only reaching so far back as your archivelogs do. Needless to say, it also, unlike AUDITING, requires ARCHIVELOG mode.

• Kenneth Koenraadt