单项选择题
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？（）
A. Disable SQL tracing for the APPS tablespace.
B. Disable logging attributes for the APPS tablespace.
C. Modify the tablespace to be a dictionary-managed 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 metric for the APPS tablespace.
相关考题
-
多项选择题
Youareworkinginadedicatedserverenvironment.YourdatabaseisrunningintheautomaticProgramGlobalArea（PGA）memorymanagementmode.Whichtwostatementsarecorrectinthisscenario？（）
A. The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B. The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C. Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
D. The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode. -
单项选择题
Inoneofyouronlinetransactionprocessing（OLTP）applications，usersaremanipulatingandqueryingadatabasetablesimultaneously.FromtheSegmentAdvisor，youfindthatoneofthetablesishighlyfragmentedandyouwanttoshrinkthetableimmediatelywithoutaffectingthecurrentlyactivequeries.WhichoptionwouldyouusewiththeALTERTABLEcommandtoachievethisobjective？（）
A. REBUILD
B. CASCADE
C. TRUNCATE
D. ROW MOVEMENT
E. SHRINK SPACE COMPACT
F. SHRINK SPACE CASCADE -
多项选择题
You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP； How does RMAN find the control file autobackup？（）
A. By using the trace file.
B. By using the alert log file.
C. By using the database ID
D. By using the server parameter file.
E. By using the V$CONTROLFILE view.
F. By using the autobackup format configuration setting.
