(주)누리웨어 | 화상연동/Web,APP 구축및서비스/LMS/평생교육/학점은행/기업교육/연수관리/설문구축/

19 04 2017

XCode 구버젼을 IOS10.3에서 컴파일 및 배포시 변경내용

소스변경 : 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

Swift : WebView 사용방법

Haeng Ho Kang | Programming, Swift | 0

Loading Local HTML to WebView

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);
}

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

Swift : 다양한 팁

Haeng Ho Kang | Programming, Swift | 0

ios 에서 이쁜 차트 Graph 사용하기 http://m.blog.naver.com/syowoo/220770292459

2 03 2017

Oracle 용량확인

Haeng Ho Kang | DataBase, Oracle | 0

테이블스페이스 정보 조회 SELECT * FROM DBA_TABLESPACES; Oracle 테이블 스페이별 용량

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;

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 단위)

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;

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;

테이블스페이스별, 파일별 현황 확인 쿼리문(바이트 단위)

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;

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;

테이블 용량 조회

<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('&amp;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">&gt;</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>

SELECT

owner, table_name, TRUNC(sum(bytes)/1024/1024/1024) GB

FROM

(SELECT segment_name table_name, owner, bytes

FROM dba_segments

WHERE segment_type in ('TABLE','TABLE PARTITION')

UNION ALL

SELECT i.table_name, i.owner, s.bytes

FROM dba_indexes i, dba_segments s

WHERE s.segment_name = i.index_name

AND s.owner = i.owner

AND s.segment_type in ('INDEX','INDEX PARTITION')

UNION ALL

SELECT l.table_name, l.owner, s.bytes

FROM dba_lobs l, dba_segments s

WHERE s.segment_name = l.segment_name

AND s.owner = l.owner

AND s.segment_type IN ('LOBSEGMENT','LOB PARTITION')

UNION ALL

FROM dba_lobs l, dba_segments s

WHERE s.segment_name = l.index_name

AND s.owner = l.owner

AND s.segment_type = 'LOBINDEX')

---WHERE owner in UPPER('&owner')

GROUP BY table_name, owner

HAVING SUM(bytes)/1024/1024 > 10 /* Ignore really small tables */

ORDER BY SUM(bytes) desc

17 01 2017

썸네일 이미지 생성

Haeng Ho Kang | Programming, Java | 0

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

오라클 테이블 컬럼 검색하여 일괄 속성변경

Haeng Ho Kang | Uncategorized | 0

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

ERwin 을 사용 comment를 Logical 로 사용방법

Haeng Ho Kang | TOOL, erwin | 0

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

Unix – HP-UX 명령어

Haeng Ho Kang | OS, Linux/Unix | 0

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

IText Pdf

Haeng Ho Kang | Uncategorized | 0

http://zero-gravity.tistory.com/251 참고

16 11 2016

HP-UX 에서 Apache + Tomcat 설치

Haeng Ho Kang | OS, Server, Linux/Unix, Web | 0

설치된 OS버젼을 확인

root@dev_was [/opt/hpws]# swlist -l bundle QPKBASE
# Initializing...
# Contacting target "dev_was"...
#
# Target: dev_was:/
#

QPKBASE B.11.31.1603.421a Base Quality Pack Bundle for HP-UX 11i v3, March 2016

root@dev_was [/opt/hpws]# swlist -l bundle QPKBASE

# Initializing...

# Contacting target "dev_was"...

# Target: dev_was:/

QPKBASE B.11.31.1603.421a Base Quality Pack Bundle for HP-UX 11i v3, March 2016

개별 환경 변수 설정의 경우는 cd ~ 해당 홈디렉토리 의 vi .profile 예 저장하시면 되구요 전체 공용 계정별 환경변수 저장은 vi /etc/profile에 설정 하면됩니다. 다운로드 https://h20392.www2.hp.com/portal/swdepot/displayProductsList.do?category=NSM 설치하기

root@dev_was [/tmp]# swinstall -s ./HP_UX_11.31_HPUXWS22ATW-B408-11-31-64.depot

1	root@dev_was [/tmp]# swinstall -s ./HP_UX_11.31_HPUXWS22ATW-B408-11-31-64.depot

설치선택화면 설치선택완료화면(선택하고 Actions>Mark for Install 그다음 Actions>install하면 설치합니다. 설치중 화면 대화형 창이 뜨면 Space Bar로 apache를 선택 2)위의 명령어로 설치하면

root@dev_was [/opt/hpws22]# pwd
/opt/hpws22

root@dev_was [/opt/hpws22]# ls -al
total 112
drwxr-xr-x 8 bin bin 8192 Jul 16 2015 .
dr-xr-xr-x 93 bin bin 8192 Nov 16 13:56 ..
drwxr-xr-x 2 bin bin 96 Nov 16 15:46 LICENSES
-r--r--r-- 1 bin bin 3853 Dec 16 2008 README
drwxr-xr-x 22 bin bin 8192 Jul 16 2015 apache
drwxr-xr-x 8 bin bin 8192 Nov 16 15:46 hp_docs
drwxr-xr-x 13 bin bin 8192 Nov 16 15:46 tomcat
dr-xr-xr-x 2 bin bin 96 Jul 16 2015 util
drwxr-xr-x 19 bin bin 8192 Jul 16 2015 webmin

root@dev_was [/opt/hpws22]# pwd

/opt/hpws22

root@dev_was [/opt/hpws22]# ls -al

total 112

drwxr-xr-x 8 bin bin 8192 Jul 16 2015 .

dr-xr-xr-x 93 bin bin 8192 Nov 16 13:56 ..

drwxr-xr-x 2 bin bin 96 Nov 16 15:46 LICENSES

-r--r--r-- 1 bin bin 3853 Dec 16 2008 README

drwxr-xr-x 22 bin bin 8192 Jul 16 2015 apache

drwxr-xr-x 8 bin bin 8192 Nov 16 15:46 hp_docs

drwxr-xr-x 13 bin bin 8192 Nov 16 15:46 tomcat

dr-xr-xr-x 2 bin bin 96 Jul 16 2015 util

drwxr-xr-x 19 bin bin 8192 Jul 16 2015 webmin

위에서 […]

Previous Posts Next posts