The collection level for the AWR should be set to BASIC
The moving window size must be less than Undo Retention
The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
第1题:
A. It does not allow you to change the moving window size.
B. Adaptive threshold functionalities use it by default to compute statistics.
C. It is created by default with the window size being equal to the AWR retention time.
D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
第2题:
A. Compute the baseline statistics.
B. Take an immediate AWR snapshot.
C. Decrease the window size for the baseline.
D. Decrease the expiration time for the baseline.
第3题:
A. because AWR baseline is not enabled
B. because Current Open Cursors Count is not a basic metric
C. because the STATISTICS_LEVEL parameter is set to BASIC
D. because the AWR baseline is a system-defined moving window baseline
第4题:
A server is connected to a gigabit Ethernet switch and has negotiated 1Gbps / Full Duplex. When transferring large files to and from other servers on the segment via FTP slow performance is noticed.All network cabling,network hardware and server hardware were verified to be working correctly. Which of the following could be done to improve performance?()
第5题:
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?()
第6题:
You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?()
A. Set a threshold for the default system-defined moving window baseline.
B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).
C. Modify the profile for the targeted users for which control needs to be imposed.
D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
第7题:
You notice that the elapsed time for an important database scheduler Job is unacceptably long.The job belongs to a scheduler job class and window.Which two actions would reduce the job‘s elapsed time?()
A. Increasing the priority of the job class to which the job belongs
B. Increasing the job‘s relative priority within the Job class to which it belongs
C. Increasing the resource allocation for the consumer group mapped to the scheduler job‘s job class within the plan mapped to the scheduler window
D. Moving the job to an existing higher priority scheduler window with the same schedule and duration
E. Increasing the value of the JOB_QUEUE_PROCESSES parameter
F. Increasing the priority of the scheduler window to which the job belongs
第8题:
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?()
A. The collection level for the AWR should be set to BASIC
B. The moving window size must be less than Undo Retention
C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
第9题:
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?()
第10题:
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()