WhentuningAutomaticPGAMemoryManagement,whichofthefollowingviewswillprovidetheinformationspecified?()A.TheV$PGA_TARGET_ADVICEviewshowsthepredictedcachehit-ratioimprovementifyou increasePGA_AGGREGATE_TARGETB.TheV$PGA_TARGET_ADVICEviewshowshowtheV$SQL_WORKAR

题目
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


相似考题
参考答案和解析
参考答案:A