Tina Admin

Similar documents
SQL Developer Connect to TimesTen 유니원아이앤씨 DB 기술지원팀 2010 년 07 월 28 일 문서정보 프로젝트명 SQL Developer Connect to TimesTen 서브시스템명 버전 1.0 문서명 작성일 작성자

PowerPoint 프레젠테이션

6주차.key

리눅스 free 메모리의이해 엑셈컨설팅본부 /DB 컨설팅팀임경석 개요 리눅스환경에서메모리사용률을모니터링하기위해명령어를실행하다보면시스템을기동한지얼마되지않아 free 영역의지표가급격히줄어드는것을쉽게확인할수있다. 리눅스어드민경험이있는사람이라면이것이무엇을의미하는지알수있지만그렇

Sena Technologies, Inc. HelloDevice Super 1.1.0

Tina Admin

1217 WebTrafMon II

Solaris Express Developer Edition

PowerPoint 프레젠테이션

MySQL-Ch10

PowerPoint 프레젠테이션

bn2019_2

휠세미나3 ver0.4

PowerPoint 프레젠테이션

TCP.IP.ppt

untitled

28 THE ASIAN JOURNAL OF TEX [2] ko.tex [5]

목차 BUG offline replicator 에서유효하지않은로그를읽을경우비정상종료할수있다... 3 BUG 각 partition 이서로다른 tablespace 를가지고, column type 이 CLOB 이며, 해당 table 을 truncate

untitled

10X56_NWG_KOR.indd

Copyright 2012, Oracle and/or its affiliates. All rights reserved.,.,,,,,,,,,,,,.,...,. U.S. GOVERNMENT END USERS. Oracle programs, including any oper

untitled

Remote UI Guide

<C0CCBCBCBFB52DC1A4B4EBBFF82DBCAEBBE7B3EDB9AE2D D382E687770>

PowerPoint 프레젠테이션

chapter4

UDP Flooding Attack 공격과 방어

PowerPoint 프레젠테이션

SRC PLUS 제어기 MANUAL

본문서는 초급자들을 대상으로 최대한 쉽게 작성하였습니다. 본문서에서는 설치방법만 기술했으며 자세한 설정방법은 검색을 통하시기 바랍니다. 1. 설치개요 워드프레스는 블로그 형태의 홈페이지를 빠르게 만들수 있게 해 주는 프로그램입니다. 다양한 기능을 하는 플러그인과 디자인

PowerPoint 프레젠테이션

Microsoft PowerPoint - comp_prac_081223_2.pptx

LXR 설치 및 사용법.doc

리눅스설치가이드 3. 3Rabbitz Book 을리눅스에서설치하기위한절차는다음과같습니다. 설치에대한예시는우분투서버 기준으로진행됩니다. 1. Java Development Kit (JDK) 또는 Java Runtime Environment (JRE) 를설치합니다. 2.

Sena Device Server Serial/IP TM Version

untitled

MPLAB C18 C

Copyright 2004 Sun Microsystems, Inc Network Circle, Santa Clara, CA U.S.A..,,. Sun. Sun. Berkeley BSD. UNIX X/Open Company, Ltd.. Sun, Su

Sun Java System Messaging Server 63 64

hd1300_k_v1r2_Final_.PDF

INSIDabcdef_:MS_0001MS_0001 시험종목 제 회리눅스마스터 급 차 시험일자 토 분 수검자기재사항및감독자확인 수검번호 감독자확인 성 명 생년월일 수검자유의사항 수험자는반드시신분증을지참하여야시험에응시할수있습니다 답안지는반드시검정필기구를사용하되 연필이나샤프

Network seminar.key

슬라이드 1

CD-RW_Advanced.PDF

본교재는수업용으로제작된게시물입니다. 영리목적으로사용할경우저작권법제 30 조항에의거법적처벌을받을수있습니다. [ 실습 ] 스위치장비초기화 1. NVRAM 에저장되어있는 'startup-config' 파일이있다면, 삭제를실시한다. SWx>enable SWx#erase sta

PowerPoint 프레젠테이션

CPX-E-SYS_BES_C_ _ k1

Oracle Database 10g: Self-Managing Database DB TSC

Mango220 Android How to compile and Transfer image to Target

/chroot/lib/ /chroot/etc/

Simplify your Job Automatic Storage Management DB TSC

