화상연동/Web,APP 구축및서비스/LMS/평생교육/학점은행/기업교육/연수관리/설문구축/
27 04 2017
1.키체인에 접근( 상단의 spotlight 검색에서 키체인) (1) Apple Worldwide Developer Relations Certification Authority (2) iPhone Developer : (사용자이름) (고유번호) (3) iPhone Distribution : (사용자이름) (고유번호) 를 옮기면 된다. 1번의 경우는 키체인에서 왼쪽 시스템 클릭하면 오른쪽에 Apple Worldwide Developer Relations Certification Authority 항목에 오른쪽 마우스하고 보내기를 누르면 된다. ==> 등록시에는 drag and drop 하면됨 2번,3번의 경우는 로그인의 인증서를 선택하고 오른쪽 마우스하고 […]
19 04 2017
소스변경 : WebFrame –> UIWebView로 변경 1)Error: ld: library not found for -lcrt1.3.1.o Solution: If your project source have deployment target from iOS 5.0 then change it to iOS 6.0 or later and your error will be fix. Now that work fine for device too. 2)Apple Match-O Linker (id)Error – Product > Clean Enable BitCode를 […]
7 04 2017
Loading Local HTML to WebView
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
override func viewDidLoad() { super.viewDidLoad() // Do any additional setup after loading the view, typically from a nib. //getting local file let localHtmlFile = NSBundle.mainBundle().URLForResource("index", withExtension: "html"); //creating request let request = NSURLRequest(URL: localHtmlFile!); //loading request webView.loadRequest(request); } |
7 04 2017
ios 에서 이쁜 차트 Graph 사용하기 http://m.blog.naver.com/syowoo/220770292459
2 03 2017
테이블스페이스 정보 조회 SELECT * FROM DBA_TABLESPACES; Oracle 테이블 스페이별 용량
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
select substr(a.tablespace_name,1,30) tablespace, round(sum(a.total1)/1024/1024,1) "TotalMB", round(sum(a.total1)/1024/1024,1)-round(sum(a.sum1)/1024/1024,1) "UsedMB", round(sum(a.sum1)/1024/1024,1) "FreeMB", round((round(sum(a.total1)/1024/1024,1)-round(sum(a.sum1)/1024/1024,1))/round(sum(a.total1)/1024/1024,1)*100,2) "Used%" from (select tablespace_name,0 total1,sum(bytes) sum1,max(bytes) MAXB,count(bytes) cnt from dba_free_space group by tablespace_name union select tablespace_name,sum(bytes) total1,0,0,0 from dba_data_files group by tablespace_name) a group by a.tablespace_name order by tablespace; |
테이블스페이스별 현황 확인 쿼리문(MB 단위)
|
1 2 3 4 5 6 7 |
SELECT TABLESPACE_NAME, FILE_NAME, BYTES/1024 AS MBytes, RESULT/1024 AS USE_MBytes FROM ( SELECT E.TABLESPACE_NAME,E.FILE_NAME,E.BYTES, (E.BYTES-SUM(F.BYTES)) RESULT FROM DBA_DATA_FILES E, DBA_FREE_SPACE F WHERE E.FILE_ID = F.FILE_ID GROUP BY E.TABLESPACE_NAME, E.FILE_NAME, E.BYTES ) A; |
테이블스페이스별, 파일별 현황 확인 쿼리문(바이트 단위)
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
SELECT A.TABLESPACE_NAME "테이블스페이스명", A.FILE_NAME "파일경로", (A.BYTES - B.FREE) "사용공간", B.FREE "여유 공간", A.BYTES "총크기", TO_CHAR( (B.FREE / A.BYTES * 100) , '999.99')||'%' "여유공간" FROM ( SELECT FILE_ID, TABLESPACE_NAME, FILE_NAME, SUBSTR(FILE_NAME,1,200) FILE_NM, SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY FILE_ID,TABLESPACE_NAME,FILE_NAME,SUBSTR(FILE_NAME,1,200) ) A, ( SELECT TABLESPACE_NAME, FILE_ID, SUM(NVL(BYTES,0)) FREE FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME,FILE_ID ) B WHERE A.TABLESPACE_NAME=B.TABLESPACE_NAME AND A.FILE_ID = B.FILE_ID; |
테이블 용량 조회
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
<span class="kwd">SELECT</span><span class="pln"> owner</span><span class="pun">,</span><span class="pln"> table_name</span><span class="pun">,</span><span class="pln"> TRUNC</span><span class="pun">(</span><span class="pln">sum</span><span class="pun">(</span><span class="pln">bytes</span><span class="pun">)/</span><span class="lit">1024</span><span class="pun">/</span><span class="lit">1024</span><span class="pun">/</span><span class="lit">1024</span><span class="pun">)</span><span class="pln"> GB </span><span class="kwd">FROM</span> <span class="pun">(</span><span class="kwd">SELECT</span><span class="pln"> segment_name table_name</span><span class="pun">,</span><span class="pln"> owner</span><span class="pun">,</span><span class="pln"> bytes </span><span class="kwd">FROM</span><span class="pln"> dba_segments </span><span class="kwd">WHERE</span><span class="pln"> segment_type </span><span class="kwd">in</span> <span class="pun">(</span><span class="str">'TABLE'</span><span class="pun">,</span><span class="str">'TABLE PARTITION'</span><span class="pun">)</span> <span class="kwd">UNION</span> <span class="kwd">ALL</span> <span class="kwd">SELECT</span><span class="pln"> i</span><span class="pun">.</span><span class="pln">table_name</span><span class="pun">,</span><span class="pln"> i</span><span class="pun">.</span><span class="pln">owner</span><span class="pun">,</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">bytes </span><span class="kwd">FROM</span><span class="pln"> dba_indexes i</span><span class="pun">,</span><span class="pln"> dba_segments s </span><span class="kwd">WHERE</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">segment_name </span><span class="pun">=</span><span class="pln"> i</span><span class="pun">.</span><span class="pln">index_name </span><span class="kwd">AND</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">owner </span><span class="pun">=</span><span class="pln"> i</span><span class="pun">.</span><span class="pln">owner </span><span class="kwd">AND</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">segment_type </span><span class="kwd">in</span> <span class="pun">(</span><span class="str">'INDEX'</span><span class="pun">,</span><span class="str">'INDEX PARTITION'</span><span class="pun">)</span> <span class="kwd">UNION</span> <span class="kwd">ALL</span> <span class="kwd">SELECT</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">table_name</span><span class="pun">,</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">owner</span><span class="pun">,</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">bytes </span><span class="kwd">FROM</span><span class="pln"> dba_lobs l</span><span class="pun">,</span><span class="pln"> dba_segments s </span><span class="kwd">WHERE</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">segment_name </span><span class="pun">=</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">segment_name </span><span class="kwd">AND</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">owner </span><span class="pun">=</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">owner </span><span class="kwd">AND</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">segment_type </span><span class="kwd">IN</span> <span class="pun">(</span><span class="str">'LOBSEGMENT'</span><span class="pun">,</span><span class="str">'LOB PARTITION'</span><span class="pun">)</span> <span class="kwd">UNION</span> <span class="kwd">ALL</span> <span class="kwd">SELECT</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">table_name</span><span class="pun">,</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">owner</span><span class="pun">,</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">bytes </span><span class="kwd">FROM</span><span class="pln"> dba_lobs l</span><span class="pun">,</span><span class="pln"> dba_segments s </span><span class="kwd">WHERE</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">segment_name </span><span class="pun">=</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">index_name </span><span class="kwd">AND</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">owner </span><span class="pun">=</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">owner </span><span class="kwd">AND</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">segment_type </span><span class="pun">=</span> <span class="str">'LOBINDEX'</span><span class="pun">)</span> <span class="com">---WHERE owner in UPPER('&owner')</span> <span class="kwd">GROUP</span> <span class="kwd">BY</span><span class="pln"> table_name</span><span class="pun">,</span><span class="pln"> owner </span><span class="kwd">HAVING</span><span class="pln"> SUM</span><span class="pun">(</span><span class="pln">bytes</span><span class="pun">)/</span><span class="lit">1024</span><span class="pun">/</span><span class="lit">1024</span> <span class="pun">></span> <span class="lit">10</span> <span class="com">/* Ignore really small tables */</span> <span class="kwd">ORDER</span> <span class="kwd">BY</span><span class="pln"> SUM</span><span class="pun">(</span><span class="pln">bytes</span><span class="pun">)</span> <span class="kwd">desc</span> |
17 01 2017
import javax.imageio.ImageIO; import javax.media.jai.JAI; import javax.media.jai.RenderedOp; //썸네일 이미지 파일 File save = new File(saveFile); //load파일은 원본이미지 파일 RenderedOp 객체 생성 RenderedOp rOp = JAI.create(“fileload”, loadFile); //BufferImage 객체를 얻어옴 BufferedImage im = rOp.getAsBufferedImage(); //줌이 5이면 원본 이미지의 1/5 크기가 된다 float zoom = 1f; if(im.getWidth() > 200) { zoom = ((float)im.getWidth()) / 200f; } int […]
23 12 2016
select ‘alter table ‘||TABLE_NAME||’ modify(컬럼명 VARCHAR2(32));’ AS query, COLUMN_NAME, DATA_TYPE, DATA_LENGTH from ALL_TAB_COLUMNS where COLUMN_NAME LIKE ‘%USR_ID’ and data_length != 20 컬럼 속성 길이나 컬럼 속성을 변경 쿼리(alter table)를 뽑아 일괄 실행하여 변경한다.(티베로DB도 동일한 방법으로 사용할 수 있다.)
15 12 2016
1.Physical에서 전체 선택하고 harden physical Names를 선택 2.완료되면 Phyiscal -> Logical로 변경후 메뉴에서 Model>Domain Dictionary를 선택하고 Name Inherited by Attribute항목에 다음을 복사 %if(%>(%Len(%ColumnComment),0)){%ColumnComment}%ELSE{%ColName} OK를 눌러 창을 닫는다 3.다시 Model > Attributes 를 선택후 Reset을 클릭하면 아래의 화면이 나옴 Reset all attributes in model 선택하고 Select Propertiers to Reset 에서 Name만 선택하고 OK 를 누르고 […]
6 12 2016
start/stop start : 파워스위치를 3초정도 길게 누른다. stop : shutdown -hy 0(0초이내 즉시 재부팅) 재부팅 : shutdown -ry 강제종료 : shutdown -h 0 디스크의 용량 # bdf 명령 실행 중지 ctrl + c 대신 delete 키를 누름 패치목록 확인 #swlist -l product 프로세스 갯수 #ps -ef | wc os bit #getconf KERNEL_BITS IP확인 #netstat -in […]
29 11 2016
http://zero-gravity.tistory.com/251 참고