- 통계 수집 프로시저
CREATE OR REPLACE PROCEDURE gather_seo_stats
AS
BEGIN
DBMS_STATS.GATHER_TABLE_STATS(
ownname => 'SJBABO',
tabname => 'WAREHOUSES',
estimate_percent => 10,
method_opt => 'FOR ALL COLUMNS SIZE AUTO',
cascade => TRUE
);
DBMS_OUTPUT.PUT_LINE('Statistics gathered for SJBABO.WAREHOUSES');
END gather_seo_stats;
/
------------------------------
SQL> EXEC gather_seo_stats;
PL/SQL procedure successfully completed.
SQL> SELECT TABLE_NAME, NUM_ROWS, BLOCKS, EMPTY_BLOCKS, AVG_ROW_LEN, LAST_ANALYZED
FROM DBA_TABLES
WHERE OWNER = 'SJBABO'
AND TABLE_NAME = 'WAREHOUSES'; 2 3 4
TABLE_NAME
--------------------------------------------------------------------------------
NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_ROW_LEN LAST_ANAL
---------- ---------- ------------ ----------- ---------
WAREHOUSES
1000 124 0 27 13-JAN-25👈
뭔가 신기
