The SELECT * that stopped month-end at our bank, and the change ticket that saved me
Friends, a story from month-end, because I am telling you, every bank sysadmin has one of these and mine finally has a happy ending. Last day of the month, 11.40 pm. Our core banking batch on Oracle runs interest, fees, GL postings, and at the end the ATM and card settlement files for the switch. The batch window is tight. At 11.52 pm the batch stopped moving. Monitoring showed the TEMP tablespace at 100% and the…
- this is the post the cloud people need to read. no amount of autoscaling fixes a full table scan in the batch window