Friday, April 2, 2010

Determining longest query length in oracle database

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