Re: undo segments online causing performance problems.

1. How are sure that the Onlining of the Undo segments is the cause of the "hang" ?
2. Do you need undo_retention at 3hours ? Have you worked out how much undo_retention you really need . You might be able to set it lower.

At 06:02 PM Thursday, The Human Fly wrote:
>Our share trading application database, patch set 9205, running on AIX
>5.3 64bit with 12CPU + 30 GB Memory,. Everyday, during trading
>beginning hours, end-users complains that the database is performing
>very slow, like hang stage for some times. We noticed that Oracle has
>brough many undo segs. online.

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l