Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: want to log all transaction made
Watch yourself when using these tools they will produce alot of information, you might want to review them periodically and delete the files afterwards, otherwise they can take up a enormous amount of disk space.
D Parent
dc <card01_at_pop.cng2.hydro.qc.ca> wrote in message
news:39662172.5D3494CF_at_pop.cng2.hydro.qc.ca...
> For the "i want to at least be able to get a log of who logged in as who,
> and when to the oracle server" part, I suggest that you audit sessions.
> After that, all you have to do is query the aud$ table via the
> dba_audit_session view.
>
> I do it here and it's the fastest way to know who loged in when. All that
> can be queried naturally via SQL Plus as you wanted.
>
> As far as knowing what the users/developpers are doing, go with the trace
as
> already mentioned to you.
>
> Hope it helps.
>
>
> Kyoichi Ozaki a écrit :
>
> > 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
>
Received on Sat Jul 08 2000 - 00:00:00 CDT