Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tuning Parallel server

Re: Tuning Parallel server

From: <ngreene_at_my-deja.com>
Date: 2000/07/14
Message-ID: <8knrnc$tmj$1@nnrp1.deja.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US