Re: Tuning Parallel server

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/07/14
Message-ID: <963560077.22424.1.nnrp-03.9e984b29@news.demon.co.uk>#1/1

The main tuning point is to design
the database so that difference instances affect disjoint sets of data. Once this is done, setting the DLM lock granularity in gc_files_to_locks can help a lot.

There are a couple of outline papers
on my web site; but nothing particularly detailed.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

gopdiv_at_hotmail.com wrote in message <8klpo5$dea$1_at_nnrp1.deja.com>...


>Hi All,

>

>   Has anyone got script for tuning oracle parallel server which could

>give recommendation on which area should be tuned etc. Thanks in

>advance.

>

>Thanks,

>With kind regards

>Gopdiv

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.

Received on Fri Jul 14 2000 - 00:00:00 CDT