On Oracle
Monday, September 15, 2025
Blog List
›
September 2025 (3) ORA-06502: NULL index table key value and plsql_optimize_level "ORA-00001: unique constraint...
ORA-06502: NULL index table key value and plsql_optimize_level
›
In this Blog, we will show that the logically equivalent Plsql code can have different behaviour when toggling plsql_optimize_level. Note:...
Saturday, September 6, 2025
"ORA-00001: unique constraint violated" Debugging
›
In this Blog, we demonstrate two approaches to debug ORA_00001, one is using errorstack event; another is with DML before trigger. Both are...
Monday, September 1, 2025
Oracle Database Stuck on DB Writer Wait Event: "oradebug request completion"
›
Blog: Perilous New Undocumented Tracing Feature in Oracle 21c oradebug request completion revealed DBWR wait event "or...
›
Home
View web version