increase in amount of redo comparing oracle 7 and 9

[Jeroen van Sluisdam]

I have recently migrated our oracle 7.3.4 environment to oracle 9.2.0.4 I noticed some batches eating up all my archive space. I have a 5 Gb filesystem solely for archiving available where I used to have 4Gb available for oracle 7 which was quite enough for years.   A small test:   Oracle 9.2.0.4   create table t6 (i int) ; SQL>  select value from v$mystat m, v$statname s   2   where m.statistic#=s.statistic# and s.name = 'redo size';        VALUE ----------      14224   SQL> insert into t6 select obj# from sys.obj$ where rownum <= 10000;   10000 rows created.   SQL> commit;   Commit complete.   SQL> select value from v$mystat m, v$statname s 2        where m.statistic#=s.statistic# and s.name = 'redo size'; 3             VALUE 4        ---------- 5           1625216   Amount of redo used 160744 On Oracle 7 : JVU_2>create table t6 (i int) ;   Table created.   JVU_2>select value from v$mystat m, v$statname s   2  where m.statistic#=s.statistic# and s.name = 'redo size';        VALUE ----------       7510   JVU_2>desc v$mystat  Name                            Null?    Type  ------------------------------- -------- ----  SID                                      NUMBER  STATISTIC#                               NUMBER  VALUE                                    NUMBER   JVU_2> insert into t6 select obj# from sys.obj$ where rownum <= 10000;   6319 rows created.   JVU_2>commit;   Commit complete.   JVU_2>select value from v$mystat m, v$statname s   2  where m.statistic#=s.statistic# and s.name = 'redo size';        VALUE ----------     101438   Amount of redo used in oracle 7.3.4: 93928 When dividing this: 160744 / 93928 = 1.7 Leads me to an increase of 70%   Is this regular behaviour for an oracle 9 environment??   I saw in post in this list mentioned bug 2874489 for use on global temporary tables, these cannot be the case here because all code is still strictly on oracle 7 base.   Details: oracle 9.2.0.4 on HPUX11.11   Regards,   Jeroen