單項(xiàng)選擇題

Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance.
What would be your next step to improve performance？（）

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.

你可能感興趣的試題

單項(xiàng)選擇題

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()

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

單項(xiàng)選擇題

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（）

A.The database instance is running with manual PGA management.
B.The database instance is running with manual shared memory management.
C.The database instance has the MEMORY_TARGET value set to a nonzero value.
D.All sessions are connected to the database instance in dedicated mode， and no RMAN or parallelquery operations have been performed.

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance. What would be your next step to improve performance？ （）

你可能感興趣的試題

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()

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance.
What would be your next step to improve performance？（）

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()