Oracle 固定执行计划--sqlprofile

步骤一-------------------------创建测试表，根据DBA_OBJECTS创建，OBJECT_ID上有索引
Create table test as select * from dba_objects;
create index t_1 on test(test_id);
 
步骤二-------------------------查看SQL默认执行计划,走了索引
explain plan for select * from test where object_id= 172;
select * from table(dbms_xplan.display(null,null,'outline')); ----通过指定outline可以获取到系统为我们生成的hint
-----------------------------------------------
| Id  | Operation                   | Name    |
-----------------------------------------------
|   0 | SELECT STATEMENT            |         |
|   1 |  TABLE ACCESS BY INDEX ROWID| TEST |
|*  2 |   INDEX RANGE SCAN          | T_1     |
-----------------------------------------------
Outline Data
-------------
 
  /*+
      BEGIN_OUTLINE_DATA
      INDEX_RS_ASC(@"SEL$1" "TEST"@"SEL$1" (