单选题Performance divergence indicated in the Workload Replay report is most likely due to what？（）A DML and SQL statement results that do not match between the capture and replay systemsB When errors that occur in the capture system dont occur in the replay systemC Top SQL statementsD Infrastructure or system-configuration differencesE Time-of-day differences between capture and replay systems
单选题
Performance divergence indicated in the Workload Replay report is most likely due to what？（）
A
DML and SQL statement results that do not match between the capture and replay systems
B
When errors that occur in the capture system dont occur in the replay system
C
Top SQL statements
D
Infrastructure or system-configuration differences
E
Time-of-day differences between capture and replay systems
参考解析
解析：
暂无解析
相关考题：
(ii) evaluates the relative performance of the four depots as indicated by the analysis in the summary tableprepared in (i); (5 marks)
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?() A. the SQL text SQLB. the execution planC. the execution contextD. the execution frequencyE. the system change number (SCN)
View the Exhibit to examine the replay settings for replay parameters.What is the implication for setting the values for replay parameters?() A. The COMMIT order in the captured workload is preserved during replay.B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.
Which two statements about workload capture and replay operations are true?() A. The clients must be created manually on the test machines to perform more realistic testing.B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this?（）A. Database replayB. SQL Tuning AdvisorC. SQL Access AdvisorD. SQL Performance AnalyzerE. Automatic Workload Repository compare reports
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?（）A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.B. Run the Automatic Workload Repository Monitor (ADDM).C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
What is the purpose of configuring Workload Manager on a server used for development and QA？（） A、To experiment with shared processor poolsB、To isolate physical hardware between workloadsC、To control resource utilization on an application-by-application basisD、To leverage Workload Partition Manager for performance trending and analysis
Which three statements about performance analysis by SQL Performance Analyzer are true? （）A、It detects changes in SQL execution plans.B、It produces results that can be used to create the SQL plan baseline.C、The importance of SQL statements is based on the size of the objects accessed.D、It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.E、It shows only the overall impact on workload and not the net SQL impact on workload.
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
In a Database Replay workload capture， what client request information is gathered？（）A、 SQL textB、 Shared server requests （Oracle MTS）C、 Bind variable valuesD、 Information about transactionsE、 Remote DESCRIBE and COMMIT operations
Which two prerequisites are needed for performing workload capture and replay？（）A、Close all sessions performing queries using database linksB、running the database in shared server modeC、The database on which the workload is replayed has to be a restore of the original database to a specific SCND、setting up the directory to capture the workload
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）A、Database replayB、SQL Tuning AdvisorC、SQL Access AdvisorD、SQL Performance AnalyzerE、Automatic Workload Repository compare reports
Performance divergence indicated in the Workload Replay report is most likely due to what？（） A、 DML and SQL statement results that do not match between the capture and replay systemsB、 When errors that occur in the capture system dont occur in the replay systemC、 Top SQL statementsD、 Infrastructure or system-configuration differencesE、 Time-of-day differences between capture and replay systems
Identify a performance impact when using the Performance Schema.（）A、There is no impact on performanceB、The overhead depends on the settings of the Performance SchemaC、There is an overhead for querying the Performance Schema but not for having it enabledD、There is a constant overhead regardless of settings and workload
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）A、the SQL text SQLB、the execution planC、the execution contextD、the execution frequencyE、the system change number (SCN)
单选题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？（）Aby using the SQL access advisorBby using the Automatic Workload Repository reportCby running the Automatic Database Diagnostic Monitor （ADDM）Dby using the Automatic Workload Repository Compare Period reportEby analyzing the output of the V$ACTIVE_SESSION_HISTORY view
单选题Identify a performance impact when using the Performance Schema.（）AThere is no impact on performanceBThe overhead depends on the settings of the Performance SchemaCThere is an overhead for querying the Performance Schema but not for having it enabledDThere is a constant overhead regardless of settings and workload
单选题What is the purpose of configuring Workload Manager on a server used for development and QA?（）ATo experiment with shared processor poolsBTo isolate physical hardware between workloadsCTo control resource utilization on an application-by-application basisDTo leverage Workload Partition Manager for performance trending and analysis
多选题Which of these recommendations should be followed before capturing a workload？（）AMake sure your replay database has the same structure as the capture database， except without data.BMake sure the replay and capture databases are similar in data content.CPerform a clean shutdown and restart of the capture database before beginning a workload capture.DStart the capture database in UNRESTRICTED mode， then start the capture.EDefine inclusion and exclusion filters.
多选题Which two prerequisites are needed for performing workload capture and replay？（）AClose all sessions performing queries using database linksBrunning the database in shared server modeCThe database on which the workload is replayed has to be a restore of the original database to a specific SCNDsetting up the directory to capture the workload
多选题You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process？（）Athe SQL textBthe execution planCthe execution contextDthe execution frequencyEthe system change number （SCN）
单选题Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment， you performed the workload capture on the production database to record the peak workload. You set up the test RAC databaseand want to replay the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload： 1） Preprocess the captured workload. 2） Restart the database in RESTRICTED mode. 3） Set up the Replay Clients. 4） Restore the test database to the point when the capture started. 5） Remap connections. Arrange the steps required in the correct sequence to accomplish this task on the test machine.（）A 1，4，5，3 （2 is not required.）B 1，4，3，5 （2 is not required.）C 1，2，4，5 （3 is not required.）D 2，1，5，3，4 E 1，2，4，5，3
单选题Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）ADatabase replayBSQL Tuning AdvisorCSQL Access AdvisorDSQL Performance AnalyzerEAutomatic Workload Repository compare reports
多选题Which three statements about performance analysis by SQL Performance Analyzer are true? （）(Choose three.)AIt detects changes in SQL execution plans.BIt produces results that can be used to create the SQL plan baseline.CThe importance of SQL statements is based on the size of the objects accessed.DIt generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.EIt shows only the overall impact on workload and not the net SQL impact on workload.
多选题Which three statements about performance analysis by SQL Performance Analyzer are true? （）AIt detects changes in SQL execution plans.BIt produces results that can be used to create the SQL plan baseline.CThe importance of SQL statements is based on the size of the objects accessed.DIt generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.EIt shows only the overall impact on workload and not the net SQL impact on workload.
多选题Which two statements about workload capture and replay operations are true?（）AThe clients must be created manually on the test machines to perform more realistic testing.BRestart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.CRestart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.DThe application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
多选题In a Database Replay workload capture， what client request information is gathered？（）ASQL textBShared server requests （Oracle MTS）CBind variable valuesDInformation about transactionsERemote DESCRIBE and COMMIT operations