单项选择题
A.Run the SQL Access Advisor.
B.Run the Memory Advisor for the sga.
C.Run the Memory Advisor for the pga.
D.Run the Memory Advisor for the shared pool.
E.Run the Memory Advisor for the buffer cache.
单项选择题 View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings,respectively. Why are advisors not available for the shared pool and the buffer cache()
单项选择题 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()