單項(xiàng)選擇題

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 tablespace
B.disable logging attribute for the APPS tablespace
C.modify the tablespace to be a dictionarymanaged tablespace
D.increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace
E.increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace

你可能感興趣的試題

多項(xiàng)選擇題

In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）

A.the alert log file
B.the core dump files
C.the change tracking file
D.the user session trace files
E.the database audit trail files
F.the background process trace files

單項(xiàng)選擇題

In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level.
You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.
How do you achieve this objective？（）

A.by setting the SQL_TRACE parameter to FALSE in the parameter file
B.by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
C.by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
D.by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

你可能感興趣的試題

In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）