Does Oracle Partition by Reference optimizes join queries
I think the answer to your question is "Yes".

The Oracle optimizer understands reference partitioning. See the Oracle documentation at http://docs.oracle.com/cd/E11882_01/server.112/e25523/part_avail.htm#BJECHCAG

Also see http://www.orafaq.com/node/2591