Expired advisor data can't be purged.
(Doc ID 2576053.1)
Last updated on JULY 20, 2024
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 |