Oracle Database 12c: Performance Management and Tuning - 1z1-064 FREE EXAM DUMPS QUESTIONS & ANSWERS
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?
Which two statements are true regarding ASM striping in combination with RAID 0?
Correct Answer: A,C
Vote an answer
Examine the parameters set for your database instance:
You upgrade your database to Oracle Database 12c. The database supports a mixed workload and works with different workloads at different times. You notice in an ADDM report that the shared pool is inadequately sized. You resize the shared pool by decreasing the sizes of other pools, which results in inadequate sizes for other pools. You want to automate the sizing of SGA components.
Which two actions should you perform? (Choose two.)
You upgrade your database to Oracle Database 12c. The database supports a mixed workload and works with different workloads at different times. You notice in an ADDM report that the shared pool is inadequately sized. You resize the shared pool by decreasing the sizes of other pools, which results in inadequate sizes for other pools. You want to automate the sizing of SGA components.
Which two actions should you perform? (Choose two.)
Correct Answer: A,C
Vote an answer
Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR report:
What should you examine to diagnose the cause of the top three wait events? (Choose the best answer.)
What should you examine to diagnose the cause of the top three wait events? (Choose the best answer.)
Correct Answer: D
Vote an answer
Examine the parameters set for a database instance:
The database supports a DSS application that performs huge sort operations on large temporary tables with LOB columns. Schema objects used in queries are updated and new rows are inserted regularly. Users complain about the poor performance of a few queries. During investigation, you execute these queries:
Which two actions would you recommend to improve the performance of these queries?
The database supports a DSS application that performs huge sort operations on large temporary tables with LOB columns. Schema objects used in queries are updated and new rows are inserted regularly. Users complain about the poor performance of a few queries. During investigation, you execute these queries:
Which two actions would you recommend to improve the performance of these queries?
Correct Answer: C,E
Vote an answer
Your database supports an online transaction processing (OLTP) workload. The database uses ASM storage. One of the ASM disks goes offline because of hardware failure. When the disk is replaced and then added back to the diskgroup, database performance is affected by rebalance operations.
Which two actions would you recommend to lower the impact of rebalance operations on the performance of the database? (Choose two.)
Which two actions would you recommend to lower the impact of rebalance operations on the performance of the database? (Choose two.)
Correct Answer: A,B
Vote an answer
Your database supports an OLTP workload.
An application frequently performs update operations on an indexed column of a table; some bulk delete and insert operations are also performed.
The table is created in a locally managed tablespace with manual segment space management.
A user complains about poor response time when querying the table.
The queries mostly perform index range scans.
You notice a high number of buffer busy waits and contention on segment headers.
Which three would you investigate further to diagnose the poor response time?
An application frequently performs update operations on an indexed column of a table; some bulk delete and insert operations are also performed.
The table is created in a locally managed tablespace with manual segment space management.
A user complains about poor response time when querying the table.
The queries mostly perform index range scans.
You notice a high number of buffer busy waits and contention on segment headers.
Which three would you investigate further to diagnose the poor response time?
Correct Answer: A,C,D
Vote an answer
You plan to upgrade your production database from Oracle Database 11g to 12c. As part of the upgrade, you want to introduce new indexes and materialized views. You have already created a test system with Oracle Database 12c, having the same structure and data as the production database, along with new schema objects to be added to the production database.
You want to identify regressed SQL statements, if any, which may have been caused by schema changes and the change in the optimizer version.
Which two methods would you use to achieve this? (Choose two.)
You want to identify regressed SQL statements, if any, which may have been caused by schema changes and the change in the optimizer version.
Which two methods would you use to achieve this? (Choose two.)
Correct Answer: B,C
Vote an answer
Examine the structure of the EMPLOYEES table.
EMPLOYEE_ID is the primary key. No other indexes exist on this table.
View the Exhibit to examine the commands and their output.
Which two actions should you perform to make the cursor bind aware? (Choose two.)
EMPLOYEE_ID is the primary key. No other indexes exist on this table.
View the Exhibit to examine the commands and their output.
Which two actions should you perform to make the cursor bind aware? (Choose two.)
Correct Answer: D,E
Vote an answer
Your database supports an OLTP workload during the day and batch processing at night. You want to monitor performance metrics to detect any degradation of performance in both types of workloads over a time period of 30 days.
Examine this list of possible steps:
1. Create a fixed baseline.
2. Create a baseline template.
3. Create a new moving window baseline.
4. Increase the retention period default value to 30 days.
5. Increase the size of the existing moving window baseline to 30 days.
6. Create warning and critical alerts for the relevant metrics.
7. Enable adaptive thresholds to detect the workload patterns and specify a high-significance-level threshold type.
8. Enable adaptive thresholds to detect the workload patterns and set different threshold values as a percentage of the maximum value.
Which option represents the required steps in the correct order? (Choose the best answer.)
Examine this list of possible steps:
1. Create a fixed baseline.
2. Create a baseline template.
3. Create a new moving window baseline.
4. Increase the retention period default value to 30 days.
5. Increase the size of the existing moving window baseline to 30 days.
6. Create warning and critical alerts for the relevant metrics.
7. Enable adaptive thresholds to detect the workload patterns and specify a high-significance-level threshold type.
8. Enable adaptive thresholds to detect the workload patterns and set different threshold values as a percentage of the maximum value.
Which option represents the required steps in the correct order? (Choose the best answer.)
Correct Answer: A
Vote an answer
Which two statements are true about gathering statistics? (Choose two.)
Correct Answer: A,D
Vote an answer