* 예를 들어..DBMS_STATS.GET_TABLE_STATS일 경우..
1. 메뉴얼 페이지 가서 형식을 분석하고.
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_stats2.htm#1003960
2. 테스트 프로시져를 만든다.
CREATE OR REPLACE PROCEDURE testFunction
IS
a number;
b number;
c number;
BEGIN
DBMS_STATS.GET_TABLE_STATS ('SCOTT','EMP',NULL,NULL,NULL,a,b,c,NULL);
DBMS_OUTPUT.PUT_LINE('Number of rows in the table (partition). : '||a);
DBMS_OUTPUT.PUT_LINE('Number of blocks the table (partition) occupies :'||b);
DBMS_OUTPUT.PUT_LINE('Average row length for the table (partition). :' ||c);
END;
IS
a number;
b number;
c number;
BEGIN
DBMS_STATS.GET_TABLE_STATS ('SCOTT','EMP',NULL,NULL,NULL,a,b,c,NULL);
DBMS_OUTPUT.PUT_LINE('Number of rows in the table (partition). : '||a);
DBMS_OUTPUT.PUT_LINE('Number of blocks the table (partition) occupies :'||b);
DBMS_OUTPUT.PUT_LINE('Average row length for the table (partition). :' ||c);
END;
3. 실행해 본다.
SQL> exec testFunction
Number of rows in the table (partition). : 14
Number of blocks the table (partition) occupies :1
Average row length for the table (partition). :37
PL/SQL 처리가 정상적으로 완료되었습니다.
SQL>
Number of rows in the table (partition). : 14
Number of blocks the table (partition) occupies :1
Average row length for the table (partition). :37
PL/SQL 처리가 정상적으로 완료되었습니다.
SQL>
