Which two are true about the Oracle database methodology? (Choose two.)

Question

Options

• AThe Oracle Database time model should be used to find the database and instance areas
• BTuning activities should stop once the user is satisfied with performance.
• CTuning activities should stop once agreed service levels for performance have been met.
• DThe database instance memory should always be tuned before tuning any file systems.
• ESQL statements should always be tuned before tuning any file systems.
• FThe alert log should be used to find the database and instance areas most in need of tuning.

• A
  74% (14)
• B
  5% (1)
• C
  16% (3)
• F
  5% (1)

Explanation

A is correct. It will show what the database is spending most time on, that (usually) indicates where tuning is required. B and C relate to user experience. We (DBAs) should work with users, to help achieve their requirements. However, we can be proactive outside of this. Just because a user is happy - doesn't mean we can't make them "happier" by doing tuning activities before things get bad. So, neither of these should be true. D is incorrect, memory is much less likely to be a culprit of an issue, than a filesystem I/O issue. E is correct. We should never try to tune a file system first. If we make a file system change that fixes one SQL statement - it might harm a different SQL statement. However, if we tune the first SQL statement, it will have no impact on the rest of the system. Therefore, we should try to tune "bad SQL" first. F is incorrect - the alert log gives us little/no information to do with tuning.

No community discussion yet for this question.