来源：蜘蛛抓取(WebSpider)
时间：2015-07-12 23:29
标签：
一带一路是什么意思
403 Forbidden
You don't have permission to access /
on this server.Oracle内存结构（之三） - 推酷
Oracle内存结构（之三）
【深入解析--eygle】 学习笔记
1.2.3 PGA的管理：
sys@felix SQL&show parameter area_size
------------------------------------ ----------------------------------------------------
bitmap_merge_area_size
create_bitmap_area_size
hash_area_size
sort_area_size
workarea_size_policy
自动化SQL执行内存管理（Automated SQL Execution Memory Management），也称为自动PGA管理，使用这个新特性，Oracle可以在一个总体PGA使用限制下自动管理和调整SQL内存区，从而大大简化了DBA的工作，同时也?高了数据库的性能。
为实现自动的PGA管理，Oracle引入了几个新的初始化参数：
（1）PGA_AGGREGATE_TARGET 此参数用来指定所有session 总计可以使用最大PGA内存。这个参数可以被动态的更改,取值范围从10M& ～（4096G-1 ）bytes。
（2）WORKAREA_SIZE_POLICY此参数用于开关PGA内存自动管理功能，该参数有两个选项：AUTO& 和& MANUAL，当 设 置为AUTO时，数据库使用自动PGA管理功能，当设置为MANUAL时，则仍然使用之前手工管理的方式。
缺省的，WORKAREA_SIZE_POLICY参数被设置为AUTO。
sys@felix SQL&show parameterWORKAREA_SIZE_POLIC
---------------------------------------------------------- --------
workarea_size_policy
此外需要注意的是，在不同版本中，自动PGA管理的范畴不同：
（1）在Oracle9i中，
PGA_AGGREGATE_TARGET参数仅对专用服务器模式下（DedicatedServer）的专属连接有效，但是对共享服务器（Shared Server）连接无效
从Oracle10g开始PGA_AGGREGATE_TARGET对专用服务器连接和共享服务器连接同时生效。
1.2.4 参数的设置与内存分配
工作区性能期望实现如下目标：
workarea execution - optimal &= 90%
workarea execution - multipass = 0%
生产系统的PGA性能指标脚本:
SELECT NAME,
(VALUE / DECODE((SELECT SUM(VALUE)
FROM v$sysstat
WHERE NAME LIKE'workarea executions%'),
(SELECT SUM(VALUE)
FROM v$sysstat
WHERE NAME LIKE'workarea executions%'))) pct
FROMv$sysstat
WHERE NAMELIKE 'workarea executions%';
&strong&sys@felix SQL&select description,dest fromx$messages where description like 'SQL Memory%';
DESCRIPTION
-------------------------------------------------- ----------
SQL Memory Management Calculation
15:26:04 sys@felix SQL&&/strong&
sys@felix SQL&select * from v$
VALUE UNIT
---------------------------------------- ---------- ------------------------
aggregate PGA target parameter
aggregate PGA auto target
global memory bound
total PGA inuse
total PGA allocated
maximum PGA allocated
total freeable PGA memory
process count
max processes count
PGA memory freed back to OS
total PGA used for auto workareas
maximum PGA used for auto workareas
6313984 bytes
total PGA used for manual workareas
maximum PGA used for manual workareas
over allocation count
bytes processed
extra bytes read/written
cache hit percentage
100 percent
recompute count (total)
19 rows selected.
1.2.6 PGA调整建议
伴随自动PGA调整功能的引入，Oracle同时引入相应的动态性能视图用于优化建议，PGA的优化建议通过v$pga_target_advice& 和& v$pga_target_advice_histogra提供。v$pga_target_advice视图通过对不同PGA设置进行评估，给出在不同设置下的PGA命中率和OverAlloc等信息。
15:32:23 sys@felix SQL&select PGA_TARGET_FOR_ESTIMATE/ PGAMB, PGA_TARGET_FACTOR,
ESTD_PGA_CACHE_HIT_PERCENTAGE, ESTD_OVERALLOC_COUNT
from v$pga_target_
PGAMB PGA_TARGET_FACTOR ESTD_PGA_CACHE_HIT_PERCENTAGE ESTD_OVERALLOC_COUNT
---------- ----------------- ----------------------------- --------------------
v$pga_target_advice_histogram&
视图可以通过对不同工作区大小的采样评估
供统计信息
供分析使用。其中几个重要字段有：
LOW_OPTIMAL_SIZE-Histogram
评估区间内
HIGH_OPTIMAL_SIZE-Histogram
评估区间内
ESTD_OPTIMAL_EXECUTIONS-Histogram
评估区间内估计
ESTD_ONEPASS_EXECUTIONS-Histogram
评估区间内估计
ESTD_MULTIPASSES_EXECUTIONS-Histogram
评估区间内估计
ESTD_TOTAL_EXECUTIONS-Histogram
评估区间内估计执行总次数
SELECT pga_target_factor factor,
low_optimal_size / 1024 low,
ROUND(high_optimal_size / 1024) high,
estd_optimal_executions estd_opt,
estd_onepass_executions estd_op,
estd_multipasses_executions estd_mp,
estd_total_executions estd_exec
FROM v$pga_target_advice_histogram
WHERE pga_target_factor = 0.25
AND estd_total_executions & 0;
&img src=&data:image/base64,iVBORw0KGgoAAAANSUhEUgAAAgkAAADNCAYAAAAyhONzAAAgAElEQVR4Ae2dTWgc17aoVx88upMTOAQeGIOu3Z1jCw3ujcADieCTBEdIujKdy40mlmODsRRP0poY22BwCww5QZNWJo5lDHFiT+R3X0T8JKGYY8sEaRBw7kTITrptGnwFDw4HfHi86em3V1Xt6l1Ve9dP13/16kSuqv271rd31V619q6q0oP/fNj5j3//N6AfESACRIAIEAEiQAREAr8TD2ifCBABIkAEiAARIAKcABkJnARtiQARIAJEgAgQAQuBA3j0P//X/7YE0gERIAJEgAgQASJABA78v//7N6JABIgAESACRIAIEAEHgdKbN286jlAKIAJEgAgQASJABPqewIHV1dW+h0AAiAARIAJEgAgQAScB8iQ4mVAIESACRIAIEAEiwAiUOuxHJIgAESACRIAIEAEiYCdw4O9//7s9jI6JABEgAkSACBABIgD0ngTqBESACBABIkAEiICUABkJUiwUSASIABEgAkSACJCRQH2ACBABIkAEiAARkBIgI0GKhQKJABEgAkSACBABMhKoDxABIkAEiAARIAJSAmQkSLFQIBEgAkSACBABIkBGAvUBIkAEiAARIAJEQEog10YCvlL697//vVQxCswuAWq37LaNl2TUdl6EgsVngWfaMqRdf7AW67/UuTYS+q+5SGMiQASIABEgAskRICMhOdZUExEgAkSACBCBXBEgIyFXzUXCEoH4CLx48QJ+97vfGX8v4quISiYCRCA3BA4EkfStt94KktyS9s2bN9rxW2/9F7x586+WODogAkQgXQJoIAwODhpC7KUrDNVOBIhAZggEMhJQatlHI/EjUWhAuMVhXjQQ+JYMBQ1F4f558bsXcPQfRwunV5EVkhkIe3tvw1Fqxtw1+1tvNRwyv3kz7wgrYgCOQVtbW/Av//Iv2njkV0d+A+s3PU+H9fWal5eRh21gIwGVsn85stHodky3ODQMsuJJkHlF+qHB4+yUaCDAXwFesP+O/iGaEQYHsKC/oz2MbknVI+oi9kGx76nCxbxR7aPeAwMDRnG6BwENhLffjqoGazlcN1Ffawo6Ckug07luFlEqLZj7YXd42wUtJ+62xvGnXq9rYv3pT38yB27ZTaso+9OnTwHT9/KTsbCHxa13L3L3kqcnI6GXirKUBxsTLU77D8OL0rB23eI+5gaCVs9f2Qjzh2hqfJuNVn/9K7M88Me94fqR9V/DQ47pe/klVY9dNryQlUole7DmlZOFOxKGCNAMI8a0vdfWDIV/+ieAuAwEfgFl6rKbjDfanR6dayEaT5JVZ1xn/Sk6w8BezV/+8j/gww//D+z98os9ynI8+O672rWUt7slMuIDNBCwL2Fdjuu6cW49lVzvHWl9yoX12M9bPUwv4OnTrZ6ND58iJJqs74wEu9XJaWOHwc6G8fPz/eGe47qH3VoMhLCF2fL/4Q+6taEZCmgIyAwFwUDg6W3FeB7yfHHXYxdEZQiowu35ez3mBgLi3DMMBYCuBwE5cCa91oH5+CCh39WhMdRh7zYpmRdZMhTC0O3mRc5ZY8nbvitlvHt2/dFTsMWu6dpPYiT0Io1uDHRgYUFtiG1t/cksWmRgl89MlPGdvjMS0BBAgwDdTGKjYWPy8KiNBNGV3YsrPMt9yGEgMC/C0aMRuREMxflgJR3AIzAQON+k6sH6xIsHP8b+qArnMkaxtRgIWCA6atABo3lsdM9N2H7K9UDPARoGALqBIG753Zh4HmLqID/x3PKbL6xuYj1/+9vfIjGmxDK99uXrDt5o2eRx6dz0cK+Dlz5xxfc6leAlDxoIfsrGcwB7PpoTda9CMxwf2EjANQfiGgRRN7c4nq5/Fyxq92wcQyG2SRgIHJR0AI/QQEi6HqyPD5K8br5VhfN41RYfX/zHP/6hitbCf4dPMbD/9vb2NA+CZiBgDE4Rsf/REAs7iGoXR806cBoGuvcXw/GnbzF9r4YCnybSn8zgrib5FnXudTpKl9f6LxoImuHKgnn/tKaI78i+7oAbZTgc2ePikyIbJcv6jiwsKmnRQMAbSq+fZh97JcpBfGAjodsZndq5xf0XuxCIv381HokUw2g/PwSSMhCUd4qGgYDE8ELNL9Z43Msgl1Q9KB8/T+xTCm7hvVz07EYDGgjafA2zVwfZHAMOmroHQTcQGMSe2KFO4g9lRd3EKQa7B0FMj2lR91505IMz6uJmKHADgacX6+9lnxsIWKfGkRUSVdlu8uh9pO5Yd8DZoSchzjUJbrJlIY6fQ16ycF5e6WTx3OOMcX7rk5WTl7DARoJ+4lvVQw8CwnKL82MUuAEP06hcWl4+dxXxYx4vhoetTzXoiOG9DGZcVr4Vy+Nh9m2v9aAhIHucMSkDAfXgd4qaTuiMUf0Mo6HXO8Wk6uF9zu4tEC889jhUGfP56ZPcMMAt/sxjwUAAjRUbVNGj8FduKERjIGCdKCvXQb8miB4FTOH88fR+dLTn5oOzylCI00BgKzo04yQJQ8FPH+iXxx3tfYCfV2xhGcD16/Zo6zGbLuDpe+lvOE7oYwX3FSyw8lm9Efy4XLKiepFVVk7QsMBGAlbg9pijWxzmdXsEEiHIIEUBB8v14yJCGfGH6cPXax/VxGNjVNOrC/mvWK69qN7q4YbAi7ethgIPN2uJYQ2CWTbb4QOA5ilAVWSqGiriQM/Ti2X42ef54q7Hjyxh03ADwVoOguMA+RYdCdGsQRDrwvOGexL4Fj0JxkJzLSmG4083Iliscdzrecfbz24oxG0g6B0yekNBvrbAe92BPF+0axJwrQE+veD2wzRJ/bQxw49xwAVCIwL/DGMh6HU+yDjCq/S7RVk0fWwZgspoyx7qsCcjIVSNHpntkKKEY29cXMTIf+I+Dwu/NUYvrSB+kQ5fqrMEsR5nbE8hxlOH2nsPDEMhaQOBy80HAOkAbqgexkBIuh5en7jV70zEkOj2daPBMAxwisGwtNgkDduPzoPAJcaLHPcM8C3Giec2Nw4wXNznxgKGB/3xfsINhaQMhLgMBfvagu7ggesO6iaeUqkuDCzJrElI0ggwFe2THfE8QZWjHAN7QZg5I4FDwRMiajhuF2K3uF7Aii5+cUpADO+lXHueqMszy9cWshmWAtugR8Fc5GYmSm6HDwAWQyFCA4FrklQ9ssGQXxxkcVy+Xrd/ZV6Wt3FqwWYg/KGHF095yYB6oA7cQOBGgKiXuM/L4+n4cS9b3n5JGwhxGAr2tQX8eqivO6hb8Fjj0P0d7w/fleD1S9SQwBs+/udjukFL66VAivH8WsDbNUVRIJNGAgKJA47oSUCjAI/5FusU4/G4n3/4GKM2jfmsFSl3HABwDTUGDhUXgQ7HXFXQ8fPHm9Yl/n++LdOE8XZqutucACNENBLykOAwFLFmUXdUXd+N1wFAaBroXzX95+fOtMETxE63MsGxof+s99i+nD1C9bW8BvnGRxXCO3OJ4mzi1/yZLXdETkMqCBgD9uKOhH6n/F9OpUqcbwa0GqQrDKAxsJbo85usWhoml/u8HuLeBGATcW7PHRNg6/qERbapylOQwFXlkKBgKvml948SIch4GQdD28viS2yItB83xMMqwseHFLy5PAZef9hB+H3cbmsQsgWNfIqjtypW0cOARKOiDooM/TRyJn3VKKqmhu5FkS5+AgsJHA7wRkurnFYfo0v93ATzC+9kBmEHCjAdNEacVl4QIjay8/YQ5DIUUDgcvLBwC+5eFht+K0kFgWGiT8TpKHh2lTmaudlytu/aYT8/D3JIiLF8Uwvi/miWPfbihgHfwcxP04PQlYflF/OsMG49ddwW+fliiq7q568ZGZb10Ts0iejm+90gvx3bGju/gWz1Vj7S0ruq796bF6Rh4mFJOb3QNBJHUbOPE9CH4ec0zzZUriRYp7D7hhgBywIfHnpqeWoM/+MQ0FpjfuZ+EXtYGAOml32jEr57dv+U2nEheNAf74I0+TlIHA60MduEcBw7jRw7c8HW2DE0jDMMD29LoRFKcZ/KxbCK65M4dFLr+DfohrPY4ZdiPXfnzdti4C+3zYc9qpeTIhgYwEFMntEUaZyEHTy8qIMow3lKyz87go6ytKWVkxDuLkGYfhEae89rLtRoD92J4+iWM8p7hRQOdXNMTTnFrIahtyuWTXdRl1nl4W5xXWi1cgTH1e8sQdH8hIENcUiIKJ3gGeRozPmqGAsuW50US2tE8Esk6AzrWst1Bx5Iu7r8VdfhZbIpCR4GdNgWgwoMJZNBCy2BAkExEgAkSACBCBrBHQ390aQCq7EcCzqtYjqNLzfLQlAkSACBABIkAEskkgsJGQTTVIKiJABIgAESACRCBqAmQkRE2UyiMCRIAIEAEiUBACJbYQg3/KqiAqkRpEgAgQASJABIhAFAQcCxcf/eWnKMqlMogAESACRIAIEIGcE3AYCajPf/z7v+VcLRKfCBABIkAEiAARCEsg0jUJC+z73HH84io3Dln9lonfuej1lxUeRdBBbIOi6SPqFuc+cVPTJTZqNjyGGHES4bZxcZR6EriovVbaaz5er2obV7mq+pIID6rT6uqqKVbQvGbGiHeCypFFHUQkRdNH1C3OfeKmpkts1Gx4DDHiJMJtw3CU1RypJ0FWAYURASJABIgAESAC+SSQUyPhEcyzD0rhe7r530c3X1la4NE8i5t/ZAnrHryCmxA3FoeoUxp2Y/mzTox3lqvUy6lCF1hItjDej8CG4JuuS4yo85WGSVlYX5rom7Zke1J6tXK5uFCmxntpUW/ugkfiW1mxvF8dgFV4fZ0YY+xHqGPsX0ToaU95gF7qXvfc5Zl7Xcuslrq8uqv3T7kLo9LfaGjnLrmiVto9V0LSJuNUb/ZIFZhX938iF0beR+yy8rDrXmiP7LXm/R5p6gfz0Pz2qRrjeeYfh4r8phwhGsfXlNs5ZjJYtrJqZGANI7DF7+80b7BgO/T/vHi4S4iNnAs7p2Dc3uLzoFTG1TehV8vdfO++Rpgk12pTzZ42AM4J5Rvlo0N/cmeUO8v8PH379oMBUGuB+fgm0/0QaArXMJ7HjKfnGQyrgnG1KsW7MHP8P1m1+h61dqD4388krDg9uoOw8UfjXb5+iJorY1t+e738LHQDx4M/gov7VlTOxb6AuujjZNMEJT5E4AH7Bj77Ztf/ggtP31P6I9v3jyAwavvehtuHm2vY+nK+MsXAFc/0w1mz3MhVqZdmZBRnrjFikUrPGU2rB8el11Xman71dWfbep3ZRX7li1RDIfdelPpP5Zz1ei/JxvwYPAqfMUvtdoY9QV8bY5bEpmRjMt4FQM4aZE5NhKk+miBrza/B/j4c/j8Y7AMdow43PzsKgw+MBqOF3H4IlzEC7jrj+Vd/AbOPfgRzHZlQ9XFr/HK+pV2N+jIfnKSGRt70OqOt44k8Qb4kPnIH9lJ39I8KSgLshv8gun0Kx9qX4GGc0wwwuIV2mfpvC3F9kBDrwGeTemzhliSvfwVfj7+RzBNLl99zy7JSWiwq+7xb9bk/U5L7qPtbcUevngJzv38PQj2oS1FiofETQ0/MTa6CIOD9usqC3+0Bt+cYzdmCilT71sJM5JhOPn5F7C3aHitv2Lj0CXjZkeWWAvj17hexitloYEjCmgkdAe1w2OalWAOgGwEhO9/PgeTvYwiqryHx+Dj4wpDAE+c4x9DauOrH5lRfuADg87uj2NlGDQHoJfw68+DUM6cjRCiLQOfJhFmQMPx56vwmXJuyGddWr/7BkQnkCWnn7a3ZMj4AXFTN1BSbAwJ/vj5JebJEm+M0CDdgy8+n1TLmHZMwoyk6rIbgq8//h4+++gj+AQe6B4yaUIjUHUOu+WJIS7HRsLPcPXd7pyvOU2GYNmwpw3MlgHQoCfexQUFqsz7c/fGm7nqTbnWJuHNj17WYlAhAqb3lPkwlAe5/Mwg0NidhMlzhuGj3SFMJnR3LrAz5/M/gW9UKgu66fOh2B/Euc+A5anq6TlcrJ9POzEvwBt9mgrXtJj9tuc6XDIKfKypeHtbQ1/dXEzXqDXFIW4mCsdOymw0efD6IBio4jXXIa8ekGzfSpuRrH6dA3pU2OWWGVT2O1VFHuU5rAAdQ3COjQT5HI4+1TCmz1mzf9GZcNWcCGIEfw4xZ63Mexy6U/aGXJ7u4BhaU1akD5nNdQloEAyWNXZsFkKbqkl2PYK1TbU5ezb/fk6mF4YJuh2++COb47enDVieqp6ew8X6xWkQXF+B6xGY+/GTMIaC2O8kQgp8rLFivu7F6d2rg/AgbaNWE5S4WdtLPEqZjSGKP9d5Wn0rbUaq+nGBMluQdG7QXPvTbVlFHuU53M0Z916OjQQZGn3xzM+4qMu4E30XF9Nw17mXi1ZWJA9T5dVcQhJ3PLqWvtiDxbBuZV5/L1u/MhvrEh6xBYrnjLkYbarm182MrkdgMA6zKZFU13v00iC2PFofOW5dOGpLojxU9TuewW/bWxZZiYYMLyiDW+KmbpQ42Yi1Yv/CacpHuEj8C3DcGGtpFQOfWE4a+0kxsuvGFhJ/gqwan8MXICxitKfjx6pzmMcntC2WkaCtAfgCfuErx7XtL/DFce4aY3dwl/CJA9vdG1tBepOvOlWC53m52xgTskdX3r2KviOpO15zLV39zPmEhbKOqCN8yqyd8FfhE6aK6RHBQfibq3A1i+sRNEwnga0DYlM7YntEzS+G8thFtWs34hqQn3t4ckTvd4MP3AZ1n20fg4qxFEnc1FgTYyOKgP2L3RHjReNj7rkV4zO2nwojkYGxbkN7MouxYwve9zyffOPncC/jlVh3uH3XNy6GKzr53I/WvoHjH/9iTDXw+nHK4ThcZSu8GifZPBB7FAUfO/sI1zPwJMeZYfEjP3DZYt4H7DFI5qXgv3PsSYkf7dNLPJKZDp9/sQjvssfKxmJ34+quPXbKar/jX/yiPxbqS2aDEV/LoZWA847MCQNJrUfQ5Vb/y04y9uzgN5iA88QphrK1PVDvxmF1KcnGyNqkDL+il4sLcu4BvOk+LsNDJVuxLP0OzTObr7aXVJV6kKgre9hZ68vETW+WlNmIfeMkuyM+DlD27IhipiT202bkrP/Sr+/C1UF2rvNrE/NmXDr3Fnwyz9atNZCJM4/26H2Y8Soi1I5PReNXIPkHnoK+3rHBHj+7fv06BM3npUtc5XrVG3f873//+8Cs8JXG7XY7Fs696FsEHUS9i6aPqFuc+8RNTZfYqNnwGGLESYTbhuUoq71QngSZglkOu3v3bpbF8yVbEXQQFc2fPvi2NvsTIOfYy5rcpiJEjaPZJ25qjsRGzYbHECNOItw2Do5kJIRrk1C5q9VqT/nRs5KVXxF0EFnmTx98pJK9bEVUIoV94qaGTmzUbHgMMeIkwm3j4FishYvh+FJuIkAEiAARIAJEQCCgXJOwsLAgJKNdIkAEiAARIAJEoKgEcD2h7KecblBlkBXCw9Cw6CUfz6/alkol6HQ6qui+C3/69CmcOHEi13oXQQexAYqmj6hbnPvETU2X2KjZ8BhixEmE2yJH1U9pJGCGXp9S+O///m9VfRROBIgAESACRIAI5IRAoDUJ4vsBcqIfiUkEiAARIAJEgAj0SCCQkYB1RG4oPLkChw5V4U67Rw0yl60FS6MlwCmSUmkONqTyiWlKMMcTtZZgVMtn5B9dgpY0f4yBG3NM7lFYMisWZRX12YA5U1YxPZNNKyNFHTQ8XvLZZGYtJddH1F9oqxibIHdFO/oMaiByE/tN7rSLQWBi4w2VGHkzsqWI6TwMbCSgWFEZCneqh+DQJsBpm655PmwtnYX5oXVtDUWzsQsTpgUgaLWxBnC3o6XprM/C8oR4EZ2Fdbb+AtdgdLZrUBayxb/LTszVXRgRKlLpszE3AbuNpqEnwPxZw6BBQ2diFxrNtHTQhRfl66wPGfIZF55VgFlBR9wV0zfZ84SmPq5tZSukDw81g1jCU9Vv+hCRQ2Vi40DiCCBGDiSuAXGehz0ZCShtFIbC+dXX8PrPY67K5y1ybWUHZqvjmtjlyWkYWV51ehPGa1Djo/94lQ1Yu/CbeeeeosYbi7AyOA1DpggtkOuzAavLs3DNUKJcuwazOyuwxnTYWJwHaNzt6meWlezOb7sjMD1pQK4MGoZPGWrbzHi5VbUJo9YHstpWNg3SOpTzVPWbtKTMVr3ycypbMqYtDTEK1gJxnoc9GwmoQhSGQjAU2U+9tzMCgxVDzvI7bMD1MABav8HuyDTw8QxgGSY0N77dHR637uwu+wawgf8doaIm+NOnAoMjO7DXxMGWDc6waEy3pOeer11j3oMKemjYNEJlHoauBfHKcH0EFLjraCtbPB0aBPz2m/4E5u+c6k82XGtixEmE2UZzHoYyElB8MhTsjTgE73AvgT3KccwG5rPCAFauwbYx1aC5vLVBzpEpngDmRZgfqoLuAxGrkOmDg+gy3OALFzDvTjfPClQVUyndNLHvjV+CBpNxojTBzK5ZMJw7imrd9dEz2dpKURIFcwKyfsPj+n1LbLx7ADHyZuQnRXiOoY2EN+yVsPQTCXh4DoSkG3MVbf3CLefIDJoL38sLIZQVdnfpBltHcEkiiFQG5ra/22AT9xXdY7A6yAbkrgdletIoxxioV/nCzLBCBsi/NFqBvWvGuoh1YMaCuO7DXpC7Ppjara3spdExEvB/HvQfL2Lj3ebEyJuRnxThOYYyEshAcDbSoGXVH5tKYBMOMs9Ca2kUJoAtcJRZCM5iYw/Z29lhYz4+kYB33riP0x14hy1Uje52ro/g9ehcAljZkesJbDWAOf0iFBX37t6O4D3QjBWPk8VFn6y1Vdzswpfv0m/CF577EpTnVO41i04BYhQFy2jOw56NBDIQ5I3I1irC/KJ+69xaW4GdWe7Cx0fsjHUG7FGVyso0NF0MBFxtv2xZqyCvL6rQW/yJis46c86PsKcTttniwzKo9eE162545oZgUxXjUJ1lBoahP1vFyKYhVMYDzx/XdhlMD0ZrzcWIsdcv6sPifLSVvQQ69tNv+peS9znVv2y45sSIkwizjeg8ZIN9R/x78J8P2dN3+k8Mx30mrvZnD+fH9Xpdy/j69euOn7/6sF4eLxeG652fJHkxPj+/ZqcxYug10ug0TcHXO2zw7TSaQrzBE/WbXbeFW/KahWg7W1tb1oBIj7icvFBBLlMmTNNtuxH2vGP3J6TX9O3GiHvx6sBqajY6zAli9tlZ9lwpC+y2DY/TdFLpI0mvtZWoib4fuz7OKjMRYvZ1C08UTWBn9hunyP3Jjdg4e4I9hBjZibgdx3keKj/wxAYux2uZcZEiMwgwSvrDTxjjtxuifi3zoUOHtIVw0kr7MLAI7ysvgg5i1yuaPqJuce4TNzVdYqNmw2OIEScRbuvGMdB0g5uBEE5Eyk0EiAARIAJEgAhkjUAgIyFrwpM8RIAIEAEiQASIQHwEyEiIjy2VTASIABEgAkQg1wSUaxIWFhYyoxhbEAlsgVNm5CFBiAARIAJEgAgUicCJEyek6iiNBGlqj0A0LHDhYtQ//KLifmc/6mJzW17zaRMqJ/i7n/OpRhF0EMkXTR9Rtzj3iZuaLrFRs+ExxIiTCLdFjioj4YBb0X//+9/dopVxUT/doKyIIogAESACRIAIEIHYCNCahNjQUsFEgAgQASJABPJNIGUjoQ13qocA34OAf1ee5BumLn0bbo8ehIMl/LsMj6UqiWkOwmX+bYPWbTil5TPyj96GtjR/HIEKmZgErvpsXGZ6noLb5qeuH8NlUwcxPA6ZfZTpkE+lj4vcWhlptIkP/bKexME/6wInIZ+qDyZRd17qEBkJ18i8iJ8lOUNev9I1Ep78BaDxGtjbGeH1t6fh/qdXIO92Qnvpc6gPfaetodhuPIczcxIzYeMRwN19Lc3++gzcmxCNiRn4jq2/wDUY+9sXYCCpzqaQyV0fdiKvPodhQcbHc2fgeWPb0O0Y1M8maegIgmi7TvlU+ohyb7NvV5lyo+E28RzqzRTaxK5O7o6d/HOnQgwCq/pgDFXlt0jF9Si/CqUkeQTXr3SNhPfPw/kBA977Y3AaXsCrdkowI6r20cozmKl+oJU2MDkFw8ubTm/C+AW4wD8nPT4GM/AcXpp34hEJErQYqUxtcNVn4yY8HJyCY2ZdbXi5OwxTkwN6SKVsMSDMZEntSOST6/MYNpdnYL6myz1Qm4eZnYfwiLXJ48U6M2S/6rZXUrIXoR4H/yIoFV4HeR8MX26hSpBejwqlYSLKRHH9StdIEDG1X8GL4Sn4cEAMzN9+a2cYyvzBg/IRNoB6GACtl/B8ZApOcqMB7sEZzV2foqvelOkVqPVhd4k32MesakeERhqAC9eY96CCnhHmvq/U4di1BL0hgiSA0yQO+dz0ETMfhvLIM2g10XhgRg/cNKaPyO0pUnLfl/F3z9Evsepzql8IBNTTvB4FzEfJI7l+ZcRIYGsT5utwtHY+Ofd6bB3oGBwxB3yvStiF9KwwkJYvwA/GVIPm8tYGW68yoo63ycTMHKk+7C6xPjQGus9EkGH8ItRH0NA5w8ydGRgbF+KS3FXJJ9UHjYJ70Fhq6xJi3p2usA9hTDE11E1DezYCSv62dH15qDin+pKFl9L265FXeoq3Ewh7/cqEkfDkyntQP/ot/Pl9u3p5PPbwHAgqPZ4b1dYvfCkZSDWXt5cXQigrql2nTDJ98C6RzdNfspsILHx0FFrXjPn7dWDGgrjeIiopvcuRy4f5ZPowD8jdOnOLjOoeg9UyM3S6HqGpSUNPwwDa5AtNvcXo2xRq/n2LRFBc1geFaNo1CTivR2YU7fgkEPb6dcBnPbEla9+pwqfwLbwuhoXA7kgFVOgmY3euYxLPQnvpFJwBtsDxln2gFfInvOuUCe+wBSFMfV7B5s4zuFc5CHUeXTkF0Jxn0xOC90AbVD/X1lt8IGHAs8axbUnl+0qhD0qAXpwLuii42KdyDOaZzM6lIiaKvAIAACAASURBVF3jIQ65i1KmnP8PtLaDNbD8nCpKy0enh/N6FF3Z/VtS8OtXup6EJ1fgvYdT8FNBDATseCen2cr4Rf2JhvbaQ3g2y13y+Iidsc6APZIyujIF2y4GAq62v2dZqxBzt5bKNKDQ5wP4kj+B0fmOTSoMs9X/fAC4B+addusRPNxJx7Uql0+lj8hWd29C4yKbSvkAxmafme0J2jREOvqIEuZhX84/D5LHL6P6GhF/3bmpQXo9yo30mRE0iuvXgTS1ubN0H+AZwHuH6qYYp799netph4HaV1BnLveDJabSSB22t+2eAnTV3wNgc96jpa7eM+vbUL7Bph/4XLiWN7lFf3KZ9uFLT33MpmM7zHho1tldOHungBE8s77vXLcgZkl4X94+aMDhGgr9N8we4fzBeNLhg1vb3fY0jCF7iyasAlWXcwLyPphzpSIWX3k9kkzNRlx1oYqL4vrl+u2GoK9lbjQa2rcbon4tM75oib7d0O27RXhfeRF06LYIm2kpwPc0RH2S2iduatLERs2GxxAjTiLcFjmqvt2Q7nRDOL0oNxEgAkSACBABIhAjATISYoRLRRMBIkAEiAARyDMBMhLy3HokOxEgAkSACBCBGAko1yQsLCzEWG2wouv1OmxtbQXLRKmJABEgAkSACBABXwRUaxKURoKvUm2J0LC4fv26LTT8YalUgk6nE76ggpTw9OlT5SKTvKhYBB1E1kXTR9Qtzn3ipqZLbNRseAwx4iTCbd04uj4CGfTpBi5m1E838HJpSwSIABEgAkSACCRHgNYkJMeaaiICRIAIEAEikCsC6RoJ7I2L+A4E/nflSa7YKYRtwdJoCXCKpFSaA/lr/sU0JZjjiVpL7AVLPC/bji5JXgusqDaK4I05JvMoLFneRSzKKuojhgs6cDmkZfHIJLYq+cRwUR9DJofcGzBntomdTRJ65LUO4qZuOY8+qM7YPzHaedi9FprXyP4hEFxTx7XLKEIV7rOGVI2E9j9/Bq9fv9b/vj0N9z+9Anm3E1pLZ2F+aF1bQ9Fs7MKErHdvrAHc7WhpOuuzsDwhDlazsM7WX+AajM52Dco+GzJsMs2wWQWYtRWk1MdVB3YRXN0F8bMPtmLjP1TIp9RHk8gp98bcBOw2mkZbDcH82YQNt/hJxVIDcVNjde+D6nz9FNOqXNLPObwOOq6R/UTCn67y67dhjEqu6/5K1VOlaiQMDAx0ZX1/DE53j3K7t7ayA7NV/d2h5clpGFledXoTxmtQ46P/eJUNzLvwm+XuPXn1a9vsZLxVtVXcAqU+bjpsLMLK4DQM2UpL9FAqn4s+KJxD7hb8tjsC05NGY1UG0zV8EgUYrjLipuanPKfUWfouplzmF0imunaN7DsEgRSWX7/LIA8PVDSkaiSIorbvLMH902OQ969F7+2MwGDF0Kz8DhsoPQyA1m+wOzINfBwCWIYJzb2dBdd2E3zpY9GBWa83AK7V3hGbN919Uz43fWRys5PsGvMeVNDTw9znlXkYupacdyddaOFqJ25qfr7OKXX2votpsQvK8mwV6LMN6TT9gXSq5bW24U71PaizjzzB6aJ8LnoI3hGMYK6pfMsGprM48HT0aYVyDbY7NS1pa2kUKmxweqdzK+WTw0sfmw7sbnx+qAr4wCrzcmXgJ8qHiz8U+qjkHr8EjZEKM9yWWV42FURXKn9tStxcOCn6oEuO/oti5+1oBebxg3ezbPr2Fp14afWBlD0JA3B+1ViTMLbJFjDmf00CeHkOhJbemGMnAVu/IOv/5dq1TExDeOlj1YGd2Dd2oXEpOye0VT6EL/PsqOTWL1R7zIjT1oisAzMWxPUjQmPSroUAXuCJmwWJcCDrg0I07TIChqsc1yRUV10WgROsuAmkbCQI6mlrEl7Aq7YQlsPdQXG1Hrq5FXeu6CmYgKxbyBVw08epA7rzd5h7HlclT7CJE9xPb9rEKZ9KH5XcGD4LxhITNjeKXgW6wPs5LYmbmpLbOaXO1ccxGVm31a8tkB0j4ckm3B+egg8H8t0UbK0izC/qzzS21lZgx5xLw0fCjAGTPZJSWZmGpsyFYKiPq8OXLWsV0uBSBqU+Uh3G4RZ/MqOzzjwhI9BobncXaSapglQ+lT5uci/DqvmI6hqs7JCr2F8zEjcVJ+U5pcrQ7+Ebqxm4FvZvI6S6JuFO9ZC+HkHjfxq+fX0eBnLeFuXaXWgwVytbewgw0oDmtt31jq5tNr/N5toqpXlT29n1JgzeMObgMFTLm9wiOXyERpv/w7qZJ2Ce1y/VR6VDRzp1gkUm/ZMzZvJJ9VFJx4yHZgNG0TNiJJld76S8RkQla7bCiZu6PbyvEeq8/RJjuR7hWiC2Vsv3Uq9+gSToaeFlXr8nYY2v68C0Zngwlq7fbgj6WuZGo6F9uyHq1zLjy5bo2w3dHuH2nu1uqmzvFUEHkXDR9BF1i3OfuKnpEhs1Gx5DjDiJcFs3jtmZbginI+UmAkSACBABIkAEIiZARkLEQKk4IkAEiAARIAJFIUBGQlFakvQgAkSACBABIhAxAeWahIWFhYir6r24er0OW1tbvRdAOYkAESACRIAIEAElgRMnTkjjlEaCNLVHIBoW169f90gVPBq/qLjf2Q+esaA5mk+bUDnB3/2cTyWLoINIvmj6iLrFuU/c1HSJjZoNjyFGnES4LXJUGQmuj0AGfbqBixn10w28XNoSASJABIgAESACyRGgNQnJsaaaiAARIAJEgAjkikA2jIQnV9h3G6pwp50rdgph23B79CAcLOHfZXgsTSWmOQiXzTf63YZTWj4j/+htSB1Jy0WmjctMx1Nw2/KZa4VuUg4xB3rKJ7aPh9zSsmKWP2vFqxiowlF+t7is6ZeYPGJfE/tgYgLkoyLqO/J2UnGRhbtdv+WlO0IzYCSwL0FuvoBhh2j5DGgvfQ71oe+0NRTbjedwZk5iJmw8Ari7r6XZX5+BexPihWIGvmPrL3ANxv72hYy8gdIuk3GRY595nLE3k6tu9sTxHWuGmkQ+Zfu4ys30XX1emD7aC3U5T5d+oFVC3GSslX1QlrhPw+T9rU9hCGrLuXidh/brt1Cgj930jYQnX8PDyhQc9SFsHpI8WnkGM9UPNFEHJqdgeHnT6U0YvwAX+DtGx8fYQPscXlruxrOu6QBc2GZGzK0xp6AZ0U0uXxuU7eMm98ZNeDg4Bcec2vZNiJynSz9AMsRN2j+UfVCauj8D5f2tP1mIWsu5eJyHYgE97KdsJDAvwhJA7fzhHkTPZpbWzjCU+YMH5SNsYPEwAFov4fnIFJzkRgPcgzPalIPdjZ+mvj3K5NAtTR2w7lfgq30scjMr/Qb7aFftSNrC56x+4qZqMF99UJWZwolAYAI9Xr+NetI1EpgXoX50DN4PrHSWMxyDI+aA7yUnu5CercOxa8a0QvkC/GBMNWw3AOoVcRrCq6yY4nuWyaZbTOIFL9arfWxys7vh+tAY6L6h4LX1bQ7i5tL0Xn3QJStFEYEgBHq+fncrSdVIuLP0AuqfFctEAC/PQZc9PJ4b1dYvfGn/UCRLM1Cbz9w0RBCZ3HQTEKSw6+7ZscqNd8PPoX6JTIRgDUXc3Hm590H3vBRLBHojEOT6LdZwQDxIer/57Bncf499LppX/F4V4KdVOD/AA/K3LY8IMqPbmk04jEk8C+2lU3AG2ALHW8UbgLKr22Fwax+n3Dg98QzuVQ52+2jlFEDzh+6aEqG5aZcTIG6chGzr1gdl6SmMCKRJIFVPwp9fv4bX2t+3cJqtHa/n3EDAhjw5zaYJFvUnGtprD+HZLHdVP4bL/HFB9qjK6MoUbLsYCI/nzsA9y1qFNLuJXrcvmXzolp4mA+r2kcr9AXzJnzTpfMc8O6yPkoHgo/mImxsk9TXCLRfFEYFwBHxdvyVVpGokSOTJfdBA7Suo757R3pMgNwTQFXsPYKcOo8I7ES5vsHDz/QoH4cxuHbYz8AikXCYuKzNk4BlbO8He66C900GlW/LNqsttlw+ncWTtkx25kyflr0Y5T1U/8Fdmv6aS98F+pSHXW97f5Gn7KVTORXUe8nD9vTu9jimu324I+lrmRqOhfbsh6tcyHzp0iL7dIJwJRXhfeRF0EJoEiqaPqFuc+8RNTZfYqNnwGGLESYTbIkfVtxvIkxCOLeUmAkSACBABIlBYAmQkFLZpSTEiQASIABEgAuEIkJEQjh/lJgJEgAgQASJQWALKNQkLCwuZUbper8PW1lZm5CFBiAARIAJEgAgUiYBqTYLSSOhFeTQsrl+/3ktW1zylUgk6nY5rmn6KfPr0qXKRSV44FEEHkXXR9BF1i3OfuKnpEhs1Gx5DjDiJcFs3jgfcig76dAMvK+qnG3i5tCUCRIAIEAEiQASSI0BrEpJjTTURASJABIgAEcgVgXSNhPYdqLJ3IOB7ELS/6h1o5wqfTNgWLI2WAKdISqU52JAlATFNCeZ4otYSe8ESz8u2o0ssZdq/HmTdmDP0z4oOAkM3xprco7Bkga7QXyiSdmUEiJuMih4mslFdI9S5+yOGGEXTziJHYawJUHi6RoIm6Gn4lr+eefU8DAQQPotJW0tnYX5oXVtD0WzswoRpAQjSbqwB3O1oaTrrs7A8IV4oZmGdrb/ANRid7RqUhWyp7AaVFQfhiV1oNDOkgwOcnbFxIq0CzNrTuupvT0zHJgHiZqKw7/i6Rtgz9dkxMYqowSM4DzNgJEQEIyPFrK3swGxV/6xjeXIaRpZXnd6E8RrU+Og/XmUD0y78Zrl7zYgyKEZAWTcW5wEad7v6ZUgVtShlqG0zo+ZW1ZkkoP7OAvo0hLgpG97XNUKZuz8iiFFE7RzBeZgBI+E+fKpNN1ThTjsiMCkWs7czAoMVQ4DyOzDkZQC0foPdkWmY5EYDLMOENuVgd3unqBSv2lPWDVhdHoFpWDSnG2SOFF5cetseGTv0T0+DXNVM3CzNFfgaYcndHwfEKIZ27vE8TNdIGDgPq8ZUw0919vXE967AkxjYJFvkELxjDvheNTM399l5GLpmTCuUa7BtTDU0GwDzFXEawqusuOP9y7oCVcVUStwy+ii/Z8Y2/X1URUmQAHFz9oMg1whn7v4IIUbRtnPv52G6RoJAYeB8jX0u+gW8aguBudz1P3WwMVfR1i/c0mcnLNqWa9cyNQ0RRNbpSUOh8UvQGFmGVb4w06Jh+gdBGLvpn74m2ZWAuMnaxv81Qpa7P8KIUZTtHOY8zIyRECWQNMsaHBFqR/cOm3CQeRZaS6MwAWyBo8xCEIrIwm44WYXplywo04MM4fTvocKCZCFu8ob0e42Q5+6PUGIUXTuHPQ8zYyQ8ufIp3B+egg8HooOTRklsrSLML+q3zq21FdiZrYJ+X70BcyVjnQF71K6yMg1NFwNhY24Cli1rFdLQhtUZSNZxqM7umPrDxiLM78iNpJS0sVTri7EP/S2F0oFOgLgpe4L6GqHM0ncRxCiiJo/gPEzVSLhT7b4j4dMXdfipAI9Almt3obE7oS3ckxsCbG7oxjLAzjxUhHcizG2wcPP9CiWY2G1AMwOPQAaVdfxW09S/pD0KecswkiLq9CGLkTPm7JlhBszIqfD3O6jaKqQQfZBd3m/6QHEfKnpfI3wUUvAkxCiaBo7iPHT9dkPQ1zI3Gg3t2w1Rv5YZX7RE327odhq392x3U2V7rwg6iISLpo+oW5z7xE1Nl9io2fAYYsRJhNu6cUzVkxBOLcpNBIgAESACRIAIxEmAjIQ46VLZRIAIEAEiQARyTICMhBw3HolOBIgAESACRCBOAso1CQsLC3HWG6jser0OW1tbgfJQYiJABIgAESACRMAfgRMnTkgTKo0EaWqPQDQsrl+/7pEqeDR+UXG/sx88Y0FzNJ82oXKCv/s5n0oWQQeRfNH0EXWLc5+4qekSGzUbHkOMOIlwW+SoMhIOuBUd9OkGXlbUTzfwcmlLBIgAESACRIAIJEeA1iQkx5pqIgJEgAgQASKQKwLpGwlPrgC+B0H7q96Bdq7wyYRtw+3Rg3CwhH+X4bEsCdOym+YgXObfNmjdhlNaPiP/6O1s8Ni4zHQ5Bbctn7NW6MA0vmzqYM8jhZFwoEJuN/aa/hlrk4SpuVbn2T9U54FrqQWOFPsgsZE3NDGSc3EJjek8TNdIaN+B6qcvoP7Ta3iNX4MswBsX20ufQ33oO20NxXbjOZyZk5gJG48A7u5rafbXZ+DehHihmIHv2PoLXIOxv30BBlz6RBJRmjGzCjBjr0yhw+O5M/C8sW3odgzqZzNi6HD5FXLr0RL2aDxMPId6MzttwlXJwlbVP3ydB1lQIAUZiI03dGLkzUhMEed5mKqR8OTrOvs+dAPOD4jq5nv/0cozmKl+oCkxMDkFw8ubTm/C+AW4wD8nPT7GBuDn8NJyl54dBhe22eB4a8wpkFSHNrzcHYapyQE9faUMw86c6YZI5VaL9HixDtD4qtte6qR9GSPvH23wdR70JTEgNj7anfqPD0hCkjjPw1SNhM37bECBr83phitPBK1zutvaGYYyf/CgfASOeRkArZfwfGQKTnKjAe7BGc1dn0VXvaJRTB0G4MI15j2ooGeETTtU6nDsWvreEIXUAKbcPIWd/WPYXMY+etOYPhKmhngW2koIvILA54GklKIGERvvliVG3oy8U0RzHqZqJKCSD2FMn2r49jTc//QK5N9OOAZHzAHfqxnZvNtZYSAtX4AfjKmG7QZzsmiDrVcZacfbdBi/CPURHGzPMHNnBsb0T2CmLaSkfpvcLuyxj2rTP46pIUmxFGQQCHIe9Bs0YuPd4sTIm5GfFOE5pm4kTH34vq7p+59Bffg+bObeSvA/dfB4blRbv/ClZCAdqM1nehqCd0+rDrjYaBRa14z5+3VgxoK43oLnSn9rldsqj5391KQ+fQSGAbTJF5pas9GRhYD/88CSrS8OiI13MxMjb0Z+UoTnmLqRYFVzGCr/bA3J21F5RJAY3dlswkHmWWgvnYIzwBY43jIGICFbXnadOqB7S/AeaINq+E4aNQ+n3EFqEKaTgmTrq7SHwe950FdYDGWJjXerEyNvRt4pojkPUzUSxk4/g/rXhuvgyddQf3YUDg94q57lFCen2TTBov5EQ3vtITybHQPdDMBHA411BuxRldGVKdh2MRDwKYF7lrUKGdNaqcM9MO+0W4/g4Y7cSEpNG6XcXYm67D+AsVnWR432hI2bUM+aPl2xM7Q3AOrzIENipiQKsfEGT4y8GXmniOY8dH3jorcQ4VK8/+efoF59jy1cxHKG2aOQq2BMPoQrOMXcA7WvoM5c7gdLTIiROmxv2z0FzCV/4x7ADsBoqW5KOrO+DeUbbPqBhWs/LW/6i/7w0RpTpgrb1+Q6CY+kOuzDl806nGLpDhpqzKzvG0aSEZDyJij7gVvb3fbEPtr8IVP6pIxTe9+Hs3+wfut5HqQteXr1Extv9sTIm5GYQn6djuY8dP12Q9DXMjcaDe3bDVG/lhlftETfbuh2iSK8r7wIOnRbBKBo+oi6xblP3NR0iY2aDY8hRpxEuC1yVH27IdXphnBqUW4iQASIABEgAkQgTgJkJMRJl8omAkSACBABIpBjAmQk5LjxSHQiQASIABEgAnESUK5JWFhYiLPeQGXX63XY2toKlIcSEwEiQASIABEgAv4IqNYkKI0Ef8VaU6Fhcf36dWtgBEelUgk6nU4EJRWjiKdPnyoXmeRFwyLoILIumj6ibnHuEzc1XWKjZsNjiBEnEW7rxtH1EcigTzdwMaN+uoGXS1siQASIABEgAkQgOQK0JiE51lQTESACRIAIEIFcEUjVSLjC3n+A70Do/lXhTjtX/CTCtmBptAQ4RVIqzYH8Nf9imhLM8UStJfaCJZ6XbUeXIKNfkNb13pgz9JTIqsWNwlIWFZDKpmgT1oJzZptkVB9JL0w8SMbUrX8kLmCWKhT7muoakSV505CFGPVEPYbzMFUj4c+vX+tfgMQt+wokDE/BhwM9oclMptbSWZgfWtfWUDQbuzBhWgCCiBtrAHc7WprO+iwsT4gXillYZ+svcA1GZ7sGZSFbpnbRoJnYhUZTJis7wVd3QfyMRVZk1wy4VYBZu0CKNtmYm4DdRtNoqyGYP5txw82uVyLHkvZ27R+JCJXZSnxdIzIrfTKCEaNeOMdzHqZqJIgYnmzeZzbChzAgBuZwf21lB2ar+mcdy5PTMLK86vQmjNegxkf/8SobsHbhtyzecbvw31icB2jc7eohpt1YhJXBaRgSwzKyX9tmRs2tqlMaaZu04LfdEZieNBqrMphJw8epTMIhkvZ27R8Ji5e16nxdI7ImdMLyEKMegMd0HmbESHgCm/eHYSrvbgTWrns7IzBYMRq4/A4bKD0MgNZvsDsyDXwcAliGCc29nW3X9uoyGzxh0Zxu6DpMmDV7A+Ba7Z0eenlGsphtUobaNeY9qKCnh007VOZh6FqGvTup4JO19wao+0cqQmaq0sDXiExJn4wwxCgo5/jOw2wYCU824X4Bphr0Zh2Cd7iXwLOdWcOeFQaecg22jamGZgOMwcmzkNQSrEDVOWXCrNn5oSrovpTURAtRsa1Nxi9BYwQNtwlmvs2C4SQKUX7Bsrq0t7R/FEz93tQJco3orYb85yJGgdowxvMwE0ZCUaYa9Eb18BwILb8xV9HWL9ySjKjl2rXMT0NMTxqCGwPp6gZas2ydwiWJQoLeWd61tgnTZ7QCe9eMdRfrwIwFcf1IljVJRja39nb2j2Rkyn4t/q8R2dclLgmJURCycZ6HB4IIEk9aY6rhp4F4ik+41EFxtR66rdmEQ1XiWWgtjcIEsAWOMgshYZmjqQ6nWZpsumUHlislYCsW9F9llH0icVu+doGnycjW2Saoj+A90Iyhs9r6kXFJm2ZEjUTFkLf3NYkMwjScJLafgvxeI/qJiV1XYmQn4n4c53mYuiehfWepQFMNAGytIswv6s80ttZWYGeWu97xUTpjnQF7TKWyMg1NFwMBV9UvW9YquHeSpGOrszumnoCurh10D47DLf5kRmedeUJG2NMP+TAQQNkmy7BqPqK6BiuanknTzm598vYeB3n/yK4eSUqmvkYkKUW26yJGwdonzvMwZU9CG/7y8Bl7qqGR+6caeJOWa3ehwVzUbO0hwEiD3UTbXe/okl8G2AGolMz7bZhdb8LgDTb9wMK1n5Y3u4vkxm81u3oaxoBdU0OTTG3wEUiTMXo8NM6TsCZtkw7cYotDRlk6bE78za53crzeQtchiX/z2j+SYON9jUhCimzXQYyiaZ8ozkPXbzcEfS1zo9HQvt0Q9WuZ8WVL9O2Gbqdxe892N1W294qgg0i4aPqIusW5T9zUdImNmg2PIUacRLitG8fUpxvCqUa5iQARIAJEgAgQgbgIkJEQF1kqlwgQASJABIhAzgmQkZDzBiTxiQARIAJEgAjERUC5JmFhYSGuOgOXW6/XYWtrK3A+ykAEiAARIAJEgAh4Ezhx4oQ0kdJIkKb2CETD4vr16x6pgkfjFxX3O/vBMxY0R/NpEyon+Luf86lkEXQQyRdNH1G3OPeJm5ousVGz4THEiJMIt0WOKiPB9RHIoE83cDGjfrqBl0tbIkAEiAARIAJEIDkCtCYhOdZUExEgAkSACBCBXBFI2Uh4AlfYOxDwPQiHDlXhTjtX7BTCtuH26EE4WMK/y/BYmkpMcxAum2/0uw2ntHxG/tHbkD8kCt2kHHIUuHGZtecpuJ2zT3qrCavaSQwX++9juGz2TYGDxoX3d6Evs57rfR6opSt2DLHxbt9+YSTq6ef8Sf48TNVIeHLlU3hR/wlev34Nr789CvX5OzkcFK3dvb30OdSHvtPWUGw3nsOZOYmZsPEI4O6+lmZ/fQbuTYgX4xn4jq2/wDUY+9sX8vcmSlfdrKzyc8RO5NXnMJwfgb0lVbSTqv8+njsDzxvbRr8GqJ/VDdh25aLeV7G/Cn1ZVY63YMVPQWy827hvGOXgPEzVSHj1YhimPhzQe8w/VwpxEX608gxmqh9oOg1MTsHw8qbTmzB+AS7wDwSNj8EMPIeXRblDLaJuGzfh4eAUHPO+tuUnhbSd2iDvv49hc3kG5msDer+uzcPMzkN4xPrsQFkP0yK0vox7qnK0VH3/j5xx32OxAOgbRjk4D1M1Es7XmPfgvSvwhP135b06HK2dz9+ds6VrA7R2hqHMHzwoH2EDi4cB0HoJz0em4CQ3GuAenNHcuoJL11ZHbg4duuVGckFQ5kW4wT7aVTsihBVs12ynVz7772EojzyDVtPKob3UgHuzY/AB+C3Hmr9fjgJfI/oFjKBnXzLK6HmYqpEA738G9eH78OmhT+E+nIax94VektvdY3DEHPC9lGAD0Nk6HLtmTCuUL8APxlTDdoO5dCviNIRXWVmLt+mWNfH8ysO8CPUhHPiK+rO3k6z/olFwDxpLbR0CMuEfIhPWHozuzcP+LU5KVk5RGQbVi9h4E+s3Rtk9D1M1Eu5U34Nmja1H0NYkADMW0KuQ95+H50BQ7/HcqLZ+4UvJ5xMH0KXr5YUQysrarptuWZPVTZ7bN55D/RIf+NxS5jPO2U6y/jsAF+7WmTtlVF+Qu1qG+gj3mLG4bWMNTXVTWKwrKyefjKKXmth4M+0vRlk+D1M1EprPBO+B5lV4Aa/a3t0nyynKI4J06D5iEw4yz0J76RScAbbA0bzzEvLlfLdIurV2njGPDq7eP8MmgnC/ANNARv9ythN6DITOJ/Zfwcu1fwng4Y6kX5vra1zKEYrv110l434FItG7nxhl/TxM1UgANsmwyV0H7b/Aw2dH4fCApMfkKOjkNJsmWNSfaGivPYRn2hwtKoCPrhgDDHtsbHRlCrZdDARcTX7PslYhJxB86JYTTTQxv+RPmnS+Y56dYag3f+guOs2TInZZpe00AOr+ywvQ3aLQuOicgtnYNPqsn3J4ef239Wbcf0zsGvcNoxychwfsjZPk8Z9/b7Hq3QAAAYVJREFUqkP1PfaOBKPS09++hrwvSxiofQX1UXTLMqVG6rC9bXdVs4vsjXsAbE53tFQ3cc+sb0P5Bpt+4HO9Wt78PQIp120fZFMqpvK0kzgBZTtJ+y8auOhJ0X/D7FHIH7QnHVhfZn3d7LPMjPquY/RZaTmJq5nJCr2vEZkUO1Gh+oVRHs5DPR0L7dEPVrmfFlS/Tthu45WoT3lRdBh26LABRNH1G3OPeJm5ousVGz4THEiJMIt0WOqm83pDzdEE4xyk0EiAARIAJEgAjER4CMhPjYUslEgAgQASJABHJNgIyEXDcfCU8EiAARIAJEID4CyjUJCwsL8dUasOR6vQ5bW1sBc1FyIkAEiAARIAJEwA8B1ZoEpZHgp1BKQwSIABEgAkSACBSXAE03FLdtSTMiQASIABEgAqEIkJEQCh9lJgJEgAgQASJQXAJkJBS3bUkzIkAEiAARIAKhCJCREAofZSYCRIAIEAEiUFwCZCQUt21JMyJABIgAESACoQj8f1SS7j6DD8cwAAAAAElFTkSuQmCC& alt=&& /&
1.2.7 PGA的转储
对于PGA的进一步研究可以通过转储进程内存结构来实现，Oracle?供如下命令用于将进程内存地址信息转储到跟踪文件：
alter session set events 'immediate trace name heapdumplevel n';
其中不同的level级别决定了将哪些内存堆转储到跟踪文件：
Level 1:&& PGA汇总信息
Level 2:&& SGA汇总信息
Level 4:&& UGA汇总信息
Level 8:& 当前调用的汇总信息（CGA）
Level 16:& 用户调用的汇总信息（CGA）
Level 32:&& Large pool的汇总信息（LGA）
Level 1025:&& PGA详细信息
Level 2050:&& SGA详细信息
Level 5000:&& UGA 详细信息
Level 8200:& 当前调用的详细信息
Level 16400:& 用户调用的详细信息
Level 32800:&& Largepool的详细信息
看一个简单的范例，通过Level 1转储PGA概要信息：
HEAP DUMP&strong&&span style=&color:#ff0000;&& heap name=&pga heap&
desc=0xbaf3ca0
--注意这里&/span&&/strong&
extentsz=0x20c0 alt=216 het=32767 rec=0 flg=3 opc=2
parent=(nil)owner=(nil) nex=(nil) xsz=0xfff0 heap=(nil)
fl2=0x60,nex=(nil), dsxvers=1, dsxflg=0x0
dsx firstext=0xf7fa7720
EXTENT 0 addr=0x7fadf7c72010
7fadf7c72020 sz=
EXTENT 1 addr=0x7fadf7d00010
7fadf7d00020 sz=
7fadf7d07118 sz=
7fadf7d08f00 sz=
& ds=0x7fadf82157e0
7fadf7d09f80 sz=
& ds=0x7fadf82157e0
7fadf7fd28d0 sz=
7fadf7fd4688 sz=
7fadf7fd46b0 sz=
&dbgdInitEventGr&
7fadf7fd4700 sz=
&sdbgrf: iosb
7fadf7fd47b8 sz=
7fadf7fd4808 sz=
&PLS cca hpdesc&
EXTENT 18 addr=0x7fadf7fcd860
7fadf7fcd870 sz=
EXTENT 19 addr=0x7fadf7fc9958
7fadf7fc9968 sz=
EXTENT 20 addr=0x7fadf7fc7868
7fadf7fc7878 sz=
7fadf7fc8520 sz=
7fadf7fc9190 sz=
7fadf7fc95d0 sz=
7fadf7fc9678 sz=
7fadf7fc96a8 sz=
&koh-kghu callh&
7fadf7fc96f0 sz=
&joxp heap
EXTENT 21 addr=0x7fadf7fc5778
7fadf7fc5788 sz=
7fadf7fc6a78 sz=
&krbabrPgaRespMs&
7fadf7fc6c30 sz=
&krbabrPgaReqCtx&
7fadf7fc6c68 sz=
&krbabrPgaReqMsg&
7fadf7fc6e10 sz=
&kjztprq struct&
EXTENT 22 addr=0x7fadf7fc3688
7fadf7fc3698 sz=
7fadf7fc54c0 sz=
®heapd_kdlwpg&
7fadf7fc5560 sz=
&KCFIS GCTX
7fadf7fc55b8 sz=
&krbabrPgaStbyRe&
EXTENT 23 addr=0x7fadf7fb5e28
7fadf7fb5e38 sz=
EXTENT 24 addr=0x7fadf7fb3d38
7fadf7fb3d48 sz=
7fadf7fb5060 sz=
&KSFQ heap
& latch=(nil)
进一步的，可以将某个具体的数据存储结构转储出来（
），如 以 上 的
ds dcd00c0
其空间使用的大小为
& sz= 14036
，首先对空间地址进行一下转换：
select to_number('baf3ca0','xxxxxxxxxx') from dual
15:50:33 sys@felix SQL&/
TO_NUMBER('BAF3CA0','XXXXXXXXXX')
---------------------------------
15:50:33 sys@felix SQL&
使用如下命令转储固定地址空间的内容：
alter session set events'immediate trace name heapdump_addr level 1, addr n';
以上计算的地址空间可以通过如下命令转储：
SQL& ALTER SESSIONSET EVENTS 'immediate trace name heapdump_addr level 1, addr ';
Session altered.
SELECT a.VALUE || b.symbol || c.instance_name || '_ora_' || d.spid ||
'.trc' trace_file
FROM (SELECT VALUE FROM v$parameter WHERE NAME = 'user_dump_dest') a,
(SELECT SUBSTR(VALUE, -6, 1) symbol
FROM v$parameter
WHERE NAME = 'user_dump_dest') b,
(SELECT instance_name FROM v$instance) c,
(SELECT spid
FROM v$session s, v$process p, v$mystat m
WHERE s.paddr = p.addr
AND s.SID = m.SID
AND m.statistic# = 0)
检查这个进程转储文件，可以发现如下
地址信息及空间分配：
[oracle@felix ~]$&span style=&color:#ff0000;&& grep heap
/u01/app/oracle/diag/rdbms/felix/felix/trace/felix_ora_6443.trc&/span&
HEAP DUM&strong&&span style=&color:#ff0000;&&P heap name=&pga heap&
desc=0xbaf3ca0&/span&&/strong&
parent=(nil) owner=(nil) nex=(nil) xsz=0xfff0 heap=(nil)
7fadf7fc96f0 sz=
&joxp heap
7fadf7fc54c0 sz=
®heapd_kdlwpg&
7fadf7fb5060 sz=
&KSFQ heap
latch=(nil)
7fadf7fb5c10 sz=
&KSFQ heap descr&
7fadf7fb0790 sz=
&iovecheapd_kdlw&
7fadf7fb0878 sz=
&bcheapd_kdlwpga&
7fadf7fb09a8 sz=
&sioheapd_kdlwpg&
7fadf7fb0ad8 sz=
&KSZ pga subheap&
Total heap size
&strong&&span style=&color:#ff0000;&&HEAP DUMP heap name=&top call heap&
desc=0xbaf94e0&/span&&/strong&
parent=(nil) owner=(nil) nex=(nil) xsz=0xfff8 heap=(nil)
7fadf7ccb7d8 sz=
latch=(nil)
7fadf7cceb78 sz=
ds=0xbaf85c0
7fadf7ccfbf8 sz=
latch=(nil)
Total heap size
&strong style=&background-color: rgb(255, 255, 255);&&&span style=&color:#ff0000;&&HEAP DUMP heap name=&top uga heap&
desc=0xbaf9700&/span&&/strong&
parent=(nil) owner=(nil) nex=(nil) xsz=0xfff8 heap=(nil)
7fadf7c62018 sz=
&session heap
ds=0x7fadf7cd5be0
7fadf7d10018 sz=
&session heap
ds=0x7fadf7cd5be0
7fadf7cf0018 sz=
&session heap
ds=0x7fadf7cd5be0
7fadf7ce0068 sz=
&session heap
latch=(nil)
Total heap size
&span style=&color:#ff0000;&&&strong&HEAP DUMP heap name=&pga heap&
desc=0xbaf3ca0&/strong&&/span&
parent=(nil) owner=(nil) nex=(nil) xsz=0x1fff0 heap=(nil)
7fadf7fc96f0 sz=
&joxp heap
7fadf7fc54c0 sz=
®heapd_kdlwpg&
7fadf7fb5060 sz=
&KSFQ heap
latch=(nil)
7fadf7fb5c10 sz=
&KSFQ heap descr&
7fadf7fb0790 sz=
&iovecheapd_kdlw&
7fadf7fb0878 sz=
&bcheapd_kdlwpga&
7fadf7fb09a8 sz=
&sioheapd_kdlwpg&
7fadf7fb0ad8 sz=
&KSZ pga subheap&
Total heap size
由上面红色字体可见，在自动管理模式下，
PGA,CGA,UGA
都是独立分配的。
已发表评论数()
&&登&&&陆&&
已收藏到推刊！
请填写推刊名
描述不能大于100个字符!
权限设置： 公开
仅自己可见
