Re: Redos gone crazy--a job for audit?

Barb,

Every time I have run into this situation, I have used the following approach and it has always worked. I've never validated it in all cases, so take it with a grain of salt.

Redo is generated by block changes. Find the session that is generating the most # of block changes (v$sess_io.block_changes). Then trace back to the session info, sql, etc.
Also check for tablespaces in hot backup mode.

Daniel

Barbara Baker wrote:

> Hi, list. Ya, I'm still alive and kickin'.
>
> We have this small database that's running a weird
> vendor application. (We get all the gems.) It's on
> Solaris 5.8, Oracle 8.1.7.2
>
> The database suddenly went from kicking out 50 meg
> redo logs 2 or 3 times a day to churning them out
> every 15 minutes. The entire database is only about 6
> gigs; we now sometimes generate 2 or 3 gigs of redo
> per day.
>
> Even tho this started when a "small" change was made
> by the vendor, the vendor is claiming that (ok, hold
> on to your hats) it was not their change!!
>
> I want to know what's in those redo logs.
>
> I initially thought about log miner. However, I'm not
> sure log miner will give me what I want.
>
> I tried these 2 audit commands. I'm not seeing much
> from them. Is there another audit command that might
> give me better info? There's only 1 user in the
> database, so I only really need to audit 1 user.
>
> audit all by <myuser> by access;
> audit update table, insert table, delete table by
> <myuser> by access;
>
> Is there anything else that will be going to redo that
> I can capture with audit??
>
> Thanks for any help.
>
> Barb
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Barbara Baker
> INET: barbarabbaker_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Fink
  INET: Daniel.Fink_at_Sun.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



text/x-vcard attachment: Card for Daniel Fink