Re: undo segments online causing performance problems.

From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
To: sjaffarhussain@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 29 Dec 2005 20:07:25 +0800

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

Follow-Ups:

Re: undo segments online causing performance problems.
From: The Human Fly

References:
- undo segments online causing performance problems.
  - From: The Human Fly

Re: undo segments online causing performance problems.

Other related posts: