Youreceivecomplaintsfromusersregardingthehighwaitingtimefortheirtransactions.Oninvestigation,youfindthatsomeusersarenotcommittingtheirtransactionsthoughtheyarenotperforminganyactivityforalongtime.Asaresult,SQLstatementsneedtowaitforrow-levellocks.Whichtwoactionscouldyoutaketopreventthislockingprobleminthefuture()
A.DecreasetheIDLE_TIMEresourcelimitintheprofileassignedtotheblockingusers.
B.UseDatabaseResourceManagertoautomaticallylogoutsessionsthatblockothersandareidle.
C.Setthelimitintheprofileofblockinguserstocontrolthenumberofblockstobeaccessedinasession.
D.Decreasethemaximumnumberofinterestedtransactionlist(ITL)slotsforthesegmentsonwhichtheblockinguserperformsthetransaction
时间:2023-09-20 09:49:21
相似题目