常用SQL性能统计代码

 1 BEGIN
    DBMS_STATS.GATHER_TABLE_STATS(OWNNAME=> 'TELEDB', TABNAME=> 'WFGTEST', PARTNAME=> NULL);
END;
ALTER   TABLE  WFGTEST  DEALLOCATE   UNUSED ;
COMMIT;

SELECT TABLE_NAME,NUM_ROWS,BLOCKS,EMPTY_BLOCKS
FROM USER_TABLES
WHERE TABLE_NAME='WFGTEST';

SELECT COUNT(1) FROM WFGTEST;

DELETE FROM WFGTEST;
COMMIT;

TRUNCATE TABLE WFGTEST;
COMMIT;

SELECT *FROM WFGTEST;

DECLARE
    NUM NUMBER(20);
    DT1 DATE;
BEGIN
    NUM :=1;
    DT1 := SYSDATE();
    FOR NUM IN 1 .. 1000000
    LOOP
        INSERT INTO WFGTEST VALUES(TO_CHAR(NUM),TO_CHAR(NUM),NUM);
    END LOOP;
COMMIT;

DBMS_OUTPUT.PUT_LINE(FLOOR(TO_NUMBER(SYSDATE-DT1)*24*60*60));

END ;