Dan: Thanks for this -- I'll definitely tuck this away for future reference.
Sadly, it's not going to help this time. I don't have a user generating redo, I have an application running amuck. The users (reporters) never log into the database. Some service (Solaris high availability service, I believe) logs a database user on 20 times, then buffers requests from the HA service to the database. A minute or two later, it logs the 20 sessions out and logs in 20 more. Between around 5:30 am and 3:00 am the following day, the database is rolling a new redo log about every 16 minutes. Pretty much new log file every 16 minutes like clockwork. Between 3:00 and 5:30, the HA service is disabled and some kind of maintenance is running. The entire database is about 4100 megs. We're generating more than 3 gigs of redo per day. I sure would like to know what's in those redo logs. Thanks for the help! Looks like another beautiful weekend to hang out on top of a mountain. Did you get to see the leaves turning this year?? Barb --- Daniel Fink <[EMAIL PROTECTED]> wrote: > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). > > begin:vcard > n:Fink;Daniel > x-mozilla-html:FALSE > org:Sun Microsystems, Inc. > adr:;;;;;; > version:2.1 > title:Lead, Database Services > x-mozilla-cpt:;9168 > fn:Daniel W. Fink > end:vcard > __________________________________ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
