单选题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，

题目内容(请给出正确答案)

单选题

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？（）

The EVENT parameter was not set.

The SQL_TRACE parameter is set to FALSE

The Enterprise Manager Grid Control is not used.

The STATISTICS_LEVEL parameter is set to BASIC

The TIMED_STATISTICS parameter is set to FALSE

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）A DBMS_STATS B DBMS_ALERT C DBMS_SPACE D DBMS_MONITOR E DBMS_SERVER_ALERTF DBMS_SPACE_ADMIN

点击查看答案
第2题

单选题While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）AA primary key must have been created.BA mapping table must have been created.CAn overflow tablespace must have been specified.DThe PCTTHRESHOLD option must have been specified.

点击查看答案
第3题

单选题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？（）A run a procedure to check the tablespace space usageB define the warning threshold for the tablespace at 75% in Database ControlC create a trigger to be executed when tablespace space usage reaches 75%D submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervalsE define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

点击查看答案
第4题

单选题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（）A System monitor （SMON）B Process monitor （PMON）C Memory manager process （MMAN）D Manageability Monitor process （MMON）

点击查看答案
第5题

单选题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？（）A disable SQL tracing for theAPPS tablespaceB disable logging attribute for the APPS tablespaceC modify the tablespace to be a dictionarymanaged tablespaceD increase the critical threshold value for the tablespace space usage metrics for the APPS tablespaceE increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace

点击查看答案
第6题

单选题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 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 usage metrics for the APPS tablespace. What should you do？（）ADisable SQL tracing for the APPS tablespace.BDisable logging attributes for the APPS tablespace.CModify the tablespace to be a dictionary-managed tablespace.DIncrease the critical threshold value for the tablespace space usage metrics for the APPS tablespace.EIncrease the warning threshold value for the tablespace space usage metric for the APPS tablespace.

点击查看答案
第7题

单选题The warning level threshold value for a tablespace， DATA1， is set to 60% and the critical level threshold value is set to 80%. The tablespace， DATA1， is infrequently used and is not a part of the production environment. You issued the following command： SQL> EXECUTE DBMS_SERVER_ALERT.SET_THRESHOLD （dbms_server_alert.tablespace_pct_full， dbms_server_alert.operator_ge，80， dbms_server_alert.operator_ge，90， 1，1，NULL， dbms_server_alert.object_type_tablespace，’DATA’）； What will be the result of the command？（）AThe command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.BThe total numbers of alerts that you receive every day will be reduced.CThe total number of alerts that you receive every day will be increased.DNo more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.

点击查看答案

You have specified the warning and critical threshold values

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容