Usually when you see such an error -- Numeric Overflow SQL error code 17026 in your JAVA application code, it means the data type used in the java code is not bigger enough to hold the result data fetched. Oracle's Java Developer guide has a mapping table called Java Type to SQL Type Mappings: Java … Continue reading JDBC Numeric Overflow with SQL error code: 17026
Month: August 2020
Which Oracle session is generating redo logs most?
From time to time, we would notice Oracle generates a significant amount of redo logs than usual volumes. It might causes the system down if the flash recovey area is full due to the huge archive logs created in a short period. So the basic thing to do is to find out which program/session is … Continue reading Which Oracle session is generating redo logs most?