Oracle OCP 19c 认证1Z0-083考试(第25题)

最新推荐文章于 2021-06-26 09:10:59 发布

wwwleoocom

最新推荐文章于 2021-06-26 09:10:59 发布

阅读量360

点赞数 1

分类专栏： Oracle 19c OCP-1z0-083（2021）文章标签： ocp oracle linux nginx docker

本文链接：https://blog.csdn.net/itsaka/article/details/117632964

版权

Oracle 19c OCP-1z0-083（2021）专栏收录该内容

60 篇文章 47 订阅

订阅专栏

当自动共享内存管理在某个数据库实例中被禁用时，某些SQL语句由于频繁的硬解析操作导致性能下降。为了解决这个问题，应该运行内存顾问来分析共享池，以获取不同池大小的预计解析时间，从而提高性能。同时，考虑使用SQL调优顾问来进一步优化SQL执行效率。

摘要由CSDN通过智能技术生成

Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?

A. Run the SQL Access Advisor.
B. Run the Memory Advisor for the shared pool.
C. Run the SQL Tuning Advisor.
D. Run the Memory Advisor for the Program Global Area.
E. Run the Memory Advisor for the System Global Area.

https://blogs.oracle.com/oraclemagazine/using-database-advisors

The shared pool advisor provides information about the estimated parse time in the shared pool for different pool sizes, the buffer cache advisor provides information about physical reads and time for the cache size, and the PGA advisor provides information about cache hit percentage against PGA target memory size.