1Z0-054 無料問題集「Oracle Database 11g: Performance Tuning」
View the Exhibit and examine the Load Profile from the AWR report of a test database.The application must process an average of 10,000 very small transactions per day. The bulk of the processing activity is for DML operations with minimal to nil query processing.Which two statements are correct about the values of the Physical reads events? (Choose two.)
正解：C、D
解答を投票する
Your database has the ACCTG service configured for an accounting application running on a middle tier. These service is used by the middle-tier applications to connect to the database by using connection pools. The application has three modules LEDGER, ACCOUNTS, and BILLING. You asked the developers to invoke the DBMS_APPLICATION_INFO.SET_MODULE procedure to set the module name and action in the code for the application. You enabled tracing at the service level by executing the following command: SQL> exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE('ACCTG'); You want to consolidate the trace output from the trace files created based on module. Which is the appropriate solution for this?
正解：D
解答を投票する
You work in an online transaction processing (OLTP) environment and users are experiencing slow response time on their queries. These users connect as FINANCE to run their application and run hundreds of sessions. Your investigation shows that there is lot of I/O contention happening on only one temporary tablespace and there is no load on other temporary tablespaces. View the Exhibit and examine the details. After some time you observed that sort operations are running out of temporary space.
What would be a long-term solution?
What would be a long-term solution?
正解：A
解答を投票する
You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently, whereas other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command at regular intervals: SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH','SALES',GRANULARITY=>'AUTO');You need statistics to be collected more quickly. How do you achieve this?
正解：D
解答を投票する
The OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter is set to TRUE for a 24x7
database instance. The space consumption has significantly increased by the automatically
captured plan baselines. You are suggested to run the following block:
BEGIN
dbms_spm.configure('SPACE_BUDGET_PERCENT', 30);
END;
After a few weeks of work, you observe warnings on exceeding space usage by SQL Management
Base (SMB) in alert log file. Which two actions can be solutions for this? (Choose two.)
database instance. The space consumption has significantly increased by the automatically
captured plan baselines. You are suggested to run the following block:
BEGIN
dbms_spm.configure('SPACE_BUDGET_PERCENT', 30);
END;
After a few weeks of work, you observe warnings on exceeding space usage by SQL Management
Base (SMB) in alert log file. Which two actions can be solutions for this? (Choose two.)
正解：A、B
解答を投票する
Examine the values for the following initialization parameters:
STATISTICS_LEVEL = TYPICAL
TIMED_STATISTICS = true
You are managing an online transaction processing (OLTP) system. Application users notice that
some queries have poor response time. You determine that queries from session ID 27, serial
number 60, for user OE are heavy-resource consumers.
To investigate further, you enabled tracing for the session by executing the following command:
SQL> EXECUTE dbms_system.set_sql_trace_in_session (27, 60, true);
Which statement is true?
STATISTICS_LEVEL = TYPICAL
TIMED_STATISTICS = true
You are managing an online transaction processing (OLTP) system. Application users notice that
some queries have poor response time. You determine that queries from session ID 27, serial
number 60, for user OE are heavy-resource consumers.
To investigate further, you enabled tracing for the session by executing the following command:
SQL> EXECUTE dbms_system.set_sql_trace_in_session (27, 60, true);
Which statement is true?
正解：B
解答を投票する
The database application developers are planning to make some major schema changes such as creating new indexes and materialized views. They want to check the net impact of these changes on the workload performance. This activity has to be performed in the production database, so they want only the query part of the data manipulation language (DML) statements to be executed so that the side effects to the database or user data can be prevented. What should they use to achieve this?
正解：A
解答を投票する