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: Brian Peasland <peasland_at_usgs.gov>
Date: Mon, 19 Mar 2001 16:08:15 GMT
Message-ID: <3AB62EEF.DEC01F14@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 Mon Mar 19 2001 - 10:08:15 CST

Original text of this message

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