Re: Performance Monitoring

Stefan Wetter wrote:
> Thank all of you. I do understand that i have to understand some basic
> things. My problem is, that i am no dba. I am software developer with
> some basic oracle-dba-knowledges. Now, one of our customers has a
> problem with his oracle database. And because i set it up und keep it
> running i am his contact if there are problems. And the Problem is, that
> the database is slow. Or, I should better say: is getting slow.
>
> And i do understand that having data in memory is much faster than
> having data to be red from disk. And i do see, that we have much
> physical read and empty buffers. So, can someone please give me an
> advice how i can tell my server to have more data in memory?
>
> And i see one more thing: There are about 15% unindexed queries. How can
> i find out which queries were maid that are unindexed?
>

Hi Stefan,

read Cary Milsap, Optimizing Oracle for Performance.

My approach would be to start with the business transaction or GUI screen, where your customer experiences the biggest problem and can generate the largest benefit by getting this faster.

Once you tuned this, step ahead to the second one.

Jan Received on Fri Oct 05 2007 - 05:25:04 CDT