Youreceivecomplaintsfromusersregardingthehighwaitingtimefortheirtransactions.Oninvestigation,youfindthatsomeusersarenotcommittingtheirtransactionsthoughtheyarenotperforminganyactivityforalongtime.Asaresult,SQLstatementsneedtowaitforrow-levellocks.Whichtwoactionscouldyoutaketopreventthislockingprobleminthefuture()

A.DecreasetheIDLE_TIMEresourcelimitintheprofileassignedtotheblockingusers. B.UseDatabaseResourceManagertoautomaticallylogoutsessionsthatblockothersandareidle. C.Setthelimitintheprofileofblockinguserstocontrolthenumberofblockstobeaccessedinasession. D.Decreasethemaximumnumberofinterestedtransactionlist(ITL)slotsforthesegmentsonwhichtheblockinguserperformsthetransaction

时间:2023-09-20 09:49:21

相似题目