oracle-ocp-043试题分类汇总

性能调优1.You observe that a database performance has degraded over a period of time. While investigatin

性能调优 1.Youobservethatadatabaseperformancehasdegradedover aperiodoftime.Whileinvestigatingthereason,youfindthesizeof thedatabasebuffercacheisnotlargeenoughtocachealltheneededdata blocks.Whichadvisorycomponentwoldyoureferto,inordertodetermine thatrequiredsizeofthedatabasebuffercache? A.MemoryAdvisor B.SegmentAdvisor C.SQLTuningAdvisor D.SQLAccessAdvisor E.AutomaticDatabaseDiagnosticMonitor(ADDM) A buffercache 发现数据库运行一段时间后性能下降了，调查发现原因是因为不能装下所有需 buffercache 要的数据块，用个工具确定数据库所需要的的大小。 2.Exhibit -- 显示所有日志在同一个目录下 Inyourproductiondatabase,thetotalwaitsandthetimewaitedforlog fileparallelwritearesignificantlyhigh.Whileinvestigatingthe reason,youfindthattherearethreeredologgroupswithtwomembers ineachgroup,and allredologmembersareplacesonasinglephysical disk.Whatactionwouldyoutaketominimizethewaits? A.Startthelogwriterslaveprocesses B.Increasethenumberofredologfiles C.Increasethesizeoftheredologbuffer D.Placetheredologfilesonthedifferentdisks. E.Increasethenumberoflogwriterprocesses. Answer:D 等待并行写日志的时间明显很高。调查发现三个日志文件组，每组由两个成员，都在同一个 -- 物理磁盘上。通过什么方法解决问题？主要是不懂题目意思会出错。 24.YouaredesigninganapplicationforCertkiller.comandyouhave beenaskedtodesignadatabasetabletofacilitatemonthlybillgen eration.Thebillwouldincludedetailsofcustomercalls,listedin chronologicalorder.Whichmethodwouldyoufollowtoachievethisob jectivewithoutincreasingtheoverheadofsortingtherows? A.createahashclustertostorethedata B.createanindexclustertostorethedata C.createapartitionedtabletostorethedata D.createasortedhashclustertostorethedata E.createaheaptablewithrowidtostorethedata Answer:D