In a recent Automatic Workload Repository (AWR) report for your database you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.

欢迎免费使用小程序搜题/刷题/查看解析,提升学历,成考自考报名,论文代写、论文查重请加客服微信skr-web


In a recent Automatic Workload Repository (AWR) report for your database you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.
On further investigation you f ind that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?

A.Decreasing PCTUSED
B.Decreasing PCTFREE
C.Increasing the number of DBWN process
D.Using Automatic Segment Space Management (ASSM)
E.Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation
正确答案D
访客
邮箱
网址

通用的占位符缩略图

人工智能机器人,扫码免费帮你完成工作


  • 自动写文案
  • 自动写小说
  • 马上扫码让Ai帮你完成工作
通用的占位符缩略图

人工智能机器人,扫码免费帮你完成工作

  • 自动写论文
  • 自动写软件
  • 我不是人,但是我比人更聪明,我是强大的Ai
Top