Three of the tables are partitioned 16 ways so that explains why I see
each table scanned 16 times.



Why does each partition get scanned one at a time? The table has a
degree of parallel set and the explain shows that it is running parallel
queries.



Any ideas why each partition is scanned in serial?

Oracle LazyDBA home page