oracle lock

SELECT B.TYPE, C.OBJECT_NAME, 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 '1348, 16425';


Popular posts from this blog

com.gpki.secureweb.GPKISecureWEBException: ErrCode=1507,ErrMsg=[GPKI_CMS_ProcessEnvelopedData] 해당 인증서로는 데이터를 풀 수 없습니다.

om.gpki.secureweb.GPKISecureWEBException: ErrCode=1507,ErrMsg=[GPKI_CMS_ProcessEnvelopedData] 해당 인증서로는 데이터를 풀 수 없습니다. at com.gpki.servlet.GPKIHttpServletRequest.init(GPKIHttpServletRequest.java:550) at com.gpki.servlet.GPKIHttpServletRequest.<init>(GPKIHttpServletRequest.java:134) at kr.go.elevator.com.user.web.ComUserController.actionCrtfctLogin(ComUserController.java:485) at sun.reflect.GeneratedMethodAccessor1601.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doInvokeMethod(HandlerMethodInvoker.java:421) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:136) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:326) at org.springfr...
Read more

PL/SQL Developer Tip 선택한 것만 실행

Image
sql Window 에서 여러개의 쿼리가 있을경우 선택한 부분만 실행  -   Tool > Preferences > Window Types의 SQL Window 선택 > AutoSelect statement 체크 - 실행고자 하는 쿼리에 커서를 위치한 다음 'F8'로 실행하면 해당 쿼리만 실행됨.
Read more

전자정부 EgovMap Xml Jsp

<?xml version='1.0' encoding='utf-8'?> <%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@ page import="java.util.List,acdn.welvt.elvtr.service.ElvtrSpecVo"%> <%@ page import="egovframework.rte.psl.dataaccess.util.EgovMap" %> <web> <% List<EgovMap> troubleList = (List)request.getAttribute("troubleList");  System.out.println("jsp"); if (troubleList != null) { for (int i = 0; i < troubleList.size(); i++) { EgovMap pnMap = (EgovMap)troubleList.get(i); out.print("<trouble_detail>"); out.print("<trouble_sn>" +  pnMap.get("troubleSn")+ "</trouble_sn>"); out.print("<defect_dt>" + pnMap.get("defectDt") + "</defect_dt>"); out.print("<defect_type>" + pnMap.get("defectType") + "</def...
Read more