AWR, ASH and the 10 minutes that saved a go-live
Friday evening, the night before a go-live. Performance collapses. Using AWR and ASH I found a hidden full table scan in a stored procedure in under ten minutes — and the production release went ahead.
·8 mins