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

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

Oracle Database 11g: Performance Tuning

Question No: 91

You find that the OS utilization is over 40% in your database server. Examine the following set of performance monitoring-related activities:

  1. Investigate the operating system for network transfers, paging, and swapping.

  2. Check the SQL and the transactions submitting the SQL for optimal execution.

  3. Investigate the top SQL by CPU utilization.

  4. Consider rescheduling some work to off-peak hours.

  5. Check whether there are any nondatabase jobs consuming CPU time on the machine.

    What is the correct sequence in which the above activities should be performed to diagnose and reduce potential performance issues?

    A. 1,5,3,2,4

    B. 1,2,3,4,5

    C. 2,4,5,3,1

    D. 4,5,3,1,2

    Answer: A

    Question No: 92

    You work in an online transaction processing (OLTP) environment and users are experiencing slow response time on their queries. These users connect as FINANCE to run their application and run hundreds of sessions.

    Your investigation shows that there is lot of I/O contention happening on only one temporary tablespace and there is no load on other temporary tablespaces. View the Exhibit and examine the details. After some time you observed that the sort operations are running out of temporary space.

    What would be a long-term solution?

    Ensurepass 2018 PDF and VCE

    1. Configure the large pool if it is not done already.

    2. Change the temporary tablespace assigned to this user ID.

    3. Create and assign temporary tablespace group to this user ID.

    4. Increase the number of database writer (DBWn) processes ID.

    5. Make the bigger temporary tablespace the default temporary tablespace ID.

Answer: C

Question No: 93

You are working for a company that uses huge applications to manage its customer details. During your regular performance checks, you executed the following query:

SQLgt; show parameter shared_pool_reserved_size NAME TYPE VALUE

————— ———– ———

shared_pool_reserved_size big integer 6920601

SQLgt; SELECT free_space, used_space, request_misses, request_failures from V$SHARED_POOL_RESERVED;


—– —– ——- ——– 6469776 555528 0 113

You observed that REQUEST_FAILURES is 113 but not increasing, and also that REQUEST_MISSES is not increasing.

What would you interpret from this?

  1. The reserved pool is very large. Consider reducing the size of the shared pool.

  2. The reserved pool is large and has free space to satisfy requests. Consider reducing the size of the reserved pool.

  3. The reserved pool is very small and is not finding enough memory to satisfy requests. Increase the size of the shared pool.

  4. The reserved pool is very small and is not finding enough memory to satisfy requests. Increase the size of the reserved pool.

Answer: B

Question No: 94

You are managing an online transaction processing (OLTP) application database. Some users on the system are reporting degradation in the performance of SQL statements. To diagnose the problem, you want to identify the SQL statements that are expensive on system resources.What would you recommend to accomplish the task? (Choose all that apply.)

  1. running SQL Access Advisor

  2. running SQL Performance Analyzer

  3. querying the V$SQLSTATS and V$SQL_PLAN views to get the information

  4. creating an Automatic Workload Repository (AWR) report for the problematic period

Answer: C,D

Question No: 95

You are managing an online transaction processing (OLTP) system. The database is supporting a large number of applications using connection pools to connect to the database.Which method would you use for performance management?

  1. Service aggregation for action within application module

  2. Monitoring individual sessions by querying V$SESSION_LONGOPS

  3. Monitoring individual sessions in an application by querying V$SESSION

  4. Mapping the sessions for an application to one resource consumer group

Answer: A

Question No: 96

As a DBA, you notice that the response time of your database has degraded. Which two pieces of tuning-related information can you examine in the alert log to identify possible causes? (Choose two.)

  1. frequency of log switches

  2. frequency of block corruption errors

  3. concurrent parsing and buffer cache latch contention

  4. the amount of CPU time spent on database user-level calls

Answer: A,B

Question No: 97

Your database has the HR and Reporting applications. The HR application does most of the transactions on the database and the Reporting application does most of the batch processing operations.The Reporting application has more workload during nonpeak hours. Both the HR and Reporting applications run on the middle tier using connection pooling for connecting to database.You want to statistically measure the workload generated by both the applications and set priority for the workload generated by the applications. Which option would help you achieve this?

  1. Assigning individual sessions created by the applications to consumer groups and setting relative priority

  2. Assigning profiles to individual sessions created by the applications to set the relative priority for the resource usage

  3. Creating services for the applications and setting the relative priority of services within an instance by binding the services directly to consumer groups

  4. Creating services for the applications and assigning different profiles to the sessions created by the sessions to set the relative priority for the resource usage

Answer: C

Question No: 98

You are managing an online transaction processing (OLTP) system. Many users complain about the slow response time. You investigated and found that in the Top 5 events, direct path read accounts for 73.2% of the total wait time.Which two are the possible reasons for the high direct path read time? (Choose two.)

  1. The I/O subsystem is slow.

  2. The SQL statements are using high CPU.

  3. The SQL statement has a long parsing time.

  4. The SQL statements are performing a large number of physical and logical reads.

Answer: A,D

Question No: 99

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

  1. Cursor cache

  2. Stored outline

  3. SQL Tuning Set

  4. Automatic Workload Repository (AWR) snapshots

Answer: A,C

Question No: 100

Which two inferences are correct about the CPU time and the wait time that appear in the Automatic Workload Repository AWR and Statspack reports in the Top 5 Event section? (Choose two.)

  1. Adding CPUs to systems showing increased wait time due to contention will improve response time.

  2. Systems where the CPU time is dominant in comparison to the wait time have optimal response time.

  3. Increase in wait time when the CPU time increases or remains the same indicates an increase in the load on the system.

  4. Systems where the proportion of CPU time does not decrease significantly with increasing load would most likely benefit from adding CPUs.

  5. The appearance of CPU time together with wait time in the Top 5 Event section of the AWRreport of a system always indicates high contention.

Answer: C,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 *