单项选择题
A.because the DB_CACHE_ADVICE parameter is set to OFF
B.because Automatic Memory Management (AMM) is disabled for the database instance
C.because Automatic Shared Memory Management (ASMM) is enabled for the database instance
D.because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not setinitially
单项选择题 View the Exhibit to examine the output produced by the following query at three different times sincethe database instance started and has experienced workloads of different capacities: SQL> SELECT substr(component, 0, 10) COMP, current_size CS,user_specified_size USFROM v$memory_dynamic_componentsWHERE current_size!=0; What do you infer from this()
单项选择题 Automatic Shared Memory Management (ASMM) has been enabled for your database instance. Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM, you executed the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true in this scenario()
单项选择题 View the Exhibits and examine lock waits. Users HR and SH complain that their transactions on one of the application tables, EMP, are waiting for response. Which action would you take to release the lock and enable users HR and SH to continue with theirtransactions()