Inyourtestdatabase,youfindthatauser’ssessionisexecutingalotofSQLstatements,resultinginthegenerationofalargenumberoftracefiles.Whileinvestigatingthereason,youfindthatSQLtracehasbeenenabledattheinstancelevel.YouwanttodisableSQLtrace,remotely,onlyforthatuser

题目

Inyourtestdatabase,youfindthatauser’ssessionisexecutingalotofSQLstatements,resultinginthegenerationofalargenumberoftracefiles.Whileinvestigatingthereason,youfindthatSQLtracehasbeenenabledattheinstancelevel.YouwanttodisableSQLtrace,remotely,onlyforthatusersessiontoreducethevolumeoftracedatabeinggenerated.Howdoyouachievethisobjective?()

A.bysettingtheSQL_TRACEparametertoFALSEintheparameterfile

B.byusingDBMS_MONITOR.SESSION_TRACE_DISABLEtodisablethetracingfortheusersession

C.bysettingtheSQL_TRACEparametertoFALSEbyusingtheALTERSYSTEMcommandintheusersession

D.bysettingtheSQL_TRACEparametertoFALSEbyusingtheALTERSESSIONcommandintheusersession


相似考题