How to use SQL Health Check SQLHC report for a slow SQL in Oracle database
SQLHC is a great tool to investigate a slow SQL performance issue. With SQLHC in place, you don't have to query database using any dynamic view or anything. It saves lot of times and efforts when you have performance problem in hand. Check SQL Tuning Health-Check Script (SQLHC) (Doc ID 1366133.1) to know more about it and to download the tool.