HTN20190109 https://blog.hatena.ne.jp/HTN20190109/ HTN20190109の日記 https://htn20190109.hatenablog.com/ 演習 https://docs.oracle.com/cd/F19136_01/arpls/DBMS_SPM.html#GUID-0E915A6D-F783-4BE6-9E5A-C2B756666341 SELECT SQL_HANDLE, PLAN_NAME, ENABLED, ACCEPTED, FIXED ,origin, created, SQL_TEXTFROM DBA_SQL_PLAN_BASELINESorder by CREATED; declaren number;beginn := DBMS_SPM.ALTER_SQL_PLAN_BASELINE ( sql_handle =>'… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2024%2F12%2F15%2F090918" title="{SQL計画管理}SPMで実行計画を使用可能 - 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-15 09:09:18 rich https://htn20190109.hatenablog.com/entry/2024/12/15/090918 1.0 100%