Oracle 9.2.0.1.0 Undo Management?

undo_manager is auto

I try this ...

conn user/password_at_ora92
update sometable set field1='1234567890', field2='1234567890'; SQL>update 100000 rows
rollback;

conn user/password_at_ora92
update sometable set field1='1234567890', field2='1234567890'; SQL>update 100000 rows
rollback;

conn user/password_at_ora92
update sometable set field1='1234567890', field2='1234567890'; SQL>update 100000 rows
rollback;
....

I check UNDOTBS1 size, It grows up, every time! I test about 30 times; It still grows up :( It's management?

How do I solve this problem?

Thanks!

Jackie Chang. Received on Sat Jun 18 2005 - 11:43:40 CDT