performance

What are the different ways you will come to know that there is performance problem in a database..
thomaslijuAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
>>If we get the complaint what we do first..

Call the DBA and System Administrator.

Before you post that you are the DBA or System Administrator, please don't.

This question is way to vague to answer in a Q&A site like this.

Narrow down what specfic system part is showing signs of stress:
Memory, Disk or CPU.

That is half the battle right there.  Once you figure that out, dig deeper.

For example:
Are you licensed for ADDM and AWR?
Are you licensed for the Diagnostics or Performance packs?
Are you familiar with StatsPack?

From strictly a database perspective, most DBAs have collected scripts over the years that grab specifics and help them narrow down where problems are.

No, I cannot post mine.

Many scripts can be found with a simple Google search.
0
 
johnsoneSenior Oracle DBACommented:
You get a phone call.  If there is a problem, users are very quick to point it out.  If nobody is complaining, it isn't a problem.
0
 
thomaslijuAuthor Commented:
If we get the complaint what we do first..
0
 
thomaslijuAuthor Commented:
Yes AWR report helps and look for

db_file sequential read
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.