Have you checked out the first couple of papers at http://oracledoug.com/papers.html ? That should give you food for thought. On Wed, Dec 2, 2009 at 4:52 PM, Juan Miranda <jcmiranda@xxxxxxxxx> wrote: > Hi > > > > > > 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 > > > -- Niall Litchfield Oracle DBA http://www.orawin.info