ORA-01423: error encountered while checking for extra rows in exact fetc

SQL Optimizer SQL Optimizer for Oracle
1

Oracle 12.2.0.1 x64
Client 19.3 x64
SQL Optimizer: 9.3.2.1266
When start run one simple query get an error:

ORA-01423: error encountered while checking for extra rows in exact fetch
ORA-06512: at line 69
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_XPLAN", line 6513
ORA-06512: at line 1
ORA-06512: at line 63

when I run
desc SYS.DBMS_XPLAN
sqlplus return me correctly list of methods from the package.

Plan is available and pic of the error is here:

2020-03-26_05-46-51
2020-03-26_05-46-511825×1198 135 KB

What am I missing?
Brg
Damir

when I run with that user "desc SYS.DBMS_XPLAN", sqlplus return me correctly list of package.

Plan is available and pic of the error is here:

2020-03-26_05-46-51
2020-03-26_05-46-511825×1198 135 KB

What am I missing?
Brg
Damir

P.S.
DB is upgraded from 11.2 version recently.

2

Hi Damir,

I would need more information to investigate. Would you please repeat the error and use SQL Tracker to capture the SQL being executing when this error happens?

Also, did you get this error only for some specific SQL? Maybe a quick test using "select 1 from dual" could help isolate if the problem is SQL related. If the problem is still repeatable using the DUAL table, it would also help you avoiding sensitive information when sending back the SQL Tracker log.

Thanks,
Alex

3

Hi Alex,

Select * from dual has no errors.
Repeated same SQL (from initial post) in same DB -> now works fine!
So it was not SQL Optimizer problem but some of our "internal stuff".
Sorry for inconvenience and false alarm.
Case may be closed as "customer side problem".
Brg
Damir

4

Hi Damir,

Thank you for retesting and confirming that the problem is not related to SQL Optimizer.

Thanks,
Alex