You Lead!!

* trace --alter session set timed_statistics=true; alter session set sql_trace=true; alter session set sql_trace=false; EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(123,1234,TRUE); EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(123,1234,FALSE); --EXEC DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(sid=>123, serial#=>1234, sql_trace=>TRUE); --EXEC DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(sid=>123, serial#=>1234,..

오라클의 PLAN_TABLE 생성문의 위치 : ORACLE_HOME/rdbms/admin/utlxplan.sql * 오라클 10g create table PLAN_TABLE ( statement_id varchar2(30), plan_id number, timestamp date, remarks varchar2(4000), operation varchar2(30), options varchar2(255), object_node varchar2(128), object_owner varchar2(30), object_name varchar2(30), object_alias varchar2(65), object_instance numeric, object_type varchar2(30), optimizer v..

출처 : http://www.superuser.co.kr, http://blog.empas.com/bkseo21/18491412 import, export사용(imp, exp) linux라는 사용자로 연결한다 SQL> connect linux/linux 연결되었습니다. SQL> set pagesize 30 linux가 가진 테이블은 다음과 같다 SQL> select * from tab; TNAME TABTYPECLUSTERID ------------------------------ ------- ---------- S_CUSTOMER TABLE S_DEPT TABLE S_EMP TABLE S_IMAGE TABLE S_INVENTORY TABLE S_ITEM TABLE S_LONGTEXT TABLE S_O..