DATA traveler

-- SELECT * FROM DBA_JOBES;-- SERLECT * FROM USER_JOBS; execute DBMS_JOB.BROKEN(잡번호, TRUE)

ALTER SESSION KILL SESSION 'SID, SERIAL#';

ORACLE 11g Data Pump Export expdp 아이디/암호 DIRECTORY=expdp받는곳 DUMPFILE=덤프파일명 \LOGFILE=로그파일명 SCHEMAS=스키마명 TABLES=테이블명 -- DIRECTORY 확인SQL> SELECT * FROM DBA_DIRECTOREIS; http://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_export.htm#g1022624

SELECT value FROM V$PARAMTERWHERE NAME='background_dump_dest;

-- 옵션 켜기SQL> ALTER SESSION SET SQL_TRACE=TRUE;Session altered. -- 트레이스 확인할 쿼리 수행SQL> query -- 옵션 끄기SQL> ALTER SESSION SET SQL_TRACE=FALSE; --트레이스 파일 확인 shell> tkprof 트레이스파일 텍스트파일로추출

오라클 플랜 확인하기 -- 쿼리 수행SQL> EXPLAIN PLAN FOR query -- 플랜 확인SQL> SELECT * FROM table(dbms_xplan.display);

SQL> SELECT NAME FROM V$PGASTAT; NAME----------------------------------------------------------------aggregate PGA target parameteraggregate PGA auto targetglobal memory boundtotal PGA inusetotal PGA allocatedmaximum PGA allocatedtotal freeable PGA memoryprocess countmax processes countPGA memory freed back to OStotal PGA used for auto workareasmaximum PGA used for auto workareastotal PGA used f..

db file scattered read: 랜덤 I/Odb file sequential read: sequential I/Oenq: TX - index contentionenq: TX - row lock contention