tag:blogger.com,1999:blog-6888143.post2769630199021320046..comments2023-08-16T00:46:48.846-07:00Comments on Where ORACLE is not just another database: A Typical Case of SQL Tuning using 11g SQL BaselineYingkuan Liuhttp://www.blogger.com/profile/07173527060088964047noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6888143.post-83937572603896926452018-07-07T15:55:49.674-07:002018-07-07T15:55:49.674-07:00LOAD SQL PLANS from Cursor Cache.
SQL> VARIAB...<br />LOAD SQL PLANS from Cursor Cache. <br /><br />SQL> VARIABLE cnt NUMBER<br />SQL> EXECUTE :cnt := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE( sql_id => 'cz6xfzbzk5dkw');<br /><br />PL/SQL procedure successfully completed.<br /><br />SQL> SELECT SQL_HANDLE, SQL_TEXT, PLAN_NAME,<br /> ORIGIN, ENABLED, ACCEPTED<br />FROM DBA_SQL_PLAN_BASELINES; Yingkuan Liuhttps://www.blogger.com/profile/07173527060088964047noreply@blogger.comtag:blogger.com,1999:blog-6888143.post-80265132483846543862018-07-07T15:22:50.005-07:002018-07-07T15:22:50.005-07:00baseline_ref_cursor for select VALUE(p) from table...baseline_ref_cursor for select VALUE(p) from table(DBMS_SQLTUNE.SELECT_WORKLOAD_REPOSITORY(<b>1,132,</b>NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ALL')) p;<br /><br />The two numbers are snapshot ID, find your current from AWRYingkuan Liuhttps://www.blogger.com/profile/07173527060088964047noreply@blogger.com