vm-웨어-앞부속

Snort Install Manual Ad2m VMware libnet tar.gz DebianOS libpcap tar.gz Putty snort tar.gz WinSCP snort rules 1. 첫번째로네트워크설정 1) ifconf

CPX-E-EC_BES_C_ _ k1

2008

DE1-SoC Board

SMB_ICMP_UDP(huichang).PDF


K7VT2_QIG_v3

Interstage5 SOAP서비스 설정 가이드

<31332DB9E9C6AEB7A2C7D8C5B72D3131C0E528BACEB7CF292E687770>

ARMBOOT 1

다음 사항을 꼭 확인하세요! 도움말 안내 - 본 도움말에는 iodd2511 조작방법 및 활용법이 적혀 있습니다. - 본 제품 사용 전에 안전을 위한 주의사항 을 반드시 숙지하십시오. - 문제가 발생하면 문제해결 을 참조하십시오. 중요한 Data 는 항상 백업 하십시오.

단계

Session XX-XX: Name

Mango-AM335x Hardware Test Manual

Chapter 1

Interstage4 설치가이드

PowerChute Personal Edition v3.1.0 에이전트 사용 설명서

B _00_Ko_p1-p51.indd

APOGEE Insight_KR_Base_3P11

PowerPoint Presentation

Microsoft Word ARM_ver2_0a.docx

1. What is AX1 AX1 Program은 WIZnet 사의 Hardwired TCP/IP Chip인 iinchip 들의성능평가및 Test를위해제작된 Windows 기반의 PC Program이다. AX1은 Internet을통해 iinchip Evaluation

ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE (Online Upgrade) ORANGE CONFIGURATION ADMIN O

PowerPoint 프레젠테이션

T100MD+

<4D F736F F F696E74202D FC7C1B7CEBCBCBDBABFCD20BBE7BFEBC0DA20B8EDB7C920C0CDC8F7B1E22E >

인켈(국문)pdf.pdf

Microsoft PowerPoint - ch07.ppt

TTA Verified : HomeGateway :, : (NEtwork Testing Team)

Chapter11OSPF


¹Ìµå¹Ì3Â÷Àμâ

Social Network

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션

manual pdfÃÖÁ¾

슬라이드 1


Integ

4. 스위치재부팅을실시한다. ( 만약, Save 질문이나오면 'no' 를실시한다.) SWx#reload System configuration has been modified. Save? [yes/no]: no Proceed with reload? [confirm] (

Microsoft Word - KPMC-400,401 SW 사용 설명서

제2장 유닉스 사용

초보자를 위한 C++

Backup Exec

PowerPoint 프레젠테이션

3ÆÄÆ®-11

Microsoft Word - ntasFrameBuilderInstallGuide2.5.doc

Transcription:

유니원아이앤씨 DB 팀최순석 문서정보프로젝트명서브시스템명 버전 1.0 문서명 작성일 2015-09-04 작성자 최순석 최종수정일 2015-09-04 문서번호 UNIONE-201509041200-css 재개정이력 일자내용수정인버전 문서배포이력 발신자수신자배포목적일자비고.

Table of Contents 1 개요... 3 2 기본설정... 3 2.1 파일업로드... 3 2.2 압축해제... 3 2.3 설정파일수정... 4 3 실행및종료... 6 3.1 실행... 6 3.2 종료... 7 4 수집항목내용... 7 4.1 ifconfig... 7 4.2 iostat... 8 4.3 meminfo... 8 4.4 mpstat... 9 4.5 netstat... 10 4.6 prvstat... 12 4.7 ps... 12 4.8 slabinfo... 13 4.9 top... 13 4.10 vmstat... 14 5 OSWatcher 에대한의견... 14 6 참고자료 owsbb 사용방법... 15 6.1 java 최신버전다운로드... 15 6.2 java 설치... 15 6.3 java 등록... 15 6.4 oswbb 실행... 16 6.5 gif파일생성... 18 6.6 archive 경로에수집된자료의그래프... 19.

