單項選擇題

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

你可能感興趣的試題

多項選擇題

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

單項選擇題

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

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

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？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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