Toad Data Point Premium Connections

Recently I tuned the peformance of a oracle pl/sql package. The description of the issue: This package is taking about 17 hours to complete. This packages is having approximately 3000+ lines of code...