I figured out how to get some wait statistics. Here is a table comparing a slow execution (3 hrs) vs a fast execution (1 hr). Keep in mind that all tests were done on the same server, alone, database was restored from a backup every time, and Oracle was shutdown and restarted between each tests. Usually the slow tests happens when the Oracle server was sitting idle for a few days (like a weekend):

Capture.PNG