1 개요 OSWatcher 사용밥법기술 2 기본설정 OSWatcher (Includes: [Video]) ( 문서 ID 301137.1) => 문서를통해최신파일다운로드 : oswbb732 OS Watcher User's Guide ( 문서 ID 1531223.1) 2.1 파일업로드 ex ) $> /oracle/work/oswbb732.tar 2.2 압축해제 $> tar xvf oswbb732.tar $> ls l drwxrwxr-x 2 oracle 502 drwxr-xr-x 12 oracle dba drwxrwxr-x 2 oracle 502 drwxrwxr-x 4 oracle 502 drwxrwxr-x 2 oracle 502 drwxr-xr-x 2 oracle 502 4096 May 2 19:46 analysis 4096 Oct 6 17:57 archive 67 Jan 16 2014 call_du.sh 68 Oct 8 2013 call_sar.sh 71 Jan 8 2014 call_uptime.sh 4096 May 2 19:46 data 4096 Sep 9 00:37 docs 626 Jan 16 2014 Example_extras.txt 1864 Oct 8 2013 Exampleprivate.net 4096 May 2 19:49 gif 772 May 8 22:21 ifconfigsub.sh 743 Oct 8 2013 iosub.sh 4096 Oct 10 13:15 locks 1486 Jan 9 2014 ltop.sh 542 Oct 8 2013 mpsub.sh 740 Oct 8 2013 nfssub.sh 3/24

5062 Sep 17 18:15 OSWatcherFM.sh 34832 Sep 17 18:27 OSWatcher.sh 235221 Sep 5 23:37 oswbba.jar -rwxr-xr-x 1 oracle dba drwxrwxr-x 2 oracle 502 drwxrwxr-x 2 oracle 502 drwxr-xr-x 2 oracle dba 414 Oct 8 2013 oswib.sh 435 Jan 9 2014 oswnet.sh 825 Oct 8 2013 oswrds.sh 524 Oct 8 2013 oswsub.sh 262 Oct 6 17:25 private.net 4096 May 2 19:50 profile 1445 Oct 18 2013 psmemsub.sh 4096 May 2 19:50 src 2385 Oct 8 2013 startoswbb.sh 558 Oct 10 09:11 stoposwbb.sh 746 Nov 6 2013 tarupfiles.sh 4219 Nov 6 2013 tar_up_partial_archive.sh 4096 Oct 10 13:15 tmp 537 Jan 9 2014 topaix.sh 544 Oct 8 2013 vmsub.sh 1486 Jan 9 2014 xtop.sh # uninstall 방법은디렉토리를삭제하면된다 $> rm -rf oswbb 2.3 설정파일수정 $> cp /oracle/work/oswbb/exampleprivate.net /oracle/work/oswbb/private.net $> vi / oracle/work/oswbb/private.net # This file contains examples of how to monitor private networks. To # monitor your private networks create an executable file in this same # directory named private.net. Use the example for your host os below. # Make sure not to remove the last line in this file. Your file # private.net MUST contain the rm lock.file line. #Solaris Example 4/24

echo "zzz ***"`date` traceroute -r -F <node1-priv> traceroute -I -r -F <node1-priv> traceroute -r -F <node2-priv> traceroute -I -r -F <node2-priv> #HP Example echo "zzz ***"`date` traceroute -r -F <node1-priv> traceroute -r -F <node2-priv> #Linux Example echo "zzz ***"`date` traceroute -r -F <node1-priv> traceroute -r -F <node2-priv> #Tru64 Example echo "zzz ***"`date` traceroute -r -f <node1-priv> traceroute -r -f <node2-priv> #AIX Example echo "zzz ***"`date` traceroute -r <node1-priv> traceroute -r <node2-priv> # DO NOT DELETE THE FOLLOWING LINE!!!!!!!!!!!!!!!!!!!!! rm locks/lock.file 5/24

==> 위항목중에운영중인 OS의설정을제외한다른항목은제거한다. ex) linux #Linux Example echo "zzz ***"`date` traceroute -r -F <node1-priv> traceroute -r -F <node2-priv> # DO NOT DELETE THE FOLLOWING LINE!!!!!!!!!!!!!!!!!!!!! rm locks/lock.file ==> 싱글 db 의경우서버호스트네임을입력하면된다 3 실행및종료 3.1 실행 $> cd /oracle/work/oswbb/ $>./ startoswbb.sh # 옵션을이용해서백그라운드로수행한다 => nohup./startoswbb.sh 60 1 gzip & : 60초마다 1회씩수집하고파일은자동 gzip 실행 [1] 21261 nohup: appending output to `nohup.out' $> ps -ef grep OSWatcher.sh oracle 21266 1 0 09:25 pts/1 00:00:00 /bin/sh./oswatcher.sh 60 1 gzip # oswatcher 을실행할경우./oswbb/archive 폴더가자동생성되며 archive 하위에실행되는각각의수집명령에관련된폴더들이추가로생성된다 $> pwd /oracle/work/oswbb/archive drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswifconfig 6/24

drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswiostat drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswmeminfo drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswmpstat drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswnetstat drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswprvtnet drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswps drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswslabinfo drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswtop drwxr-xr-x 2 oracle dba 4096 Oct 10 13:00 oswvmstat 3.2 종료 $> cd /oracle/work/oswbb/ $>./ stoposwbb.sh 4 수집항목내용 4.1 ifconfig zzz ***Fri Oct 10 13:36:54 KST 2014 eth0 Link encap:ethernet HWaddr 08:00:27:D1:6D:E9 inet addr:192.168.1.10 Bcast:192.168.1.255 Mask:255.255.255.0 UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:28174 errors:0 dropped:0 overruns:0 frame:0 TX packets:22353 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:8655927 (8.2 MiB) TX bytes:4362043 (4.1 MiB) lo Link encap:local Loopback inet addr:127.0.0.1 Mask:255.0.0.0 UP LOOPBACK RUNNING MTU:16436 Metric:1 RX packets:26907 errors:0 dropped:0 overruns:0 frame:0 TX packets:26907 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:4174143 (3.9 MiB) TX bytes:4174143 (3.9 MiB 7/24

4.2 iostat zzz ***Fri Oct 10 13:36:54 KST 2014 avg-cpu: %user %nice %system %iowait %steal %idle 2.04 0.00 3.06 0.00 0.00 94.90 Device: rrqm/s wrqm/s r/s w/s rkb/s wkb/s avgrq-sz avgqu-sz await svctm %util sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 sda1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 sda2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 sda3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 sda4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4.3 meminfo zzz ***Fri Oct 10 13:36:54 KST 2014 MemTotal: MemFree: Buffers: Cached: SwapCached: Active: Inactive: Active(anon): Inactive(anon): Active(file): Inactive(file): Unevictable: Mlocked: SwapTotal: SwapFree: Dirty: Writeback: AnonPages: Mapped: Shmem: Slab: 1016464 kb 17904 kb 28916 kb 625780 kb 3372 kb 456152 kb 413688 kb 216908 kb 218180 kb 239244 kb 195508 kb 4448 kb 4448 kb 3068404 kb 3047600 kb 76 kb 0 kb 216608 kb 215204 kb 216796 kb 68456 kb 8/24

SReclaimable: SUnreclaim: KernelStack: PageTables: NFS_Unstable: Bounce: WritebackTmp: CommitLimit: Committed_AS: VmallocTotal: VmallocUsed: VmallocChunk: 35028 kb 33428 kb 1696 kb 37808 kb 0 kb 0 kb 0 kb 3576636 kb 963076 kb 34359738367 kb 8000 kb 34359724368 kb HugePages_Total: 0 HugePages_Free: 0 HugePages_Rsvd: 0 HugePages_Surp: 0 Hugepagesize: DirectMap4k: DirectMap2M: 2048 kb 8128 kb 1040384 kb 4.4 mpstat zzz ***Fri Oct 10 13:36:54 KST 2014 Linux 2.6.32-200.13.1.el5uek (single) 10/10/2014 01:36:54 PM CPU %user %nice %sys %iowait %irq %soft %steal %idle intr/s 01:36:55 PM all 4.00 0.00 8.00 1.00 0.00 0.00 0.00 87.00 910.00 01:36:55 PM 0 4.00 0.00 8.00 1.00 0.00 0.00 0.00 87.00 11.00 01:36:55 PM CPU %user %nice %sys %iowait %irq %soft %steal %idle intr/s 01:36:56 PM all 2.02 0.00 3.03 0.00 0.00 0.00 0.00 94.95 860.61 01:36:56 PM 0 2.02 0.00 3.03 0.00 0.00 0.00 0.00 94.95 23.23 Average: CPU %user %nice %sys %iowait %irq %soft %steal %idle intr/s Average: all 3.02 0.00 5.53 0.50 0.00 0.00 0.00 90.95 885.43 Average: 0 3.02 0.00 5.53 0.50 0.00 0.00 0.00 90.95 17.09 9/24

4.5 netstat zzz ***Fri Oct 10 13:36:54 KST 2014 Kernel Interface table Iface MTU Met RX-OK RX-ERR RX-DRP RX-OVR TX-OK TX-ERR TX-DRP TX-OVR Flg eth0 1500 0 28174 0 0 0 22353 0 0 0 BMRU lo 16436 0 26907 0 0 0 26907 0 0 0 LRU Ip: 50717 total packets received 182 with invalid addresses 0 forwarded 0 incoming packets discarded 50535 incoming packets delivered 45738 requests sent out 42 dropped because of missing route Icmp: 4947 ICMP messages received 0 input ICMP message failed. ICMP input histogram: destination unreachable: 4947 4947 ICMP messages sent 0 ICMP messages failed ICMP output histogram: destination unreachable: 4947 IcmpMsg: InType3: 4947 OutType3: 4947 Tcp: 6869 active connections openings 19 passive connection openings 6864 failed connection attempts 10 connection resets received 5 connections established 39108 segments received 35811 segments send out 6 segments retransmited 10/24

0 bad segments received. 6882 resets sent Udp: 55 packets received 4947 packets to unknown port received. 0 packet receive errors 4972 packets sent UdpLite: TcpExt: 3 TCP sockets finished time wait in fast timer 1 time wait sockets recycled by time stamp 495 delayed acks sent 4 delayed acks further delayed because of locked socket 261 packets directly queued to recvmsg prequeue. 39786 packets directly received from prequeue 12293 packets header predicted 72 packets header predicted and directly queued to user 5202 acknowledgments not containing data received 2119 predicted acknowledgments 0 TCP data loss events 6 other TCP timeouts 6 DSACKs received 1 connections reset due to early user close 8 connections aborted due to timeout TCPDSACKIgnoredOld: 6 IpExt: InMcastPkts: 42 OutMcastPkts: 14 InBcastPkts: 1478 InOctets: 12236383 OutOctets: 8122036 InMcastOctets: 5915 OutMcastOctets: 2125 InBcastOctets: 151618 11/24

4.6 prvstat zzz ***Fri Oct 10 13:34:54 KST 2014 traceroute to single (127.0.0.1), 30 hops max, 40 byte packets 1 single (127.0.0.1) 0.028 ms 0.007 ms 0.005 ms zzz ***Fri Oct 10 13:35:54 KST 2014 traceroute to single (127.0.0.1), 30 hops max, 40 byte packets 1 single (127.0.0.1) 0.022 ms 0.006 ms 0.004 ms zzz ***Fri Oct 10 13:36:54 KST 2014 traceroute to single (127.0.0.1), 30 hops max, 40 byte packets 1 single (127.0.0.1) 0.023 ms 0.006 ms 0.005 ms 4.7 ps zzz ***Fri Oct 10 13:35:54 KST 2014 USER PID PPID PRI %CPU %MEM VSZ RSS WCHAN S STARTED TIME COMMAND oracle 2888 1 19 0.0 10.8 479288 110248 semtim S Oct 09 00:00:06 ora_smon_stg oracle 2896 1 19 0.0 9.1 480504 92660 semtim S Oct 09 00:00:29 ora_mmon_stg oracle 2876 1 19 0.0 8.0 481080 82072 semtim S Oct 09 00:00:19 ora_dbw0_stg oracle 2971 1 19 0.0 7.6 481324 77744 semtim S Oct 09 00:01:07 ora_cjq0_stg oracle 14136 1 19 0.4 6.0 478240 61380 semtim S 12:57:42 00:00:11 ora_j000_stg oracle 2934 1 19 0.0 4.1 506492 42376 semtim S Oct 09 00:00:03 ora_arc2_stg... root 13 2 19 0.0 0.0 0 0 worker S Oct 09 00:00:00 [kintegrityd/0] root 125 1 23 0.0 0.0 13072 408 poll_s S Oct 09 00:00:00 /sbin/udevd -d root 12 2 19 0.0 0.0 0 0 bdi_fo S Oct 09 00:00:00 [bdi-default] root 11 2 19 0.0 0.0 0 0 bdi_sy S Oct 09 00:00:00 [sync_supers] root 10 2 19 0.0 0.0 0 0 async_ S Oct 09 00:00:00 [async/mgr] root 1 0 19 0.0 0.0 10364 584 poll_s S Oct 09 00:00:01 init [5] oracle 18915 18890 19 0.0 0.0 109148 712 pipe_w S 13:36:54 00:00:00 sort -nr -k 6 oracle 18914 18890 19 0.0 0.0 65596 1000 - R 13:36:54 00:00:00 ps -aeo user,pid,ppid,pri,pcpu,pmem,vsize,rssize,wchan,s,start,cputime,command oracle 18897 21266 19 0.0 0.0 58896 536 hrtime S 13:36:54 00:00:00 sleep 60 oracle 18887 18876 19 0.0 0.0 58924 728 pause S 13:36:54 00:00:00 iostat -xk 1 3 oracle 18879 18870 19 0.0 0.0 58924 648 pause S 13:36:54 00:00:00 mpstat -P ALL 1 2 12/24

oracle 18878 18868 19 0.0 0.0 5864 464 hrtime S 13:36:54 00:00:00 vmstat 1 3 avahi 2377 2376 19 0.0 0.0 23164 164 unix_s S Oct 09 00:00:00 avahi-daemon: chroot helper 68 2134 2109 19 0.0 0.0 12340 724 evdev_ S Oct 09 00:00:00 hald-addon-keyboard: listening on /dev/input/event1 68 2131 2109 19 0.0 0.0 12340 724 evdev_ S Oct 09 00:00:00 hald-addon-keyboard: listening on /dev/input/event0 68 2125 2109 19 0.0 0.0 12340 764 evdev_ S Oct 09 00:00:00 hald-addon-keyboard: listening on /dev/input/event3 68 2119 2109 19 0.0 0.0 12340 728 unix_s S Oct 09 00:00:00 hald-addon-acpi: listening on acpid socket /var/run/acpid.socket 4.8 slabinfo zzz ***Fri Oct 10 13:36:54 KST 2014 slabinfo - version: 2.1 # name <active_objs> <num_objs> <objsize> <objperslab> <pagesperslab> : tunables <limit> <batchcount> <sharedfactor> : slabdata <active_slabs> <num_slabs> <sharedavail> rpc_buffers 8 8 2048 2 1 : tunables 24 12 0 : slabdata 4 4 0 rpc_tasks 8 12 320 12 1 : tunables 54 27 0 : slabdata 1 1 0 rpc_inode_cache 8 8 832 4 1 : tunables 54 27 0 : slabdata 2 2 0 iser_descriptors 0 0 320 12 1 : tunables 54 27 0 : slabdata 0 0 0 ib_mad 0 0 448 8 1 : tunables 54 27 0 : slabdata 0 0 0...... size-32(dma) 0 0 32 112 1 : tunables 120 60 0 : slabdata 0 0 0 size-128 930 1050 128 30 1 : tunables 120 60 0 : slabdata 35 35 0 size-32 14620 14672 32 112 1 : tunables 120 60 0 : slabdata 131 131 0 kmem_cache 181 181 2176 1 1 : tunables 24 12 0 : slabdata 181 181 0 4.9 top zzz ***Fri Oct 10 13:36:54 KST 2014 top - 13:36:56 up 1 day, 2:00, 4 users, load average: 0.00, 0.00, 0.00 Tasks: 182 total, 1 running, 181 sleeping, 0 stopped, 0 zombie Cpu(s): 2.0%us, 2.0%sy, 0.0%ni, 95.1%id, 1.0%wa, 0.0%hi, 0.0%si, 0.0%st 13/24

Mem: 1016464k total, 996720k used, 19744k free, 28916k buffers Swap: 3068404k total, 20804k used, 3047600k free, 625856k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 18907 oracle 20 0 12760 1156 832 R 2.0 0.1 0:00.03 top 2503 root 20 0 101m 10m 3924 S 1.0 1.1 0:12.69 Xorg 17742 root 20 0 90144 3360 2612 S 1.0 0.3 0:00.73 sshd 1 root 20 0 10364 584 548 S 0.0 0.1 0:01.15 init 2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd 3 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0 4 root 20 0 0 0 0 S 0.0 0.0 0:26.46 ksoftirqd/0 5 root RT 0 0 0 0 S 0.0 0.0 0:00.00 watchdog/0 6 root 20 0 0 0 0 S 0.0 0.0 0:04.08 events/0 7 root 20 0 0 0 0 S 0.0 0.0 0:00.00 cpuset 8 root 20 0 0 0 0 S 0.0 0.0 0:00.02 khelper 9 root 20 0 0 0 0 S 0.0 0.0 0:00.00 netns 4.10 vmstat zzz ***Fri Oct 10 13:36:54 KST 2014 procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------ r b swpd free buff cache si so bi bo in cs us sy id wa st 5 0 20804 20552 28916 625780 0 0 31 44 346 204 1 1 95 3 0 0 0 20804 19744 28916 625856 0 0 0 56 910 1892 3 7 89 1 0 0 0 20804 20776 28916 625848 0 0 0 0 853 1669 2 3 95 0 0 5 OSWatcher 에대한의견 오라클SR 확인결과 OSWatcher 실행시 OS에미치는영향은거의없다고합니다. 서버에부하를주지않기때문에운영서버에평상시걸어놔도문제가없다고합니다. 한가지고려할사항은로그파일사이즈와관련해서디스크공간확보문제인데, 테스트결과 60 1 설정의경우 1일누적로그사이즈가 5M 를넘지않았습니다. 여기에 gzip 옵션을추가할경우 2M 정도로감소하는것을확인했습니다. 노트북의테스트환경과실제운영서버환경의차이가있겠지만그크기차는미미할것으로예상합니다. 서버과부하를야기시키지도않고다양한 OS 정보를수집할수있는 OSWatcher 를활용해봅시다. 14/24

6 참고자료 owsbb 사용방법 java version 1.4.2 이상설치 xwindow 환경설정 - 조건이안될경우 gif 파일을생성해서분석가능하다. OSWatcher Analyzer User Guide ( 문서 ID 461053.1) 6.1 java 최신버전다운로드 http://www.java.com/ko/download/manual.jsp 6.2 java 설치 # cd /usr/ # mkdir java # cd java # tar zxvf jre-7u7-linux-x64.tar.gz # java 설치경로 : /usr/java/jre1.7.0_67/bin 6.3 java 등록 $> java version java version "1.4.2" gij (GNU libgcj) version 4.1.2 20080704 (Red Hat 4.1.2-51) Copyright (C) 2006 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. $ su # cd /usr/bin #> ls l java lrwxrwxrwx 1 root root 22 Nov 30 2012 java -> /etc/alternatives/java #> mv java java.1.4.bak #> ls -l java* lrwxrwxrwx 1 root root 22 Nov 30 2012 java.1.4.bak -> /etc/alternatives/java lrwxrwxrwx 1 root root 23 Nov 30 2012 javac -> /etc/alternatives/javac 15/24

lrwxrwxrwx 1 root root 25 Nov 30 2012 javadoc -> /etc/alternatives/javadoc lrwxrwxrwx 1 root root 23 Nov 30 2012 javah -> /etc/alternatives/javah #> ln -s /usr/java/jre1.7.0_67/bin /usr/bin/java #> ls -l java* lrwxrwxrwx 1 root root 25 Oct 10 15:02 java -> /usr/java/jre1.7.0_67/bin lrwxrwxrwx 1 root root 22 Nov 30 2012 java.1.4.bak -> /etc/alternatives/java lrwxrwxrwx 1 root root 23 Nov 30 2012 javac -> /etc/alternatives/javac lrwxrwxrwx 1 root root 25 Nov 30 2012 javadoc -> /etc/alternatives/javadoc lrwxrwxrwx 1 root root 23 Nov 30 2012 javah -> /etc/alternatives/javah #> ls -l /usr/bin/java lrwxrwxrwx 1 root root 25 Oct 10 15:02 /usr/bin/java -> /usr/java/jre1.7.0_67/bin $> java -version java version "1.7.0_67" Java(TM) SE Runtime Environment (build 1.7.0_67-b01) Java HotSpot(TM) 64-Bit Server VM (build 24.65-b04, mixed mode) 6.4 oswbb 실행 $> java -jar oswbba.jar -i /oracle/work/oswbb/archive/ Starting OSW Analyzer V7.3.1 OSWatcher Analyzer Written by Oracle Center of Expertise Copyright (c) 2014 by Oracle Corporation Parsing Data. Please Wait... WARNING. oswbba has detected at least some of the files in you archive have been compressed. These files will not be analyzed. You must uncompress all the files in the archive for full analysis and graphing capabilities. Scanning file headers for version and platform info... Compressed file found. Ignoring single_iostat_14.10.10.1200.dat.gz... 16/24

Compressed file found. Ignoring single_iostat_14.10.10.1200.dat.gz... Parsing file single_iostat_14.10.10.1300.dat... Compressed file found. Ignoring single_vmstat_14.10.10.1200.dat.gz... Parsing file single_vmstat_14.10.10.1300.dat... Compressed file found. Ignoring single_netstat_14.10.10.1200.dat.gz... Parsing file single_netstat_14.10.10.1300.dat... Compressed file found. Ignoring single_top_14.10.10.1200.dat.gz... Parsing file single_top_14.10.10.1300.dat... Compressed file found. Ignoring single_ps_14.10.10.1200.dat.gz... Parsing file single_ps_14.10.10.1300.dat... Parsing Completed. Enter 1 to Display CPU Process Queue Graphs Enter 2 to Display CPU Utilization Graphs Enter 3 to Display CPU Other Graphs Enter 4 to Display Memory Graphs Enter 5 to Display Disk IO Graphs Enter 6 to Generate All CPU Gif Files Enter 7 to Generate All Memory Gif Files Enter 8 to Generate All Disk Gif Files Enter L to Specify Alternate Location of Gif Directory Enter T to Alter Graph Time Scale Only (Does not change analysis dataset) Enter D to Return to Default Graph Time Scale 17/24

Enter R to Remove Currently Displayed Graphs Enter A to Analyze Data Enter S to Analyze Subset of Data(Changes analysis dataset including graph time scale) Enter P to Generate A Profile Enter X to Export Parsed Data to File Enter Q to Quit Program Please Select an Option: => 위 Option 항목에 1~5 의항목을선택하면화면에그래프를띄워준다 => 위 Option 항목에 6~8 의항목을선택하면 gif 파일을생성한다. 6.5 gif 파일생성 oswbb 를실행후 Generate를선택한경우 OSWatcher 를설치한메인디렉토리에 gif 폴더가생성되고그래프로출력한파일들이날짜별로생성된다. $> ls -l /oracle/work/oswbb/gif/ Oct10130052_1412922970 -rw-r--r-- 1 oracle dba 1295 Oct 10 15:36 BlockQueue.data -rw-r--r-- 1 oracle dba 1332 Oct 10 15:36 CpuIdle.data -rw-r--r-- 1 oracle dba 1295 Oct 10 15:36 CpuSystem.data -rw-r--r-- 1 oracle dba 1295 Oct 10 15:36 CpuUser.data -rw-r--r-- 1 oracle dba 1296 Oct 10 15:36 CpuWaitIo.data -rw-r--r-- 1 oracle dba 1406 Oct 10 15:36 CS.data -rw-r--r-- 1 oracle dba 1369 Oct 10 15:36 Interrupts.data -rw-r--r-- 1 oracle dba 7864 Oct 10 15:36 OSWg_OS_Block_Queue.gif -rw-r--r-- 1 oracle dba 13572 Oct 10 15:36 OSWg_OS_Context_Switches.gif -rw-r--r-- 1 oracle dba 8544 Oct 10 15:36 OSWg_OS_Cpu_Idle.gif -rw-r--r-- 1 oracle dba 12407 Oct 10 15:36 OSWg_OS_Cpu_Interrupts.gif -rw-r--r-- 1 oracle dba 7471 Oct 10 15:36 OSWg_OS_Cpu_System.gif -rw-r--r-- 1 oracle dba 7142 Oct 10 15:36 OSWg_OS_Cpu_User.gif -rw-r--r-- 1 oracle dba 7147 Oct 10 15:36 OSWg_OS_Cpu_Wa.gif -rw-r--r-- 1 oracle dba 8533 Oct 10 15:36 OSWg_OS_Run_Queue.gif -rw-r--r-- 1 oracle dba 1295 Oct 10 15:36 RunQueue.data 18/24

6.6 archive 경로에수집된자료의그래프 19/24

20/24

21/24

22/24

23/24

24/24