SET TIMING—one of the most frequently used commands—displays timing statistics on each SQL command or PL/SQL block. What if you want to collect timing statistics for multiple group of statements? TIMING command becomes handy in such situation—one of things that I knew and have forgotten over time. It can be used to collect data to do …
I noticed a strange behavior—a SQL statement, which used to return no rows in the past, started returning rows in an environment where the test data set has not changed. I performed a code comparison and observed a difference in the order of a table in FROM clause. After looking through, I found a bug entry on MOS …
SQL returns wrong result when the table order is swapped Read More »
The Art of Scalability: Scalable Web Architecture, Processes, and Organizations for the Modern Enterprise—A must read for technical and business persons in your company, if you are looking to scale your business, whether you are a startup or Fortune 500. Scalability is widely used term, often, refers to scaling a specific technology—for most technical people. …