set autotrace on sqlplus / as sysdba SQL>@?/rdbms/admin/utlxplan.sql SQL> @?/sqlplus/admin/plustrce.sql SQL>grant plustrace to hr; SQL>conn hr/hr SQL>set autotrace on; explain plan for select * from employees; select * from table(dbms_xplan.display); alter system set timed_statistics = true; alter system set max_dump_file_size=10; alter system set user_dump_dest='/u01/app/oracle/admin/orcl/udump'; alter session .. 더보기 이전 1 ··· 353 354 355 356 357 358 359 ··· 595 다음