Pass with professional 1z1-064 actual quiz materials

For your database some users complain about not being able to execute transactions. Upon investigation, you find that the problem is caused by some users performing long-running transactions that consume huge amounts of space in the UNDO tablespace.
You want to control the usage of the UNDO tablespace only for these user sessions.
How would you avoid the issue from repeating in future? (Choose the best answer.)

• A. Create external roles to restrict the usage of the UNDO tablespace and assign them to the users.
• B. Set the threshold for UNDO tablespace usage for the users.
• C. Create a profile for the users with the LOGICAL_READS_PER_SESSION and LOGICAL_READS_PER_CALL limits defined.
• D. Implement a Database Resource Manager plan by mapping the users to a resource consumer group with limits defined for UNDO tablespace usage.

To diagnose the performance degradation of your production database, you execute these queries:



Segment space management is manual for some of the tablespaces.
What can be the reason for the performance degradation?

• A. Contention is caused by freelist management.
• B. The buffer cache is undersized.
• C. The database writer (DBWR) process is processing buffers at a rate that is faster than the rate at which the I/O system can return the buffers.
• D. PGA is undersized
• E. There are too many disk sort operations.

You want to enable the Database Smart Flash Cache feature on your database. For this purpose, you configure two flash devices: /dev/sdj and /dev/sdk, with sizes of 64 GB and 32 GB, respectively.
Examine the parameters set for your database instance:

How would you make sure that the database uses these devices for Database Smart Flash Cache?

• A. by configuring the DB_FLASH_CACHE_SIZE parameter and making sure that all flash devices are of the same size
• B. by setting the value of the DB_FLASH_CACHE_SIZE parameter to 64G, 32G
• C. by setting the DB_FLASH_CACHE_SIZE parameter to 86G and the MEMORY_TARGET parameter to 112G
• D. by disabling Automatic Memory Management, setting SGA_TARGET to 96G, and setting the required memory that you want to set for SGA
• E. by setting the value of the DB_FLASH_CACHE_SIZE parameter to 8G

Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries.
You want to set a priority for the workload generated by the ERP application and optimize resource usage for them.
Which three objectives can be achieved by the Resource Manager? (Choose three.)

• A. limiting the amount of time that a session is idle and blocking other sessions of the ERP application
• B. creating two resource plans with resource limits defined for the workload generated by the applications and automatically changing resource plans based on the workload
• C. limiting the physical I/O performed by the sessions or users of the ERP application that are connected to the database
• D. allocating a lower percentage of CPU to sessions used by the REPORTING apnplication than to those used by the ERP application
• E. limiting the amount of undo generated by operations performed by sessions created by the ERP application

Which two actions can reduce library cache latch contention for an OLTP application that repeatedly executes queries containing a mix of literals and bind variables? (Choose two.)

• A. coding the application such that a frequently executed statement is parsed only once and executed repeatedly as required
• B. avoiding the granting of privileges on objects associated with cursors during peak load
• C. setting the CURSOR_SHARING parameter to EXACT
• D. configuring shared server connections
• E. enabling Automatic Memory Management and allocating at least 50% of the available memory for SHARED_POOL_SIZE
• F. setting the OPEN_CURSORS parameter to hold a sufficient number of concurrently open cursors