Re: Excessive rode log generation after upgrade

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 12 Sep 2000 10:40:08 -0400
Message-Id: <10617.116726@fatcity.com>

Val,
  Did you make any changes to the init.ora file specifically the check_poin= t_interval? Is the size of your archivelog the same as before? Did you = have to create the database when you went from 7.2 to 7.3.4 and change = some of the parameters?
Just things to think about.
ROR
>>> Val_Gamerman/Victoria_Financial.VICTORIA_FINANCIAL_at_lnn.com 09/11/00 =
05:45PM >>>

Hello,

I upgraded Oracle over the weekend from 7.2 to 7.3.4 (I know 7.3.4 is to = be
desupported soon, please no flames :-).

Our redo log switches used to occur every 1 hour - 2 hours.

Now they occur every 25-30 minutes.

I know that this is still acceptable, however I can see that the database/application is sort of behaving slower then usual.

I tried to talk to Oracle Support and did not get any help from them. The guy I talked to philosophy was -- if it's not down, it's working fine :-)

It looks almost as if I was in the BACKUP mode all the time -- too much redo is generated. I did verify v$backup and all the files are in the 'NOT ACTIVE' status. When there is no activity against the database, naturally there is no log switches -- no log switches during the night.

What should I check for? What can it be?

There were no changes made to the application. We have the same number of users as we had before the upgrade. The only two things that changed are the Oracle version and location of some data files.

Platform: Netware 4
Oracle: 7.3.4
LOG file size =3D 10M, there are 5 of them Database is in the ARCHIVE_LOG mode.

Any help is greatly appreciated.

Thanks,
Val Gamerman

--=20
Author:=20
  INET: Val_Gamerman/Victoria_Financial.VICTORIA_FINANCIAL_at_lnn.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Tue Sep 12 2000 - 09:40:08 CDT