Database Administration (MOSC)

MOSC Banner

Facing Intermittent Numeric Overflow error - ORA-01426

edited Apr 15, 2021 10:00PM in Database Administration (MOSC) 13 commentsAnswered

We have been facing numeric overflow ORA-01426 for 2-3 queries[only operand used - SUM()] intermittently and on re-execution the same query for same data works successfully.

Any pointers to debug the issue?

Oracle Version - :18.9.0.0.0

Oracle Database 18c Enterprise Edition

Attached trace and alert logs


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center