Oracle OCP 19c 认证1Z0-083考试(第81-90题) - #宝，舔狗聪_choose three which three rman persistent settings -CSDN博客

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

本文详细分析了Oracle 19c数据库在自动共享内存管理关闭时如何优化性能，讨论了如何通过运行内存顾问优化共享池。此外，还涵盖了Oracle 19c的闪回特性、数据库恢复策略以及RMAN双工备份集的管理技巧。

摘要由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 Tunning Advisor.

D. Run the Memory Advisor for the Program Global Area. E. Run the Memory Advisor for the System Global Area.

Answer: B

(解析:出现上述情况,可能是共享池的 SHARED_POOL_SIZE 参数设置太小,建议是执行内存指
导来重新设置 SHARED_POOL_SIZE 参数的值。)
42 、 Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

A. Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.

B. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.

C. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.

D. Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.