在sql数据库中怎样取消您自己的进程

查看锁表进程SQL语句1：

select sesssid,

sessserial#,

looracle_username,

loos_user_name,

aoobject_name,

lolocked_mode

from v$locked_object lo,

dba_objects ao,

v$session sess

where aoobject_id = loobject_id and losession_id = sesssid;

查看锁表进程SQL语句2：

select from v$session t1, v$locked_object t2 where t1sid = t2SESSION_ID;

杀掉锁表进程：

如有记录则表示有lock，记录下SID和serial# ，将记录的ID替换下面的738,1429，即可解除LOCK

alter system kill session '738,1429';

我们使用linux时遇到端口占用，在了解占用程序影响不大的情况下，会通过netstat命令找到占用端口的进程，直接kill掉

查找端口占用命令：

netstat -tnlp | grep 80

可以看到，进程id为20902的进程占用了80端口

我们可以选择使用命令 kill pid 杀掉进程

kill 20902

或者使用kill -9 pid 强杀进程

kill -9 20902

如果你需要杀掉所有筛选结果下的进程可以使用

ps -aux|grep name|awk '{print $2}'|xargs kill -9

其中name是你要查询的服务名称，例如我要查nginx的所有服务可以使用

ps -aux|grep nginx

我们要筛选出第二项pid

ps -aux|grep name|awk '{print $2}'

筛选出后要杀掉这些进程

ps -aux|grep name|awk '{print $2}'|xargs kill -9

这样就批量杀掉筛选出的所有进程了

windows下Oracle的启动一般是伴随windows自动启动 自动关闭的 但是如果同过任务管理器杀掉了Oracle进程 如果通过命令行方式打开Oracle就会报错误信息

解决办法如下

 

Microsoft Windows XP [Version ]

(C) Copyright Microsoft Corp

C:/Documents and Settings/wangbao>cd/

C:/>net stop OracleServiceWBQ

The OracleServiceWBQ service is stopping

The OracleServiceWBQ service could not be stopped

C:/>net start OracleServiceWBQ

The OracleServiceWBQ service is starting

The OracleServiceWBQ service was started successfully

C:/>lsnrctl stop

LSNRCTL for bit Windows: Version Production on MAR : :

Copyright (c) Oracle Corporation All rights reserved

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC )))

The mand pleted successfully

C:/>lsnrctl start

LSNRCTL for bit Windows: Version Production on MAR : :

Copyright (c) Oracle Corporation All rights reserved

Starting tnslsnr: please wait

TNSLSNR for bit Windows: Version Production

System parameter file is C:/UserDefine/oracle/ora /neork/admin/listener ora

Log messages written to C:/UserDefine/oracle/ora /neork/log/listener log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=// /pipe/EXTPROC ipc

)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=scn asiapacific hpqc

)(PORT= )))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC )))

STATUS of the LISTENER

Alias LISTENER

Version TNSLSNR for bit Windows: Version Produc

tion

Start Date MAR : :

Uptime days hr min sec

Trace Level off

Security OFF

SNMP OFF

Listener Parameter File C:/UserDefine/oracle/ora /neork/admin/listener ora

Listener Log File C:/UserDefine/oracle/ora /neork/log/listener log

Listening Endpoints Summary

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=// /pipe/EXTPROC ipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=scn asi)(POR

T= )))

Services Summary

Service PLSExtProc has instance(s)

Instance PLSExtProc status UNKNOWN has handler(s) for this service

Service wbq has instance(s)

Instance wbq status UNKNOWN has handler(s) for this service

The mand pleted successfully

C:/>sqlplus /nolog

SQLPlus: Release Production on Thu Mar : :

Copyright (c) Oracle Corporation All rights reserved

SQL> connect sys/change_on_install as sysdba

Connected

SQL>

lishixinzhi/Article/program/Oracle/201311/17222

以上就是关于在sql数据库中怎样取消您自己的进程全部的内容，包括:在sql数据库中怎样取消您自己的进程、linux如何杀掉线程、Windows下Oracle数据库进程的启动和关闭等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！