WhentuningAutomaticPGAMemoryManagement,whichofthefollowingviewswillprovidetheinformationspecified?() A.TheV$PGA_TARGET_ADVICEviewshowsthepredictedcachehit-ratioimprovementifyou increasePGA_AGGREGATE_TARGETB.TheV$PGA_TARGET_ADVICEviewshowshowtheV$SQL_WORKAREAhistogramwill changeifyouchangethevalueofPGA_AGGREGATE_TARGETC.TheV$PGA_TARGET_ADVICE_HISTOGRAMviewshowshowtheV$SQL_WORKAREA_HISTOGRAM willchangeifyouswitchbetweenManualandAutomaticPGAMemoryManagementD.TheV$PGA_TARGET_ADVICEviewshowshowperformancewillimproveforthedifferentworkareas ifyouswitchfromManualtoAutomaticPGAMemoryManagement

WhentuningAutomaticPGAMemoryManagement,whichofthefollowingviewswillprovidetheinformationspecified?()

A.TheV$PGA_TARGET_ADVICEviewshowsthepredictedcachehit-ratioimprovementifyou increasePGA_AGGREGATE_TARGET

B.TheV$PGA_TARGET_ADVICEviewshowshowtheV$SQL_WORKAREAhistogramwill changeifyouchangethevalueofPGA_AGGREGATE_TARGET

C.TheV$PGA_TARGET_ADVICE_HISTOGRAMviewshowshowtheV$SQL_WORKAREA_HISTOGRAM willchangeifyouswitchbetweenManualandAutomaticPGAMemoryManagement

D.TheV$PGA_TARGET_ADVICEviewshowshowperformancewillimproveforthedifferentworkareas ifyouswitchfromManualtoAutomaticPGAMemoryManagement

相关考题：

热门标签