Database Backup and Recovery (MOSC)

MOSC Banner

What would be the best number to increase the undo tablespace and the undo_retention to do export wi

edited Apr 8, 2011 5:31AM in Database Backup and Recovery (MOSC) 12 commentsAnswered ✓
 Hi experts.
What would be the best number to increase the undo tablespace and the undo_retention to do export with consistent=y full=y ?

Oracle version 9.2.0.3
db size:

 FILE TYPE              MB
---------------- --------
DB Files Total:    71,164
Redo Log Total:     3,072
                 --------
sum                74,236



SQL> select max(bytes) from dba_segments
  2  ;

MAX(BYTES)
----------
5712642048 -------> 5.3 Gb

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center