Where to get SQL workload from SGA or AWR?

If you know when the bottleneck of your system is, you can use AWR to retrieve SQL workload from the specific time slots. If the current running SQL in SGA is good enough to represent your peak hour workload in your application, you should extract SQL from SGA directly for IM Advisor and IM Simulator recommendation.