YouaremaintainingthePRODdatabaseofNetFxCorporation.YousetthevalueoftheSQL_TRACEparametertoTRUE.Whatwillbetheimpactofthissetting?()A.TheSQLtracefacilitywillgeneratetheperformancestatisticsforalltheSQLstatementsforaninstanceandwritethemintheUSER_DUMP_DESTdi
题目
YouaremaintainingthePRODdatabaseofNetFxCorporation.YousetthevalueoftheSQL_TRACEparametertoTRUE.Whatwillbetheimpactofthissetting?()
A.TheSQLtracefacilitywillgeneratetheperformancestatisticsforalltheSQLstatementsforaninstanceandwritethemintheUSER_DUMP_DESTdirectory.
B.TheSQLtracefacilitywillgeneratetheperformancestatisticsforalltheSQLstatementsforasessionandwritethemintheUSER_DUMP_DESTdirectory.
C.TheSQLtracefacilitywillgeneratetheperformancestatisticsforalltheSQLstatementsforaninstanceandwritethemintheBACKGROUND_DUMP_DESTdirectory.
D.TheSQLtracefacilitywillgeneratetheperformancestatisticsforalltheSQLstatementsforasessionandwritethemintheBACKGROUND_DUMP_DESTdirectory.