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 <Daniel.Fink_at_Sun.COM> 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: 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).
> > 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: 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).
Received on Fri Oct 10 2003 - 10:34:25 CDT
