Let me add My agreement with what Dustin and Stacy have said. Ignore
the fancy stuff until you want to shave milliseconds off of query
response time. Concentrate on hardware.

Just say no to tuning wait event, cache hit ratio, latch contention,
etc...

You will have your work cut out for you because you are running
peoplesoft - I know from experience it is nearly un-tunable. The only
worst case is Siebel and you didnt mention that.

Your best bang for the buck is to add memory, then I/O throughput, then
processors (in that order) and not spend time trying to make oracle
overcome stupid design and implementation practices of the vendors you
mention. Overwhelm stupidity with hardware.

HTH
Cliff

On Thu, 2005-10-27 at 10:24 -0400, Stacy Gaddy wrote:
> I agree with Dustin. In my experience, there are two area that typically give
> you the most bang for your buck, IO and application design (ie. how the
> developers are writing their queries). So, dont overlook the SAN layout.
>
> Stacy
>
> On Wednesday 26 October 2005 12:21 pm, Dustin Hayden wrote:
> > There are recommended options for the mount points from your SAN you don't
> > be too quick to just leave that to someone else.
> >
> >
> > -----Original Message-----
> > From: Newbie-DBA
> > [mailto:oracledba-ezmlmshield-x41191192.[Email address protected]
> > Sent: Tuesday, October 25, 2005 7:57 PM
> > To: LazyDBA Discussion
> > Subject: Performance tuning, WAIT CONTENTION, LATCH CONTENTION etc.
> >
> > Hi all,
> >
> > I apologize if this is a very trivial question. Am very new to Oracle,
> > especially DBA tuning, so am hoping that anyone can suggest how should I
> > start. I know I have the Performance Tuning docs from Oracle but at the
> > moment they're too deeply technical for me.
> >
> > Disk-wise, am leaving that to the SAN Storage Expert, he give me the space
> > I need and I leave it for him to determine the location of where the
> > datafiles are to be although I have to take care of having the multiple
> > copies of REDO and CONTROL files. Of course, I would expect him to tell me
> > where I should be placing the most active datafiles.
> >
> > I do not foresee changing the SQLs as this is a SAP/PeopleSoft/JDE
> > environment in which more or less, changing the SQLs is out of the question
> > unless you are a bigger entity that these two (2) major players ... Should
> > I add an index? Maybe, but then again I have to discuss it with these
> > 'experts
> >
> >
> > So am left with tuning the memory, am looking at using the default that
> > Oracle will choose during the installation. This should be my baseline and
> > then slowly increase this as necessary up to the maximum that I can without
> > jeopardizing the OS from starting up or doing its other task like
> > printing/spooling etc.
> >
> > I managed to source out some scripts from the web about latch contention,
> > hit ratios, wait events contentions, IOs etc. While some scripts seem
> > self-explanatory, especially the hit ratios one, am more curious about the
> > values for latch contentions and waits. How do I judge whether I have latch
> > contention or wait contentions from the values that am getting from the
> > V$VIEWS, are the ratios enough as per the docs as good as it gets? Also,
> > are WAITS and LATCH contentions most of the time involve sizing the memory
> > or possibly a batch job that was run by a user at a time that he/she
> > shouldn't be running it?
> >
> > FYI, Oracle is on Version 9.2.0.5. Any response will be very much
> > appreciated. Alternatively, if someone can suggest a site to go for case
> > studies on Oracle performance tuning, that will be very much appreciated. I
> > ve been to an Oracle Course on Performance Tuning but I can't get much out
> > from the lab exercises to suggest a performance issue.
> >
> > Thanks in advance ...
> >
> >
> >
> >
> >
> >
> > --------
> > website: http://www.LazyDBA.com
> > Please don't reply to RTFM questions
> > Oracle documentation is here: http://tahiti.oracle.com
> > To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> > To subscribe: see http://www.lazydba.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> >
> >
> > --------
> > website: http://www.LazyDBA.com
> > Please don't reply to RTFM questions
> > Oracle documentation is here: http://tahiti.oracle.com
> > To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> > To subscribe: see http://www.lazydba.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
>


Oracle LazyDBA home page