Free Oracle 1Z0-054 Exam Dumps Questions & Answers

You generate an AWR Compare Periods Report for two consecutive time periods as a routine activity to monitor your database performance.View the Exhibit and examine the partial details of the Time Model Statistics generated in the report.Which two statements give a correct inference based on the DB Time and DB CPU in the Time Model Statistics? (Choose two.)

• A.More of DB Time was consumed by background processes in the first time period.
• B.More transactions were processed in the first time period based on the DB Time values.
• C.A change to the database configuration reduced the % DB time for transactions.
• D.A reduction in Hard Parse activity resulted in a reduction of DB CPU Time (in seconds).
• E.More CPU time was used for background processes in the first time period.

You are working on an online transaction processing (OLTP) database that runs on a machine having multiple CPUs. The database uses normal file system storage. Examine the following initialization parameters and their respective values for the instance: NAME TYPE VALUE
dbwr_io_slaves integer 0 db_writer_processes integer 1 filesystemio_options string NONE disk_asynch_io boolean TRUE The applications perform small, random I/Os in which each foreground process reads a data block into the buffer cache for updates and the changed blocks are written in batches by the DBWR process. You noticed free buffer waits events for your database. To solve the problem, you increased the size of the buffer cache. But after some time, you notice the same event again.Which three possible actions would you recommend? (Choose three.)

• A.spread data files over multiple disks, controllers, and I/O buses to ensure that there are no hotspots in the I/O subsystem
• B.configuring multiple DBWR processes
• C.configuring I/O slaves for the DBWR process
• D.decreasing the size of the buffer cache
• E.configuring instances to make asynchronous I/O available to DBWR

You work as a database administrator to manage an online transaction processing (OLTP)
system.The application code was recently tuned for optimum performance and users
acknowledged the performance improvement. However, the users are now again complaining that
the application response time has gone down considerably.
You used a few queries to investigate the problem and a couple of important queries are shown in
the Exhibit. View the Exhibit and analyze the output shown.
Which actions would improve the performance? (Choose all that apply.)

• A.decreasing the number of database writers
• B.decreasing the value set to the FAST_START_MTTR_TARGET parameter
• C.increasing the size of the database buffer cache
• D.increasing the number database writers
• E.decreasing the size of the database buffer cache

While configuring the snapshot data capture for your database, you have specified the snapshot level setting as 6.Which statistics would be captured by the Statspack report? (Choose all that apply.)

• A.segment-level statistics
• B.parent and child latches
• C.resource limit
• D.optimizer execution plans
• E.memory statistics

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 ORA06512: at line 2 Which action would allow you to perform the preceding task successfully?

• A.increasing the undo retention period for the database instance
• B.increasing the retention period for SQL Management Base
• C.increasing the Automatic Workload Repository (AWR) retention period
• D.increasing the flashback retention period