Parallel procesing configuration.

With today multicore servers, parallel query is very important to get the max performance from a server.

It´s common to see 16 core servers using only one of them…  

Do you put some little parallelism on OLTP databases?

Where do you configure it? At table level? Instance level?    

Please, share your kwnoledge, interesting docs, hints, etc about this complex topic.

This is my biggest question about Oracle configuration.  

Thanks.  

Juan  

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