3월 2020 | (주)누리웨어

16 03 2020

Oracle Lock 제거 및 Connection Pool 관련

1.DB Conneciton Pool 관련 Pool조회 select * from v$resource_limit where resource_name in (‘processes’, ‘sessions’); Sessions 접속 정보 쿼리 SELECT username, program FROM v$session; 접속 사용자 제거

--alter system kill session 'session_id,serial#';
alter system kill session '32,11234';

1 2	--alter system kill session 'session_id,serial#'; alter system kill session '32,11234';

현재 Connection Pool 사용현황

SELECT  * 
  FROM  V$resource_limit 
 WHERE   resource_name IN ('processes','sessions');

SELECT *

FROM V$resource_limit

WHERE resource_name IN ('processes','sessions');

접속이 안되는 경우 INACTIVE 갯수가 많을 경우 삭제 하면 됨

SELECT  'alter system kill session ''' || sid || ',' || serial# || ''' immediate;'
  FROM  v$session
 WHERE  username = 'NURIWARE'
   AND  status = 'INACTIVE'

SELECT 'alter system kill session ''' || sid || ',' || serial# || ''' immediate;'

FROM v$session

WHERE username = 'NURIWARE'

AND status = 'INACTIVE'

나오는 결과를 아래처럼 실행

alter system kill session '13,46763';
alter system kill session '29,30175';
alter system kill session '39,21235';
alter system kill session '43,53103';
alter system kill session '45,40359';
alter system kill session '46,50781';
alter system kill session '62,65397';
alter system kill session '71,15497';
alter system kill session '256,13051';
alter system kill session '262,14689';

alter system kill session '13,46763';

alter system kill session '29,30175';

alter system kill session '39,21235';

alter system kill session '43,53103';

alter system kill session '45,40359';

alter system kill session '46,50781';

alter system kill session '62,65397';

alter system kill session '71,15497';

alter system kill session '256,13051';

alter system kill session '262,14689';

2.DB Lock 관련 lock 조회

SELECT  DO.OBJECT_NAME, DO.OWNER, DO.OBJECT_TYPE, DO.OWNER,

        VO.XIDUSN, VO.SESSION_ID, VO.LOCKED_MODE

FROM    V$LOCKED_OBJECT VO, DBA_OBJECTS DO

WHERE   VO.OBJECT_ID = DO.OBJECT_ID;

SELECT DO.OBJECT_NAME, DO.OWNER, DO.OBJECT_TYPE, DO.OWNER,

VO.XIDUSN, VO.SESSION_ID, VO.LOCKED_MODE

FROM V$LOCKED_OBJECT VO, DBA_OBJECTS DO

WHERE VO.OBJECT_ID = DO.OBJECT_ID;

[…]

12 03 2020

Apache Http 와 Tomcat 동접 늘리기

Haeng Ho Kang | Programming, Server, WAS, Linux/Unix, Web

1. 아파치 설정값 확인 ./apachectl -V 환경 Linux apache 2.2.19 MPM은 Prefork 방식 참고 : MPM prefork 방식은 프로세스:쓰레드 = 1:1 방식 Worker 방식은 프로세스:쓰레드 = 1:n 방식 아파치 컴파일된 셋팅값 조회 # /usr/local/apache/bin/apachectl -V 설정 Httpd.conf 에서 /conf/extra/httpd-mpm.conf 을 Include 처리 (리마크 제외) 하고 Httpd-mpm.conf 파일을 열고 지시자 변경

[root@web1 bin]# ./apachectl -V

Server version: Apache/2.4.37 (Unix)
Server built:   Dec 20 2018 17:37:42
Server's Module Magic Number: 20120211:83
Server loaded:  APR 1.6.5, APR-UTIL 1.6.1
Compiled using: APR 1.6.5, APR-UTIL 1.6.1

Architecture:   64-bit

Server MPM:    <strong> event</strong>
  threaded:     yes (fixed thread count)
    forked:     yes (variable process count)

Server compiled with....
-D APR_HAS_SENDFILE
-D APR_HAS_MMAP
-D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
-D APR_USE_SYSVSEM_SERIALIZE
-D APR_USE_PTHREAD_SERIALIZE
-D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
-D APR_HAS_OTHER_CHILD
-D AP_HAVE_RELIABLE_PIPED_LOGS
-D DYNAMIC_MODULE_LIMIT=256
-D HTTPD_ROOT="/opt/web/apache2"
-D SUEXEC_BIN="/opt/web/apache2/bin/suexec"
-D DEFAULT_PIDLOG="logs/httpd.pid"
-D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
-D DEFAULT_ERRORLOG="logs/error_log"
-D AP_TYPES_CONFIG_FILE="conf/mime.types"
-D SERVER_CONFIG_FILE="conf/httpd.conf"

[root@web1 bin]# ./apachectl -V

Server version: Apache/2.4.37 (Unix)

Server built: Dec 20 2018 17:37:42

Server's Module Magic Number: 20120211:83

Server loaded: APR 1.6.5, APR-UTIL 1.6.1

Compiled using: APR 1.6.5, APR-UTIL 1.6.1

Architecture: 64-bit

Server MPM: <strong> event</strong>

threaded: yes (fixed thread count)

forked: yes (variable process count)

Server compiled with....

-D APR_HAS_SENDFILE

-D APR_HAS_MMAP

-D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)

-D APR_USE_SYSVSEM_SERIALIZE

-D APR_USE_PTHREAD_SERIALIZE

-D SINGLE_LISTEN_UNSERIALIZED_ACCEPT

-D APR_HAS_OTHER_CHILD

-D AP_HAVE_RELIABLE_PIPED_LOGS

-D DYNAMIC_MODULE_LIMIT=256

-D HTTPD_ROOT="/opt/web/apache2"

-D SUEXEC_BIN="/opt/web/apache2/bin/suexec"

-D DEFAULT_PIDLOG="logs/httpd.pid"

-D DEFAULT_SCOREBOARD="logs/apache_runtime_status"

-D DEFAULT_ERRORLOG="logs/error_log"

-D AP_TYPES_CONFIG_FILE="conf/mime.types"

-D SERVER_CONFIG_FILE="conf/httpd.conf"

위의 MPM방법은 event 방식이다 여기에 맞는 설정값을 변경해야 한다. MaxRequestWorkers 을 변경한다.

#<IfModule mpm_event_module>
# StartServers 3
# MinSpareThreads 75
# MaxSpareThreads 250
# ThreadsPerChild 25
# MaxRequestWorkers 400
# MaxConnectionsPerChild 0
#</IfModule>

<IfModule mpm_event_module>
StartServers 8
ServerLimit 16
MinSpareThreads 64
MaxSpareThreads 256
ThreadsPerChild 64
<strong>MaxRequestWorkers 1024</strong>
MaxConnectionsPerChild 0
</IfModule>

#<IfModule mpm_event_module>

# StartServers 3

# MinSpareThreads 75

# MaxSpareThreads 250

# ThreadsPerChild 25

# MaxRequestWorkers 400

# MaxConnectionsPerChild 0

#</IfModule>

StartServers 8

ServerLimit 16

MinSpareThreads 64

MaxSpareThreads 256

ThreadsPerChild 64

<strong>MaxRequestWorkers 1024</strong>

MaxConnectionsPerChild 0

</IfModule>

2.Tomcat 의 경우 Server.xml에 maxThreads를 확인해서 숫자를 늘린다.

3월, 2020

Oracle Lock 제거 및 Connection Pool 관련

Apache Http 와 Tomcat 동접 늘리기