Re: Transaction per minute

almost there wrote:
> IANAL_VISTA wrote:
> > soalvajavab1_at_yahoo.com wrote in
> > news:1105210171.343026.201650_at_c13g2000cwb.googlegroups.com:
> >
> > > How do you measure the application / database transactions
> throughput
> > > and health check once you inhereit a DB from pprevious DBA? Do
you
> have
> > > a check list for all you will do in the first weeks?
> > >
> > >
> >
> > Start with determining the Buffer Cache Hit Ratio
> > If it is too low, proceed to make it closer to 1.
> >
> > The maximum transaction throughput is a function of the application
> > and the underlying hardware.
> >
> > If you have to ask this question, I wonder how qualified you are.
>
> Who cares about Buffer Cache Hit Ratio. Run a few statpack reports
to
> get a reference of how the system is runing. Talk to the business
end
> users. See what they say is their biggest complaint is and start
there
> working on what is most important to them. There's an excellent
Oracle
> performane tuning book out there by Carl Milisap (not sure on
> spelling). Check that out - or take his class ;-)
> Of course, my first priority would be to review and test the back
ups!

That would, of course, be Cary Millsap, one of the most knowledgeable sources on performance tuning we have. His book is:

"Optimizing Oracle Performance", O'Reilly Press ISBN 0-596-00527-X and it is well worth a read.

I would tend to agree on running the statspack reports. Uploading them to www.oraperf.com is also something I would suggest, as the recommendations there are quite good.

I would also agree that the backup strategy be reviewed (should there be one; I have been called in to shops where none existed and the first order of business was to resurrect the database), tested and re-tested, and regularly put through its paces afterwards (once monthly is a good interval).

David Fitzjarrell Received on Sun Jan 09 2005 - 22:27:17 CST