Oracle-L: RE: Redos gone crazy--a job for audit?

From: Rich Gesler <rgesler_at_atriumwindows.com>
Date: Thu, 09 Oct 2003 09:54:24 -0800
Message-ID: <F001.005D2933.20031009095424@fatcity.com>

Just a quick thought, are any tablespaces left in Hot Backup Mode?

Rich

-----Original Message-----
Barbara Baker
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: 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: Rich Gesler
INET: rgesler_at_atriumwindows.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------