Set the STATISTICS_LEVEL initialization parameter to ALL.
Create a baseline on a pair of snapshots that have the statistics of the peakload period in the database.
Decrease the snapshot interval in the AWR to collect more number of snapshots during the peakload period.
Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid theautomatic purging of the snapshots.
第1题:
第2题:
You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running?()
第3题:
第4题:
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()
第5题:
Your archive-log destination directory runs out of space. What is the impact of this on the database?()
第6题:
第7题:
Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()
第8题:
第9题:
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data, you want to have minimal impact on the database performance and optimize the dataload operation. Which method would you use to load data into the Oracle database()
第10题:
Your database is in ARCHIVELOG mode. You have two online redo log groups,each of which contains one redo member. When you attempt to start the database, you receive the following errors:()