My Oracle Support Banner

Expired advisor data can't be purged. (Doc ID 2576053.1)

Last updated on SEPTEMBER 05, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Expired advisor data is not purged automatically.
Try to purge manually by the procedure prvt_advisor.delete_expired_tasks, ORA-1722 occurs in 10046 event trace.

PARSING IN CURSOR #350871520 len=354 dep=1 uid=0 oct=7 lid=0 tim=5581781713 hv=1379595660 ad='7ff115aff78' sqlid='fzsxusp93pxcc'
DELETE FROM wri$_adv_rec_actions a
WHERE a.task_id = :task_id_num AND
(:execution_name IS NULL OR
EXISTS (SELECT 1
FROM wri$_adv_recommendations b
WHERE b.task_id = :task_id_num1 AND
b.id = a.rec_id AND
b.exec_name = :execution_name1))
END OF STMT
PARSE #350871520:c=0,e=208,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,plh=0,tim=5581781713
BINDS #350871520:

Bind#0
oacdty=01 mxl=128(128) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=873 siz=128 off=0
kxsbbbfp=1916fd30 bln=128 avl=08 flg=09
value="EXEC_220"                                                                    <<<<<<
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=00 csi=00 siz=48 off=0
kxsbbbfp=14e9d0e0 bln=22 avl=02 flg=05
value=2
Bind#2
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=14e9d0f8 bln=22 avl=02 flg=01
value=2
Bind#3
oacdty=01 mxl=128(128) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=873 siz=128 off=0
kxsbbbfp=1916fd30 bln=128 avl=08 flg=09
value="EXEC_220"
EXEC #350871520:c=0,e=1460,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,plh=3611671654,tim=5581783248
ERROR #350871520:err=1722 tim=5581783264                     <<<<<<
STAT #350871520 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE WRI$_ADV_REC_ACTIONS (cr=0 pr=0 pw=0 str=1 time=0 us)'

Changes

 None.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.