单项选择题
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？（）
A. The EVENT parameter was not set
B. The SQL_TRACE parameter is set to FALSE
C. The Enterprise Manager Grid Control is not used
D. The STATISTICS_LEVEL parameter is set to BASIC
E. The TIMED_STATISTICS parameter is set to FALSE
相关考题
-
多项选择题
YouworkasadatabaseadministratoratCertkiller.com.Inyourproductiondatabase，youobservethatusers’transactionsareconsumingalotofresourceandyouplantoimposeresourcerestrictionsbyusingResourceManager.ForwhichthreeresourcescanyouenableusagerestrictionsbyusingResourceManager？（）
A. CPU usage
B. degree of parallelism
C. number of open cursors
D. number of sorts performed
E. idle time for blocking sessions
F. number of disk I/O operations performed
G. number of memory I/O operations performed -
单项选择题
Whichstatementcorrectlydescribesthechangetrackingwriter（CTWR）backgroundprocess？（）
A. It keeps track of changes in the background processes.
B. It records the system change number （SCN） in the control file.
C. It writes audit records for user changes to the change tracking file.
D. It records any changes to the listened configuration in the listener.ora file.
E. It records any changes to the database parameters in the change tracking file.
F. It records the physical location of all the changes that are made to the database in the change tracking file. -
多项选择题
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below： SGA_TARGET= 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario？ （）
A. A maximum of 3 GB can be allocated to shared pool
B. The value for SGA_TARGET can be increased up to a maximum of 15 GB
C. A total of 14 GB memory will be allocated to the automatically tuned memory components.
D. Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
F. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
