1Z0-054 Real Exam Questions

You find that in the Top 5 Timed Events section of the Automatic Workload Repository (AWR) report, the wait event buffer busy waits shows significantly high values.The database uses only non-ASSM locally managed tablespaces.On further investigation, you find that the contention is on data blocks. Which option would you consider first to decrease the wait event values on a long-term basis?

Your company wants to migrate a single instance Oracle 11g Release 1 database to a RAC environment. The database supports middle-tier applications using connection pooling for connecting to database. Being a part of the performance management team, you want to test the performance of the SQL statements and the peak workload of the applications in the new environment before upgrading the production system. Given below are some of the steps in random order to accomplish the task: 1) Capture the real workload on the existing system. 2) Create a SQL Tuning Set (STS) for the statements executed by the application. 3) Transport STS on the test environment and use SQL Tuning Advisor to compare the before and after performance. 4) Replay the workload on the test environment. 5) Analyze the divergence after replay. 6) Use Automatic Workload Repository (AWR) to capture the information for top SQL on the existing system. 7) Transport STS on the test environment and use SQL Performance Analyzer to compare the before and after performance. Identify the correct steps required to perform the test.

Which is the correct description of SQL profiling while using SQL Tuning Advisor?

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?

View the Exhibit and examine the content of the V$SGA_RESIZE_OPS view. The Shared Pool was shrunk when the Default Buffer Cache required more memory. Why did the Java Pool not shrink when the Default Buffer Cache grew?