MultiColumn Range / Range-List Partitioning

The docs do say that the Partition Key for Range Partitioning (or Hash Partitioning)
can comprise of multiple columns.

Has anyone used multiple columns as the Partition Key in a Range Partitioning implementation ?
Further to that, use Composite Partitioning where the SubPartition is based on List Partitioning ?

I understand that if a new row qualifies to fit into a particular partition based on the first column itself, the actual value in the second column doesn't matter as the desired partition has already been identified.

What would be the Pros and Cons of MultiColum Partition Keys ? Of mixing with a List Partition as a SubPartition ?

Hemant K Chitale
http://web.singnet.com.sg/~hkchital
and
http://hemantscribbles.blogspot.com
and
http://hemantoracledba.blogspot.com

"There is more to life than increasing its speed." Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html

--
http://www.freelists.org/webpage/oracle-l