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: View DB Activity ?

Re: View DB Activity ?

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 20 Mar 2001 18:37:30 +1100
Message-ID: <3ab708cf@news.iprimus.com.au>

Not quite Brian. It was released with 8.1.5, and can be applied from there to Oracle 8.0 log files.

Regards
HJR "Brian Peasland" <peasland_at_usgs.gov> wrote in message news:3AB62EEF.DEC01F14_at_usgs.gov...
> The easiest way to see what was happening is to use LogMiner utilities
> to read the archived redo logs. You'll need to be on Oracle 8.1.6+ for
> this though.
>
> HTH,
> Brian
>
>
> tom wrote:
> >
> > Hi
> >
> > I came back to work this morning to see that
> > 3 gigs of archivelogs were created on sunday.
> >
> > There shouldnt have been anythign going on that would cause that.
> >
> > Is there a way i can determine what if any user activity
> > was happening ?
> >
> > Can i extract the statements form the archive logs and look at them ?
> >
> > thanks
> > tompr
> > tomprREMOVE_REMOVE_at_hotmail.com
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Tue Mar 20 2001 - 01:37:30 CST

Original text of this message

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