오라클 락 해제(펌)

DB/Oracle 2014. 8. 21. 13:28


원문 : http://blog.naver.com/dozuq/14972088


 


 

-- 세션 조회

SELECT

A.SID

    ,A.SERIAL# 

FROM

V$SESSION A

    ,V$LOCK B

    ,DBA_OBJECTS C 

WHERE

A.SID=B.SID

AND B.ID1=C.OBJECT_ID

AND B.TYPE = 'TM'

AND C.OBJECT_NAME = '[테이블명]'

; 

 



 

-- 세션 제거...

ALTER SYSTEM KILL SESSION '[SID], [SERIAL]';

ALTER SYSTEM KILL SESSION '416, 46371';

 

 

---------------------------------------------------


출처 : http://blog.naver.com/bsc3425/10141921934



============== 락 상태 확인  =====

SELECT CC.SID, CC.SERIAL#, BB.OWNER,BB.OBJECT_NAME,CC.MACHINE,CC.PROGRAM,CC.TERMINAL

  FROM V$LOCKED_OBJECT AA,

       ALL_OBJECTS     BB,

       V$SESSION       CC

 WHERE BB.OBJECT_ID = AA.OBJECT_ID

   AND CC.SID       = AA.SESSION_ID

============== 락걸린테이블 확인 확인========
SELECT OBJECT_ID,SESSION_ID FROM V$LOCKED_OBJECT
/
============== 테이블 확인 ==============
SELECT * FROM ALL_OBJECTS WHERE OBJECT_ID = OBJECT_ID
/
============== 세션확인 ================
SELECT * FROM V$SESSION WHERE SID = 278;
   SID,SERIAL#
/
============== 세션죽이기 =============
ALTER SYSTEM KILL SESSION '132,58458';  ------SID,SERIAL#

 

SELECT sid, count(sid) cursor
FROM V$OPEN_CURSOR
GROUP BY sid
ORDER BY cursor DESC

 

SELECT 'ALTER SYSTEM KILL SESSION '''||SID||','||SERIAL#||''';'
  FROM V$SESSION
-- WHERE SID = 11
WHERE SID IN (145,130,63,144,134,110,131);

[출처] 오라클 락 상태확인 및 세션죽이기|작성자 운수좋은날

[출처] 오라클 락 해제|작성자 정서


저작자표시 비영리 동일조건

'DB > Oracle' 카테고리의 다른 글

오라클 테이블 락 확인/해제(링크)  (0) 2014.03.28
Oracle 8.0.5 이전. 서비스에 관해..  (0) 2011.12.21
Oracle] 제약조건 삭제 및 추가  (0) 2011.12.14
Posted by 야동우
,

AIX 시스템 정보보기 명령어모음

OS/AIX 2014. 7. 25. 15:31




출처 : http://blog.naver.com/photofocus/120046149200




# prtconf  | grep Clock  // CPU 확인

 

# prtconf : 전체 시스템 사양 보기

 

# lsdev -Ccprocessor : 프로세서 보기 (물리적인 개수)

 

root@angeltime/]lsdev -Ccprocessor
proc0 Available 00-00 Processor
proc2 Available 00-02 Processor
proc4 Available 00-04 Processor

 

root@angeltime/]lsattr -El proc0       // 메모리 clock 확인
frequency   4704000000     Processor Speed       False
smt_enabled true           Processor SMT enabled False
smt_threads 2              Processor SMT threads False
state       enable         Processor state       False
type        PowerPC_POWER6 Processor type        False

 

root@angeltime/]lsdev -Ccmemory    // 메모리 확인
L2cache0 Available  L2 Cache
mem0     Available  Memory
root@angeltime/]lsattr -El mem0   // 메모리보기 Mb단위
goodsize 4096 Amount of usable physical memory in Mbytes False
size     4096 Total amount of physical memory in Mbytes  Fals

root@angeltime/]bootinfo -r   // 메모리보기 kb 단위
4194304

 

root@angeltime/]lsdev -Ccdisk
hdisk0 Available 09-08-00 SAS Disk Drive
hdisk1 Available 09-08-00 SAS Disk Drive
root@angeltime/]lspv
hdisk0          00c471d02233335a                    rootvg          active
hdisk1          none                                None            
root@angeltime/]lsattr -El hdisk0    // 디스크 용량확인

 

