Oracle performance tuning - an update

Oracle performance tuning – an update

A tutorial is now available to perform Oracle performance tuning of applications and SQL statements. This tutorial has been expanded to include case studies, which will go a long way in better understanding of concepts explained. Link to the PDF tutorial here: Tuning.pdf This current posting is an extension to the existing post on performance [...]

Flowers from Indian spring

Flowers from Indian spring

Sharing some recent flower photographs. Hope you like, please do let me know.

Places of pilgrimage in Sikhism

Places of pilgrimage in Sikhism

Recently returned from a visit to Sachkhand Sri Hazur Sahib. This was the last residing place for the Tenth Guru. The journey was enjoyable, and the time spent very gainfully. I wished I could stay a few more days. On the way, I spent some time thinking about what would constitute the most important place [...]

Gurbani Plaque

Gurbani Plaque

It has been some time since my last post on this blog, things have been quite busy. Today I am sharing a Gurbani Plaque with you all, for the purpose of printing and putting at home or office. Its available in SVG format as well, which means it can be enlarged to any size, as [...]

Holi

Holi

I have written about many Indian festivals, but never about Holi. It is the Hindu festival of colours, much like Diwali being the festival of lights. For Sikhism, colours are strong depictions of mental state. There is no physical relevance to colours. A Sikh is expected to wear ordinary clothes that do not attract attention. [...]

Oracle: Snapshot too old?

Oracle: Snapshot too old?

Okay, so you have received the Oracle error ORA-01555 Snapshot Too Old and have no clue how to go about resolving it? This post is made for you then. (The first time an application developer has written about this rather than a DBA.) First, why does this occur? When you run a query, Oracle retains [...]