본문 바로가기

스터디북125

[11/07] TTS SYS@orcl>create tablespace data01 datafile '/home/oracle/data01.dbf' size 50m reuse autoextend on; SYS@orcl>alter tablespace data01 read only; SYS@orcl>create directory ttsdump as '/home/oracle/dump'; [oracle@lnx04 dump]$ expdp system/oracle transport_tablespaces=data01 dumpfile=tts_data.dmp directory=ttsdump Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at 15:41:01 [oracle@l.. 2015. 11. 7.
<11/07> 밤 TEST ..... 오타를 조심하자 Duplicate and TTS 연습 금요일 튜닝 복습 2015. 11. 7.
[11/07] duplicate DB TEST and Duplicate DB 필요 디렉터리 생성 mkdir /datacd /datamkdir reorcl arc2 pfile을 복제 및 수정 SYS@orcl>create pfile from spfile; [oracle@lnx04 dbs]$ cp initorcl.ora initreorcl.ora[oracle@lnx04 dbs]$ vi initreorcl.ora 치환 명령을 이용한다 :% s/orcl/reorcl/g control_files의 경로 FRA 관련항목 주석처리 logfile 경로 수정convert할 항목들 경로 설정 reorcl.__db_cache_size=687865856reorcl.__java_pool_size=16777216reorcl.__large_pool_size=167772.. 2015. 11. 7.
<11/06> 사랑은 타이밍 Test and Tuning 성능이란response time + concureent through-put 확장성(스케빌리티) 고려 해야함 service time(수행시간) + latency(or wait) time(지연시간)edWrote file afiedt.buf 1 select ename, e.deptno, d.deptno, d.dname 2 from emp e, dept d 3 where e.deptno = d.deptno 4* and ename like 'A%'SCOTT@orcl>/ Execution Plan----------------------------------------------------------Plan hash value: 3625962092 ---------------------.. 2015. 11. 6.

티스토리툴바