Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tuning Parallel server
In article <396EF816.2D65_at_yahoo.com>,
connor_mcdonald_at_yahoo.com wrote:
> 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...
I believe this came about after 8.1.6 R2, where you can assign one node as the write only node. --- n
-- Neil Greene email: ngreene_at_my-dejanews.com Sent via Deja.com http://www.deja.com/ Before you buy.Received on Fri Jul 14 2000 - 00:00:00 CDT