You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table sc

题目

You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.Identify three possible reasons for this.（）

A. Missing or stale histogram statistics

B. Undersized shared pool

C. High clustering factor for the indexes

D. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter

E. Oversized buffer cache

相似考题

1.执行下列命令后,当前打开的表文件名是()Number=“3”File= “file”＋Numberuse&FileA、File3B、&FileC、FileNumberD、File

2.YouareworkingasaDBAonOracleDatabase9i.Youplantoupgradeyour9idatabasetoOracle10g.Tobefamiliarwiththenewdatabasetechnology，youdecidetoinstallOracleDatabase10gonyourworkstationathome.Youcreateageneralpurposedatabase.Aftertheinstallation，youmakethefollowingchangesinyourinitializationparameterfile：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’DB_RECOVERY_FILE_DEST=’LOCATION=d：\product\10.1.0\flash_recovery_area’DB_RECOVERY_FILE_DEST_SIZE=10gWherearethearchivedredologsstoredforyourdatabase？（）

3.Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile?()A.DB_CREATE_FILE_DESTB.DB_RECOVERY_FILE_DESTC.DB_RECOVERY_FILE_DEST_SIZED.DB_ONLINE_LOG_DEST_n

4.YoudecidetoenableFlashbackDatabaseinyourOracle10gdatabasesothatfuturerecoverieswilltakelesstimethantraditionalrecoveries.WhichofthefollowingparametersmustbeincludedinyourinitializationparameterfilebeforeenablingFlashbackDatabase？（）A.DB_RECOVERY_FILE_DESTonlyB.DB_FLASHBACK_RETENTION_TARGETonlyC.DB_RECOVERY_FILE_DEST_SIZEandDB_RECOVERY_FILE_DESTonlyD.DB_RECOVERY_FILE_DESTandDB_FLASHBACK_RETENTION_TARGETonlyE.DB_RECOVERY_FILE_DEST_SIZE，DB_RECOVERY_FILE_DESTandF.DB_FLASHBACK_RETENTION_TARGET

更多“You notice a high number of waits for the db file scattered read and db file sequential re ”相关问题

  • 第1题：

    执行下列命令后,当前打开的数据库文件名是Number="3"File="File"＋NumberUSE&FileA.File3B.&a

    执行下列命令后，当前打开的数据库文件名是 Number="3" File="File"+Number USE &File

    A．File3

    B．&File

    C．FileNumber

    D．File


    正确答案：A
    解析：通过执行题目所示的程序段{Number="3"File="File"+Number}变量File的值为“File3”。而在VisualFoxPro中，命令USE的含义是打开数据库，因此本题中应该的打开的数据库为File3，因此答案为A。

  • 第2题：

    Examinethefollowingparametersettingsfromaninitialization（init.ora）file：DB_CREATE_FILE_DEST=’/u01/oradata/’DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’DB_CREATE_ONLINE_LOG_DEST_2=’/u03/oradata/’IfyoucreateanOracleManagedFiles（OMF）databaseusingthesesettings，whatistheresult？（）

    A.A

    B.B

    C.C

    D.D


    参考答案：D

  • 第3题：

    假设file是文本文件对象，下列选项中，哪个用于读取一行内容？（）

    A．file.read()

    B．file.read(200)

    C．file.readline()

    D．file.readlines()


    file.readline()

  • 第4题：

    下面哪2个参数是flashback databae必须设置的? ()

    A. DB_FLASHBACK_RETENTION_TARGET

    B. DB_RECOVERY_FILE_DEST

    C. RECOVERY_PARALLELISM

    D. FLASHBACK_TRANSACTION_QUERY

    E. DB_RECOVERY_FILE_DEST_SIZE


    参考答案BE

  • 第5题：

    假设文件file是文本文件对象，下列选项只能够，哪个用于读取一行内容（）

    A．file.read()

    B．file.read(200)

    C．file.readline()

    D．file.readlines()


    file.readline()

  • 第6题：

    3、假设file是文本文件对象，下列选项中，哪个用于读取一行内容？（）

    A．file.read()

    B．file.read(200)

    C．file.readline()

    D．file.readlines()


    file.readline()

相关内容