多项选择题
A.Increase the size of redo log files
B.Increase the size of redo log buffer
C.Increase the number of redo log files
D.Place the redo log files on a separate disk
E.Decrease the number of redo log groups to two
F.Increate the number Log Writer (LGWR) process
单项选择题 Initially,fortheAutomaticWorkloadRepository(AWR)statistics,theretentionperiodissetto7days,thecollectionintervalissetto30minutesandthecollectionlevelissettoTypicalinyourproductiondatabase.YouhavebeenusingtheMemoryAdvisorforthelastthreemonthstogeneraterecommendationsfortuningmemorycomponents.However,whenyouobservetheMemoryAdvisoronaFriday,youfindthatthestatisticsareavailableonlyfortwodays,ThursdayandFriday,ofthatweek.Whatwouldhavecausedthestatisticstoberemoved?()
单项选择题 Inyourdatabaseserver,theparameterPLSQL_OPTIMIZE_LEVELhasbeensetto2.Whatwouldthissettingachieve?()
单项选择题 YouworkasadatabaseadministratorforSupportcenter.cn.Youfindthatreportsarerunningforalongtimeinyourdatawarehousingapplications.Yoususpectalackofindexesisthereasonfortheperformancedegradation.Whichadvisorycomponentwouldyoureferto,inordertodeterminetheappropriateindexes?()