单选题You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）ACompare Period ADDM reportBAWR Compare Period reportCActive Session History (ASH) reportDTaking a new snapshot and comparing it with a preserved snapshot
单选题
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）
A
Compare Period ADDM report
B
AWR Compare Period report
C
Active Session History (ASH) report
D
Taking a new snapshot and comparing it with a preserved snapshot
参考解析
解析：
暂无解析
相关考题：
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE path;C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE path;D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.() A. Change in the Oracle Database versionB. Change in your network infrastructureC. Change in the hardware configuration of the database serverD. Migration of database storage from non-ASM to ASM storageE. Database and operating system upgrade
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.Which three findings would you get from the report?（）A. It detects any configuration change that caused a performance difference in both time periods.B. It identifies any workload change that caused a performance difference in both time periods.C. It detects the top wait events causing performance degradation.D. It shows the resource usage for CPU, memory, and I/O in both time periods.E. It shows the difference in the size of memory pools in both time periods.F. It gives information about statistics collection in both time periods.
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.Which method or feature should you use?() A. Compare Period ADDM reportB. AWR Compare Period reportC. Active Session History (ASH) reportD. Taking a new snapshot and comparing it with a preserved snapshot
A technician wants to compare a new server performance over a period of time. Which of the following should the technician do FIRST?（）A、Monitor processor performance logsB、Constantly check the task managerC、Use performance server logsD、Establish a baseline for the server
You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ；D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ；
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）A、Compare Period ADDM reportB、AWR Compare Period reportC、Active Session History (ASH) reportD、Taking a new snapshot and comparing it with a preserved snapshot
Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）A、 use DBMS_IJOB packageB、 use Oracle SchedulerC、 use DBMS_JOB packageD、 use Oracle Data Pump Export and Import
You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）A、Enable Memory Access Mode, which reads performance data from SGA.B、Use emergency monitoring to fetch data directly from SGA analysis.C、Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.D、Use Active Session History (ASH) data and hang analysis in regular performance monitoring.E、Run ADDM in diagnostic mode.
Your database instance is functional for the past one month. The Automatic Workload Repository（AWR） snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of theprevious day. Choose two actions any of which can be referred to first to diagnose the problem. （）A、Use the Active Session History report.B、Use the AWR Compare Periods report.C、Use an ADDM analysis between 7 PM and 9 PM of the previous day.D、Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.
You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database. While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data.
The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）A、by using the SQL access advisorB、by using the Automatic Workload Repository reportC、by running the Automatic Database Diagnostic Monitor （ADDM）D、by using the Automatic Workload Repository Compare Period reportE、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）A、use the external table populationB、use the Oracle Data Pump export and import utilityC、use the conventional path data load of SQL*Loader utilityD、use the direct path data load of Oracle export and import utility
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）A、Insert finding directives for ADDM tasks in the future.B、Create a baseline on a pair of snapshots spanning the peak-load period.C、Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）A、Change in the Oracle Database versionB、Change in your network infrastructureC、Change in the hardware configuration of the database serverD、Migration of database storage from non-ASM to ASM storageE、Database and operating system upgrade
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）A、ALTER DATABASE ENABLE BLOCK CHANGE TRACKINGB、ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C、ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D、ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）A、It detects any configuration change that caused a performance difference in both time periods.B、It identifies any workload change that caused a performance difference in both time periods.C、It detects the top wait events causing performance degradation.D、It shows the resource usage for CPU, memory, and I/O in both time periods.E、It shows the difference in the size of memory pools in both time periods.F、It gives information about statistics collection in both time periods.
单选题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）AALTER DATABASE ENABLE BLOCK CHANGE TRACKING;BALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE path;CALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE path;DALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
单选题A technician wants to compare a new servers performance over a period of time. Which of the following should the technician do FIRST？（）A Monitor processor performance logsB Constantly check the task managerC Use performance server logsD Establish a baseline for the server
单选题You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）A ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；B ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；C ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ；D ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ；
单选题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）AALTER DATABASE ENABLE BLOCK CHANGE TRACKINGBALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE CALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE DALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
单选题You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）ACompare Period ADDM reportBAWR Compare Period reportCActive Session History (ASH) reportDTaking a new snapshot and comparing it with a preserved snapshot
多选题You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）AIt detects any configuration change that caused a performance difference in both time periods.BIt identifies any workload change that caused a performance difference in both time periods.CIt detects the top wait events causing performance degradation.DIt shows the resource usage for CPU, memory, and I/O in both time periods.EIt shows the difference in the size of memory pools in both time periods.FIt gives information about statistics collection in both time periods.
单选题Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）A use DBMS_IJOB packageB use Oracle SchedulerC use DBMS_JOB packageD use Oracle Data Pump Export and Import
单选题You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）ACompare Period ADDM reportBAWR Compare Period reportCActive Session History (ASH) reportDTaking a new snapshot and comparing it with a preserved snapshot
多选题Your database instance is functional for the past one month. The Automatic Workload Repository（AWR） snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of theprevious day. Choose two actions any of which can be referred to first to diagnose the problem. （）AUse the Active Session History report.BUse the AWR Compare Periods report.CUse an ADDM analysis between 7 PM and 9 PM of the previous day.DUse the AWR Compare Period report between 7 PM and 9 PM of the previous day.
单选题You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）AEnable Memory Access Mode, which reads performance data from SGA.BUse emergency monitoring to fetch data directly from SGA analysis.CRun Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.DUse Active Session History (ASH) data and hang analysis in regular performance monitoring.ERun ADDM in diagnostic mode.
单选题Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）AInsert finding directives for ADDM tasks in the future.BCreate a baseline on a pair of snapshots spanning the peak-load period.CDecrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.DSet the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots