Message-Id: <10616.116664@fatcity.com> From: Val_Gamerman/Victoria_Financial.VICTORIA_FINANCIAL@lnn.com Date: Mon, 11 Sep 2000 15:38:12 -0500 Subject: Excessive rode log generation after upgrade 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 = 10M, there are 5 of them Database is in the ARCHIVE_LOG mode. Any help is greatly appreciated.