EXCESSIVE UNDO GENERATION USING A PROGRAM WITH MASSIVE INSERTS AND UPDATES
Hi,
we are using a OIC application
AIX platform and 9.2.0.6 database version.
a program is done a lot of insert and update and we use a undo tablespace with size 350 Go ( the size of database is 700 Go with this tablespace of course)
the application runs very slowly and generate and generate a lot of undo segment, then it consumes all space in undo tablespace.
we are using AUM with ASSM
undo_retention i fixed to 72000 and we still receive ora-01551 !!!
i find a bug but in 10g
have ever seen this behavior ???
thanks
AIX platform and 9.2.0.6 database version.
a program is done a lot of insert and update and we use a undo tablespace with size 350 Go ( the size of database is 700 Go with this tablespace of course)
the application runs very slowly and generate and generate a lot of undo segment, then it consumes all space in undo tablespace.
we are using AUM with ASSM
undo_retention i fixed to 72000 and we still receive ora-01551 !!!
i find a bug but in 10g
have ever seen this behavior ???
thanks
0