HTN20190109 https://blog.hatena.ne.jp/HTN20190109/ HTN20190109の日記 https://htn20190109.hatenablog.com/ 演習 https://docs.oracle.com/cd/F19136_01/tgsql/managing-sql-plan-baselines.html#GUID-C7C5AEF7-5833-4780-81CF-C40CE6B43571 select max(prod_id) from sh.sales;select sql_id from v$sql where sql_text like 'select max(prod_id) from sh.sales%'; DECLARE my_plans PLS_INTEGER;BEGIN my_plans := DBMS_SPM.LOAD_PLAN… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2024%2F12%2F13%2F235213" title="{SQL計画管理}SQL計画ベースラインにカーソルから手動ロード - HTN20190109の日記" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2024-12-13 23:52:13 rich https://htn20190109.hatenablog.com/entry/2024/12/13/235213 1.0 100%