Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: want to log all transaction made
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 worseReceived on Fri Jul 07 2000 - 00:00:00 CDT