| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Redos gone crazy--a job for audit?
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
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). Received on Thu Oct 09 2003 - 12:09:24 CDT
 |
 |