System monitor (SMON)
Process monitor (PMON)
Memory manager process (MMAN)
Manageability Monitor process (MMON)
第1题:
Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently, the warning threshold for the tablespace space usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool, you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do?()
第2题:
You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this?()
第3题:
While setting up the threshold for tablespace space usage metrics for one of your tablespaces, you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting?()
第4题:
You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact?()
第5题:
Note the following functionalities of various background processes: 1:Record the checkpoint information in data file headers. CKPT 2:Perform recovery at instance startup. SMON 3:Cleanup unused temporary segments. SMON 4:Free the resources used by a user process when it fails. 5:Dynamically register database services with listeners. 6:Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process()
第6题:
The warning and critical threshold values have been set to 85% and 97%, respectively, for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50 % and critical threshold to be 53% in Database Control. Which statement is true?()
第7题:
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?()
第8题:
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?()
第9题:
While setting up the thresholds for tablespace space usage metrics for one of your tablespaces, you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting?()
第10题:
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:Warning (%): 90Critical (%): 95 Which background process is responsible for issuing alerts when the threshold is crossed()