Well, that was an excellent idea. But sadly, that's not it. (We actually don't use hot backups, but I checked just in case someone mucked with it. No dice.)
Thanks. Barb --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote: > Do you have the database in backup mode? > > Waleed > > -----Original Message----- > Sent: Thursday, October 09, 2003 1:09 PM > To: Multiple recipients of list ORACLE-L > > > 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). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Khedr, Waleed > 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). __________________________________ 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).