root@angeltime/]lsdev -Ccadapter   // LAN or FC card 확인
ent0      Available       Logical Host Ethernet Port (lp-hea)
ent1      Available       Logical Host Ethernet Port (lp-hea)
ent2      Available 03-00 2-Port 10/100/1000 Base-TX PCI-Express Adapter (14104003)
ent3      Available 03-01 2-Port 10/100/1000 Base-TX PCI-Express Adapter (14104003)
ent4      Available 04-00 2-Port 10/100/1000 Base-TX PCI-Express Adapter (14104003)
ent5      Available 04-01 2-Port 10/100/1000 Base-TX PCI-Express Adapter (14104003)
ent6      Available 06-00 2-Port 10/100/1000 Base-TX PCI-Express Adapter (14104003)
ent7      Available 06-01 2-Port 10/100/1000 Base-TX PCI-Express Adapter (14104003)
fcs0      Available 05-00 4Gb FC PCI Express Adapter (df1000fe)
lhea0     Available       Logical Host Ethernet Adapter (l-hea)
sa0       Available 01-08 2-Port Asynchronous EIA-232 PCI Adapter
sissas0   Available 09-08 PCI-X266 Planar 3Gb SAS Adapter
sisscsia0 Available 02-08 PCI-XDDR Dual Channel Ultra320 SCSI Adapter
usbhc0    Available 0A-08 USB Host Controller (33103500)
usbhc1    Available 0A-09 USB Host Controller (33103500)
vsa0      Available       LPAR Virtual Serial Adapter

 

 

 

::::::::::::::::::::::::::::::::::::::  네트워크 링스 속도 확인 및 조절  ::::::::::::::::::::::::::::::::::::::::::::::

 

만약  LINK STATe

 

 

#smitty dev > communication > Ehternet adapter > Adapter > show & change

 

 

 

 


 ^M                                     Change / Show Characteristics of an Ethernet Adapter

Type or select values in entry fields.
Press Enter AFTER making all desired changes.
  
                                                        [Entry Fields]
  Ethernet Adapter                                    ent2
  Description                                         2-Port 10/100/1000 Base-TX PCI-Express Adapter (14104003)
  Status                                              Available
  Location                                            03-00
  Rcv descriptor queue size                          [1024]                                                                      +#
  TX descriptor queue size                           [512]                                                                       +#
  Software transmit queue size                       [8192]                                                                      +#
  Transmit jumbo frames                               no                                                                         +
  Enable hardware TX TCP resegmentation               yes                                                              +
  Enable hardware transmit and receive checksum       yes                                                             +
  Media speed                                         Auto_Negotiation                                                           +
  Enable ALTERNATE ETHERNET address                   no                                                              +
  ALTERNATE ETHERNET address                         [0x000000000000]                                               +
  Apply change to DATABASE only                       no                                                                     +
  Enable failover mode                                disable           

[출처] AIX 시스템 정보보기 명령어모음|작성자 흘러가는


저작자표시 비영리 동일조건
Posted by 야동우
,

리눅스 디렉토리 및 파일 갯수 세기

OS/Linux 2014. 7. 22. 19:08





디렉토리 갯수 세기

현재 디렉토리만 :

 ls -l | grep ^d | wc -l


하위 디렉토리 포함 : 

  ls -lR | grep ^d | wc -l


파일 갯수 세기

현재 디렉토리만 :

 ls -l | grep ^- | wc -l 


하위 디렉토리 포함 : 

 ls -l | grep ^- | wc -l 


grep 옵션

^ 옵션은 정규표현식 메타문자로 행의 시작 지시자 이다.

^d 는 d로 시작하는 모든 행을 의미.


출처 : http://geundi.tistory.com/113

출처 : http://redgura.tistory.com/343


저작자표시 비영리 동일조건

'OS > Linux' 카테고리의 다른 글

리눅스 특정포트 죽이기  (0) 2014.07.14
페도라 한글입력  (0) 2011.12.02
Linux Directory(리눅스 디렉토리 기능 및 내용)  (0) 2009.11.28
리눅스 명령어  (0) 2009.11.28
리눅스 한글 입력  (0) 2009.11.28
Posted by 야동우
,

티스토리툴바