From an operational perspective, I argue that the use of ANSI syntax for JOINs is superior to that of Oracle’s native syntax.
Now that Flashback Data Archive is now included in the base 220.127.116.11 license, I had the crazy idea to mix it with Database Editioning.
I have recently used SQLTXPLAIN to solve a production performance issue. This post is about my experiences with this tool.
Today, I had a question about how to exchange the names of two (2) columns in a table. Apparently, there was a transposition error in the data loading program.
Today I learnt something new about Oracle 11.2. I found an interesting MOS document: How to Obtain Tracing of Optimizer Computations (EVENT 10053) (Doc ID 225598.1).