Free Oracle 1z1-064 Exam Dumps Questions & Answers

In which three scenarios can you use ADDM to get recommendations?

• A.to determine whether SQL profiling needs to be done to tune SQL statements transparently without requiring any change to the application code
• B.to analyze problems in an unresponsive database, which requires a database restart
• C.to determine if the SGA_TARGET parameter value needs to be changed when your database is configured for Automatic Shared Memory Management and additional physical memory is added to the database server
• D.to determine the segments on which waits are occurring when the database has a high number of buffer busy waits
• E.to determine the SQL statements that are performing poorly before you launch the SQL Tuning Advisor to tune them

You are administering a database that supports a mixed workload. The CURSOR_SHARING parameter is set to the default value. While analyzing the latest Automatic Workload Repository (AWR) report, you find a large number of cursor: pin S wait on X, cursor: pin X wait on S, and library cache mutex waits in the Top 10 foreground events section. Examine the Instance Efficiency Percentages section in the AWR report:

Which three statements are true in this scenario? (Choose three.)

• A.Sessions are waiting for mutexes in exclusive mode on cursors but other sessions are holding the mutexes in share mode.
• B.The buffers required by queries are not found in the buffer cache, thereby increasing expensive disk I/O.
• C.Cursors are not getting shared, resulting in a large number of hard parses.
• D.The CPU is spending more time in finding cursors in the library cache.
• E.Sessions are waiting for mutexes in share mode on cursors but other sessions are holding the mutexes in exclusive mode.

Which two statements are true about ADDM? (Choose two.)

• A.It first identifies the performance symptoms, and then refines them to reach the root cause with the singular aim of reducing the DB CPU metric.
• B.It documents only those components and wait classes that are significantly impacting the performance of the database.
• C.It analyzes the performance of a database instance based on the time period covered by the most recent AWR snapshot, and generates recommendations based on hard-coded criteria.
• D.It can analyze performance issues that occurred in past events provided they fall within the AWR retention period.
• E.ADDM resource utilization and cost of analysis depends on the actual load on the database and the number of performance problems analyzed.

Examine the output of the query executed to diagnose the reason for performance degradation of queries:

Which three factors will you investigate further to identify the cause of the performance degradation? (Choose three.)

• A.Check the number of chained or migrated rows.
• B.Check the number of disk sorts.
• C.Check the indexes on the tables used in queries for clustering factor.
• D.Check the size of the temporary tablespace for sorting operations.
• E.Check for the causes of the full table scans.

Which two statements are true about DB time in V$SYS_TIME_MODEL? (Choose two.)

• A.DB time is always greater than or equal to the DB CPU time.
• B.DB time cannot exceed the maximum number of concurrent sessions multiplied by the actual elapsed time for each session.
• C.Reducing DB time allows a database instance to support more user requests by using the same resources.
• D.DB time includes the time spent on client processes and background processes.
• E.DB time cannot exceed the total elapsed time (walk clock time) since the database instance started.