[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-054 Dumps with VCE and PDF 21-30

2018 Jan Oracle Official New Released 1z0-054
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Performance Tuning

Question No: 21

View the Exhibit and analyze a portion of the Active Session History (ASH) report marked with a red rectangle.Which two can be inferred from the output? (Choose two.)

Ensurepass 2018 PDF and VCE

  1. increase in the number of active sessions

  2. unable to grow the database buffer cache as per demand

  3. increase in number of COMMITS and ROLLBACKS per second

  4. increase in the number of processes waiting for the buffer busy wait event

Answer: A,D

Question No: 22

Which two symptoms related to the database buffer cache together indicate that there are many full table scans happening? (Choose two.)

  1. too many buffer busy waits

  2. very low buffer cache-hit ratio

  3. very high buffer cache-hit ratio

  4. many waits on the db file scattered read event

Answer: B,D

Question No: 23

Your database supports many applications running on the middle tier. Many applications users create jobs for which you want to statistically measure workload as a part of performance management.What would you do to accomplish the task?

  1. Assign resource consumer group to jobs while creating the jobs.

  2. Create services for the applications and create jobs by using the DBMS_JOBS PL/SQL package.

  3. Query v$SESSION to gather statistics of the individual sessions for the workload created by the jobs.

  4. Create services for the applications, create job class associated with the service, and then create jobs by using the job classes.

Answer: D

Question No: 24

View the Exhibit that shows your investigation on degraded performance.What would you do? (Choose all that apply.)

Ensurepass 2018 PDF and VCE

  1. Shrink the temporary segment.

  2. Keep the large tables in the KEEP pool.

  3. Use free list groups wherever applicable.

  4. Increase the value set to the PGA_AGGREGATE_TARGET parameter.

  5. Switch the segments to Automatic Segment Space Management (ASSM).

Answer: C,E

Question No: 25

You are working as a DBA for a DSS system, on which applications primarily perform large sequential I/Os. The company wants to upgrade the storage used by the database to faster hard disks. What other factors would you consider before giving the go-ahead for the new hard disks? (Choose all that apply.)

  1. the sizing of PGA to meet the faster data access

  2. the sizing of buffer cache to meet the faster data access

  3. the time it takes for a submitted I/O request to be serviced by the storage

  4. the capacity of the I/O channel that connects the server to the storage array

Answer: C,D

Question No: 26

The OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter is set to TRUE for a 24×7 database instance. The space consumption has significantly increased by the automaticallycaptured plan baselines. You are suggested to run the following block:


dbms_spm.configure(#39;SPACE_BUDGET_PERCENT#39;, 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.)

  1. increasing the AWR retention period

  2. purging the older SQL management objects

  3. increasing the size of the SYSTEM tablespace

  4. increasing the size of the SYSAUX tablespace

Answer: B,D

Question No: 27

Identify the type of recommendation that can automatically be implemented by the Automatic Tuning Advisor as part of automatic SQL tuning task?

  1. recommendation for SQL profiles

  2. recommendation about effective indexing

  3. recommendation about stale or no statistics

  4. recommendation about the structure of SQL statements

Answer: A

Question No: 28

A user in a session executed the following SQL statement to set the optimizer mode: ALTER SESSION SET OPTIMIZER_MODE = ALL_ROWS

What impact would it have on the goal of the optimizer for that session? (Choose all that apply.)

  1. Statement level OPTIMIZER_MODE hints take precedence over the session-level setting.

  2. The OPTIMIZER_MODE parameter set at instance level takes precedence over the session-level value.

  3. The optimizer uses a cost-based approach, regardless of the presence of statistics; it optimizes with a goal of best response time.

  4. The optimizer uses a cost-based approach for all SQL statements in the session, regardless of the presence of statistics; it optimizes with a goal of best throughput.

Answer: A,D

Question No: 29

View the Exhibit and examine the content of the V$SGA_RESIZE_OPS view.

Ensurepass 2018 PDF and VCE

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?

  1. because it is not an auto-tuned component

  2. because it uses memory available outside the total SGA size

  3. because it always requires three granules and cannot be reduced

  4. because it has less free memory than the Database Buffer Cache

  5. because it cannot be shrunk below the value set to the JAVA_POOL_SIZE parameter

Answer: E

Question No: 30

You work as a consultant DBA for various clients. A performance issue in one of the online transaction processing (OLTP) systems is reported to you and you received the Automatic Workload Repository (AWR) report generated in the database. The main sections of the AWR report are shown in the Exhibits.

View the Exhibit named DBTIME and note % DB Time.

Ensurepass 2018 PDF and VCE

View the Exhibit named TIMEMODEL and note what has contributed to % DB Time.

Ensurepass 2018 PDF and VCE

View the Exhibit named EFFICIENCY and examine the various percentages shown.

Ensurepass 2018 PDF and VCE

Identify the option that has the correct answers for the questions given below:

  1. Which factor indicates the main problem?

  2. What is the main problem?

  3. What solution would you recommend?

  1. 1) The Exhibit DBTIME shows that the DB CPU event consumed very high % DB Time.

    1. The CPU is very slow.

    2. Increase the number of processors.

  2. 1) hard parse elapsed time has the majority time in parse time elapsed, which is shown in the TIMEMODEL Exhibit.

    1. This is due to inadequate Database Buffer Cache.

    2. Increase the size of database buffer cache.

  3. 1) sql execute elapsed time and parse time elapsed are consuming very high % DB Time in the TIMEMODEL Exhibit.

    1. There are too many soft parses.

    2. Investigate the HOLD_CURSOR parameter setting in the application and set it appropriately.

  4. 1) % Non-Parse CPU is low and Soft Parse % is also low in the EFFICIENCY Exhibit. This shows that very few statements are found in the cache.

  1. There are too many hard parses.

  2. Investigate the CURSOR_SHARING parameter setting and set it appropriately.

Answer: D

100% Free Download!
Download Free Demo:1z0-054 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 1z0-054 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 EnsurePass IT Certification PDF and VCE

Leave a Comment


Your email address will not be published. Required fields are marked *