Data Guard today
Today had noticed that redo logs were not being applied to standby. Checking live database alert log showed errors like:
Read More Data Guard todayBug? with wrong results from all_objects in stored plsql procedures
Wouldn’t it be nice if sql code produced the same result, regardless of whether it is inside a stored procedure or is a standalone plsql block? But that’s not what happens when the all_ views are used. Run this code to see the anomaly for yourself: set serverout on declare var1 number ; begin select […]
Read More Bug? with wrong results from all_objects in stored plsql procedures