Hi Experts.
We have recently start evaluation of new Oracle Database version in Development and QA environment.
I have observed multiple errors as in database alerts log as below. These errors are reported for Oracle internal queries, not for application queries.
Please give your valuable suggestion or inputs for these errors.
1)
WARNING: too many parse errors, count=100 SQL hash=0x750004bb
PARSE ERROR: ospid=123182, error=933 for statement:
2017-10-11T10:51:37.594078+05:30
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=0x1df6a4080 phd=0x1df6a57d8 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0
2017-10-11T10:51:37.594289+05:30
----- PL/SQL Call Stack -----
object line object
handle number name
0x833ab948 259 type body SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION
0x87933c68 2134 package body SYS.PRVT_ADVISOR.COMMON_DELETE_TASK
0x87933c68 7342 package body SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS
0x1dbd125d0 1 anonymous block
2017-10-11T10:51:43.801804+05:30
2)
WARNING: too many parse errors, count=100 SQL hash=0x8839857f
PARSE ERROR: ospid=122346, error=12872 for statement:
2017-10-11T11:08:51.603739+05:30
SELECT /*OracleDictionaryQueries.ALL_COLUMN_ORACLE12c_QUERY*/
C.COLUMN_NAME, C.DATA_TYPE, C.DATA_TYPE_OWNER,
C.DATA_LENGTH, C.DATA_PRECISION, C.DATA_SCALE, C.NULLABLE,
C.DEFAULT_LENGTH, C.CHAR_LENGTH, C.DATA_DEFAULT,
( SELECT CMT.COMMENTS FROM SYS.DBA_COL_COMMENTS CMT
WHERE C.OWNER = CMT.OWNER
AND C.TABLE_NAME = CMT.TABLE_NAME
AND C.COLUMN_NAME = CMT.COLUMN_NAME) COMMENTS
, decode(C.CHAR_USED, 'B', 'BYTE', 'C', 'CHAR', null)
, C.DATA_TYPE_MOD, C.VIRTUAL_COLUMN, C.IDENTITY_COLUMN, C.DEFAULT_ON_NULL
FROM SYS.DBA_TAB_COLS C
WHERE C.OWNER = :1 AND C.TABLE_NAME = :2
AND C.HIDDEN_COLUMN = 'NO'
ORDER BY C.COLUMN_ID
Additional information: hd=0x1db533570 phd=0x1db54d0b0 flg=0x110676 cisid=0 sid=0 ciuid=0 uid=0
Thanks in Advance.
Regards,
Smit