Re: Oracle Parallel Server

Thanks Mark,
I didn't intend to use autoextend, it was just a query. But the question about control files still stands. How large should the control file device be given that they can grow ( to quite a size, the ref says 20000 oracle blocks ).

Dave Leather

"Mark D Powell" <markp7832_at_my-deja.com> wrote in message news:8q7qvi$gpe$1_at_nnrp1.deja.com...
> In article <8q7l6q$vps$1_at_newsg1.svr.pol.co.uk>,
> "Dave Leather" <david.leather_at_energis-squared.com> wrote:
> > All,
> >
> > When you implement raw devices ( as you must for OPS),how does the
> > autoextend feature happen, is is disabled for raw dev's . Also
 control files
> > grow, what should be allocated to manage the growth , or is the growth
> > different in OPS ?
> > ( if you have any good references for OPS could you let me have them )
> >
> > Thanks in advance
> >
> > Dave Leather
> >
> >
> I would not attempt to use auto-extend with OPS and raw partitions. We
> run OPS on raw partitions and have never tried auto-extend. Since raw
> partitions are fixed in size at creation it makes no sense to allocate
> less than the entire partition. I would think that it would work as
> long as the rdbms did not try to extend past the partition boundries,
> but I would hope that Oracle is smart enough not to allow auto-extend
> on raw partitions. Post if you find out it works.
> --
> Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --

>
>