Master the 1z0-054 Oracle Database 11g: Performance Tuning content and be ready for exam day success quickly with this Pass4sure 1z0-054 exam question. We guarantee it!We make it a reality and give you real 1z0-054 questions in our Oracle 1z0-054 braindumps.Latest 100% VALID Oracle 1z0-054 Exam Questions Dumps at below page. You can use our Oracle 1z0-054 braindumps and pass your exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-054 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q81. You want to capture the performance statistics during a system test that is scheduled for the weekend. Which action would help you to automatically capture the performance statistics?
A. Creating SQL tuning sets
B. Setting up SQL plan baselines
C. Configuring new services for the database
D. Creating Automatic Workload repository (AWR) baseline templates
Q82. You are hired by ABC Pvt Ltd., and assigned the task of managing one of its development databases. The company has recently upgraded this database to Oracle Database 11g from Oracle Database 10g.
You noticed that SGA is undersized as shown in Exhibit 1.
To investigate further, you checked the related parameters as shown in Exhibit 2.
You executed the following command to solve the problem:
ALTER SYSTEM SET MEMORY_TARGET=800M;
What would happen?
A. The implementation of AMM fails because the MEMORY_MAX_TARGET parameter is not set.
B. It implements AMM by setting MEMORY_TARGET and
MEMORY_MAX_TARGET parameters to 800M.
C. It implements Automatic Memory Management (AMM) by setting MEMORY_TARGET to 768M and the MEMORY_MAX_TARGET parameter to 800M.
D. The implementation of AMM fails because the MEMORY_TARGET parameter cannot be set to a value less than the sum of the current PGA_AGGRAGATE_TARGET and SGA_MAX_SIZE values.
Q83. Examine the initialization parameter values for the instance given below:
NAME TYPE VALUE
------------------------------------ ----------- ------------------
optimizer_capture_sql_plan_baselines boolean FALSE
optimizer_dynamic_sampling integer 2
optimizer_features_enable string 126.96.36.199
optimizer_index_caching integer 0
optimizer_index_cost_adj integer 100
optimizer_mode string ALL_ROWS
db_file_multiblock_read_count integer 64
The index created on the column used in the WHERE clause of the query. You notice that the query is not using the index. Instead of an index scan, a full table scan is used. View the Exhibit and examine the autotrace output for a query.
What could be the reason for it? (Choose all that apply.)
A. The OPTIMIZER_INDEX_COST_ADJ initialization parameter has a low value.
B. The DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter has a low value.
C. The statistics for the table and all the indexes associated with the table are not current.
D. The table has less than DB_FILE_MULTIBLOCK_READ_COUNT blocks under the high-water mark.
Q84. Which two statements are true about the database buffer cache? (Choose two.)
A. A buffer can be written to by many processes at the same time.
B. A buffer containing a block that is identical to the block on disk is called free buffer.
C. A buffer containing a block that is being accessed by a process is called dirty buffer.
D. A buffer available to be overwritten with a different database block at any time is called a dirty buffer.
E. A buffer can contain a different version of a block that is available in a different buffer of the same cache.
Q85. View the Exhibit that shows your investigation of performance degradation in your database. You also know that there are a few tablespaces using automatic segment-space management in the database.
What could be the problem?
A. There are excessive disk sorts.
B. There are excessive memory sorts.
C. There is a contention due to free list management.
D. The tablespace that contains the segments on which waits are occurring is full.
E. The server process is processing buffers at a rate that is faster than the rate at which the I/O system can return the buffers.
Q86. You identified poorly performing SQL statements that use bind variables. You want to examine the execution plans for the most recently executed statements for further diagnosis.
Which method would you recommend to view the execution plans?
A. SQL*Plus Autotrace
B. the dbms.xplan package
C. EXPLAIN PLAN for SQL statements
D. the SQL trace utility to generate trace files and read the formatted output using the tkprof utility
Q87. Which three statements are true about performance analysis by SQL Performance Analyzer? (Choose three.)
A. It detects changes in SQL execution plans.
B. It shows only the overall impact on workload.
C. It produces results that can be used to create the SQL plan baseline.
D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQL statements.
E. The importance of SQL statements to be analyzed is based on the size of the objects accessed.
Q88. You queried V$SYSTEM_EVENT in your online transaction processing (OLTP) environment to check the following wait events:
Event Total Seconds Total Average Wait
Name Waits Waiting Timeouts (in secs)
------------------------------ ------------ -------- ------------ ---------
direct path read temp 18.274 11.312 16.282 .619
direct path write temp 3.251 416 25 .127
Which step would be appropriate to improve the performance?
A. Increase the number of I/O slaves.
B. Increase the size of the Database Buffer Cache.
C. Increase the size of the Program Global Area (PGA).
D. Increase the number of database writer (DBWn) processes.
Q89. 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. configuring multiple DBWR processes
B. decreasing the size of the buffer cache
C. configuring I/O slaves for the DBWR process
D. configuring instances to make asynchronous I/O available to DBWR
E. spread data files over multiple disks, controllers, and I/O buses to ensure that there are no hotspots in the I/O subsystem
Q90. View the Exhibit and examine the output for the WRC command-line utility that you executed to estimate the number of replay clients.
Identify three prerequisites for completing the replay. (Choose three.)
A. The replay database should be in the RESTRICTED mode.
B. You need to start at least 21 replay clients on six CPUs to start the replay.
C. The replay directory must have all the replay files that have been preprocessed.
D. The user should be able to use the workload replay package and should have the DBA role.
E. The replay options for think_time_scale and connect_time_scale must be set to 100 each.