Java7 AES256 사용하기
java7 에서 aes256을 사용하기 위해서는 security 라이브러리를 교체해야함. 첨부파일 /sw/jdk7/jre/lib/security 에 교체하면됨
시간 오래 걸리는 쿼리는?
시간 오래 걸리는 쿼리는? ------------------------------------------------ -- sys 계정으로 들어가서 느린 쿼리를 골라 낸다. ------------------------------------------------ select sql_text, elapsed_time, executions, -- ((elapsed_time / executions ) || '(ms)') as AVG_ELA_TIME, last_load_time ((ROUND(ELAPSED_TIME/EXECUTIONS/1000000,4)) ||…
오라클 FullScan 쿼리 찾기
오라클 Full Scan 쿼리를 찾아보자. SELECT /*+ ORDERED USE_NL(A SQ)*/ SQL_FULLTEXT ,SQ.SQL_ID ,PLAN_HASH_VALUE ,SQ.MODULE ,TRUNC(CPU_TIME/DECODE(EXECUTIONS,0,1,EXECUTIONS)/1000/1000,2) AS CPU_ONE ,TRUNC(ELAPSED_TIME/DECODE(EXECUTIONS,0,1,EXECUTIONS)/1000/1000,2) AS EPLAP ,TRUNC(BUFFER_GETS/DECODE(EXECUTIONS,0,1,EXECUTIONS)/1000/1000,2) AS BUFFER_GET FROM (SELECT DISTINCT SQL_ID FROM V$SQL_PLAN WHERE…
Apache 서버 설치
사전준비 yum -y install wget gcc gcc-c++ pcre-devel openssl-devel yum install expat-devel 설치 wget http://mirror.navercorp.com/apache//httpd/httpd-2.4.38.tar.bz2 wget http://apache.mirror.cdnetworks.com//apr/apr-1.6.5.tar.gz wget http://apache.mirror.cdnetworks.com//apr/apr-util-1.6.1.tar.gz wget http://downloads.sourceforge.net/project/pcre/pcre/8.41/pcre-8.41.tar.bz2 tar xvf httpd-2.4.38.tar.bz2 tar xzvf apr-1.6.5.tar.gz tar xzvf apr-util-1.6.1.tar.gz…