Oracle导出Sqlprofile,根据sql_id生成sql profile

2、创建sql profile

DECLARE

V_HINTS SYS.SQLPROF_ATTR;

CURSOR C1 IS

SELECT *

FROM V$SQL

WHERE SQL_ID = 'ct47hsv47278w'

AND CHILD_NUMBER = 0;

L_C1 C1%ROWTYPE;

BEGIN

V_HINTS := SYS.SQLPROF_ATTR(

'BEGIN_OUTLINE_DATA',

'IGNORE_OPTIM_EMBEDDED_HINTS',

'OPTIMIZER_FEATURES_ENABLE(''10.2.0.5'')',

'ALL_ROWS',

'OUTLINE_LEAF(@"SEL$1")',

'INDEX_RS_ASC(@"SEL$1"" "IDX_TF_B_PAYLOG_1")',

'INDEX_RS_ASC(@"SEL$1"" ("TD_M_STAFF"."STAFF_ID"))',

'INDEX_RS_ASC(@"SEL$1"" ("TD_B_DISCNT_ACTION"."ACTION_CODE"))',

'INDEX_RS_ASC(@"SEL$1"" ("TD_B_IDTONAME"."PARA_ID" "TD_B_IDTONAME"."INFO_TYPE"))',

'INDEX_RS_ASC(@"SEL$1"" ("TF_B_PAYOTHER_LOG"."CHARGE_ID" "TF_B_PAYOTHER_LOG"."PARTITION_ID"

"TF_B_PAYOTHER_LOG"."CARRIER_ID"))',

'LEADING(@"SEL$1""""",

'USE_NL(@"SEL$1",

'USE_NL(@"SEL$1",

'USE_NL(@"SEL$1",

'USE_NL(@"SEL$1",

'END_OUTLINE_DATA'

);