When I tried to change the password for SYS, I got an ORA-28017 error message. This was caused by a manual DB upgrade to 12C without upgrading the password file as well.
Street-Light Performance Anti-Method
Connor McDonald writes that It’s just bad code or bad design … most of the time for Oracle performance problems.
Why Choosing ANSI JOIN is an Operational Issue
From an operational perspective, I argue that the use of ANSI syntax for JOINs is superior to that of Oracle’s native syntax.
Slow Apply on Logical Standby due to SYS.AUD$
Bottom-Up Enterprise Information Systems
In Bottom-Up Enterprise Information Systems: Rethinking the Roles of Central IT Departments (behind a pay-wall), Chua and Storey look at strategies for Central IT departments to handle the challenge of these new systems.
Exercise in Database Performance Modelling
I have spent the past year doing performance modelling of a new product that is being rolled progressively to clients. The most frustrating thing has the lack of meaningful feedback from the product support group. Everytime I raise a concern that the performance is not as expected, I get the platitude that the product is performing as expected.
Clock Drift Stops OMS Startup
I had an issue in which clock drift between the OMS and OMR caused the OMS to fail to start. Full details are here.
