适用范围

Oracle 19.7.0.0.0 linux

问题概述

1、巡检发现19C数据库alert偶尔产生报错ORA-1013

  2023-06-09T02:00:00.015769+08:00
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
2023-06-09T02:00:02.280393+08:00
opidrv aborting process J000 ospid (340013) as a result of ORA-1013

2、查看自动收集统计信息job运行情况

偶尔存在统计信息未收集完情况，查看库数据量9T多。

  select CLIENT_NAME,WINDOW_NAME,JOB_NAME,JOB_STATUS from dba_autotask_job_history；
CLIENT_NAME				 WINDOW_NAME	      JOB_NAME			     JOB_STATUS
---------------------------------------- -------------------- ------------------------------ ----------
auto optimizer stats collection 	 SATURDAY_WINDOW      ORA$AT_OS_OPT_SY_1848	     SUCCEEDED
auto optimizer stats collection 	 SATURDAY_WINDOW      ORA$AT_OS_OPT_SY_1849	     SUCCEEDED
auto optimizer stats collection 	 SATURDAY_WINDOW      ORA$AT_OS_OPT_SY_1850	     SUCCEEDED
auto optimizer stats collection 	 SATURDAY_WINDOW      ORA$AT_OS_OPT_SY_1851	     SUCCEEDED
auto optimizer stats collection 	 SATURDAY_WINDOW      ORA$AT_OS_OPT_SY_1852	     SUCCEEDED
auto optimizer stats collection 	 SUNDAY_WINDOW	      ORA$AT_OS_OPT_SY_1853	     SUCCEEDED
auto optimizer stats collection 	 SUNDAY_WINDOW	      ORA$AT_OS_OPT_SY_1854	     SUCCEEDED