2015 年 9月随笔档案 - linbl

09 2015 档案

摘要：create database link JTKHJFDBconnect to khjf identified by hellousing '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1... 阅读全文

posted @ 2015-09-17 11:22 linbl 阅读(306) 评论(0) 推荐(0)

oracle 查看死锁并解锁

摘要：--查看被锁的表 select p.spid,a.serial#, c.object_name,b.session_id,b.oracle_username,b.os_user_name from v$process p,v$session a, v$locked_objec... 阅读全文

posted @ 2015-09-14 15:14 linbl 阅读(2103) 评论(0) 推荐(0)