_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
SSIS-StringToBinary › OpenRowSet › SQLReferences › HiveUDFJSONSplit › TableOfContentsMacro › PGA(ProgramGlobalArea)
Data Analysis(R)
Data Analysis(Python)
Statistics
Data Warehouse
Database System
SQL Server
Trino
Hive
Hadoop
Regular Expressions
Tools
Money
Working Smart
Blog
Booklog
Philosophy
Link
Miscellaneous
__ edit




Contents

1 PGA(Program Global Area) 螳
2 PGA(Program Global Area) 蟯襴


[edit]

1 PGA(Program Global Area) 螳 #

  • 覯 襦語り 豌 伎 蠍 覃覈襴 螻糾
  • 螳 覯襦語る 襴曙 螻糾(覯 襦語る PGA襯 螳讌.)

Upload new Attachment "PGA(ProgramGlobalArea")/pga01.png

  • Sort Area ORDER BY, GROUP BY煙 蠍 螻糾朱, 螻糾 覿譟燕る ろ襯 蟆 . (覃覈襴襷 :"覃覈襴 " 企 覿襴)
  • Session Information 豌 蟆郁骸襯 蠍 User Process 語 覲
  • Cursor State SQL Parsing 覲 ル 譯殊襯
  • Stack Space SQL覓 Bind Variable 蟆曙 企 Bind Variable ロ 螻糾

[edit]

2 PGA(Program Global Area) 蟯襴 #

朱誤
  • WORKAREA_SIZE_POLICY
    • MANUAL SORT_AREA_SIZE 朱誤一 螳 譟
    • AUTO (蠍磯蓋螳)
  • SORT_AREA_SIZE
    • 螻糾 蠍 れ
  • PGA_AGGREGATE_TARGET
    • 覈 語 蠍一 れ
    • れ 螳覲企 襷 PGA襯 蟲 蟆曙 覃覈襴襯 麹讌 覈詩覩襦 覦

覈磯
  • V$PROCESS 一危 襴 觀
    • PGA_USED_MEM : 襦語り PGA蠍
    • PGA_ALLOC_MEM:襦語れ 豪 PGA蠍( ろ 覦讌 覃覈襴 )
    • PGA_MAX_MEM : 襦語り 豕 PGA蠍
鏤
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

覈 殊 襷れ企 蟆覲企 覿 蟆 蟇語 蟆企.