#) 새로 샘플 테이블 생성. (nologging 조건으로 생성) create table hr.emp nologging as select * from hr.employees; create table hr.dept nologging as select * from hr.departments; create table hr.loc nologging as select * from hr.locations; #) 프로시저 생성 exec dbms_stats.gather_table_stats('hr', 'emp'); exec dbms_stats.gather_table_stats('hr', 'dept'); exec dbms_stats.gather_table_stats('hr', 'loc'); #) 생성 확인 select ..