Login  Register

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