多项选择题
You work as a database administrator at Certkiller .com. In your production database, you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager? ()
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 -
多项选择题
Inwhichscenarioswouldyourebuildanindex?()
A. when you need to disable the index usage
B. when you need to change storage options
C. when you need to enable index monitoring
D. when you need to move the index to another tablespace
