create baseline metrics for today’s performance
write the current database metrics to a database table and create a trigger to compare with future database statistics
write the current database metrics to a flat file and create an operating script to compare with future database statistics
write the current database metrics to a database table and create a procedure to compare with future database statistics
write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
第1题:
You have created a baseline metric, DISK_IO_BL, for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics?()
第2题:
You are working on the 24X7 database with high transaction volume, to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database?()
第3题:
A. What ‟s your job
B. What ‟re you doing
C. Are you a scientist
D. What ‟s your dream for the future
第4题:
You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?()
第5题:
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA?()
第6题:
You find today’s performance of your production database to be the best ever. Therefore, you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this?()
第7题:
You work as a database administrator for Supportcenter.cn. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metrics to achieve your objective?()
第8题:
A、What’s the exchange rate today
B、What kind of currency do you want to exchange for
C、What’s the amount you’d like to exchange
第9题:
You work as a database administrator for Certkiller .com. In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve?()
第10题:
You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to, in order to determine the appropriate indexes?()