1z0-064 試験問題を無料オンラインアクセス
| 試験コード: | 1z0-064 |
| 試験名称: | Oracle Database 12c: Performance Management and Tuning |
| 認定資格: | Oracle |
| 無料問題数: | 120 |
| 更新日: | 2026-11-18 |
You are administrating a database that supports a mixed workload. Given are the details of the workload:
During the day, short transactions and syntactically similar queries are repeatedly issued.
At night, DSS batch queries and jobs are executed with large sort operations.
Examine the parameters set for the database instance:
To automate memory requirements for both workloads, which three changes to parameters would you recommend?
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 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.)
You are administering a database that supports an OLTP workload. An application regularly creates global temporary tables and a large number of transactions are performed on them. You notice that performance is degraded because of excessive generation of undo due to a large number of transactions on the global temporary tables.
What is the recommended action to improve performance? (Choose the best answer.)