by-nc-sa     개발자, DBA가 함께 만들어가는 구루비 지식창고!

14S_데이터베이스와 인스턴스




오라클은 이식이 매우 편리하도록 설계되었으나 물리 구조는 다름 (윈도우, 유닉스, 메인프레임 등)
플랫폼 특성
유닉스 멀티 프로세스
윈도우 스레드(단일 프로세스)
메인프레임 복수의 '주소 공간(address space)', 단일 인스턴스
데이터베이스와 인스턴스
구분 정의 비고
데이터베이스 물리적인 파일/디스크 집합 DBF, ASM, RAW
인스턴스 프로세스(스레드) + 공유 메모리 영역 하나 이상의 인스턴스는 하나의 데이터베이스를 마운트/오픈(RAC)
데이터베이스와 인스턴스 간단한 예제
$ORACLE_HOME/dbs 에 아무것도 없음
[oracle@pdbmon1x dbs]$ ls -al
total 8
drwxr-xr-x  2 oracle dba 4096 Sep 25 07:43 .
drwxr-xr-x 78 oracle dba 4096 Dec 10  2013 ..
oracle 사용자 관련 프로세스 없음
[oracle@pdbmon1x dbs]$ ps -aef | grep oracle
root     18087 18086  0 07:42 ?        00:00:00 login -- oracle                 
oracle   18088 18087  0 07:42 pts/1    00:00:00 -bash
oracle   18796 18088  0 07:46 pts/1    00:00:00 ps -aef
oracle   18797 18088  0 07:46 pts/1    00:00:00 grep oracle
oracle 사용자 관련 공유 메모리 없음
[oracle@pdbmon1x dbs]$ ipcs -a

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status      
0x00000000 4718593    root      644        80         2                       
0x00000000 4751363    root      644        16384      2                       
0x00000000 4784132    root      644        280        2                       

