SQL Relay附录
在自己学习的过程中,很少能找到中文的相关资料,这里将SQL Relay文档中的附录翻译整理一下,发出来给大家参考,用到的时候备查。
由于我水平有限,英文原版也会附在最后。
实际案例
先看一个比较综合的配置文件:
<?xml version="1.0"?>
<instances>
<!-- Regular SQL Relay Instance -->
<instance id="example" enabled="yes" dbase="oracle"
port="9000" socket="/tmp/example.socket"
connections="3" maxconnections="15" maxqueuelength="5" growby="1" ttl="60" softttl="0"
maxsessioncount="1000" endofsession="commit" sessiontimeout="600"
runasuser="nobody" runasgroup="nobody" cursors="5" maxcursors="10" cursors_growby="1"
authtier="connection" sessionhandler="process" handoff="pass" deniedips="" allowedips=""
maxquerysize="65536" maxbindvars="256" maxstringbindvaluelength="4000" maxlobbindvaluelength="71680"
idleclienttimeout="-1" maxlisteners="-1" listenertimeout="0" reloginatstart="no"
fakeinputbindvariables="no" translatebindvariables="no" isolationlevel="read committed"
ignoreselectdatabase="no" waitfordowndatabase="yes">
<users>
<user user="user1" password="password1"/>
<user user="user2" password="password2"/>
<user user="user3" password="password3"/>
</users>
<session>
<start>
<runquery>alter session set nls_date_format='MM-DD-YYYY HH24:MI:SS'</runquery>
</start>
<end>
<runquery>alter session set nls_date_format='DD-MON-YYYY'</runquery>
</end>
</session>
<