<< Prev Question Next Question >>

Question 31/84

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

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (84q)
Question 1: You want to capture the performance of your database during ...
Question 2: Examine the parameter values configured in your database: sg...
1 commentQuestion 3: Your database supports a mixed workload. In an application, ...
Question 4: Which two statements are true about ADDM? (Choose two.)...
1 commentQuestion 5: For which two requirements can you always use the V$ACTIVE_S...
1 commentQuestion 6: Examine the parameters set for your database instance: (Exhi...
1 commentQuestion 7: Which two result in the latest fragmentation within segments...
Question 8: A senior DBA asks you to decrease the values of the connect_...
1 commentQuestion 9: You are administering a database that supports an OLTP workl...
Question 10: Which two statements are true about Active Session History (...
Question 11: You are administering a database that supports an OLTP workl...
Question 12: Examine the partial AWR report taken for a time period of 60...
Question 13: You have been asked to use table compression for two large t...
Question 14: You have been asked to assess if using column store compress...
Question 15: In which three situations can dynamic statistics be used? (C...
Question 16: You are administering a database that supports a mixed workl...
Question 17: Which four objectives are achieved by using Resource Manager...
Question 18: You observe that queries are performing poorly on the SALES_...
Question 19: You want to capture AWR data to monitor performance variatio...
Question 20: Examine the parameters set for a database instance supportin...
Question 21: Which two statements are true about DB timein V$SYS_TIME_MOD...
Question 22: Which three methods can you use to create a pre-change SQL t...
Question 23: You want to generate statistics for new objects added to an ...
Question 24: Your database supports an OLTP system. Examine the parameter...
Question 25: Examine the parameters: (Exhibit) Your database supports a m...
Question 26: Users complain about increased response time for queries in ...
Question 27: For which three problem categories does Automatic Database D...
Question 28: Identify two effects of the DB_FILE_MULTIBLOCK_READ_COUNTpar...
Question 29: Which two statements are true about Compare Period ADDM? (Ch...
Question 30: You plan to upgrade your production database from Oracle Dat...
Question 31: Your database supports an OLTP workload during the day and b...
Question 32: Examine the partial TKPROFoutput for an SQL statement: (Exhi...
Question 33: You are administering a database that supports a mixed workl...
Question 34: Which two actions can reduce library cache latch contention ...
Question 35: Which two statements are true about viewing the details of R...
Question 36: Which two statements are true about server-generated alerts?...
Question 37: In your database, the locally managed tablespace, USERS, has...
Question 38: In your database, the measured 99th percentile value is used...
Question 39: In the CUSTOMERStable, the values in the CUST_STATEcolumn ar...
Question 40: In which three situations does DB timealways increase? (Choo...
Question 41: Examine the partial Activity Over Time section of an Active ...
Question 42: Examine the structure of the EMPLOYEES table. (Exhibit) EMPL...
Question 43: Examine the output of the query executed to diagnose the rea...
Question 44: Examine the query and its output: (Exhibit) Which two infere...
Question 45: Examine the parameters set for a database instance: (Exhibit...
Question 46: Which three actions should you perform to reduce shared pool...
Question 47: Your database supports an online transaction processing (OLT...
Question 48: Examine the command to change a parameter value from the def...
Question 49: Examine this list of possible tasks: 1. Ensure that STATISTI...
Question 50: You are administering a database that supports an OLTP workl...
Question 51: Which three statements are true about the interpretation of ...
Question 52: Which three statements are true about using Real-Time Databa...
Question 53: You plan to upgrade your production database from Oracle Dat...
Question 54: You are administering a database that supports a DSS workloa...
Question 55: Examine the Load Profile section of an AWR report: (Exhibit)...
Question 56: Which two statements are true about ADDM or Real-Time ADDM? ...
Question 57: Examine the initialization parameters set for a database ins...
Question 58: Examine the parameters set for your database instance: (Exhi...
Question 59: Examine the parameters set for a database instance: (Exhibit...
Question 60: For your database some users complain about not being able t...
Question 61: Examine the partial TOP 10 Foreground Events by Total Wait T...
Question 62: You define the warning threshold for the tablespace usage me...
Question 63: Which two statements are true about the interpretation of Bu...
Question 64: You execute this query twice in a session: (Exhibit) Then yo...
Question 65: Examine the parameters set for your database instance: (Exhi...
Question 66: Which two are prerequisites for running the I/O calibration ...
Question 67: You are administering a database that supports multiple appl...
Question 68: Your database supports multiple applications. The applicatio...
Question 69: Examine an extract from a PGA Memory Advisory for your datab...
Question 70: Your database supports a DSS workload. In an application, a ...
Question 71: Examine the parameters set for your database instance: (Exhi...
Question 72: To investigate the slow response time of queries on the TRAN...
Question 73: You are administering a database that supports an OLTP workl...
Question 74: Which two statements are true about gathering statistics? (C...
Question 75: Which two actions should you take to monitor the throughput ...
Question 76: You are administering a database that supports an OLTP workl...
Question 77: Your database supports a mixed workload. The ERP application...
Question 78: You are administering a database that supports a mixed workl...
Question 79: Examine the partial PLAN_TABLEoutput: (Exhibit) Which is the...
Question 80: Examine the query and its output: (Exhibit) Which two statem...
Question 81: Examine the Time Model Statistics section of an AWR report: ...
Question 82: You recently joined a new team administering a database. You...
Question 83: Which two situations can lead to sparsely populated index bl...
Question 84: You are administering a database that supports an OLTP workl...