Following is the query to determine the longest query length in oracle database, this query can be very useful in setting up UNDO_RETENTION parameter.
SQL> select max(maxquerylen) from V$undostat;
Make sure this is atleast equal to the value of UNDO_RETENTION to prevent a famous
ORA-01555
No comments:
Post a Comment