declare 
    s number := dbms_utility.get_time;
begin
delete from test_tdt;
commit; 
dbms_output.put_line('delete:'||(dbms_utility.get_time-s)/100);
end;
/
delete:0
declare 
    s number := dbms_utility.get_time;
begin
execute immediate 'truncate table test_tdt'; 
dbms_output.put_line('trunc:'||(dbms_utility.get_time-s)/100);
end;
/
trunc:,02
declare 
    s number := dbms_utility.get_time;
begin
execute immediate 'truncate table test_tdt'; 
dbms_output.put_line('trunc:'||(dbms_utility.get_time-s)/100);
end;
/
trunc:,02
declare 
    s number := dbms_utility.get_time;
begin
delete from test_tdt;
commit; 
dbms_output.put_line('delete:'||(dbms_utility.get_time-s)/100);
end;
/
delete:0
declare 
    s number := dbms_utility.get_time;
begin
delete from test_tdt;
commit; 
dbms_output.put_line('delete:'||(dbms_utility.get_time-s)/100);
end;
/
delete:0
declare 
    s number := dbms_utility.get_time;
begin
execute immediate 'truncate table test_tdt'; 
dbms_output.put_line('trunc:'||(dbms_utility.get_time-s)/100);
end;
/
trunc:,01

-- DDL Script for Table ow.test_tdt
CREATE TABLE test_tdt
    (id_tdt                VARCHAR2(15 BYTE) NOT NULL,
    v1                   VARCHAR2(200 BYTE),
    v2                   VARCHAR2(100 BYTE),
    v3                   VARCHAR2(100 BYTE),
    v4                   VARCHAR2(100 BYTE),
    v5                   VARCHAR2(3 BYTE),
    v6                   VARCHAR2(3 BYTE),
    n1                   NUMBER(1,0),
    n2                   NUMBER(1,0),
    n3                   NUMBER(4,0),
    n4                   NUMBER(2,0),
    n5                   NUMBER(1,0),
    d1                      DATE,
    d2                      DATE)
  SEGMENT CREATION IMMEDIATE
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  TABLESPACE  tbs_table
  STORAGE   (
    INITIAL     262144
    NEXT        262144
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
  NOCACHE
  MONITORING
  NOPARALLEL
  LOGGING
/
ALTER TABLE test_tdt
ADD CONSTRAINT pk_id_tdt PRIMARY KEY (id_tdt)
USING INDEX
  PCTFREE     10
  INITRANS    2
  MAXTRANS    255
  TABLESPACE  tbs_table
  STORAGE   (
    INITIAL     262144
    NEXT        262144
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
/
-- End of DDL Script for Table ow.test_tdt