May 10 2009

Short Circuit=>Power Down=>SAN Down=>DB Crashed=>Oracle 9i DB started fine=>but…OOPS! SAP Application not working properly

Once a User complained about some modules having issues :
There was a Database Alert Log recorded ORA-600 internal error with different first actual code argument. A search into Meta link showed that DB had problems in executing DMLs on some tables, as some of  the indices on these tables had logical corruption. So its obvious [...]

May 7 2009

Out of deep Woods- Thanking the Heavens!!

A few days back, I found a huge index on my main transaction table in primary production database(9i RAC Database), which I suspected was not being used by any query. So I decided to monitor its usage using oracle 9i Monitoring usage command. And after monitoring it for a week, [...]

TAGS:
Mar 26 2009

Managing Technology - A pain for startups.

We all know that it just takes an idea to be a successful especially in today’s world where people are ready to invest in your ideas. However with increasing competition; path to success is getting difficult day-by-day and distance between success and failure is shrinking.
Today’s entrepreneurs have much more to manage than ever before. [...]