Monthly Archives: March 2015

Oracle Database Transactions and Locking Revealed, by Tom Kyte and Darl Kuhn

I recently came across the book called “Oracle Database Transactions and Locking Revealed” by Tom Kyte and Darl Kuhn. Usually, any new book by Tom Kyte is a big deal and acquires a huge following very quickly. Strangely enough there … Continue reading

Posted in Uncategorized | 1 Comment

PostgreSQL Hints and DBMS_STATS

For those who don’t know,‭ ‬it is now possible to use hints on PgSQL.‭ ‬Here is how things work: -‭ ‬Download and install the extension from the home page: ‭  ‬http://sourceforge.jp/projects/pghintplan/ If you are using Red Hat derivative,‭ ‬like me,‭ … Continue reading

Posted in Uncategorized | Tagged | 3 Comments