同义词:可以在任何用户下用sname的名称察看user.tbname表
create public synonym sname for user.tbname;
select * from sname; = select * from user.tbname;
察看当前会话:
select * from v$session ;
删除会话:
alter system kill session '3,5';//会话号
create public synonym sname for user.tbname;
select * from sname; = select * from user.tbname;
察看当前会话:
select * from v$session ;
删除会话:
alter system kill session '3,5';//会话号
解决方案 »
- 数据库awr报告分析求教!
- Oracle 数据库导入dmp文件后,CPU占用率一直为50%,正常否
- sqlload 导入问题
- oracle开发的工作,应该具备哪些知识呢?
- 新手求助:表比较大,又要多表查询,应该如何写sql语句
- ORA-00932: inconsistent datatypes: expected - got - 存储过程如何将两个查询的结果合在一起放进游标
- Oracle中的时间格式约束问题。
- EXP-00056: ORACLE 错误 600 出现
- 来鸟问题20分
- 再问关于ORA-04031
- 一个简单问题:关于删除列
- Chinese Display Problem (Via ODBC)
2. 查询进程的命令 select * from v$session;
3. 删除进程的命令 alter system kill session(#进程号, #会话号);
具体语法记不太清了,你可以直接到oracle介质上找帮助。/doc/index.html
我输了:select * from v$session;
显示:SADDR SID SERIAL# AUDSID PADDR USER# USERNAME COMMAND
-------- --------- --------- --------- -------- --------- ------------------------------ ---------
OWNERID TADDR LOCKWAIT STATUS SERVER SCHEMA# SCHEMANAME
--------- -------- -------- -------- --------- --------- ------------------------------
OSUSER PROCESS
------------------------------ ---------
MACHINE TERMINAL
---------------------------------------------------------------- ----------------
PROGRAM TYPE SQL_ADDR SQL_HASH_VALUE
---------------------------------------------------------------- ---------- -------- --------------
PREV_SQL PREV_HASH_VALUE MODULE MODULE_HASH
-------- --------------- ------------------------------------------------ -----------
ACTION ACTION_HASH
-------------------------------- -----------
CLIENT_INFO FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ#
---------------------------------------------------------------- -------------------- -------------
ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# LOGON_TIME LAST_CALL_ET PDM FAILOVER_TYPE FAILOVER_M
-------------- --------------- ------------- ----------- ------------ --- ------------- ----------
FAI RESOURCE_CONSUMER_GROUP PDML_STA PDDL_STA PQ_STATU
--- -------------------------------- -------- -------- --------
026AD938 1 1 0 0268CB7C 0 0
2.147E+09 ACTIVE DEDICATED 0 SYS
SYSTEM 1540是从这里可以看到吗?哪个是:进程号,会话号?
查询正在等待锁资源的用户名:
select a.username, a.sid, a.serial#, b.id1
from v$session a, v$lock b
where a.lockwait = b.kaddr;
查找阻塞其它用户的用户进程:
select a.username, a.sid, a.serial#, b.id1
from v$session a, v$lock b
where b.id1 in
(select distinct e.id1
from v$session d, v$lock e
where d.lockwait = e.kaddr)
and a.sid = b.sid
and b.request = 0
执行异常缓慢,耐心一点。