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 ...





Oracle LazyDBA home page