My Oracle Support Banner

过期的advisor数据无法被清理 (Doc ID 2639889.1)

Last updated on FEBRUARY 24, 2020

适用于:

Oracle Database - Enterprise Edition - 版本 12.2.0.1 到 12.2.0.1 [发行版 12.2]
本文档所含信息适用于所有平台

症状

过期的advisor数据没有被自动清理。
手工执行存储过程prvt_advisor.delete_expired_tasks进行清理, 在10046 event trace中发生了ORA-1722。

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)'

更改

无。

原因

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

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


文档内容
症状
更改
原因
解决方案
参考

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