可学答题网 > 问答 > 1Z0-060题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

In a recent Automatic Workload Reposi


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 find 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 the V$DB_CACHE_ADVICE recommendatio
参考答案
参考解析:
分类:1Z0-060题库
相关推荐

1、A database is stored in an Automatic

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:There is enough free space in the disk...

2、In more recent years, () heat exchange

In more recent years, () heat exchangers have frequently been employed for jacket water and oil cooling.Ashell and tube typeBplate typeCcoil typeDconical disc type

3、Text 3 In recent years, railroads have

Text 3 In recent years, railroads have been combining with each other, mergingsintossuper systems, causing heightened concerns about monopoly. As...

4、They have learned about()in recent yea

They have learned about()in recent years.Aseveral hundreds English wordsBhundreds of English wordsChundred of English wordsDseveral hundred English word

5、In order for the automatic lifeboat dr

In order for the automatic lifeboat drain to operate properly().Athe cap should be removed to drain the boat when it is waterborneBthe cage ...

6、In more recent years,()has been used b

In more recent years,()has been used by civilians in many new ways to determine positions,such as in automobile and boat navigation,hiking,emergency rescue,and precision agriculture and mining.AGPSBGMDSSCAISDNavtex