Question: is undo_retention a dynamic parameter?
Answer: The initialization parameters shown in Table 8.6 are relevant for undo management. ... A dynamic parameter specifying the name of an undo tablespace to use. undo_retention. A dynamic parameter specifying the length of time to retain undo.