ora - 1555 error
I have a 10.2.0.4 database on AIX . I am getting ora-1555 error message :
ORA-01555 caused by SQL statement below (SQL ID: cqcxg8udfzxy6, Query Duration=1866 sec, SCN: 0x0705.7807eb6c):
I have increased the size of Undo Tablespace , its currently 7 GB , and the current usage of Undo
tablespace is 5749MB.
What else I can do other than asking the application to do frequent commit.
Plz let me know...
Thanx