V$Pga_Aggregate_Target Advice

V$Pga_Aggregate_Target Advice




Column Datatype Description PGA_TARGET_FOR_ESTIMATE: NUMBER: Value of PGA_AGGREGATE_TARGET for this prediction (in bytes): PGA_TARGET_FACTOR: NUMBER: PGA_TARGET_FOR_ESTIMATE / the current value of the PGA_AGGREGATE_TARGET parameter: ADVICE _STATUS: VARCHAR2(3) Indicates whether the advice is enabled (ON) or disabled (OFF).

??Oracle???work area size & pga_aggregate_target????? ??session?PGA???????????????????????? 1???PGA????????????????*_area_size??? sort_area_size??????? workarea_size_policy:????????PGA??????????, Oracle 12c PGA Target???? ??PGA_AGGREGATE_TARGET?? ??????Oracle??????????????PGA_AGGREGATE_TARGET?pga?????????????????????Oracle DOC?????????????????????????16G?PGA_AGGREGATE_TARGET?2G?????????pga????…

4/3/2013  · This discussion is archived. 4 Replies Latest reply on Apr 3, 2013 2:03 PM by sb92075 Latest reply on Apr 3, 2013 2:03 PM by sb92075, This Oracle10g OCP course is an intensive 5-day course is designed to provide Oracle professionals with an in-depth understanding of the DBA concepts and knowledge required for the OCA exam, and tips and techniques for passing the Oracle10g OCA exam.

6 MCA Science Computer – Free # as PDF File (.pdf), Text File (.txt) or read online for free.

Oracle10g Database Administration OCA Exam Preparation_Syllabus – Free # as Word Doc (.doc / .docx), PDF File (.pdf), Text File (.txt) or read online for free.




Share this: