- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
61.
Which of the following components of the Oracle architecture stores the statistics
gathered by the MMON process?
- A.ADDM
- B.AWR
- C.ASMM
- D.ADR
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The MMON process gathers statistics from the SGA and stores them in the AWR. The ADDM process then uses these statistics to compare the current state of the data- base with baseline and historical performance metrics before summarizing the results on the EM Cloud Control screens. |
62.
Which of the following options for the pfile/spfile’s STATISTICS_LEVEL parameter turns
off AWR statistics gathering and ADDM advisory services?
- A.OFF
- B.TYPICAL
- C.ALL
- D.BASIC
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| Setting STATISTICS_LEVEL = BASIC disables the collection and analysis of AWR statistics. TYPICAL is the default setting, and ALL gathers information for the execution plan and operating-system timing. OFF is not a valid value for this parameter. |
63.
Which parameter is used to enable Automatic Memory Management?
- A.AMM_TARGET
- B.MEMORY_TARGET
- C.SGA_TARGET
- D.AUTOMATIC_MEMORY
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Automatic Memory Management is enabled by setting a nonzero value for the MEMORY_TARGET parameter. The default value for this parameter is zero. SGA_TARGET enables the ASSM (Automatic Shared Memory Management) feature. AMM_TARGET and AUTOMATIC_MEMORY are invalid parameters. |
64.
Which two parameters configure automatic PGA memory management?
- A.SGA_TARGET
- B.PGA_AGGREGATE_TARGET
- C.WORKAREA_SIZE_POLICY
- D.PGA_AGGREGATE_LIMIT
- Answer & Explanation
- Report
Answer : [B,C]
Explanation :
Explanation :
| When the WORKAREA_SIZE_POLICY is set to AUTO , work areas used by memory- intensive operations are sized automatically, based on the PGA memory used by the system, and the target PGA memory set in PGA_AGGREGATE_TARGET . When WORKAREA_ SIZE_POLICY is set to MANUAL , the *_AREA_SIZE parameters need to be configured manually. |
65.
Suppose you have used EM Database Control to drill down into ADDM findings and
have found that a single SQL statement is causing the majority of the I/O on your system.
Which of the following advisors is best suited to troubleshoot this SQL statement?
- A.SQL Tuning Advisor
- B.SQL Access Advisor
- C.Both A and B
- D.Neither A nor B
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| You can use the SQL Tuning Advisor to determine if there is a better optimizer plan and use SQL Access Advisor to determine if creating an index or materialized view would improve performance. These tools together can be used to determine whether I/O can be minimized and overall DB Time reduced to the targeted SQL statement |
|
|
||||||||||||||||||||||||||||
