I have found that one of the most common areas of concern for Oracle is performance.
I am frequently run into sites that are new to Oracle, complaining about sluggish
performance and have taken their flat file systems and jammed them into Oracle.
For the benefits of the "newbies" out there, I would like to put together a list
of common areas to look at when systems are performing slowly.
For Example:
. Check for locking contentions (how?)
. Check to see if Database is over-extended (how?)
. Check to see if rollback segments should be increased
. Can the database be split across multiple drives to easy disk useage
. Should a more efficient index be defined?
If you can add anything to this thread please feel free to you. I think this type
of listing would be beneficial to all of us.