one of the pl/sql code takes long time to run and does nothing.
Tried running the sqltrpt.sql against the sql id to pin a plan and re-execute the query, but this is of no help.
Tune the sql
~~~~~~~~~~~~
GENERAL INFORMATION SECTION
-------------------------------------------------------------------------------
Tuning Task Name : TASK_25638
Tuning Task Owner : SYS
Workload Type : Single SQL Statement
Scope : COMPREHENSIVE
Time Limit(seconds): 1800
Completion Status : COMPLETED
Started at : 07/19/2016 13:05:07
Completed at : 07/19/2016 13:05:07
-------------------------------------------------------------------------------
Schema Name: GTA
SQL ID : 4kh61gf428r7r
SQL Text : declare
v_cretour varchar2(1) := '0';
v_nproc varchar2(100);
v_message varchar2(500);
v_cetat varchar2(100);
erreur exception;
begin
dbms_output.put_line('Calling ta_xml.register_schema to
register the schema...');
ta_xml.register_schema ( v_cretour, v_nproc, v_message,
v_cetat );
if v_cretour <> '0' then
raise erreur;
end if;
dbms_output.put_line ('Successfully registered the
schema...');
commit;
exception
when erreur then
dbms_output.put_line ('Error from ta_xml.register_schema =
'||v_message);
when others then
dbms_output.put_line ('Oracle error = '||sqlerrm(sqlcode));
end;
-------------------------------------------------------------------------------
ADDITIONAL INFORMATION SECTION
-------------------------------------------------------------------------------
- Type of SQL statement not supported.