DEVFYI - Developer Resource - FYI

Why and when should one tune? (for DBA

ORACLE Interview Questions and Answers (Part 2)

(Continued from previous question...)

237. Why and when should one tune? (for DBA

One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to be monitored and adjusted to increase its performance. One should do performance tuning for the following reasons:
The speed of computing might be wasting valuable human time (users waiting for response); Enable your system to keep-up with the speed business is conducted; and Optimize hardware usage to save money (companies are spending millions on hardware). Although this FAQ is not overly concerned with hardware issues, one needs to remember than you cannot tune a Buick into a Ferrari.

(Continued on next question...)

Other Interview Questions