Monday, April 4, 2011

Expect Exadata Performance Decline After Cell Reboot

Well, just a note, that if you experience dead slow performance after the reboot of Exadata database machine, then it is most likely that the storage indexes are being rebuilt by the cell software upon the first access of the data.

Instead of logging an SR, it would be good idea to wait a little and then check later. Or make it part of SOP to run smoke test queries on the tables after the restart, to let cell software rebuild storage indexes, and then put the Exadata into the production.

No comments: