Free Oracle 1z1-064 Exam Dumps Questions & Answers


Exam Code/Number:	1z1-064Join the discussion
Exam Name:	Oracle Database 12c: Performance Management and Tuning
Certification:	Oracle
Free Question Number:	120
Publish Date:	Aug 10, 2026
# of views:	2476
Rating 100%

Page: 1 / 24
Total 120 questions

Question 1

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

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

Question 2

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

Question 3

A parallel SQL statement is taking a long time to execute. You want to verify how the server processes are dividing work.
How should you determine this?

A.by using services
B.by using SQL Tuning Advisor
C.by using ASH
D.by using Real-Time SQL monitoring
E.by using Real-Time ADDM

Question 4

You are administering a database that supports multiple applications, which make dedicated connections to the database instance by using different services.
You execute the command to enable tracing of the ORCL1 service:

Which two statements are true? (Choose two.)

A.SQL trace is not enabled for the service because a module name is not specified.
B.A single trace file is generated for all sessions mapped to the ORCL1 service.
C.A SQL trace file is generated for each session that maps to the ORCL1 service.
D.SQL trace is enabled for all modules and actions for sessions mapped to the ORCL1 service.
E.A SQL trace file is generated for each of the modules using the ORCL1 service.

Question 5

Examine this list of possible tasks:
1. Ensure that STATISTICS_LEVEL is set to TYPICAL or ALL.
2. Ensure that TIMED_STATISTICS is set to TRUE.
3. Set MAX_DUMP_FILE_SIZE to UNLIMITED and DIAGNOSTIC_DEST to an appropriate destination.
4. Ensure that SQL_TRACE is set to TRUE.
5. Enable tracing at the database instance level by using the DBMS_MONITOR.DATABASE_TRACE_ENABLE procedure.
6. Enable tracing in the required session by using the DBMS_SESSION.SET_SQL_TRACE procedure.
7. Run TKPROF with the EXPLAIN parameter on the output trace file.
8. Run the trcsess utility on the output trace files, and then run TKPROF on the output of the trcsess utility.
Select the minimum tasks to perform, in the correct order, to generate both a formatted trace file with timing information and an explain plan for each SQL statement for all sessions. (Choose the best answer.)

A.2, 4, 5, 8
B.1, 3, 6, 7
C.1, 2, 4, 8
D.1, 2, 5, 8
E.1, 3, 4, 5, 6, 7