oracle关闭释放不掉的存储过程

发表于 2015-10-21 | 分类于 Oracle |

Oracle层:

select * from v$db_object_cache where locks > 0 and pins > 0 and type='PROCEDURE';
select b.sid,b.SERIAL# from SYS.V_$ACCESS a, SYS.V_$session b
	where a.type = 'PROCEDURE' and (a.OBJECT like upper('%xxx%')
	or a.OBJECT like lower('%xxx%')) and a.sid = b.sid and b.status = 'ACTIVE';
alter system kill session 'sid,SERIAL';

OS层：

1
2
3

SELECT P.SPID, S.SID, S.SERIAL#, S.USERNAME, S.PROGRAM FROM V$PROCESS P, V$SESSION S
	WHERE P.ADDR=S.PADDR AND S.STATUS='KILLED';
kill –9 $SPID

oracle小结

发表于 2015-10-12 | 分类于 Oracle |

近期安装oracle 11/12企业版小结

阅读全文 »

配置docker-http代理

发表于 2015-09-23 | 分类于 Docker |

利用ssh

阅读全文 »

oracle建立databaselink

发表于 2015-09-10 | 分类于 Oracle |

SQL>CREATE PUBLIC DATABASE LINK xxx
CONNECT TO user identified by passwd
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.4)(PORT = 1521))
)
(CONNECT_DATA =
(service_name=xe
)
)';
CREATE PUBLIC DATABASE LINK "XXXX"
   CONNECT TO "USER" IDENTIFIED BY VALUES '05A36CC2DA77E7B3B758F0A763041F08EF35CE8688B5E673AA'
   USING '172.17.0.2';

阅读全文 »