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
