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

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-054
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-054.html

Oracle Database 11g: Performance Tuning

Question No: 31

You identified poorly performing SQL by analyzing the V$SQL and V$SQLSTATS views. You want to investigate the plans for these SQL statements.Which two methods can you use to pull out the execution plan from the library cache for the already executed SQL? (Choose two.)

  1. Query V$SQL_PLAN to view the execution plan.

  2. Query DBA_HIST_SQL_PLAN to view the execution plan.

  3. Copy and paste the SQL text from the V$SQL view and use EXPLAIN PLAN to generate theexecution plan.

  4. Use the dbms_xplan.display_cursor function with the SQL ID and child number to generate the execution plan.

Answer: A,D

Question No: 32

You observed very low cache-hit ratio in your database as shown below: SQLgt; SELECT (1-((phy.value-phyd.value) / (cur.value con.value))) * 100 2 quot;Cache Hit ratioquot;

3 FROM v$sysstat cur, v$sysstat con, v$sysstat phy, v$sysstat phyd 4 WHERE cur.name = #39;db block gets#39;

5 AND con.name = #39;consistent gets#39; 6 AND phy.name = #39;physical reads#39;

7 AND phyd.name = #39;physical reads direct#39;; Cache Hit Ratio

——– 68.43

After further investigation, you decided to increase the database buffer cache size. You are using the

Buffer Cache Advisor to check the appropriate size for the buffer cache. View the Exhibit and examine the graph shown by the advisory.

What can you infer from the graph?

Ensurepass 2018 PDF and VCE

  1. The buffer cache size can be set to 12 MB for optimal performance.

  2. The buffer cache size can be set to more than 16 MB to get more benefit.

  3. The buffer cache size can be set to more than 16 MB but there would be no benefit from it.

  4. The buffer cache size cannot be set to more than 16 MB because the SGA_MAX_SIZE value does not allow that.

Answer: B

Question No: 33

Examine the output of the following query:

SQLgt; SELECT c.name,a.addr,a.gets,a.misses,a.sleeps, 2 a.immediate_gets,a.immediate_misses,b.pid

  1. FROM v$latch a, v$latchholder b, v$latchname c

  2. WHERE a.addr = b.laddr( ) and a.latch# = c.latch#

  3. AND c.name LIKE #39;amp;latch_name%#39; ORDER BY a.latch#;

LATCH NAME ADDR GETS MISSES SLEEPS IMMEDIATE_GETS IMMEDIATE_MISSES

—— —- —- —- — ——- ——– shared pool 20016544 8520540 14112 3137 0 0

Which two conclusions can you draw from this? (Choose two.)

  1. The latch was requested in no wait mode.

  2. The latch was requested in willing-to-wait mode.

  3. The shared pool operations to allocate and free memory in it caused the misses.

  4. Automatic Memory Management is not enabled because the IMMEDIATE_GETS and IMMEDIATE_MISSES columns have zero in them.

Answer: B,C

Question No: 34

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?

  1. SQL*Plus Autotrace

  2. the dbms.xplan package

  3. EXPLAIN PLAN for SQL statements

  4. the SQL trace utility to generate trace files and read the formatted output using the tkprof utility

Answer: B

Question No: 35

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 What do these wait events indicate?

  1. The DBWn processes are not creating free buffers fast enough.

  2. The buffer cache is too small and block replacement is excessive.

  3. The aggressive checkpointing policy is causing too many writes to disk.

  4. The work areas are too large to fit in memory and are, therefore, written to disk.

Answer: D

Question No: 36

You observed in your database that the queries formerly executed in 5 seconds now take longer time.View the Exhibit and analyze the output of the query that you executed to find the problem.Which is the primary concern?

Ensurepass 2018 PDF and VCE

  1. the number of disk sorts

  2. the number of full table scans

  3. the number of chained and migrated rows

  4. the number of rows fetched based on rowid

Answer: C

Question No: 37

View the Exhibit and examine the query based on the DBA_THRESHOLDS view and its partial output :

Which observation about the output is correct?

Ensurepass 2018 PDF and VCE

  1. Logons Per Sec triggers an alert when the number of users logging on in an interval of one second is equal to or greater than 100.

  2. Blocked User Session Count triggers an alert based on the

    ELAPSED_TIME_PER_CALL and DB_TIME_WAITING metrics collection per minute.

  3. Database Time Spent Waiting(%) triggers an alert when more than 30% of the DB time per second for three consecutive seconds is spent on lock waits.

  4. Average Users Waiting Counts triggers an alert when the count is more than 30 for 3 consecutive 1 minute intervals and is related to the log file sync wait event.

Answer: D

Question No: 38

A batch workload that historically completed in the maintenance window between 10:00 PM and midnight is currently showing poor performance and completing at 2 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 a Compare Periods report. Which two statements are true about the report produced by this script? (Choose two.)

  1. It is refreshed automatically based on the moving window baseline.

  2. It compares details between any two selected time periods of the same duration.

  3. It normalizes the statistics by the amount of time spent on the database for each time period.

  4. It compares details between two consecutive time periods of the same or different durations and is refreshed every 60 minutes.

Answer: B,C

Question No: 39

View Exhibit1 and examine a portion of Active Session History(ASH) report.

Ensurepass 2018 PDF and VCE

View Exhibit2 to examine the tablespaces.

Ensurepass 2018 PDF and VCE

Which action would you suggest after analyzing the output?

  1. Increase the log buffer size.

  2. Rebuild indexes on SPCT table.

  3. Decreasing the number of free lists in segment SPCT.

  4. Move SPCT table to a different tablespace that is locally managed with automatic segment space management.

Answer: D

Question No: 40

View the Exhibit and examine a portion of the output obtained from the following query:

Ensurepass 2018 PDF and VCE

SQLgt; SELECT * FROM v$sys_time_model;

Select three correct interpretations of the time model statistics. (Choose three.)

  1. DB time includes the wait time of all the nonidle and idle user sessions.

  2. SQL execute elapsed time includes the time spent in performing fetches of query results.

  3. DB CPU includes the CPU time spent on database user-level calls and background CPU time.

  4. SQL execute elapsed time includes components of the hard parse elapsed time like bind elapsed time.

  5. DB time includes the connection management call elapsed time excluding the background process time.

Answer: B,D,E

100% Ensurepass Free Download!
Download Free Demo:1z0-054 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-054 Dumps

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

Leave a Reply

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