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, [...]