Youfindthattheexecutiontimeofreportsinyourdatawarehouseapplicationissignificantlyhigh.You suspectthelackofindexestobethereasonforthedegradationinperformance.Whichadvisorycomponentwouldyoureferto,inordertodeterminetheappropriateindexes?()A.MemoryAdvisorB.SegmentAdvisorC.SQLAccessAdvisorD.AutomaticWorkloadRepository(AWR)E.AutomaticDatabaseDiagnosticMonitor(ADDM)
Youfindthattheexecutiontimeofreportsinyourdatawarehouseapplicationissignificantlyhigh.You suspectthelackofindexestobethereasonforthedegradationinperformance.Whichadvisorycomponentwouldyoureferto,inordertodeterminetheappropriateindexes?()
A.MemoryAdvisor
B.SegmentAdvisor
C.SQLAccessAdvisor
D.AutomaticWorkloadRepository(AWR)
E.AutomaticDatabaseDiagnosticMonitor(ADDM)
相关考题:
AcustomerhasWindowsserversandapplicationsthatuseblockI/O.Thecustomercannotaffordthecostofafibrechannelinfrastructurebutstillrequiressharedstorage.Whichconfigurationmeetstheserequirementsatthelowestcost?()A.iSCSIHBAsandN3400B.MicrosoftiSCSIinitiatorandN3400C.MicrosoftiSCSIinitiatorandDS3400D.SAN04B-Rmulti-protocolrouterandDS3400