Configure Java Pool to cache the java objects.
Configure Streams Pool to enable parallel processing.
Increase Shared Pool size to cache more PL/SQL objects.
Increase Database Buffer Cache size to increase cache hits.
Configure Large Pool to be used by RMAN and shared server.
Increase the total System Global Area (SGA) size to increase memory hits.
第1题:
You are maintaining your OLTP database in Oracle10g. While observing the performance of the database, you find that the log switch occurs more than once for every 20 minutes, affecting the database performance. Which factor is responsible for frequent log switches?()
第2题:
You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()
第3题:
You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to, in order to determine the appropriate indexes?()
第4题:
The baseline, once created, cannot be removed.
Disable the baseline metrics in the Database Control Manage Metrics page.
The baseline will be automatically removed once the database performance has been optimized.
Drop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.
第5题:
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the database administrator for your company. You find a problem that there are three reports which are running slowly. And through detailed analysis, you conclude that no error messages are generated from these reports. Not only the indexing strategy but also the status of the current indexes is tested by you. You confirm that the slow performance of the financial reports is not caused by it. Since you are the technical support, you are required to find out which statement is causing the slow performance. Which action should be performed first?()
第6题:
In the parameter file of your production database, the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery, you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files?()
第7题:
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? ()
第8题:
In your production database, you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation, you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server?()
第9题:
the value of the UNDO_RETENTION initialization parameter
the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
the online redo log files size
the number of redo log members in a group
第10题:
Memory Advisors
Segment Advisors
SQL Tuning and Access Advisors
Automated Workload Repository (AWR)
Automatic Database Diagnostic Monitor (ADDM)