Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01555 caused by SQL statement below

3236389May 4 2018 — edited Jun 7 2018

I am using Oracle 11g R2 and in my database there appear an ORA in alert log ORA-01555

and looking at the sql is obviously oracle internal task

(SQL ID: g0jvz8csyrtcf, Query Duration=6 sec, SCN: 0x0000.27c4f832)

SELECT T.TASK_ID FROM SYS.DBA_ADVISOR_TASKS T, WRI$_ADV_PARAMETERS P WHERE T.TASK_ID = P.TASK_ID AND T.STATUS# <> :B2 AND T.READ_ONLY = 'FALSE' AND P.NAME = 'DAYS_TO_EXPIRE' AND PRVT_ADVISOR.CHECK_EXPIRATION_COMP(:B1 , T.LAST_MODIFIED, P

.VALUE) = 1

and checked my undo space should be enough . how come it still cause the error ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2018
Added on May 4 2018
#general-database-discussions
33 comments
4,294 views