------ Semaphore Arrays --------
key        semid      owner      perms      nsems     

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages    
SQL*Plus 접속 실패 (접속 대상 알 수 없음)
[oracle@pdbmon1x dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Sep 25 07:48:28 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-12162: TNS:net service name is incorrectly specified


Enter user-name: 
SQL*Plus 접속 성공 (idle instance)
[oracle@pdbmon1x dbs]$ export ORACLE_SID=ora11g
[oracle@pdbmon1x dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Sep 25 07:51:15 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> 
상태 점검 (오라클 서버 프로세스만 기동 됨, 공유 메모리 없음)
SQL> !ps -aef | grep oracle
root     18087 18086  0 07:42 ?        00:00:00 login -- oracle                 
oracle   18088 18087  0 07:42 pts/1    00:00:00 -bash
oracle   18812 18088  0 07:51 pts/1    00:00:00 sqlplus   as sysdba
oracle   18813 18812  0 07:51 ?        00:00:00 oracleora11g (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle   18816 18812  0 07:52 pts/1    00:00:00 /bin/bash -c ps -aef | grep oracle
oracle   18817 18816  0 07:52 pts/1    00:00:00 ps -aef
oracle   18818 18816  0 07:52 pts/1    00:00:00 grep oracle

SQL> !ipcs -a

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status      
0x00000000 4718593    root      644        80         2                       
0x00000000 4751363    root      644        16384      2                       
0x00000000 4784132    root      644        280        2                       

------ Semaphore Arrays --------
key        semid      owner      perms      nsems     

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages   

-- 프로세스 이름은 메모리에 적재할 때 변경 가능, 지금 실행 중인 프로세스 이름은 oraclee$ORACLE_SID 임 (oracleora11g)
기동 실패 (initora11g.ora 파일 없음)
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/sw/oracle/app/oracle/product/11.2.0/dbs/initora11g.ora'
파라미터 파일 생성 (파라미터 파일은 인스턴스를 기동하기 위해 반드시 필요한 유일한 파일)
[oracle@pdbmon1x dbs]$ echo db_name=ora11g > initora11g.ora
[oracle@pdbmon1x dbs]$ cat initora11g.ora
db_name=ora11g
기동 성공 (nomount)
[oracle@pdbmon1x dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Sep 25 07:59:46 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  250560512 bytes
Fixed Size		    2227256 bytes
Variable Size		  192938952 bytes
Database Buffers	   50331648 bytes
Redo Buffers		    5062656 bytes
SQL> 
상태 점검 (구동에 필요한 PMON, LGWR 외 다수 백그라운드 프로세스 기동 됨, 공유 메모리, 세마포어 생성 됨)
SQL> !ps -aef | grep oracle
root     18087 18086  0 07:42 ?        00:00:00 login -- oracle                 
oracle   18088 18087  0 07:42 pts/1    00:00:00 -bash
oracle   18833 18088  0 07:59 pts/1    00:00:00 sqlplus   as sysdba
oracle   18837     1  0 07:59 ?        00:00:00 ora_pmon_ora11g
oracle   18839     1  0 07:59 ?        00:00:00 ora_psp0_ora11g
oracle   18841     1  0 07:59 ?        00:00:00 ora_vktm_ora11g
oracle   18845     1  0 07:59 ?        00:00:00 ora_gen0_ora11g
oracle   18847     1  0 07:59 ?        00:00:00 ora_diag_ora11g
oracle   18849     1  0 07:59 ?        00:00:00 ora_dbrm_ora11g
oracle   18851     1  0 07:59 ?        00:00:00 ora_dia0_ora11g
oracle   18853     1  0 07:59 ?        00:00:00 ora_mman_ora11g
oracle   18855     1  0 07:59 ?        00:00:00 ora_dbw0_ora11g
oracle   18857     1  0 07:59 ?        00:00:00 ora_lgwr_ora11g
oracle   18859     1  0 07:59 ?        00:00:00 ora_ckpt_ora11g
oracle   18861     1  0 07:59 ?        00:00:00 ora_smon_ora11g
oracle   18863     1  0 07:59 ?        00:00:00 ora_reco_ora11g
oracle   18865     1  0 07:59 ?        00:00:00 ora_mmon_ora11g
oracle   18867     1  0 07:59 ?        00:00:00 ora_mmnl_ora11g
oracle   18868 18833  0 07:59 ?        00:00:00 oracleora11g (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle   18884 18833  0 08:02 pts/1    00:00:00 /bin/bash -c ps -aef | grep oracle
oracle   18885 18884  0 08:02 pts/1    00:00:00 ps -aef
oracle   18886 18884  0 08:02 pts/1    00:00:00 grep oracle

SQL> !ipcs -a

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status      
0x00000000 4718593    root      644        80         2                       
0x00000000 4751363    root      644        16384      2                       
0x00000000 4784132    root      644        280        2                       
0x00000000 5308422    oracle    640        8388608    16                      
0x00000000 5341191    oracle    640        243269632  16                      
0x66a46acc 5373960    oracle    640        2097152    16                      

------ Semaphore Arrays --------
key        semid      owner      perms      nsems     
0x2121606c 262145     oracle    640        204       

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages    
데이터베이스 마운트 실패 (아직 데이터베이스가 없음)
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
Thu Sep 25 08:05:49 2014
alter database mount
Thu Sep 25 08:05:49 2014
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/sw/oracle/app/oracle/product/11.2.0/dbs/cntrlora11g.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Thu Sep 25 08:05:49 2014
Checker run found 1 new persistent data failures
ORA-205 signalled during: alter database mount...
데이터베이스 생성 (실전은 파일 경로 등 더 많은 정보를 정의 해야 함)
SQL> create database;

Database created.
Thu Sep 25 08:07:09 2014
create database
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Database mounted in Exclusive Mode
Lost write protection disabled
Thu Sep 25 08:07:13 2014
Successful mount of redo thread 1, with mount id 4255433965
Using SCN growth rate of 16384 per second
Assigning activation ID 4255433965 (0xfda4c4ed)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: /sw/oracle/app/oracle/product/11.2.0/dbs/log1ora11g.dbf
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Sep 25 08:07:13 2014
SMON: enabling cache recovery
processing ?/rdbms/admin/dcore.bsq
create tablespace SYSTEM datafile '?/dbs/dbs1@.dbf' SIZE 81920000 REUSE AUTOEXTEND ON
  default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
Completed: create tablespace SYSTEM datafile '?/dbs/dbs1@.dbf' SIZE 81920000 REUSE AUTOEXTEND ON
  default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
UNDO_SEG_CRT: Could not find usn tail
Completed: create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
Undo initialization finished serial:0 start:3303269434 end:3303269464 diff:30 (0 seconds)
processing ?/rdbms/admin/dsqlddl.bsq
processing ?/rdbms/admin/dmanage.bsq
CREATE TABLESPACE sysaux DATAFILE '?/dbs/dbx1@.dbf' SIZE 40960000 REUSE AUTOEXTEND ON
  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE
Completed: CREATE TABLESPACE sysaux DATAFILE '?/dbs/dbx1@.dbf' SIZE 40960000 REUSE AUTOEXTEND ON
  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE
processing ?/rdbms/admin/dplsql.bsq
processing ?/rdbms/admin/dtxnspc.bsq
CREATE UNDO TABLESPACE SYS_UNDOTS DATAFILE '?/dbs/dbu1@.dbf' SIZE 10M REUSE AUTOEXTEND ON
[18868] Successfully onlined Undo Tablespace 2.
Completed: CREATE UNDO TABLESPACE SYS_UNDOTS DATAFILE '?/dbs/dbu1@.dbf' SIZE 10M REUSE AUTOEXTEND ON
ALTER DATABASE DEFAULT TABLESPACE SYSTEM 
Completed: ALTER DATABASE DEFAULT TABLESPACE SYSTEM 
processing ?/rdbms/admin/dfmap.bsq
processing ?/rdbms/admin/denv.bsq
processing ?/rdbms/admin/drac.bsq
processing ?/rdbms/admin/dsec.bsq
Thu Sep 25 08:07:19 2014
processing ?/rdbms/admin/doptim.bsq
processing ?/rdbms/admin/dobj.bsq
processing ?/rdbms/admin/djava.bsq
processing ?/rdbms/admin/dpart.bsq
processing ?/rdbms/admin/drep.bsq
processing ?/rdbms/admin/daw.bsq
processing ?/rdbms/admin/dsummgt.bsq
processing ?/rdbms/admin/dtools.bsq
processing ?/rdbms/admin/dexttab.bsq
processing ?/rdbms/admin/ddm.bsq
processing ?/rdbms/admin/dlmnr.bsq
processing ?/rdbms/admin/ddst.bsq
SMON: enabling tx recovery
Starting background process SMCO
Thu Sep 25 08:07:23 2014
SMCO started with pid=18, OS id=18952 
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Thu Sep 25 08:07:25 2014
QMNC started with pid=19, OS id=18954 
Completed: create database
V$뷰 조회
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/sw/oracle/app/oracle/product/11.2.0/dbs/dbs1ora11g.dbf
/sw/oracle/app/oracle/product/11.2.0/dbs/dbx1ora11g.dbf
/sw/oracle/app/oracle/product/11.2.0/dbs/dbu1ora11g.dbf

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/sw/oracle/app/oracle/product/11.2.0/dbs/log1ora11g.dbf
/sw/oracle/app/oracle/product/11.2.0/dbs/log2ora11g.dbf

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/sw/oracle/app/oracle/product/11.2.0/dbs/cntrlora11g.dbf


SQL> select status from v$instance;

STATUS
------------------------
OPEN
데이터베이스 닫고 열기 (실패, 인스턴스 구동 중 하나의 데이터베이스만을 마운트하고 오픈할 수 있음)
SQL> alter database close;

Database altered.

SQL> select status from v$instance;

STATUS
------------------------
MOUNTED

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16196: database has been previously opened and closed
16196, 00000, "database has been previously opened and closed"
// *Cause:  The instance has already opened and closed the database,
//          which is allowed only once in its lifetime. 
// *Action: Shut down the instance.

Thu Sep 25 08:13:28 2014
alter database close
Warning: ALTER DATABASE CLOSE is not a publicly supported command.
Thu Sep 25 08:13:28 2014
SMON: disabling tx recovery
Stopping background process QMNC
CLOSE: killing server sessions.
CLOSE: all sessions shutdown successfully.
Stopping background process SMCO
SMON: disabling cache recovery
Thu Sep 25 08:13:30 2014
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Completed: alter database close
Thu Sep 25 08:14:17 2014
alter database open
ORA-16196 signalled during: alter database open...
|

데이터베이스와 인스턴스 정리
  • 하나의 인스턴스는 백그라운드 프로세스와 공유 메모리의 합집합
  • 데이터베이스는 디스크에 저장된 데이터의 집합
  • 인스턴스는 오직 하나의 데이터베이스만 마운트/오픈 가능
  • 하나의 데이터베이스를 하나 혹은 여러(RAC) 인스턴스 에서 마운트/오픈 가능
SGA와 백그라운드 프로세스
  • SGA 특징
    • 모든 프로세스가 액세스하기 위해 필요한 다수의 내부 데이터 구조를 갖는다
    • 디스크에서 데이터를 읽어 캐시, 디스크에 쓰기 전 리두 데이터 버퍼 등을 담는다
    • 파싱된 SQL의 실행계획 저장 등
    • 오라클은 SGA에 덧붙여진 프로세스들의 집함
  • 백그라운드 프로세스 특징
    • 인스턴스를 구성하고 인스턴스 시작 부터 종료 까지 존재 함
    • 단 하나의 오라클 바이너리 실행 파일(oracle)이 다른 이름으로 여러번 실행 됨 (ora_pmon_ora11g, ora_ckpt_ora11g...)
    • 오라클은 데이터베이스 프로세스(스레드)가 읽고 쓰는 파일 집합을 가짐 (DBF, REDO 등...)
  • 유닉스 / 윈도우 차이
    구분 동작 그림
    유닉스 운영체제가 할당한 공유 메모리에 오라클 프로세스들이 붙어 있음
    윈도우 하나의 프로세스의 가상 메모리 공간을 스레드가 공유
윈도우 프로세스(스레드) 정보
-- wmic process list
Handle  HandleCount  KernelModeTime   MaximumWorkingSetSize  MinimumWorkingSetSize  Name                 OtherOperationCount  OtherTransferCount  PageFaults  PageFileUsage  ParentProcessId  PeakPageFileUsage  PeakVirtualSize  PeakWorkingSetSize  Priority  PrivatePageCount  ProcessId  QuotaNonPagedPoolUsage  QuotaPagedPoolUsage  QuotaPeakNonPagedPoolUsage  QuotaPeakPagedPoolUsage  ReadOperationCount  ReadTransferCount  SessionId  Status  TerminationDate  ThreadCount  UserModeTime  VirtualSize  WindowsVersion  WorkingSetSize  WriteOperationCount  WriteTransferCount  
0       0            128570914231244                                                System Idle Process  0                    0                   1           0              0                0                  0                24                  0         0                 0          0                       0                    0                           0                        0                   0                  0                                   2            0             0            6.1.7601        24576           0                    0                   
4       597          12000064923                                                    System               6900200              107705434           215792      112            0                332                8654848          5372                8         114688            4          0                       0                    0                           0                        14778               129966972          0                                   98           0             3526656      6.1.7601        376832          501514               2249406070          
240     33           1560010          1380                   200                    smss.exe             656                  14634               602         460            4                492                19423232         1140                11        471040            240        2                       11                   7                           38                       815                 2778171            0                                   3            0             5758976      6.1.7601        1146880         5                    20                  
328     682          55380355         1380                   200                    csrss.exe            22655                973244              5481        2296           320              2300               121884672        6552                13        2351104           328        13                      273                  19                          280                      37476               85007536           0                                   9            25896166      120508416    6.1.7601        6692864         0                    0                   
384     71           2184014          1380                   200                    csrss.exe            694                  51150               2303        1888           372              1888               172093440        7292                13        1933312           384        9                       337                  9                           337                      87                  118745             1                                   7            156001        172093440    6.1.7601        7467008         0                    0                   
392     81           312002           1380                   200                    wininit.exe          575                  3874                1544        1560           320              1868               62255104         5532                13        1597440           392        10                      114                  13                          118                      3                   14396              0                                   3            0             59822080     6.1.7601        5582848         0                    0                   
420     79           936006           1380                   200                    winlogon.exe         616                  1230                1458        1528           372              1760               57393152         5432                13        1564672           420        7                       64                   8                           105                      3                   14396              1                                   3            0             35921920     6.1.7601        5513216         0                    0                   
480     259          127140815        1380                   200                    services.exe         56966                1612054             776502      4612           392              9508               193060864        9544                9         4722688           480        14                      67                   75                          356                      99380               201482095          0                                   10           53820345      41144320     6.1.7601        9564160         5333                 16775120            
488     837          8161036314       1380                   200                    lsass.exe            2606738              75163007            44068       7340           392              7568               54087680         16104               9         7516160           488        29                      108                  31                          111                      265066              18354292           0                                   9            9287207533    51134464     6.1.7601        16490496        306357               163689282           
496     239          1560010          1380                   200                    lsm.exe              125                  524                 70268       3260           392              3848               36720640         7364                8         3338240           496        11                      71                   13                          71                       0                   0                  0                                   10           1872012       34091008     6.1.7601        7413760         0                    0                   
592     355          2193218059       1380                   200                    svchost.exe          19786                519798              302796      4208           480              4392               52826112         11456               8         4308992           592        15                      93                   18                          96                       35538               70754762           0                                   11           664252258     50823168     6.1.7601        11206656        0                    0                   
672     268          334466144        1380                   200                    svchost.exe          1299900              202751562           492053      4104           480              4164               43229184         9400                8         4202496           672        18                      88                   20                          93                       8881                10903471           0                                   8            414026654     40357888     6.1.7601        9596928         0                    0                   
748     175          2496016          1380                   200                    LogonUI.exe          913                  76174               11306       7480           420              19708              132395008        25908               13        7659520           748        27                      234                  28                          238                      5833                3107353            1                                   6            936006        131010560    6.1.7601        19451904        2                    320                 
772     338          152724979        1380                   200                    svchost.exe          1716592              43906877            7365063     10524          480              13624              120926208        17092               8         10776576          772        17                      88                   34                          215                      8020834             3524179310         0                                   13           103428663     53350400     6.1.7601        15802368        201200               2345904328          
812     985          132912852        1380                   200                    svchost.exe          1926190              245598504           904266      22852          480              35368              314798080        44792               8         23400448          812        53                      224                  65                          246                      154055              451510427          0                                   33           132444849     160841728    6.1.7601        38400000        41308                46900413            
852     597          44928288         1380                   200                    svchost.exe          44495                3085404             220469      7388           480              7752               71749632         17032               8         7565312           852        26                      152                  28                          156                      276471              154233811          0                                   12           65364419      68501504     6.1.7601        17375232        21                   2948                
896     336          1452057308       1380                   200                    svchost.exe          1028195              11463482            1235695     7548           480              9500               89559040         20052               8         7729152           896        26                      149                  30                          157                      44327               103401558          0                                   7            883277662     83345408     6.1.7601        17645568        16                   208340              
936     428          13100963980      1380                   200                    svchost.exe          87468723             9034879702          286608      17772          480              31236              251355136        38744               8         18198528          936        35                      147                  42                          152                      141877              139967454          0                                   15           10494343271   239230976    6.1.7601        25985024        7955                 1787060             
260     300          1852355874       1380                   200                    svchost.exe          958229               37456826            808257      10032          480              10236              63959040         13840               8         10272768          260        34                      94                   37                          102                      1565                3631754            0                                   18           442262835     60366848     6.1.7601        14172160        1                    16384               
916     334          39780255         1380                   200                    spoolsv.exe          7706                 289354              551022      7740           480              9340               121413632        17848               8         7925760           916        23                      196                  25                          200                      36014               36540771           0                                   12           26832172      113119232    6.1.7601        16842752        2                    320                 
1028    395          4093310239       1380                   200                    ACAAS.exe            12897682             445214940           15636827    68340          480              99476              360628224        82492               8         69980160          1028       44                      155                  45                          435                      10073691            25122113762        0                                   23           4723866281    214188032    6.1.7601        1499136         20646                53449617            
1092    36           1092007          1380                   200                    ACAEGMgr.exe         1733391              51553156            20094090    1008           480              1008               21000192         2688                8         1032192           1092       5                       37                   5                           37                       0                   0                  0                                   3            156001        19951616     6.1.7601        229376          0                    0                   
1112    88           335870153        1380                   200                    ACAIS.exe            588207               8937522             821804      31480          480              31524              64962560         4452                8         32235520          1112       9                       45                   10                          70                       342771              198982974          0                                   11           15288098      62865408     6.1.7601        323584          4411                 365105              
1176    65           43524279         1380                   200                    AhnSDsv.exe          61119                5188696             82490       1460           480              1564               40415232         5624                8         1495040           1176       8                       59                   9                           67                       95740               202409802          0                                   4            21996141      35844096     6.1.7601        5529600         603                  60256               
1216    395          59484429308      1380                   200                    FastBackClient.exe   612573235            282687242067672     2203487     77132          480              80752              179953664        83260               13        78983168          1216       32                      131                  723                         132                      61730360            115727390602       0                                   25           17255738613   176631808    6.1.7601        81592320        2709174              8612350088          
1260    210          41496266         1380                   200                    FastBackMount.exe    134381709            2745280636          7268982     14108          480              14112              131137536        18796               8         14446592          1260       25                      180                  27                          181                      7296064             1042590757         0                                   16           8112052       127197184    6.1.7601        19243008        3585                 276479              
1296    157          312002           1380                   200                    omtsreco.exe         683                  5050                4517        10300          480              19204              123088896        17988               8         10547200          1296       21                      215                  22                          215                      54                  164123             0                                   6            156001        120991744    6.1.7601        18391040        137                  11880               
1404    179          1337396573       1380                   200                    FBVssComServer.exe   11138893             183895040           498446      9068           592              60080              161939456        67492               8         9285632           1404       14                      126                  23                          139                      17799               8269808            0                                   5            541011468     124145664    6.1.7601        18022400        9294                 596012              
1488    174          1860311925       1380                   200                    TNSLSNR.EXE          4082838              40884353            349375      18148          480              20956              137027584        23256               8         18583552          1488       29                      223                  1185                        239                      1721534             1183442884         0                                   5            395618536     133013504    6.1.7601        23777280        359707               41601028            
1532    78           3215336611       1380                   200                    svchost.exe          2508234              230821486           3042568     6256           480              6744               42913792         10628               8         6406144           1532       8                       59                   12                          63                       427448              474789243          0                                   3            377678421     38031360     6.1.7601        10465280        195130               225645376           
1552    210          50232322         1380                   200                    snmp.exe             3034810              336250168           6854787     5416           480              5416               62730240         11732               8         5545984           1552       23                      104                  23                          104                      2180                5480680            0                                   11           9984064       59973632     6.1.7601        12005376        0                    0                   
1664    261          13802812479      1380                   200                    vmtoolsd.exe         104058020            4743354840          646971      28352          480              28360              150421504        38124               13        29032448          1664       24                      201                  26                          202                      2390                5959601            0                                   8            20647512355   150421504    6.1.7601        39038976        0                    0                   
1324    277          12948083         1380                   200                    svchost.exe          5592                 461572              63074       3408           480              3720               49115136         10016               8         3489792           1324       15                      86                   18                          86                       3613                6194322            0                                   10           2340015       46444544     6.1.7601        10055680        130                  10582               
1660    97           0                1380                   200                    svchost.exe          304                  7932                1816        2108           480              2232               35561472         6528                8         2158592           1660       11                      66                   12                          66                       0                   0                  0                                   5            156001        34914304     6.1.7601        6668288         0                    0                   
2260    151          468003           1380                   200                    msdtc.exe            216                  972                 3120        3652           480              3760               67682304         9564                8         3739648           2260       19                      71                   45                          72                       0                   0                  0                                   12           624004        66109440     6.1.7601        9744384         69                   370176              
2984    422          225733447        1380                   200                    csrss.exe            12433                306676              10209       2680           2976             2680               193990656        11608               13        2744320           2984       14                      384                  18                          393                      25527               9162278            2                                   10           4524029       187813888    6.1.7601        11616256        0                    0                   
3008    99           2964019          1380                   200                    winlogon.exe         1723                 30248               2111        1840           2976             1996               57917440         6392                13        1884160           3008       8                       72                   10                          105                      2925                5651382            2                                   3            312002        42139648     6.1.7601        6500352         0                    0                   
2628    151          3588023          1380                   200                    taskhost.exe         6172                 17656               29548       2632           480              2944               65335296         8248                8         2695168           2628       12                      110                  14                          118                      2745                6046304            2                                   6            468003        57151488     6.1.7601        8048640         452                  42488               
1080    188          9516061          1380                   200                    rdpclip.exe          1866                 120936              25305       3352           1324             27724              104808448        33884               8         3432448           1080       12                      146                  13                          172                      32349               46137790           2                                   7            5148033       79413248     6.1.7601        10153984        5913                 331654              
1900    157          5472983083       1380                   200                    sppsvc.exe           5569115              7521636             132543      5660           480              8712               45031424         14352               8         5795840           1900       9                       70                   10                          73                       1387                9788047            0                                   4            9847875127    41164800     6.1.7601        14045184        1804                 29729920            
1700    72           1092007          1380                   200                    dwm.exe              175                  21532               13386       1584           896              1848               60473344         5940                8         1622016           1700       8                       105                  9                           112                      2808                4554816            2                                   3            156001        55762944     6.1.7601        5689344         0                    0                   
1744    832          363794332        1380                   200                    explorer.exe         1148347              11421244            5908541     54172          616              56560              436891648        71724               8         55472128          1744       93                      516                  105                         716                      367687              445044573          2                                   32           133848858     329539584    6.1.7601        72241152        539                  9263459             
2976    49           0                1380                   200                    cpqteam.exe          19                   70                  935         1200           1744             1288               60129280         3628                8         1228800           2976       5                       106                  6                           106                      0                   0                  2                                   2            0             56983552     6.1.7601        3715072         0                    0                   
1040    72           3432022          1380                   200                    VMwareTray.exe       18175076             64110               955901      23024          1744             23112              106774528        27044               8         23576576          1040       9                       136                  10                          137                      1733                3915282            2                                   2            1872012       103628800    6.1.7601        27635712        0                    0                   
1680    177          18578939095      1380                   200                    vmtoolsd.exe         18179629             124795930           8671        25256          1744             25256              130818048        34228               8         25862144          1680       16                      183                  18                          184                      6227                13763593           2                                   2            27201738369   130818048    6.1.7601        35049472        0                    0                   
2948    58           2808018          1380                   200                    AhnSD.exe            4705                 282118              439081      1352           864              2084               69459968         5340                8         1384448           2948       7                       117                  8                           126                      11917               21766421           2                                   2            1872012       64638976     6.1.7601        5242880         80                   13559               
1936    70           936006           1380                   200                    svchost.exe          1696                 61190               1553        1592           480              1880               38363136         5096                8         1630208           1936       8                       65                   8                           72                       475                 1139071            0                                   5            156001        34164736     6.1.7601        5189632         0                    0                   
3284    897          137501153412     1380                   200                    oracle.exe           22185062             1494556739          58687021    7207248        480              8462528            11728404480      7474464             8         7380221952        3284       68                      624                  4091                        627                      615639076           6273186349429      0                                   34           887483916963  10501439488  6.1.7601        7211450368      16995769             1153620184109       
3364    22           0                1380                   200                    cmd.exe              123                  2012                871         1940           1744             1940               43143168         3336                8         1986560           3364       5                       84                   5                           84                       136                 285752             2                                   1            0             43143168     6.1.7601        3416064         0                    0                   
3372    82           3276021          1380                   200                    conhost.exe          499                  31088               2507        2240           2984             2348               82190336         8312                8         2293760           3372       9                       155                  9                           157                      3856                2335564            2                                   3            780005        81661952     6.1.7601        8474624         0                    0                   
3424    111          21996141         1380                   200                    adrci.exe            37401583             276354              4092        8876           3364             9596               134987776        16304               8         9089024           3424       17                      249                  17                          249                      8623                13043585           2                                   1            4212027       134987776    6.1.7601        16695296        0                    0                   
2148    128          244765569        1380                   200                    taskmgr.exe          22897                534674              16547       3068           1744             7868               245899264        12928               13        3141632           2148       12                      172                  15                          462                      27632               53683390           2                                   5            36036231      90697728     6.1.7601        13160448        0                    0                   
3096    239          1092007          1380                   200                    ACASP.exe            1258                 9088                11806       15924          1944             16008              123596800        19496               8         16306176          3096       19                      183                  19                          185                      223                 1645358            2                                   10           1872012       120451072    6.1.7601        19963904        7                    5040                
3080    187          2184014          1380                   200                    dllhost.exe          770                  33676               3464        4516           480              4788               67764224         12912               8         4624384           3080       17                      75                   18                          77                       8269                12145770           0                                   13           156001        62521344     6.1.7601        13221888        6                    3585                
3244    51           0                1380                   200                    V3ClnSrv.exe         46                   88                  303095      1452           480              1452               32112640         3780                8         1486848           3244       6                       53                   7                           53                       1                   3872               0                                   4            0             31064064     6.1.7601        249856          0                    0                   
4052    21           468003           1380                   200                    cmd.exe              357                  6346                787         1972           1744             1972               43393024         2980                8         2019328           4052       5                       84                   5                           84                       419                 944402             2                                   1            0             43143168     6.1.7601        3051520         0                    0                   
3324    78           1560010          1380                   200                    conhost.exe          168                  9374                1955        2084           2984             2192               82120704         7336                8         2134016           3324       8                       155                  9                           156                      1206                1739982            2                                   3            312002        81596416     6.1.7601        7462912         0                    0                   
2060    369          16848108         1380                   200                    powershell.exe       5756                 99994               28302       63376          1744             105196             594739200        106328              8         64897024          2060       24                      322                  24                          322                      10150               27598618           2                                   5            23088148      583335936    6.1.7601        77262848        15                   48519               
3164    82           8424054          1380                   200                    conhost.exe          137                  246                 2255        5016           2984             5016               85270528         8568                8         5136384           3164       9                       155                  9                           156                      20                  649                2                                   5            624004        85266432     6.1.7601        8773632         0                    0                   
4000    24           468003           1380                   200                    cmd.exe              820                  11650               834         2020           1744             3024               44191744         3128                8         2068480           4000       5                       84                   5                           85                       424                 931184             2                                   1            156001        43143168     6.1.7601        3203072         0                    0                   
3024    83           4368028          1380                   200                    conhost.exe          173                  8810                2000        2188           2984             2188               82198528         7524                8         2240512           3024       9                       155                  9                           156                      1114                1501338            2                                   5            1248008       82186240     6.1.7601        7696384         0                    0                   
3360    86           1248008          1380                   200                    notepad.exe          213                  8580                2230        1864           1744             2068               82993152         8388                8         1908736           3360       9                       150                  9                           156                      1071                1963568            2                                   2            624004        79458304     6.1.7601        8552448         0                    0                   
2028    88           1872012          1380                   200                    notepad.exe          186                  716                 2313        1976           1744             2152               100831232        8612                8         2023424           2028       9                       189                  9                           191                      18                  12014              2                                   2            624004        99733504     6.1.7601        8744960         0                    0                   
468     91           780005           1380                   200                    notepad.exe          196                  572                 2351        2172           1744             2172               100782080        8768                8         2224128           468        9                       189                  9                           191                      1                   60                 2                                   4            468003        100782080    6.1.7601        8962048         0                    0                   
3504    124          1560010          1380                   200                    WmiPrvSE.exe         2052                 4532                4203        3548           592              3788               41172992         7260                8         3633152           3504       11                      69                   11                          71                       499                 697121             0                                   7            468003        40615936     6.1.7601        7389184         0                    0                   
1428    142          156001           1380                   200                    WMIC.exe             306                  3760                2398        3532           4000             3536               85581824         8776                8         3616768           1428       13                      147                  13                          147                      431                 1075816            2                                   5            312002        85434368     6.1.7601        8986624         0                    0                   

-- Get-WmiObject win32_thread -Filter "ProcessHandle=3284"
-- (첨부파일:thread.txt)

문서정보

Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.