Applies to: Oracle Net Services – Version: 8.1.7.4.0 to 11.2.0.1 – Release: 8.1.7 to 11.2 Information in this document applies to any platform. This document describes creating database links and troubleshooting the ORA-2085 error that might occur during a select across the dblink. Checked for relevance on 01-OCT-2010. Purpose Purpose To explain database link . . . → Read More: Database Links: Troubleshooting ORA-2085 “database link %s connects to %s”
|
|||||
|
Applies to: Oracle Server – Enterprise Edition – Version: 7.3.2.0 to 11.1.0.7 – Release: 7.3.2 to 11.1 Information in this document applies to any platform. Symptoms The Effect of GLOBAL_NAME and GLOBAL_NAMES on Database Links: Changes {CHANGE} Cause N/a Solution ============================================================= GLOBAL_NAME ———– GLOBAL_NAME is of datatype VARCHAR2(2000). GLOBAL_NAME is the name of the database. . . . → Read More: EFFECT OF GLOBAL_NAME, GLOBAL_NAMES ON DB LINKS 该脚本可以用于显示活跃的分布式事务(Distributed Transactions from dblink)，可以协助诊断dblink远程事务：
REM distri.sql column origin format a13 column GTXID format a35 column LSESSION format a10 column s format a1 column waiting format a15 Select /*+ ORDERED */ substr(s.ksusemnm,1,10)||’-'|| substr(s.ksusepid,1,10) “ORIGIN”, substr(g.K2GTITID_ORA,1,35) “GTXID”, substr(s.indx,1,4)||’.'|| substr(s.ksuseser,1,5) “LSESSION” , substr(decode(bitand(ksuseidl,11), 1,’ACTIVE’, 0, decode(bitand(ksuseflg,4096),0,’INACTIVE’,'CACHED’), 2,’SNIPED’, 3,’SNIPED’, ‘KILLED’),1,1) “S”, substr(event,1,10) “WAITING” from x$k2gte g, x$ktcxb t, . . . → Read More: Script to show Active Distributed Transactions |
|
||||
|
Copyright © 2012 Oracle Clinic – Maclean Liu的个人技术博客 - All Rights Reserved |
|||||
最新评论