Re: Tuning Parallel server

Jonathan Lewis wrote:
>
> 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.

(Although I've not tried/tested this...) isn't there a new special 2-node config for OPS now, where one node does all the updates and the other force to read only...

Sounds very promising...

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse