Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: want to log all transaction made

Re: want to log all transaction made

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/07/07
Message-ID: <3965AD7A.49DE@yahoo.com>#1/1

Kyoichi Ozaki wrote:
>
> hi all,
>
> i'm running Oracle8.0.5 server for linux, and i'm the dba. but there's
> been few
> problems with our system on it, with few developers working on the
> server.
> (php3, sql*plus , etc)
> and i want to track who's executing what (SQL lines).
> is this possible ?
> or is there another solution?
>
> i want to at least be able to get a log of who logged in as who, and
> when to
> the oracle server.( by sqlplus or win2000access )
>
> thanks,
>
> Kyoichi Ozaki

Add sql_trace = true in your init.ora - that will be a good start (although it will hurt performance a little).

The every session's SQL's will be logged in 'user_dump_dest = '

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse
Received on Fri Jul 07 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US