1z0-064 試験問題を無料オンラインアクセス

Examine the initialization parameters set for a database instance:

The database supports an OLTP workload. Applications connect to the instance using shared server connections and perform small, random I/Os. All the data files are on the same disk. You notice free buffer wait events for sessions in the database instance.
To solve the problem, you increase the size of the buffer cache. But after some time, you notice sessions waiting again on free buffer waits.
What will you recommend to alleviate the issue? (Choose the best answer.)

• A.Run the I/O calibration tool.
• B.Configure dedicated server connections for the applications.
• C.Configure the database instance to make asynchronous I/O available to DBWR.
• D.Spread the data files over multiple disks, controllers, and I/O buses to ensure that there are no hotspots in the I/O subsystem.

Examine the query and its output:


How would you investigate the cause of three entries of identical SQL statements by using dynamic performance views?

• A.Query V$SQL to find out if any invalidations or reloads occurred for this SQL statement.
• B.Query V$SQLAREA to find out if the SQL statement is bind aware.
• C.Query V$SQL_SHARED_CURSOR to identify the reason that a child cursor cannot be shared.
• D.Query V$SQLAREA to find out if multiple sessions executed this SQL statement, which resulted in multiple entries in V$SQL.

Which two statements are true about viewing the details of Real-Time Database Operations? (Choose two.)

• A.Oracle Enterprise Manager Database Express can be used to view running database operations.
• B.Oracle Enterprise Manager Cloud Control can be used to view running database operations.
• C.SQL Developer can be used to view running database operations.
• D.When the SQL statement that is being monitored is executing, V$SQL_MONITOR is refreshed once every minute. After the execution ends, the monitoring information in V$SQL_MONITOR is deleted immediately.
• E.In V$SQL_MONITOR monitoring, statistics are cumulative over several executions of the SQL statement that is being monitored in a session.

Your database supports multiple applications. The applications run on the middle tier and use connection for connecting to the database.
You notice that the sessions created by the applications are competing for resources. You want to statistically measure the workload and set priorities.
What action must you perform to achieve this?

• A.Create services for the applications and set a relative priority by assigning them to application users and using the DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE procedure to trace the services.
• B.Create services for the applications and set the relative priority of services within an instance by mapping the services directly to consumer groups.
• C.Create services for the applications and set a relative priority by assigning them to application users.
• D.Create services for the applications and set a relative priority by assigning them to application users and using the DBMS_MONITOR.SESSION_TRACE_ENABLE procedure to trace the services.

Your database supports an OLTP workload. You are planning to migrate database storage from file system storage to Automatic Storage Management (ASM). The applications supported by the database primarily perform small, random I/Os.
Which two statements are true regarding ASM striping in combination with RAID 0?

• A.It improves availability and reliability of data be ensuring that logical data corruptions are found and repaired.
• B.It helps in reducing network latency.
• C.It improves the performance of only write-intensive workloads.
• D.It allows you to evenly spread data over multiple disks.
• E.It provides higher I/O bandwidth.