Users in your PROD database complain about the slow response of the transactions. While
investigating the reason, you find that the transactions are waiting for the undo segments to be
available, and undo retention has been set to zero. What would you do to overcome this problem?
A.
increase the undo retention
B.
create more undo segments
C.
create another undo tablespace
D.
increase the size of the undo tablespace
you can enable automatic extension for datafiles of the undo tablespace so that they automatically increase in size when more space is needed
For an undo tablespace with the AUTOEXTEND option enabled
Although websites we backlink to below are considerably not connected to ours, we feel they may be in fact really worth a go by, so possess a look.
Wonderful story, reckoned we could combine a couple of unrelated data, nevertheless actually worth taking a look, whoa did one particular discover about Mid East has got far more problerms as well
Sites of interest we’ve a link to