單項(xiàng)選擇題

Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.
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)選擇題

Which kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）

A.Failure when no standby database is configured
B.Failure because a data file is renamed accidentally
C.Failure that requires no archive logs to be applied for recovery
D.Failure due to loss of connectivity-for example， an unplugged disk cable

單項(xiàng)選擇題

Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future.
What action would you take to achieve this task（）

A.Insert finding directives for ADDM tasks in the future.
B.Create a baseline on a pair of snapshots spanning the peak-load period.
C.Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.
D.Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots

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

Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step to improve performance（）

你可能感興趣的試題

Which kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）

Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）

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

Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.
What would be your next step to improve performance（）

Which kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）

Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future.
What action would you take to achieve this task（）