关于透明网关的优化
本帖最后由 bujinpeng 于 2013-01-18 17:15:19 编辑
最近项目需要,弄了个Oracle 10g的透明网关来连接SqlServer 2005,异构数据存取问题算是解决了,可是执行效率不是太满意的,想优化一下。下面是我的配置文件,如果有弄过相关优化的哥哥姐姐,给个建议吧。
initoffoc.ora:
HS_FDS_CONNECT_INFO="SERVER=172.16.3.202;DATABASE=foc"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
HS_FDS_SUPPORT_STATISTICS=TRUE
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\tg_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = OKFOC)
(ORACLE_HOME = E:\oracle\product\10.2.0\tg_1)
(PROGRAM = tg4msql)
)
(SID_DESC =
(SID_NAME = SCHEDULE)
(ORACLE_HOME = E:\oracle\product\10.2.0\tg_1)
(PROGRAM = tg4msql)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = KAIFA01)(PORT = 1521))
)
)
LOGGING_LISTENER = OFF
DBLink创建:
CREATE PUBLIC DATABASE LINK okfoc
CONNECT TO "okfoc" IDENTIFIED BY "okfoc"
USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.190)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = OkFoc) ) (HS = OK) ) ';
先给大家说声谢谢了~~
oracle
优化
------解决方案--------------------在这里优化感觉弹性也不大哈
双监听以实现LB?还是...?
执行效率为什么不高是不是有其他情况