Everything You Need to Pass: oracle 1Z0_054

You are working on a development database that was upgraded to Oracle Database 11g from Oracle Database 9i. An ADDM finding in this database says that the shared pool is inadequately sized, as shown in the Exhibit.You diagnosed that this is due to different kinds of workloads and this occurs only during peak hours. You tried to resize this by shrinking the database buffer cache but that caused inadequate buffer cache problems. The following are the related parameter settings:SQL> show parameter sga -NAME TYPE VALUE ------------------------------- --------------- ----------------- lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 300M sga_target big integer 0SQL> show parameter target -NAME TYPE VALUE ------------------------------- --------------- -----------------.....fast_start_mttr_target integer 0memory_max_target big integer 0memory_target big integer 0pga_aggregate_target big integer 100Msga_target big integer 0You want to balance the memory between the System Global Area (SGA) components within SGA without affecting the size of the Program Global Area (PGA).Which action would solve this problem?

You observed that some of the queries are performing poorly on the SALES_RECORDS table in your database.On further investigation, you find that at the end of each day the contents of the SALES_RECORDS table are transferred to the SALES table and deleted from theSALES_RECORDS table. The deleted operations cause the table to be sparsely populated. You decided to use the ALTER TABLE...SHRINK SPACE COMPACT command to shrink the table. Why would you choose this method? (Choose all that apply.)

View the Exhibit and examine a portion of the output obtained from the following query:SQL> SELECT * FROM v$sys_time_model;Select three correct interpretations of the time model statistics. (Choose three.)

A batch workload that historically completed in the maintenance window between 10:00 PM and midnight is currently showing poor performance and completing at2 AM. To help in the diagnosis of the performance degradation, the senior DBA in your organization asks you to execute the awrddrpt.sql script to produce aCompare Periods report. Which two statements are true about the report produced by this script? (Choose two.)

You plan to use adaptive thresholds as part of the performance tuning activity. You decide to increase the window size of the default moving window baseline for all metric observations and comparisons in your database. The following error occurs when you try to increase the window size through Enterprise Manager:Failed to commit: ORA-13541: system moving window baseline size (1296000) greater than retention (1036800) ORA-06512: at"SYS.DBMS_WORKLOAD_REPOSITORY", line 601 ORA-06512: at line 2 Which action would allow you to perform the preceding task successfully?

After running SQL Performance Analyzer (SPA), you observe a few regressed SQL statements in the SPA output. Identify the two actions that you would suggest for these regressed SQL statements. (Choose two.)