DB
yhef
vv
展开
-
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_object原创 2010-02-20 10:35:00 · 585 阅读 · 0 评论 -
创建Database link
-- Create database link create database link xx.xx.com connect to ppp using (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = YHEF-xxx )(PORT = 1531)))(CONNECT_DATA =(SERVICE_N原创 2010-02-20 10:40:00 · 3315 阅读 · 0 评论