DATA traveler

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

ALTER SESSION KILL SESSION 'SID, SERIAL#';

UPDATE 데이터오너.테이블명 SET 컬럼명 = ROUND(DBMS_RANDOM.VALUE(0, 100));

SELECT * FROM 테이블명 WHERE ORDER BY decode(컬럼명, '홍길동', 1, '스머프', 2, '심슨', 3, '스누피', 4);

SELECT * FROM USER_INDEXES WHERE TABLE_NAME='테이블명'

ALTER USER 계정명 ACCOUNT UNLOCK;

ALTER TABLE 데이터오너.테이블명 DROP CONSTRAINT 제약조건명;

DROP TABLESPACE 테이블스페이스명 INCLUDING CONTENTS AND DATAFILES CASCADE COSTRAINTS;

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