undo_retention in 19c database
Posted by raiq1 on Oct 02, 2023; 3:32pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/undo-retention-in-19c-database-tp12078.html
Dear Erman sir,
I have 19c (19.10.0.0) database with 12.1.3 ebs application, some long running concurrent request are failed with snapshot too old error.
Currently undo_retention is 2400 , I need to change it , what is the optimal value I have to assign here.
Make sure undo_retention size is cdb leval & pdb level are same , both in 2400.
Need your advice.
Regards,
Raiq