Hi,
i got a situation which is i keep on getting one of my table skipped during daily export dump.
That table include a BLOB col and the total table size is about 60GB.
Below are my parameter settings:
The undo_retention = 3600 = 1hour
and :
The export needed 5hr 20min
The export takes a time more than the undo_retention
so simply we need to increase the undo_retention to a value more than the export take to export this table
which is to just set the undo_retention with value 21600.
My concern is:
is there any performance issue on the database and the server hardware (RAM, CPU..etc) if i were to set the undo retention value permanently to 6hr! just for the table to be expdp sucessfully?
Kindly advice.