文章列表
--查看有哪些表被锁住select b.owner,b.object_name,a.session_id,a.locked_modefrom v$locked_object a,dba_objects bwhere b.object_id = a.object_id;
select b.username,b.sid,b.serial#,logon_timefrom v$locked_object a,v$session bwhere a.session_id = b.sid order by b.logon_time;
--杀进程中的会话
alter system kill sess ...
<insert id="addAreaServiceMapping" parameterType="AreaServiceMappings">
<selectKey keyProperty="id" resultType="long" order="BEFORE">
select IE_SQE_AREASERVICEMAPPINGS.Nextval from dual
</selectKey>
...
今天在服务器上部署tomcat时，发现点击shutdown.bat居然关不掉服务，再点击startup.bat又会报端口已被占用，又不想改端口号，那么可以通过如下方法关闭该进程，然后就能正常启动tomcat了。
第一步：通过dos命令查找该端口号对应的PID
输入命令netstat -nao
将列出所有的端口号及进程ID
C:\Documents and Settings\Administrator>netstat -nao
Active Connections
Proto Local Address Foreign Address ...