缺少 cursor: pin S wait on X 等待事件的诊断,说明优化生涯是不完整的。
原理:
游标等待与某种形式的解析相关联。当一个会话试图在共享模式下获取互斥锁时,但另一个会话在同一个光标对象上独占持有互斥锁,它可能会等待此事件。通常,这个等待事件是一种症状,而不是原因。
首先检查共享池大小是否正确
其次看是否频繁的硬解析
然后看高版本计数是否高
最后排除掉BUG外,要看是否有解析错误情况,即ORA-923
-
共享池大小
-
col name for a40
-
set pages 100
-
select name,round(bytes/1024/1024)size_mb from v$sgainfo;
-
-
内存抖动
-
-
SELECT COMPONENT,
-
OPER_TYPE,
-
round(a.INITIAL_SIZE/1024/1024) initial_size_mb,
-
round(FINAL_SIZE/1024/1024) FINAL_SIZE_mb,
-
round((FINAL_SIZE-INITIAL_SIZE)/1024/1024) resize_mb,
-
to_char(start_time, 'yyyy-mm-dd hh24:mi:ss') Started_time,
-
to_char(end_time, 'yyyy-mm-dd hh24:mi:ss') end_time
-
FROM V$SGA_RESIZE_OPS a
-
where start_time >= to_date('2021-12-20 00:00', 'yyyy-mm-dd hh24:mi')
-
and start_time <= to_date('2021-12-23 23:59', 'yyyy-mm-dd hh24:mi')
-
order by Started_time;
-
-
查找引起此事件的会话
-
select sid,serial#,SQL_ID,BLOCKING_SESSION,BLOCKING_SESSION_STATUS,EVENT
-
from v$session where event ='cursor: pin S wait on X';
-
-
相关sql
-
SELECT s.sid, t.sql_text
-
FROM v$session s, v$sql t
-
WHERE s.event LIKE '%cursor: pin S wait on X%'
-
AND t.sql_id = s.sql_id
-
-
How to Determine the Blocking Session for Event: 'cursor: pin S wait on X' (Doc ID 786507.1)
-
awr中看这里
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAskAAAClCAYAAACunGDlAAAgAElEQVR4nO3df2wb9503+PfQ+9cd8Dz3HK7dwpITd4YqDuihcJvGiR1KAVSIIxa7aNIoWIq9OvZlLYhi7MViDYlo5Ns+G3lNMe4f9UbSA+XaeB2YogFdkrs+iEQt1oApRjHkbuEnh/wTciauLGuD9n7ggMMdnj84c38w369mhjP8IVG25bxfAGF5Zvid7ww53+9nPvOdoWLbtg0iIiIiIpJCD7sCRERERESPGgbJREREREQeDJKJiIiIiDwYJBMREREReTBIJiIiIiLyYJBMREREROTBIJmIiIiIyINBMhERERGRB4NkIiIiIiKPhkFyLBZDKBRCPp9/UPV5JOXzeYRCIYRCISiKUvdvLBaTy5qm6ZpXKpUAwPX+fD4vlzFNs6U6mKYp378fDA4OBu6vVreZdiccDru+m+IzcL6cn0s2m32Itd0ZcVz09PTUzSuVSnXHnZdo40KhEMLhsG/ZfsedmOdXpqIoSKVSu9wyIiJ62BoGybZtY69+tTqfz7s68Eedc18E/QtAdo5i2sGDB5FKpVzv7+7urntfq3XYT4L2Uzgc3neB8n77vmazWRiGgVdeecU1XXwP/b7Pj4pSqeQb9PrxHlvOMvr6+lzzEomEPGkFagHy8vKyXMYwDNdnnEqlEI1GUa1WoWmaK/C9dOkSVFVFPB6vq1MymcTs7KxrXUREtP88lOEW+XweiUTikeucm9F1HZZl1b2WlpbkMuVyGQBQLBZhWRZUVYVhGACAXC4Hy7IQiUTke1VVbWndqqrK9+wnYpvFS9M02LaNxcXFh121lu3H7+v8/DwAuII47+cAbH9PLcvC+Pj4Q6mrkzO4bSYUCmF5edl3Xi6Xg23byGQysCwLmUwGtm1jamoKQC0TLN7rPK6Wl5dlcCuOZZFFFsexaZqYm5vDG2+84bvuRCIh60BERPtXW0FyNptFKBRCKpVyXab0ZticwxPES3Q8zoCjUCi45jnLFC9XZb+c5i3fm7FxXmb1qx8A9PT0yPmtZq2AWofp9xJlio70+eefxw9/+EPEYjEUCgUAwE9+8hN861vfAgAcOHAABw4ccGVUG9XbNE35HqdUKuV6j7M8sZ9isZhrOb/t9ZYjLiOLOnnfI/Zfs4ywdz+NjIzULePdbu9lfzHdWcdm9W637KDv1G6+r879JN4n/u/8znrX7d2GRseTn1KpBMMwoOt64GcRNM05xMC53711icViclvEfOe+7unpCfzuePebs94iQDYMo+FQr1AoBNu2ZbDvtbKyAgB4+eWXoSgKXn75ZQBApVIBAKyvrwOoZX3F9ieTSQDA5uYmANQNvxAntKlUCpqmYXh42HfdkUgEADA3N+c7n4iI9gm7AV3XbQD2wsKCbdu2PT09bQPwfU1PT9u2bdurq6u2oih18xVFsW3bthcWFurmra6uBpY9ODgo6+Msy69sUb7f+sfGxuQyfvPD4XDgfnDWWVGUutfq6qpt27ataZqrTF3X5T4UL03TXNtiGEZL9TYMQ04TBgcHffezs8ygz8u5P4LK8W6XKHd1dVVuX6vfHUGUJb4vftutKIqc79xXzv3aSr3bKTvoO7Wb76u3foqiyO0XdZyenvZdt9hvzY4nP6JuyWQycBlvPYRwOOy7XaI+fvtjYWHBNgyjrp6iLPGdDypfbIv4Xvmt1wuAXalU7GKxWLcO5+cqvrPOaUH7SEwT349KpeL6bliWJeuYy+UC922j/UtERPvHjodbWJYF27Zl9uXu3bsAalkY27bl0ATbtl2XM+PxOBYWFgBsD1+IRCIYHx93Lb+6ugpg+5Knk7iEKrK2tm3LjOaVK1dg2zamp6dleQAwOzsL0zSRz+dlvcW6kskkKpVKSzco2p4xnbbjsnC5XJaZrdXVVSwtLWFpaUlm9BYWFny3x6/eYn+JenuJy8WapsntFJeYL126VLd8pVKRl58B96Vjcdm5UqnAsiwsLCy4Lk2L7K8YIrG2tgYA6O/vb7q/EomEK2so1isu7YvtLhaL8vOwbRvpdLquLHHJfGlpyVVvwzB8691O2RcvXoRt2zLTKL5T8XhcXjbXdR22bcvvq7PMYrEIYPv7WiqVXPvVtm1cu3ZNbr8wPz8v1+v8d3JyEkD98STWV61WA/e5OBYPHz7c9PPxKpfLruNQHN8bGxt1y4r9Ho/HcenSpbrj3pvlLZVKqFQqrm2Znp6GbdvIZrOIRCLyuBffa78xvwDkkJGd3Mja7OqH2H+iDuKlKAqmpqag63pgFlkQWWiRlSYiov1nR0GyuEQJAH19fQC2Ox7RqRUKBRw4cAChUAg//OEPA8vyXvotlUo4cOCALNfP0NAQFEWBqqqyI97a2pLrdS4DbI85VFVVBjNzc3MIhUI4cOCAvCzqFwg4BY1JFpdXvR2299K23zKCt96KojQctywuFxuGIffzT37yEwD1QYCu63I/PffccwDqLzuLZRRFQTwed421HhoaAgDcuHEDwPZ4VzG9Eb8TCue4arHdzz//vPw8xPu82yEumSuK4qq3qqq+9d5J2Zqm1X2nGgViH330EUKhEJ5//nnXdBEcOff98PCwK3A0TVMGzWLoghiaIKZ7j6cDBw4gFou1FBw+8cQTTZfxI57O4Dw2vJz7XWwLAJw8eVJOE4G+IE6unNsiTlhEYOqtR6M67lSz+wCcJxdiPaJtKhQKcruChjm1sg4iInr07cmNe86Ml23bWF5ebjqOUox3XltbQ7Vaxc2bNztWH79gFYArcAP8O+qgsvzGd3Zaq+V7g1ARAHdq3aqqQtd1FAoF13jXVgIB7417IiPXbBuA7SB1p/XudNlOnf6++tVRBF47OZ52SgTrf/M3f4NqtSozyZ3m3d5OP+3Em8UW5YvpficQ4vgPOrkQWeRIJIJUKgVVVVGtVhGNRvnINyKix9CeBMneTKgY2iAySX7S6TRs25aZ1I8//nhH6xZDG5xPT3DeLCWyRMlksi54m5mZ2dE6O6FZvb3EY+S8l4Qtywoc0uHn6NGjAGrZPRFI+N1wJYZWnDp1yvX/ZpqdVPg9ZcGbod9pvXdadiuafV/F5+OsXz6fdw23cJ5kiKEuzpeYv5PjCWh+ZcQrn8+jUqkgGo3KLLG4Aa4ZUdcrV67IaWLYiyCCT78rMs4nxHRCNBoFsH08iX/FMAjx/XFmysXf4rNz8maRxecovs/eY26/PeKQiIjqdTxIdt6JLy6pis7n+PHjrmWdTwsQnWw4HEYoFPIdN9qKkydPAqgFMaIeouMXY0mBWoco6ideH330UcOyRX29r3aejrHTentFIhHoui6HWzhfb775ZsvrFVliYHvfiycM/N3f/Z1cTgytEFnqVoZatEI8Ruv55593bYN4Cshu6r3TsoO0830Vn49zmUQiUZfhFGPEe3p6XHUUQ5TaOZ4EMVSplSsjTs7A3juGvJlz587Vvdd7RSMej0PTNNdwC/G6fv26a9lmT7doRjyGTRxP4vMRQa7z++N8yobIFHs5s8ji/U7eJ2GIbRfBOBER7UON7uoLerqF845wcbe780kHQU8EcHI+CWJ1dVXeSS5elUpFrl/coS7mOe9Y97uL3HuXvPcpDJZl1dWvWCwG7odGT4mA5856v/r4PenBb1vEnfp+9fZ7uoWzbPFyPrnB77MR+8ZZZ8uy7GQy2fSpAmJdjZ5q0Wibg+Ryubr9aVmWnO+3r4Lq7X3qwE7K9vsMvd9X5+cR9H31vq9SqdQ9KcS2658ao+u6q47ebfA7npxE3Rp9TkFPX8hkMq56eMvy+04JzuNO13X5fXYua1lW3VNgvN8R53e62ffH7/sseI+nRt/poDKc63DuK9GGiCdfeL+bjcojIqL9QbHt4Kf2i1nOS+TtThP8xol653mnecttdd3trt9vvleD3bSjOu6k3rvZz7stBwDGxsYwNzeH6enppj88EbR9zZb3W3+jslqp9073adD+aeX7apomwuGwfOpIPB7H559/LjPJhmG4spGd/r6Gw2EYhhH4vW11n7Z6HGazWTkERdyY+eabb2JiYgK6rrt+9GMnbUMj7WxLo/mN1mfbdsv1LJVK6O3tlb+8R0RE+1PDIJlIME0zMMAjfyJQ9Qbb3qBxLywsLCCRSGBhYSHwMWqdJAJDoP7k4kHV4VEhTiZ5nBAR7W8Mkqkp8auBIiva7BmxVGPbdt2v8GmahnK5vKdPRRHC4TDC4fCeB+SCCMydMpkMJiYmHsj6HxXKl7/exywyEdH+xiCZmmr38jdt8zu8HtQ+bHfISyfXKXwVvy8PY78TEVHnMUgmIiIiIvLYk+ckExERERHtZwySiYiIiIg8GCQTEREREXkwSCYiIiIi8mCQTERERETkwSCZiIiIiMiDQTIRERERkQeDZCIiIiIiDwbJREREREQeDJKJiIiIiDwYJBMREREReTBIJiIiIiLyYJBMREREROTBIJmIiIiIyINBMhERERGRB4NkIiIiIiIPBslERERERB5/0nyRf9n7WhAR7QtPOf5m29g6sd+4z4hax/ZmZ55qvkiLmEkmIiIiIvJgkExERERE5NFykJzPryAUetr1isXOtr6iL9+Tz68glcq0/X6vUumOLM8pFjuLbPbqjstthWneRyj0NEzzvutvP87tFvL5lV1tOxFRI0HtUk/Pi7JN8hLTe3pebFh2J8oQfYD3VSrdaWHr3Jq1wUF6el6sa4fz+ZWmdRfvdbbpfv2RmNaM2O5m2yH2u7N/K5XutFRfor0U9F0PaivEd72VOLATZexGW5lkVe2CZd2Wr3J5o6WAtFS6I98bj0dRKNxCsfg2lpYu77jiAGDbNiYnZ+um7TWxLara1XCdY2MZZDJnUKl8gOHhn8npk5OzmJmZ2PN6EtFXj2neh6b9qK5dGhvLYGDgGVjWbWQyZzA4eEbOGxw8g0zmDCzrNgYGnsHYWMa37E6UAQC2DYyOvuTqTzKZMzh58uc72uadtPu2bWN5ea0uMG+lrIGBZ1As/k7+f23tE0Sjz+LKld/UTWvGsm4jEjnScN3Z7FW53ycmLstAemrqV3jnnb9tug6ivVIq3UFv71+21d5EoynkchdgWbdh23ZgHNmJMnZrV8MtotFncffuFoDtTLOQzV5FLHYWpdId9PWdhmFsygyDYWyir++0POt2ZhWcGyrOEBplGMLhQw13TjZ7VZadSmVcdROcWQHnmbnzTMX5fucZfzj8wpf1eMF3/U888Q0ZTJvmfeTzKxgZ+bGc5qynKJ+IaCfy+RWEwy8gl7tQN29ubhGJxCAAYGjoBygUPpZXwwqFjzE09AMAQCIxiLm5Rd/yO1FGkOPHvwPD2HRlUp1ZJGcf4GybL11611WOyGq1ktHW9WM4dSo4MPf2AUIiMYiVlVvy/zdu3Mbk5KsoFD6W0+7e3UJ///Z7gq7Cim1r1pccPnwQAKBp3dja+qNMPokAW+CVSnpQstmr6Os73VZ7UyrdgWFsIh6PAgBOnvxzzM+/51t+J8rYrV0FySsrt9DX9z35f++ZhG3biESO4ObNeQBAtbqOzz57D5rWjWvXphCPR5HNXkWhcAvV6jrK5feRTl+WjaFt2/jmNw+iWl2vawiEmZk00unLvpeoSqU7SKcvo1x+H9XqOmZnF5HPr2Bo6AdYXl4DUGsEbduWWYG1tU9w+nStYdX113Dt2hSq1XXcvDmP2dlFuR6xreXy+65/vTY2vpDvUdUuJBKvY3z8RN1y4+Mn8NZbad8yiIhaEY9HUa2u49ChP3VNF23QwYNfAwB5kr619Udsbf3RNU0s421TO1FGI2trn0DTumUZsdhZDAw8g2p1HdeuTaGv77RcVtdfw8WLZ1CtrsvgUejrOy3bbU3rbph8OHnyz6FpwYkW53pGR1+SwWckcsQV0BcKHyMSOQJdPyb7r5WVW/KkIRY7K8spl993ZbBb7UtEQsowNnHw4Ndw6tTPce7cT+uWi8ej+PDDXwZuM1GnjI+fQLW6DkVRXNMbtRWbm3+ApnXLZbu7vw7D2KwruxNldEJbQbJhbEJRvi9f4fAhGck3Inagoiiuv4HaGfjU1BgURYGmdWN0dAi53LJ8b1/f9+o+ACdN60Imc9b30l4ut4zR0SFoWjcURcH09FlcufIbqGoXNK0bpnkf6+ufYmpqTH4gN27cxvHj3wFQa6yGh3UoioKurq833Tav2dk0JiYuQ9N+hIWFv0c2exWZzBlks1e/3H8veMoK3EwiopY0ai8fJXNzi67+ZGLiMlZWZuT85eU1nDv3UyiKguFhHarahXx+BaZ5H5XKPbz88g+gKIoMRIFaFlVVu2S7PTn5KmZnG2e0RTvtDehLpTuoVO5hYuIEFEXBuXM/xfLymlxO14/JjK6uHwMA9Pc/jbW1T1yJEQBYWrosy3F27k6N+pLx8RNYWbkFRfk+pqfPYn39UwwMPIv19U/l/vMri2ivPe7ftbaCZE3rdo0hU9WuXV/WqVTuIZF4XV6GavcSHVBrQCqVe3VDMhplMaLRWgOzsfEFuru3A2CREQDcNysGXQJrRuyreDyKdPoyhoZ+gHT6MizrNqLRZ/f8JkMiokdRMjkk20dN60Ymc9Y1NA2oDT0QbbDIFImsteAcurax8UXb9VDVWqLFO2xjc/MPDd8nAuK1tU/ksIrjx7+DGzduY2vrj67xyM4hIK3czOenXH4flnUb4+MncP78LM6d+ykSiddRqXyATOYsh+sR7YG2h1uIbLCiKEgkBuWwBWeg2Y5w+JAcfF0bgP1bzM62P+xgamqs7qYP77hfp76+76FY/B1u3KjdNNHfXxsPnUwOyWWGh3+GYvFtWNZtVCoftF0nYHt/1bLIZ7+sVy2zffjwQXkJjYhorzgvVQLuS5neoRHeoROdLMNLtI8rKzOuoXbifZXKB66+IR6PynUJzmTIE098o9mu8DUxcQJzc4uum/Ga9WlDQz/AjRu3XVcfI5EjKBQ+xtraJ66hiCdP/tzVz+2E2Ff5/AoGBp6FqnbBtm1oWjeefPIbMIz2nu5BtFcatRXeoRHeoROdLKMTdjUmOZdblpeZBLEhrQ6i7u9/GufPbz+hoqfnxR1lV+PxKMLhQ64bJ8TNI6JO6fRlecYfj0frGtf5+fdkw+bNQnuzDO1Kpy/Lscjiw717d6tuPB0R0V5IJreHsi0u/jN0/RhUtQuq2gVdP4bFxX8GUGvXncmCTpfhR2RznTfR6fox2e6KG+jEzWrOeWKdQK1dN4xNeSP21NSv6vqoILncBdeVzEjkCDStW/ZHly696xozvR3I33PdM6Prx3Djxm0cPfptOc3Zoe/26qHIIgumeR8bG180PSEhepCC2gpxXIlj9MqV32Bk5Md7VsZutfCz1NvEEyoE27blWXEkcgTJ5JAcljA6+lJLN22Mj5/A3btbstzR0Zd8b2xrxcxMGuHwj+T/I5EjyGTOOuo0VFe2aFiOHv02DGNTNmyq2oVkckjeLJLLXcDKyi2sr3/qavzE+OZw+AVUKh/4NlSx2Flcu3ZBLp/J1J7YoapdMkOdzV7F73+/hZkZ3rxHRJ03M5NGT88LX7a1NqrV7Yzm0tJlHDjwNNLpf4CqdqFcrrVLpdIdnDr17+XNZDspo1UTEyfw9tvvIZXKYGYmjaWly/LpFgBw7dqUDEaXli4jFHoa/+E//M8YHX3JVU6x+Daef34EicTrX9bD/0Y4r+FhHf/4j/8Rlco9Oa1QeAs9PS8gnf4HV38niBMEp/7+p3Hjxm3X9EzmLBKJ15FIvI5M5gx0/RjW1j5xBdet9CWpVAanT28/HSmXu/Bl/2ajWv0tgNowwX/8x/+460esEu1Go7aidly9iETidUSjz8q4rJ32JqiMTlPspg+F9P+9cNu2H/sB20REbk85/vZvG8mP2G/cZ0StY3uzM081X6RFOx5uwQCZiIiIiB5XuxqTTERERET0OGKQTERERETk0cKYZCIiIiKirxZmkomIiIiIPBgkExERERF5MEgmIiIiIvJgkExERERE5MEgmYiIiIjIo+UgOZ/PQ1EUhEIh+e/g4GDLKxLvyefzSKVSCIVCiMViO6o0AJRKJYRC9dUPh8PIZrMAgFQqhVQqVfe3VzabRSgUQjgcdk3v6elBqVTacR2JiB4G0zShKApM03RND4fDUBTF98egxHRvO+jViTLGxsYwNjbWwpY8fsbGxuR+UhQF+Xx+R+Vks9nAPlj0197PaHBwcMfrIwpSKpV824OgtkK0T4qiNI0jO1HGbrSVSdY0DdVqFZZloVqtolKpyIC0kVKpJN8bj8dRKBRw8+ZNfPjhhzuuOFD7aexG3nrrLbz11ltyWb/lTdNEOp1GtVpFNBqV25PP5zEwMIBIJLKrOhIRPUimafoGqalUCtFoFJZlIZPJuJIUsVgMmUwGlmUhGo0GJhQ6UcZXWTabxcrKCizLgmVZqFQqSCQSHQ9cE4kEKpUKMpmM/BxEwicej3d0XfTVViqV0NfXVze9UVuh6zpyuRwsywKAwDiyE2Xsmt2ihYUFW9M017RkMmknk0k531nc9PS0reu6vbq6agOQL03T5N8LCwuyHDFtenpalgHA1nXdBmCvrq661i3K9dI0TZYh6jc9Pe1bvm3btmEYcrump6fl9ni31VknwzCa7zAiogdMtMPiX2db5WxHDcOQ851/23Zw29qpMmy7vu/QNE229Y3aWNGviGU1TXP1MaJPcdZPvPaiDNFHaZrmel8ymXT9X9B1va4PSiaTtq7rrrLF+sQ+sm3btY/OnDnju4wg6rqwsCDL1nXdd7/quu5bV6JmxHfVG//ZdnBb4W0b/GLLTpaxW7sak7yysuJ7BuEUiURQLBYBAJZloVwuQ9M05HI5xONx15l1pVJBOp12DXFQVRWWZe0qozs+Po5kMolkMonx8fG6+YZhAADu3r2Lw4cPI5vNYmRkxLcsy7KgquqO60JEtFfi8Tgsy0J3d7druhh2cfDgQQCQbdjW1ha2trZc08Qy3qEanSgjiGEYOHnyJCzLgq7ruHTpUuCyhUIBk5OTsCwLhmHg1KlTMtN0/vx5uVw4HJaZpmQy6cpCtVqGrusyO+5XRqVSwdLSEkZGRmQ/BwBzc3O+GduTJ08inU67ypmZmcHS0hKAWlYunU6jUqnAsizMzc3VZZkty8Ivf/lLZDIZ6LqOmZkZ3/1kmiY2Njagqiry+TxUVfXtu5aWlphdph0ZHx+XmVynRm3F5uYmNE2Ty3Z3d8sYrNNldMKftLOwYRiuccDRaLSlg0uMJXGOKRF/37hxA2+88QYURYGmaRgdHUUul5NBcV9fn+9YF8E7Ltlu8wcEVVVFJpNBKBSCqqqoVCoIhUKwLEuWLQJ67zYQET1q9msbJdrY/v5+3LhxI3A5TdNk/6BpGk6fPg1FUfDcc88hnU4DqAWbqqpieHgYAHDu3DlomiY73lbLqFQqmJiYCCxDdNRDQ0PQNA2zs7MolUpIJpOB2/gXf/EXCIVCsn/RdV0GyblcDqOjo7LcTCaDK1euuPaNtz/1+7xzuZwcclOtVvGtb30LhUIBPT09MAwDmUxGJoz26/eFHg2P+/dnR2OSxbhkVVV3dfMdAFQqFfzkJz+RN/bNzc219X7nGOlqteo6u2jVxMQEqtUqyuUystksLl68iFQqhYsXL6JcLiORSLRdJhER7Y4IJkOhUFs3UW9ubsqkjt9N2a2W0SpVVaHrOkqlEnK5XMMrrIqiuPqscrksxw17M+87DUCGh4dl+devX8fAwAAWFxcxMDCAarWKdDrdcpaf6Kus7eEWzrsME4kElpeXAaDu8l6rwuEwrl27JhsNy7ICLx8F1cdbr50Q70+n05iYmIBt23jyySehaRps22aDQkT7lvNSJeC+lOkdGuEdOtHJMtolAr1qtdrWkLvu7m5XUseZ2GmnjHacPHkSa2trWFlZCbzCGgqFXHflK4qCkZEReam4k0P5RPnnz5/HuXPnAACHDx+GoihQVVV+RkSd1qit8A6N8A6d6GQZnbCrMcm5XA66rrumiQ2Zn59vqYz+/n6cP39eHtA9PT148803d1OtHctms8hkMvL/Gxsbcns4DpmI9rNkMolcLgcAWFxchK7rcpyqrutYXFwEUGvXg4YLdKKMdjiDyXZEIhEYhoHr169DURRcv37d95GhzcrQNE3eNX/p0iVomhbYFxw9ehQTExMNs9ajo6N1j76bmJhAf38/gFriaW5uTvY7znk7IZ7SJOp89+5dALWhk+LEhmgvBLUV4rgSY+2vXLkSeA9YJ8rYtVbv8BN3LyqKIl8AbMuy5DLJZFLOc96x670T0e9OYOf7BHjuNHZq5+kWzvqPjY0Flue8O9KyLFmnXC4npyuKwqdbENEjTbSPzrbKsixb0zTZrjnbbmd7p2manLe6umqHw+FdleGnlScj+Zmenna108723tsnVCoVV39VqVR2VYazv/OWITR7UoRlWa7+TlEUO5PJuJbJZDK+/aGzns66Dg4O+q7LMIy6z0h8ds51Dg4O8ukWtCt+T7do1FY4jyvnsd5OexNURqcptt36nW5+izrP8BvNt23b92+/9wUt51cf73zverzleevcqDy/5ZvViYjoURDUPgqtzmvUXrdTvt9yjfqEVtrpZu9rZZs6UQZQu4oqhuc1EtTfBS3TqD9kn0aPike5vdmNtq4/OS99+V0CazQ/6G+/9wUt51efRtP8ymtUZlC9mq2TiOhRE9Q+BrWDjdr13ZYRtFyjdTR6b6vva2WbOlFGPp+HpmmYnp4OrLdfeUHb2Wp/yD6NHhWPcnuzG21lkomIiKgeM7JEj59d3bhHREREzMgSPY4YJBMREREReTBIJiIiIiLyaOFnqf9l72tBRLQvPOX4m21j68R+4z4jah3bm515qvkiLWImmYiIiIjIg0EyEREREZFHy0FyPr+Cnp4XfefFYmeRzV6tFRh6Gvn8Smdq16Zs9ipisbOuaaZ5H6HQ0yiV7hZ1pT4AACAASURBVAAAenpelPVz/u0Vi51FKPQ0UqlMXVlERPtNqXQHodDTCIWermvL8/kVOc/bhgbxtvXZ7NW2ykilMnL5dvoN53aIv03zft1yzm1yvkRf8KCJ/ePd9z09Lz60OhHtlUbtjbOtcMZYXt5j2FmOiNH8yu+ktjLJQY9U/vDDX2J8/ETDZR4Uv/U7p3322XuIx6OBywK1D8a2bVSr6ygUbskG7NKld3Ht2tQe1JqIaG/19Z3GxYtnUK2u4/TpF2Uga5r3kUi8jmvXplCtruOb3zzYsOMCagGus/0sle5gfv49VKvrqFbXUS5vyMSJn2z2KgqFW47l30ci8XpLgfLa2icYHX0J1eo6Dh78WsM+R1W75Dqq1XXcvDmPvr7TTdfRaaZ5H+n0ZVSr6xgYeEbum3x+BQMDzyASOfLA60S0l4Lam1LpDtLpy7h5cx7V6joM435gW1Es/k4e69XqOj777D0Atfbjm988KKdrWnfTNmunOjLc4oc//CvXRhaLv6vLDoizChH9O6eJl7Ph6Ol5Ub6cmWqgtoMaNcCNfOtbP0Y+v4JY7CwMYxOJxOu+Z/Gq2gVFURAOH8Lm5h9gmvdhmvcxPKy7lmN2mYgedaXSHdi2jYmJE1AUBePjJ7C8vAbTvI/19U+hql0YHtahKArOnfspZmcXG5ZVKNyCpnXLaZHIEZTL78tfv4pGn8Xdu1uBZdy4cRsjIz+Wy2taN0ZHX8KVK7+Ry/hlm7LZq0inL2NubhE//OFfIRx+AQDkv36cv8rV2/td2LYtM8/ebLZzuvdqYlDWu1HGzElVu6EoCg4fPij3zfnzs5iZSdctG5QdJ9oPGrU3a2ufIBo9ht7e70JRFExOvor5+fd8yzHN++jr+17dL+uNj5/AzExaTuvvfxqGsTfHS0eCZO+Z/MrKLXnWnki8Lg9227bxyit/hmp1HUDtTEOcTVy7NoV0+rIso1K5h1//+n/EZ5+9h1de+TPcuHFbzpuffw9DQz/YVV0//PCX0LRuXLs25XsWL+pcqdxDd/fXkUplMDn5at1yIlNBRLTfbG39MXBeUJB26tTP8c47f1s33fljGisrt9DX973Ask+e/HOk05ddwzJmZtJYWqr1ASLbVC6/j2p1HbOzi8jnVzA+fgIXL56Frh/Dhx/+EuXy+wAg/20mn1+BpnVDVbuQz6+4stnR6LO4dOldAIBtA8vLa6hW1/HWW2mkUhmZFRNZb7GPnP1Yo4yWYWwCAO7e3cLhwweRzV7F6dM/ht9vkFSr61DVrpa2iWi/CGpvxLHhVancQyLxet1JLADXcXP37taeHS97cuPe1NSYPGtX1S6sr38q5x09+m3ZmFrWbXk2cejQn8J71UzMi8ejKBQ+ltnccPhQ4A4pFD6GonxfvjTtR77LiTr4/UqSGI6hKN9HNPosAMi6iXLdHxZ/aYmIHl0iESAyoM4rcUePfhuGsekaVhYkm72KgYFn0dv7Xd/5+fwKFOX7MIxN2Y76icejsKzfYnl5TbapsdgZ2ZbmcssYHR2CptWyr9PTZ2WWWTS3zsxSUBtsGJuu/mB4+GdYWZmRdahUPpDlePsUXT/25bxa+//732/JrLdl1ZI26+ufIhp91pUV88vCq2oXpqfPQlG+j5WVWxgfP4GJicsYHz8h6+bMTrNPof2sUXtz/Ph3ZDwHAFNTv/ItwzTvwzA2USy+Dcu6jUzmjG88l8+vYG5uEefO/bTTmwHgATzdIhw+hI2NL3znOS+nNRsnlkwOYX39Uywu/jP6+4OHN+j6MVjWbfmqVD7YUb2Xli7Dsm5jZiaNqalfYXLyVZw69XMUi28jl7uwZ+NfiIj2QrH4tszKOKlqF3K5C+jrO41Q6GkcPnzQ9/1iXK3f8AChFvzeRi53oaVhaO62+p5sVzs11EAEtM6XMxju6XlR9kFzc8FDTGZm0nJonXO4xcbGFygUPm6pHxsfPwHLuo1y+X1ks1eRyZxFKpVBJnMWlcoHMjtN9DgIam8ikSPIZM4iHH4BodDTgfGcqnbBsm7LgFvc9+YcHlsq3UEi8TqKxbf3VybZqVK5hyee+EbddNHgistpN2/ONywnkRhEsfg73Lhxu+lQC+f4lZ2ekYv3fvRR7QOJRI7AtoGurq/j0KE/Rbl8b0flEhE9DL2935VDC0QbKjqg4WFdzjt+/DtySILT+vqnsG3gwIFaQCju6fDebKcoCp555r9zjf31EpdOne30yMiP5bjCTnZ4Qf1BNnsVmtYttzuZHGpQRi1x4h1u8cQT34CuH3PdHCiyzI3qkk5fxsTECdg28OST34CmdTfcX0T7TaP2ZmLihJwnjiE/jeK3fH4FfX2nUS6/H3hlqxP2JEgWl8VKpTswjE0cPfrtumW2tv4I295uNC5c+HXDMiORI5ibW0Slcu+BjtUSWWRha+uP2Nz8A8LhQw+sDkREuyGyoJ9/XhsykEplZFAobjwTbfGpUz/HyMiP68oQWWLnHeXXrk0hHo/WPSL00qV3fQNtYXT0pbqrcen0ZZlVSiQGMTe3KING57xOETfPKYqCzz/faphJjsXO4vr1f5L7SNzbcvTot1EofIyPPvpPUBQFb775Lr71rfp955TNXsXFi9tjsTc2vpDbyXHI9Dho1N6ItkIcS4nE6zh58s/ryhDtkiBOaiORIzKDLNqhvdTCz1JvM4zNutS531mzqnbJ5UQa3DtgOxI5Al0/Ju9KLhbfRqHwccPnRSaTQ4GXAnciGn1WZgT8xs9ls1ehql3y7Oedd/5WXk4rl2vDOGpjpF9omD0gInqYVLUL165NyfY2Gn1WDpuIRI7g4sUzss0eHX3JdWnz1Kl/L2+M82Z2xP/j8Sg2Nr6QZdi23bBNnJlJyydLCBcvnpXrdV6SrdVpSM7zbpemdSMcfgGVygdtBZnnzv0UmvYjhEJPQ9O6kctdwPnzc77LvvXWBHp6XpD9RbH4tlx/sfi2Y5iFjWo1eLvFo/LEMMCZmTQOHPg+0ul/QC53QS4XCj3d9vYQPSoatTfxeFQ+AQ0ALl48I+MvZ3sTiRzBtWtTjjZi+9iamvoVbNvGgQNH5To1rbvlG3jbodhNH2z86PxeeO2GkP+FDQcRPSRPOf5+dNrGR5/Yb9xnRK1je7MzTzVfpEX74mepRdo9mRxigExEREREe66t4RYPSyRy5MtnEfOxOERERES09/ZFkAzwuZFERERE9ODsi+EWREREREQPUuMb9/5pGfjrUeD/+b8BWwHQ5B4/IiIiLwXAf/FfAqm/AVJ//bBrQ0TUkuAg+Z+WgdM/AWzrAVeJiIgeTwqQ/Csg/bcPuyJERE0FB8n/bRfw//2/D7g6RET0WFNCwN3/42HXgoioqeAb95wB8thfA//DKPC1rz+AKhER0WPlVgn4iy9/VYtXJ4lonwjOJB/+d9tDkP+3u8C/+bcPrlZERPR4efK/Rq1TUYDf/58PuzZERE0FP93CGTr/m3+LfD4vf2vb+QqHw3tfS4dSqbSjx8GNjY1hbGys7ff5bfNOyukEse2KosA0TTl9bGwM2Wz2odSJiB4fpmlCURSUSqWGy/m1w872yb9fsOW/O22Pw+Ew8vl8w2XGxsYwODjYtCyxrc62FAAGBwdl3Zz1bFRnZ//oLatZfYkeR43ag2w221I85VzO71h1rsdvXie09Qg4TdNgWZbrVS6X96Rij5Jiseja5pWVlYfS8J06dQrFYhG5XA6pVApAraFfWVnB+Pj4A68PET1eRLvSSKlUQl9fX930vr4+5HI5WJaFcDjcUlmPupmZGczMzDRdLpFIoFKpIJPJyO0WJxrxeHxP60j0KOrr60Mmk4FlWRgZGUEsFgNQOy7S6bSMq0zT9E3ylUolzM/Py7grk8lA1/W65U6dOrWn29H2c5L9MqsA0NPT4woce3p6ZCNhmiZCoZB8OZVKJTld7MR8Pu9aLpvNIhaLwTRN2Tj39PRsb4SjbL+ziWw2i7m5OczNzckPQ6zDud5WtzkajWJjY6Ou/qFQSJYvpsdiMbkt4u9QKFTXgfT09Mh5QVkc27bR1dWFQ4cOyZOTS5cu4Z133qlbNpVKMbtMRC3L5/No9ERQoNaW9vX14dq1a67ppmnCtm0888wzUBQF/f39MAxjR/Xw9heirYzFYjAMA4lEQraR2Wy2ru0VRJvq7Cva9dprr+G1117z7UOcbNuGpml48skn5XZPTU35BtjOvpHocVQqlWDbNiYmJqAoCsbHx7G8vAzTNLG2toZoNIre3l4oioLJyUnMz8/XlRGJRFAul2Xc9dxzz6FSqbiWyWaz0DRtT7elYz8mUi6XMTw8DKBW8dOnTyMSiQCoZaBFhmF0dFReCjNNE729vahUKrAsC7Zty0Db21jbtg1VVVEsFuX6gNrlN3G2kslkEI1G6+o2Pj6OZDKJZDKJ8fFxmKaJ4eFheSZTLpfbCijn5uZw/PhxAEBvb68sJ5fLYWJiwlXnV155BZZlyQ5InBUVCgXZUA4ODmJgYECW0dvbG7jura0tbG5uIhwOo1QqyX3oNTMzw+wyEbVseHgYs7OzDZcZHx+HZVl1wwpUVYWmaVhfXwcA3LhxA6qq7qge0WhU9hfFYhGzs7MwTRNLS0uyL4lEIsjn865M08TEhEySFAoFFAoFWJaFSqWy4yt/tm3Dtu26PsSPaZrY2NiAqqrI5/Nyn3iVy2XZNxJ9lWxtbflODzqhdrYzm5ubruPJNE1MTEw0bbN2q60g2TAM1xm+9+y9WCwiFothfn5eNiSlUgmapslLTufOnUOhUIBpmlhcXISu67IxXVpawtGjR1uuj2maMAxDrmt8fByGYTQ9SxfrFQ3VG2+84XsmI/T19bm2OZPJyPdaliX/7u7urnuvc3ucZ0HOhrJQKODcuXMAapfmNE3zbdTfeecd9PX1IZFIYGZmBlNTU5icnJQZ6sfh8iYRPXipVAqZTGbHgS1Qa9POnz+PUCiE/v7+loYpBJUj+ouDBw8GLnflyhWMjIzI/1vW9lMznP2Kruvyyp+fcDjsat8LhULbdc7lcgiHw0in05iZmcH58+dx7tw5mc3mVT36KhGxjYhjnN//48ePyxgQqF1xacY0TSQSCbzxxhtyWiqVQi6X62S1fe16TLLzrLq3txflctm10ZubmzAMQ6bMG6XGFUVpq5EWZyXeoR/N3L17t269jXjHJDuzxW+++aZcd6MMcDwex8jIiFzWOaYYqO1bMS/orKq3t1fW4V//9V8B1PavyFA7s9NERK0olUooFAqudm0nZYgAUwSrOx3mcP369Zb6C692+w9BXMkUL79xj80MDw/L91+/fh0DAwNYXFyUVwidWW6ir4LV1VUMDw/XxVeRSATT09My5unv729alqZpyGQycrSCuDIv/r+XOjbcAqidLYyMjOD8+fNyWnd3t29w3agx88vI+hFZBm/ZzS5lHT58uKXymzFNE+l0WjayYihIEHGpUtz8VyqV5H7wNtTNbvYQWWQAsoxwOIzNzc0ObBkRfVWsra25rhICtatn7Zxwi0uhoi0aGhqCYRg7CgwTiYRMTHjHIO4HIosMbPc1mqYFXmomehxFIhEZzwwNDclpgDsWeuKJJwJPTMX9CblczpWQLRaLKBQKCIVC8skZ4XB4T05EOxYkm6Yph1n8+te/lpnSSCQCwzBkduD69es4cOAAgO20uxCLxVxDBsQGBw2FEGO+RDb3o48+woEDB5ruqKGhIVfW9fz5875jmZvZ2tqCbdsy63HhwoXAZbPZLFKplG/GW9d1/OIXv4CiKPj8889x4MCBhh2UmCe+cGJ7K5VKyycYRETAdodVrVZRrVYBADdv3mxr3Gx3d7crKF5cXHQFza0SNwCKdvIXv/hF4LL9/f24ceOG/H8oFHroj1vL5/MYGBiQ2y2uWhqG0XDoCNHjRAS3n3/+ubxynkwmAdSOkZ6eHnmMJxIJnDx50reccDiMmzdv1mWMZ2ZmZJsl7k8rl8u7Gi4WyA7yxH+1/bJte2FhwUbtQZd1ry9/kMReXV2Vb08mk/b09LRt27ZtGIZrecMw5HLOcnVdd71fTE8mk655zvU6/++tg5NYTzKZbLher0Zl2rZt67ruWrf4V/zt3FZN0+SyYt/4zVtYWAhcn6iTs1xRB7Fttu3e/0RErXK2eaurq7amaXXLiPbTb5pfO2/btqtPcbbv3nbYOW9hYcHWNE22iWKe9//ONtXbX+i67tsWin7JW09d12Vbmkwm6/oMZzvrV56TaNed69c0rWGfQvQ4aBRj+R23tu1ub6anp33jTe/xGnQcd0rwL+49+e+2//79/yUCat9FFUWRZ/+O4Lvu/87lnfzm+a3LO89v2Ubji3fyPu92BJUpynAuv9t90GidzcptVm8iIj/N2vJG0xu2Y44+xb7r/4t7og31/r+dtt9vmXbad+f7g9bXanl+y7Ntpq+KoPagWSzUShwY9J5O+5OGcxW4fnmvUSW885r9v9m83ayrk+9rtkyjMne7D3ayzp2UR0QktNpu7ajd+bJP2Wn7vpO2bzd9T7t9Bttmom3ttB1+83Ya23VS4zHJIkDeDH58DhERUUP/+T/X/m38WyVERI+U4OEW6n8DfHkTR11KmYiIqGWePuTLIXxERI+y4EzyX/z3jv8wQCYiop1y9CFHn3t41SAiakNwJhkAzpwG/tdFsSgYLBMR0c4owFNHgfeWH3ZFiIha0jhIJiIiIiL6Cmr8dAsAwL/sfS2IiPaFpxx/s21sndhv3GdErWN7szNPNV+kRR39WWoiIiIioscBg2QiIiIiIo+Wg+R8fgWh0NN1r1Lpzl7WryHTvO+qSyx2NnCeeGWzV+UyPT0vIp9fcZWZzV5FT8+LvutLpTJIpTJt19OvHjsppxNSqUzD+ux0G9slPh/TvF83r1S6I+vlnJ9KZVyfHxG1pln7nc1eDWxLg8rztpPetqWRnR7j4n3edjsWO9vxtiEWO1u3v4L6hgfF+zk590Ozz1jsO6+enhfZrlLHOY9x73Hj/B43izd6el70/b571+MXS3RCW5lkVe2CZd2Wr2LxbfT2/uWeVKyZUukONO1HKBbflvX55jcPYmxse4fbto1K5QNXnScmLstGI+iexeDptVe7bNt21dOybqNQuOX7ge812wZGR19y1cWybmNmJi3nP6hbOYP288mTP0ex+DZyuQvy8zTN+ygUbmF8/MSDqRzRYyQej7qO90zmDKLRZxGJHAEA3LhRmybmLy1dDiwrn1/B8PDPXMdvPr8Cw7gv3z86+hIGB88ElrGbY9y2bUxOztZN6zTbtl37xLJuY2DgGVcf8yCNjWUwP/+eqz7Dwz9zJaqa9dF++4n37tNe6O39S3n8nD79omwPSqU7mJi4LGMiw7gfeJI2NpbBwMAzsKzbqFQ+wPDwz+qWOXny53v6Hd7VcAvRwIoI3nuWKw7eVCojz8rFWUPQ2XCjsw+nqalfIZM5K+sAADMzaczNLTY8o9D1Y9jc/EPb25rNXsXc3CLm5hblB+o8c2+WefGKRp/FxsYXANzb7Mx2i+li3wHubI13nc4zrk5l+P2ySyIL7Py8netzZmCcZ4nO7P6lS+82XO/Bg19Dd/fXUancAwBcuvQu3nnnb+uWi8XOPpSTDaL9yjTvI52+LE+MAaBSuYfjx7/T9L2pVAbnz88ik3G3PfF41BVY9/V9Tx67QVo9xv2Ew4caZj+DMlU9PS+62tB2r5r19X3P1b8421xnf+Vst0ulO3VZXidnfYK2yTTvY25uEYXCW67pudwFTE39KrC+3j66mXx+pe2+jMhLxAPihHd8/AQKhY9hmvextvYJdP2Y/G5OTr6K+fn3fMuZm1uU7ZQ4AXTKZq8iHD60V5sBYJdBcj6/Ak3rhqp2oVS6g3T6MqrVdVSr6xgdfUkevLYNLC+voVpdx1tvpZFKZXDx4hlUq+sol99HIvE6gNqB3Nd3GjdvzqNaXYemdQc2YoXCx3juOXejriiAZd2Gqnb5vqeWqfgYR49+u+1tHR8/gWRyCMnkEMbHT8A07yOReF3WtVzeaOuS1dzcouyUnNt87doU0untzsa2bbzyyp+hWl1HqXQHhcItuY9t25YBYix2FgMDz8gy+vpOt72NXrHYWdfntLy85srC37hxu259+fwKbNuWdSwUbsn36PprsrzDhw82XPfW1h+xufkHhMOHUCrdgWneR2/vd+uW+/DDXyIej+56W4m+Ki5dehejo0PQtO120jA20dd3uulQibfeSuOzz96HotTPUxwTNza+aNp5tXqM+5mZSSOdvhw4XCudvoxy+X1Uq+uYnV2U7aRt27INvXlzHrOzjZMqXleu/Ab9/dsJC9HmVqvrqFTuudbzzW8eRLW6jkjkCBKJ12V9Ll48I/u1bPaqrE+5/D7S6cu+CY719U+had3QtG7X9OFhvWnWX/TRrYjHo/jww1+2tCxRu7a2/ug73TA266bVRgt047XXtk8iP/roP8n5fif7e6GtINkwNqEo35ev4eGfYWVlBkDtjNWyfgtFUaAoSl0QpOvHvpxXC5p///stKIoCTeuWZwfr658iGn0Wvb3fhaIomJx8FbOzi3X1aETxtN6a9iNZX037ERYW/r7lBqORxcV/dtV1amos8GwIqF16cO676entLLhl3ZblHDr0p3XDHY4e/bbcrtpnUNvHy8v/IAPE5eU1nDv3UyiKguFhHaraFZhhnZtbdNVFUb7v2zAvLV3GxMQJ+Tl5TU6+Ktdn27Yso1K5J+tYqXyASOQITPM+KpV7ePnlH0BRFAwN/SBwX1258nP09v4lhod/htnZNKamfoXJyVcxOHgGivJ91+VO7+dNRI3NzS3i3Lmfyv9vH7cfyKES4fALvu9VlObHnLicOjn5auAy7RzjfjStC5nMWd/lcrnlL08CuqEoCqanz+LKld/I+SMjP4aiKDIgD+q4AWBi4rKrnQS2s2MzM2nMzqZlW+dtI/v6vif3lW3b+Nd//d+hKAomJk7Ijv3GjduYmhqT7x8dHUIu196PrTg/j0Z99E7KI9oJEduIGMSZQDx+/Dsyqwyg4ZUQw9jEk08ehGXdRi53wTV0aGwsg1zu731P2DuprSBZBLTOlzPgdF5md2ZDvWZm0q5L72JHbmx8gULhYzm9E9lQ75jkVrKOraTv797daqse3jHJznF3zkuDjbY5EjmCXO6C7/CHWr1fkPP8zsyEZHKo7nN0DlsRvMNAGtG0bmxu/gHxeBQjIz+uu5zp7YganajUTrhq9RLvE0NkLOs2VlZudWw4CdFXST6/Al0/5jr+xPEmpp0791MYxuaOboQRVwNzuQu+bYp3nbs5xsfHT6BSuVe33E7q7RwO4Rw2kcmcdbWTzqyt9+bwRm1upfKBb6a+UrmHROJ1OX1urr2kkFezPjrIE098Y1frJfIqFt+W322nSOQIMpmzMl4RV2aCiFhJxG5i+JJz2l5qe7iFOGsWLyGfX0G5vOG4MSR4XJOiAMvL/1A3GPuJJ74BXT/mOsBt+7e+Zej6MaytfeJTtjsrGlRfoBYMi3HB7Wo2XKC+Xv71MM37mJi4LIP5YvHthuUMD+uOfVMbbiEaQecJgW3/tuEXqNF+EU6e/DlyuQuyzEYMYxPd3V8HUPtSO29QLJXu4ODBr7mWb9aRiXqJDBNQC6wVRUE4fGhH48qJvuqKxd/5dkqdyB46b6YeHtabLt+JY3xqagwnT/7cNW0nVwqdNzaWy+876hjcVo6NZVw39vldbROcwWsmc0ZmwMPhQ6421rZ/i9nZ+svHR49+2/fEJZ9fqcv6B9VXtMF79RQAIqfe3u/K77W4cixOnCcmtmMEEfd5Nfq+Fou/Q6HwsRwhANRGDezFd7tjz0n2BpuNMslBN1sdPfptFAofux5LFHTz3uTkq3Xjt1KpjGtAeDP9/fUZ73T6Mk6e/POm7x0a+oGrrufPzyIafbal9Tp5M6yNLj00uqlC14/Jm+FEhmO32VZnZsRvvLW4LCg+y0jkCLLZq77jyFW1y1XHxcV/brp+UX/vzSeVyj0ZkBNR61ZWbtXdoOd9nNulS+/WZZubERlkMbyqVbs9xuPxKMLhQygUPpbTEolB1w3c6fTlptmqnXDemFh7uod/Jlm0x376+5/G+fPbT+oIehybqnYhmRyCrr/mmp5IvI433hhrqb6q2gVN63bdNC3qzfs6qJO8j3hNpTJIJocA1Lc3icTrvjGXiBlErJDNXoWmdSMSOYKZmbQMsiuVDwDUkoSdGErr1bEgeXz8BAxjU142unnzbVfD5fTWWxMyDR8OvyCzp6rahWLxbXlZKp2+jM8+8x/nG4kcwc2bb7suYRnG/YY3MfjVeXR0yHXJ7OLFs4ENRl/f9zA3t4hUKgNV7UIud0GuX9MO7WgAeSRyBLp+TF56EBkVvwA3Ho/Ctm1ZV1XtknVdWrqMlZVbcp9euzYV2FnNzS3WPUvTL/jOZM66Lpd4s/fiQEgkXpdf1NpdrLdkuSMjP5b1WFq6LNfdynCVvr7Tcp+K7QyFnnY9uopPtyBqnWFs1l3VicejOH16+ykNKyu3ZDtaKt1p6dnAly69C9u2XU97aDZEC2jtGG/G2+56L+eOjg7tyaMj33hjDOn0ZYRCT6NY/B2SySEUi7+rW05Vu3Dx4hm5T+bn35N1Hh8/gYGBZ+W8gYFnAus6M5PGwMAzrv177doUhodbD3DL5fdd7b+z7Qb4dAvqDFXtwrVrU/IYtG24jnPn9/jixTOuoRTO9mZp6TLm59+T8aB4uov3Ck9t2t4MTlbspg+Y4++Fk5tp3oem/Qirq/9TW1kjov3vKcffbBtbJ/Yb9xlR69je7MxTzRdpEX+WmoiIiIjI408edgVo/1HVrsAbKomIiIgeB8wkExERERF5tDAmmYiIiIjoq4WZZCIiIiIiDwbJREREREQeDJKJiIiIiDwYJBMREREReTBIJiIiIiLyMlb2GAAABWNJREFUaDlIzufzrp8BFK98Pg/TNKEoCkzT3FElstkswuFwy8uXSiVXHcbGWvvt+iBi23YjaB8MDg7K+mWzWQwODtb9HVQfb50GBweRz+d3VU8iIj+izWnWFg8ODsplve1dq2UQEe0HbWWSNU2DZVmuVzwe36u6+crn8+jr60OlUpF1ME0T2Wz2gdZjJ8bHx7G0tNR0uUQigUqlgkwmg1QqBaB2YgDgge9vInr8xWIxZDIZWJaFaDQq2x0v0c5aloVcLgdd19sug4hov2h7uIU3k+wnm826lhEBnsi2eqcLzgxFkMnJSeRyOWiaJpednZ3FxMRE0/UD7iy0N5M7NjbmmyFxlrebrHU2m0UsFkM+n8fExAQKhYJvebZtQ9M0PPnkkzAMAwAwNTWF2dnZumXD4XDdfiQiapVpmlheXsbLL78MRVGQSCR82xoAmJ+fx8mTJ6EoCoaHh1GpVFAqldoqg4hov+j4mORSqYR0Oi2zvMlkElNTUwCAVCqFXC4Hy7JQLBZx6tQp+T7DMDA5OQnLsqBpmm9m2DRNGIaBo0ePuqarqgrLspqu3zRNVxYagGv4Ql9fHyzLgq7ruHTpkpzvLG9ubm7XQx7i8TgymQx0XcfMzIzvMqZpYmNjA6qqIp/PQ1VVqKpat1y5XEYkEtlVfYjoq2trawsAZPty8OBBAPAdPmcYBrq7u+X/NU3D5uZmW2UQEe0XbQXJhmEgFArJVywWq1smEomgWq3KzOvhw4flPNu2ce/ePSiKgt7eXnz22WdynqZpiEQiUBQF0WgUd+/ebWtDRPa50foXFxcRjUZlFnppackVcMfjcSiKgv7+ftm4F4tFXLx4UZaXyWRw5cqVwHqEw2HXPioUCg3r65c1z+VyCIfDSKfTmJmZwfnz53Hu3Dn09PQgFAq5TiB2O5aaiIiIiOrtakzyhx9+6LtcLBaTQaVzGMTy8jLm5+flvI8++mh3tQ8QtH4vRVF8s7NOpmkinU7L8tLpdMPlnWOlRVa6XcPDw/L9169fx8DAABYXFzEwMADLsjAxMcEMDREREdEe2tVwC78sZj6fdwWKmUzGNb9cLvsOt2iFqqrQNA3r6+uu6aZpIhQKwTTNputvl6qq8mYU8Wrl5rtOEVlkADIrrmmavLxJRLQb3qER3qETTmJ4hSCGX7RTBhHRftHxMckbGxsA4Jt5DYfD+Oijj+Q827bbLn9qagrDw8OuTOrY2BhGR0ehqmrD9R8/ftw1/MH5eLYgfX19rkxyLBZ7YHdt5/N5DAwMyI5GDEExDEN2SkREu6GqKnRdx+LiIoDacK9kMum77MjIiBxuls/n5TC5dsogIto37BYtLCzYmqb5zjMMwwZgG4Zh27XI11YUxVYUxS4Wi7ZYTbFYlNMVRbErlYpt27Y9PT3tKjuZTNrJZDKwLrlczlVOMpm0LcuS84PW732vruu2ZVn2wsKCa5np6Wlb13X5/0wmU/eeZvtA0HVdbouz3NXVVRuAPTg4GLhPFUVxrUvTNFtRFDuTychp4XDYXl1dDdxXRETNWJYl2zhN02S7s7q6aofDYdeyuq7XteGNyiAi2q8U2249nWvbduCNYs55ziJFxjhoXqP3N7opzVttb1lB6w+qg98yzd7jVyfvPO+2tLOdQXVoVE8iop1opW1utFyzeURE+01bQTIRERER0VdBx8ckExERERHtdwySiYiIiIg8GCQTEREREXkwSCYiIiIi8mCQTERERETkwSCZiIiIiMiDQTIRERERkQeDZCIiIiIiDwbJREREREQeDJKJiIiIiDwYJBMREREReTBIJiIiIiLyYJBMREREROTBIJmIiIiIyOP/B/qHBSGTjxNsAAAAAElFTkSuQmCC)
如果硬解析高,这可能表明文字使用率高或引入了许多新的SQL。在这种情况下,
请考虑使用绑定变量代替文字。
如果软解析的百分比很高,则检查应用程序以查看它是否正在使用可共享的 SQL。
理想情况下,Execute to Parese 应该接近 100%
还有
高版本诊断请看 blog.chinaunix.net/uid-20687159-id-5853384.html
进一步深入诊断
-
单机
-
$ sqlplus "/ as sysdba"
-
-
oradebug setmypid
-
oradebug unlimit
-
oradebug dump systemstate 258
-
wait 90 seconds
-
oradebug dump systemstate 258
-
wait 90 seconds
-
oradebug dump systemstate 258
-
quit
-
-
RAC
-
$ sqlplus "/ as sysdba"
-
-
oradebug setmypid
-
oradebug unlimit
-
oradebug setinst all
-
oradebug -g all hanganalyze 4
-
oradebug -g all dump systemstate 258
-
quit
-
-
获取error stack
-
$ sqlplus "/ as sysdba"
-
-
SQL> oradebug setospid <p.spid from above>
-
oradebug dump errorstack 3
-
<< wait 1min>>
-
oradebug dump errorstack 3
-
<< wait 1min>>
-
oradebug dump errorstack 3
-
exit
如果遇到解析错误,即大量ORA-923,可以诊断一下
-
ALTER SYSTEM SET EVENTS '10035 trace name context forever, level 1';
-
等应用重复
-
ALTER SYSTEM SET EVENTS '10035 trace name context off';
好像19c数据库的告警日志中不设置此事件就有错误的sql。
剑走偏锋,获取大量硬解析的方法:
-
-
select INSTANCE_NUMBER,TOP_LEVEL_SQL_ID,SQL_ID,count(*) from dba_hist_active_sess_history
-
where IN_HARD_PARSE='Y' group by INSTANCE_NUMBER,TOP_LEVEL_SQL_ID,SQL_ID
-
having count(*)>100 order by count(*) desc;
-
应该找到原因了吧?
阅读(1508) | 评论(0) | 转发(0) |