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

試験コード:1z0-064
試験名称:Oracle Database 12c: Performance Management and Tuning
認定資格:Oracle
無料問題数:120
更新日:2026-11-18
評価
100%

問題 1

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?

問題 2

Which four statements are true about Consolidated Database Replay?

問題 3

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.)

問題 4

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.)

問題 5

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.)

コメントを追加

あなたのメールアドレスが公開されることはありません。個人情報に関する内容は隠されます *

insert code
画面にある文字を入力してください。