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