declare
  v_result varchar2(100);
begin
  v_result := dbms_sqltune.create_tuning_task(
    sql_text   => 'select * from dual where 1 = :b1 and 2 = :b2 and (:b3 is null or 3 = :b3)'
   ,bind_list  => sql_binds(anydata.ConvertNumber(1),anydata.ConvertNumber(2),anydata.ConvertNumber(null))
   ,time_limit => 60
   ,task_name  => 'tt_my_task'
  );
  v_result := dbms_sqltune.execute_tuning_task(task_name => 'tt_my_task');
end;
/
select dbms_sqltune.report_tuning_task('tt_my_task') from dual;
begin dbms_sqltune.drop_tuning_task('tt_my_task'); end;
/

SQL> select banner from v$version
  2  /

BANNER
--------------------------------------------------------------------------------
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

SQL> declare
  2    v_result    varchar2(100);
  3  begin
  4    v_result := dbms_sqltune.create_tuning_task(
  5      sql_text   => 'select * from dual where 1 = :b1 and 2 = :b2 and (:b3 is null or 3 = :b3)'
  6     ,bind_list  => sql_binds(anydata.ConvertNumber(1),anydata.ConvertNumber(2),anydata.ConvertNumber(null))
  7     ,time_limit => 60
  8     ,task_name  => 'tt_my_task'
  9    );
 10    v_result := dbms_sqltune.execute_tuning_task(task_name => 'tt_my_task');
 11  end;
 12  /

SQL> select dbms_sqltune.report_tuning_task('tt_my_task') from dual
  2  /

DBMS_SQLTUNE.REPORT_TUNING_TAS
--------------------------------------------------------------------------------
GENERAL INFORMATION SECTION
-------------------------------------------------------------------------------
Tuning Task Name   : tt_my_task
Tuning Task Owner  : SYSTEM
Workload Type      : Single SQL Statement
Scope              : COMPREHENSIVE
Time Limit(seconds): 60
Completion Status  : COMPLETED
Started at         : 07/09/2020 07:32:39
Completed at       : 07/09/2020 07:33:31
-------------------------------------------------------------------------------
Schema Name: SYSTEM
SQL ID     : dp45w53chrvyu
SQL Text   : select * from dual where 1 = :b1 and 2 = :b2 and (:b3 is null or
             3 = :b3)
Bind Variables :
 1 -  (NUMBER):1
 2 -  (NUMBER):2
-------------------------------------------------------------------------------
ERRORS SECTION
-------------------------------------------------------------------------------
- ORA-01008: не все переменные привязаны
-------------------------------------------------------------------------------