Bug 29457502 - ORA-1426: numeric overflow ORA-6512 while running workload (Doc ID 29457502.8)

Bug 29457502 ORA-1426: numeric overflow ORA-6512 while running workload

This note gives a brief overview of bug 29457502.
The content was last updated on: 14-MAR-2020
Click here for details of each of the sections below.

Affects:

Product (Component) Oracle Server (Rdbms)

Range of versions believed to be affected Versions >= 19 but BELOW 20.1

Versions confirmed as being affected

19.1.0

Platforms affected Generic (all / most platforms affected)

Fixed:

The fix for 29457502 is first included in

20.1.0

19.6.0.0.200114 (Jan 2020) Database Release Update (DB RU)

Interim patches may be available for earlier versions - click here to check.

Symptoms:	Related To:
Process May Dump (ORA-7445) / Abend / Abort Code Improvement ORA-1426 ORA-600 [kkogbro: no kkoaptyp]	(None Specified)

Description

Gather real-time stats when UPDATE stmt uses index scan.
  
 
Rediscovery Notes
Given an update stmt with index scan, real-time stats should be gathered.
 
Workaround
alter session set "_optimizer_gather_stats_on_conventional_dml" = false;

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

References

Bug:29457502 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article