Re: Parallel Server Application Dev.

Peter, It is possible that some applications may not work as well as others under an OPS environment, but I have yet to see one that was unacceptable. Still, I admit it is possible.

In article <369E9BF2.68C00671_at_us.oracle.com>,   Peter Sharman <psharman_at_us.oracle.com> wrote:
> Mark
>
> I'm afraid I have to disagree with your point that application development doesn't
> change because of OPS. Or at least say that before you get to the application
> development, you need to look at the TYPE of application to determine its
> suitability for OPS. Easily partitionable or read-only apps will be fine. Apps
> that share data across nodes may not be.
>
> Pete
>
> MarkP28665 wrote:
>
> > From: Richard Murphy >>
> > Any recomendations for parallel server application development? Looking for a
> > good reference for creating and porting applications to a parallel system. <<
> >
> > If you are talking about porting to the Oracle Paraller Server as opposed to
> > parallel query then I would suggest:
> >
> > Size each machine big enough to handle the entire application so that if one
> > machine fails the application will still function within acceptable limits,
> > though with noticablily slower reponse time.
> >
> > Make sure you have enough memory to handle the number of PCM locks that your
> > application will need.
> >
> > Do not allow round robin PCM lock assignment, but instead manually assign locks
> > to every file using the gc_files_to_locks init.ora parameter.
> >
> > Try to separate sub-sections of your application table into groups where all
> > updaters come from one machine.
> >
> > Use OS level file stripping.
> >
> > If you are using one of the versions of UNIX that I have heard can support OPS
> > on other than raw partitions, use raw partitions anyway, unless the benefits of
> > the other file system are truely monumental.
> >
> > Make your temporary segment tablespace, usually called temp or tmp a
> > non--permanent tablespace: "alter tablespace tmp temporary;"
> >
> > Read the Oracle Parallel Server Concepts manual that comes starting with ver.
> > 7.3+
> >
> > Application development really does not change because of OPS unless the
> > application needs common OS level files. This could require the need to NFS
> > mount files which creates a single point of failure if the machine where the
> > files reside fails.
> >
> > I have been working with OPS for at least four years; it is not much different
> > from regular Oracle since we have several systems and we manage and design for
> > all of them using pretty much the same techniques and rules.
> >
> > Mark Powell -- Oracle 7 Certified DBA
> > - The only advice that counts is the advice that you follow so follow your own
> > advice -
>
> --
>
> Regards
>
> Pete
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Peter Sharman Email: psharman_at_us.oracle.com
> WISE Course Development Manager Phone: +1.650.607.0109 (int'l)
> Worldwide Internal Services Education (650)607 0109 (local)
> San Francisco
>
> "Controlling application developers is like herding cats."
> Kevin Loney, ORACLE DBA Handbook
> "Oh no it's not! It's much harder than that!"
> Bruce Pihlamae, long term ORACLE DBA
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 15 1999 - 09:10:09 CST