MYSQL编程：Oracle客户端文件打包

你不用花费很多时间和金钱来培训现有的职工，或者去花大价钱雇用那些拥有各种证书的开发者。因为MySQL的维护和管理在很大程度上是“傻瓜型”的。oracle|打包|客户端
之前的一个项目，免了安装，本人做了个程序来设置ora文件

===我备份的文件列表，从服务器取得


F:ORA81客户端公布的目次

2004-07-1513:17<DIR>.
2004-07-1513:17<DIR>..
2004-07-1513:17<DIR>BIN
2004-07-1513:17<DIR>network
2004-07-1513:17<DIR>ocommon
2004-07-1513:17<DIR>oracore
2004-07-1513:17<DIR>sqlplus
2个文件4,537字节
7个目次21,490,073,600可用字节


F:ORA81客户端公布in的目次

2004-07-1513:17<DIR>.
2004-07-1513:17<DIR>..
1999-12-2117:0457,344com81.dll
1999-12-2008:51138,940COREJAVA.DLL
1999-08-3014:2268,608debmp.dll
1999-08-3014:22201,216demet.dll
1999-08-3014:2267,072exgdsf.dll
1999-08-3014:22231,424exhtml.dll
1999-12-0212:12163,877irpc.dll
1999-08-3014:221,215,488isgdi32.dll
1999-07-2107:3640,448JNLSLib3.dll
1999-07-2107:3630,720JNLSTool.dll
1999-08-3014:22105,472ltscsn10.dll
1999-08-3014:221,567,232lwpapin.dll
1999-12-0212:141,654,822nav32.dll
2000-01-2517:54146,432njssl8.dll
2000-01-2113:26557,056nmi.dll
1999-12-0212:15581,671nvbase.dll
1999-12-0212:1781,960nvdbdbc.dll
2000-02-1017:5794,248nvdbole.dll
2000-01-2518:2889,088oci.dll
2000-02-1223:1737,136ocijdbc8.dll
2000-02-0712:0320,992OCIW32.DLL
2000-02-1717:05659,456oip8.dll
2000-02-1614:4224,576oraansi.dll
2000-01-2518:029,216OracleAdNetConnectRCUS.dll
2000-01-2619:409,728OracleAdNetConnectRCZHS.dll
2000-01-2518:039,728OracleAdNetTestRCUS.dll
2000-01-2619:4010,240OracleAdNetTestRCZHS.dll
2000-02-1015:46998,160oraclient8.dll
2000-02-0209:01225,280oraclm32.dll
2000-02-0717:33397,072oracommon8.dll
2004-04-0609:00519,440ORACORE8.DLL
2000-02-0518:121,176,336oractxx8.dll
2000-01-0909:1466,320ORADBICX8.DLL
1998-08-2600:127,680ORAEVRUS8.DLL
2000-01-2517:401,155,344orageneric8.dll
2000-02-1912:283,327,760ORAJOX8.DLL
2000-02-0209:2799,600oraldapclnt8.dll
2000-02-2314:35658,192oran8.dll
2000-01-2518:01299,176oranad8.dll
2000-01-2517:5616,656oranbeq8.dll
2000-01-2517:574,880ORANCDS8.DLL
2004-04-0609:1248,912orancrypt8.dll
2000-01-2517:5648,912ORANCRYPT8E.DLL
2000-01-2517:575,392oranent8.dll
2000-02-2314:357,440oranhost8.dll
2000-01-2517:5617,680oranipc8.dll
2000-01-2518:04127,488oranjni8.dll
2000-01-2517:56187,152ORANK58.DLL
2000-02-2314:35163,088oranl8.dll
2000-01-2517:5747,376oranldap8.dll
2000-01-2518:0411,776oranldapj8.dll
1999-11-2922:24277,264ORANLS8.DLL
2000-01-2517:5728,432ORANLU628.DLL
2000-02-2314:3516,656orannds8.dll
2000-02-2314:3517,680orannmp8.dll
2000-02-0313:00101,376orannms8.dll
2000-02-2314:3510,512orannss8.dll
2004-04-0609:0039,696orannts8.dll
2000-02-0214:33373,008orannzsbb8.dll
2000-02-2314:357,952oranoname8.dll
2000-01-2518:0539,424oranoncj8.dll
2000-01-2517:5630,992ORANRAD8.DLL
2000-02-2119:14210,704oranro8.dll
2000-02-2314:3526,896oransgr8.dll
2000-01-2517:5639,696ORANSID8.DLL
2000-02-2314:3533,040orantcp8.dll
2000-02-0214:3332,016ORANTCPS8.DLL
2000-02-2314:357,952orantns8.dll
2000-01-3117:54327,680OraOLEDB.dll
2000-01-3117:5445,056oraoledbgmr.dll
2000-01-3117:5432,768OraOLEDBPUS.dll
2000-01-3117:5424,576OraOLEDBrfc.dll
2000-01-3117:5424,576OraOLEDBrmc.dll
2000-01-3117:54110,592OraOLEDBrst.dll
2000-01-3117:5424,576OraOLEDBus.dll
2000-01-3117:5424,576OraOLEDButl.dll
2000-01-1412:0724,576OraOLEDBzhs.dll
2000-02-0314:01275,216oraordim8.dll
2000-02-1014:12118,544oraordvir8.dll
2000-01-0315:5845,328ORAPLC8.DLL
1999-12-2213:55542,480ORAPLP8.DLL
2000-01-0315:582,196,752ORAPLS8.DLL
2000-01-2518:293,072ORAPRTOP8.DLL
2000-02-2314:4177,072ORAQSMASHR.DLL
1999-11-1514:5614,096ORASLAX8.dll
2000-01-2518:298,192ORASPAWN.DLL
2000-01-1215:40446,736ORASQL8.DLL
2000-01-2807:33249,104ORATRACE8.DLL
2000-01-2517:405,392oravsn8.dll
2000-01-2517:406,928orawtc8.dll
2000-01-1915:4333,280owasmus.dll
1999-08-1112:10136,192owasmzhs.dll
2000-01-1915:4932,768owastsvr.dll
2000-01-1916:21723,968owastus.dll
1999-08-1112:10723,968owastzhs.dll
2000-01-2518:07237,568owm2.dll
1999-08-3014:22119,268sccch.dll
1999-08-3014:2218,432sccda.dll
1999-08-3014:22226,304sccdu.dll
1999-08-3014:2229,696sccex.dll
1999-08-3014:22108,544sccfa.dll
1999-08-3014:22166,400sccfi.dll
1999-08-3014:2380,384scclo.dll
1999-08-3014:2341,472sccole2.dll
1999-08-3014:23140,288sccut.dll
2000-01-2113:177,680snmidl.dll
2000-02-0313:103,072snmimsg.dll
1998-09-1409:513,584snmimsgd.dll
1998-09-1409:514,096snmimsgf.dll
2000-01-2705:32409,600SQORA32.dll
2000-01-1709:2028,672SQORAS32.dll
2000-01-1709:2061,440sqresus.dll
2000-02-0311:1465,024svpxos.dll
2004-04-0609:12353,792tcl75.dll
1999-12-1617:28177,152vbj30ssl.dll
1999-12-1617:291,281,536vbjruntime.dll
2000-02-0314:3965,536vdbjdbcext.dll
2000-02-0314:3753,248vdg.dll
2004-04-0609:12393,728vppdc.dll
2000-02-0311:1460,928vpsqlsrv.dll
2000-02-0311:28539,648vpxoafnd.dll
2000-02-0311:26305,152vpxodb.dll
1999-08-3014:2322,528vsacs.dll
1999-08-3014:2379,360vsami.dll
1999-08-3014:2311,776vsbdr.dll
1999-08-3014:2316,384vsbmp.dll
1999-08-3014:2340,448vscgm.dll
1999-08-3014:2312,288vsdbs.dll
1999-08-3014:2315,360vsdez.dll
1999-08-3014:2338,400vsdif.dll
1999-08-3014:2319,968vsdrw.dll
1999-08-3014:2315,872vsdx.dll
1999-08-3014:2359,904vsdxf.dll
1999-08-3014:2320,480vsemf.dll
1999-08-3014:2316,384vsen4.dll
1999-08-3014:2314,336vsens.dll
1999-08-3014:2314,848vsenw.dll
1999-08-3014:23160,768vseshr.dll
1999-08-3014:2330,208vsexe2.dll
1999-08-3014:2311,776vsfax.dll
1999-08-3014:2313,312vsfcd.dll
1999-08-3014:2316,896vsfcs.dll
1999-08-3014:2314,848vsfft.dll
1999-08-3014:23117,760vsflw.dll
2004-04-0609:1423,552vsfwk.dll
1999-08-3014:23117,248vsgdsf.dll
1999-08-3014:2312,800vsgif.dll
1999-08-3014:2341,984vsgzip.dll
1999-08-3014:2332,768vshgs.dll
1999-08-3014:2388,576vshtml.dll
1999-08-3014:23125,952vsich.dll
1999-08-3014:2311,264vsimg.dll
1999-08-3014:2313,824vsiwp.dll
1999-08-3014:2315,872vsjw.dll
1999-08-3014:2320,992vsleg.dll
1999-08-3014:23119,296vslwp.dll
1999-08-3014:2348,128vslzh.dll
1999-08-3014:2315,360vsm11.dll
1999-08-3014:2322,016vsmanu.dll
1999-08-3014:2322,016vsmcw.dll
1999-08-3014:2418,944vsmm.dll
1999-08-3014:2420,480vsmm4.dll
1999-08-3014:2415,360vsmmfn.dll
1999-08-3014:2414,848vsmp.dll
1999-08-3014:2426,112vsmsw.dll
1999-08-3014:2411,264vsmwkd.dll
1999-08-3014:2410,752vsmwks.dll
1999-08-3014:2430,208vsmwp2.dll
1999-08-3014:2417,920vsmwpf.dll
1999-08-3014:2412,800vsmwrk.dll
1999-08-3014:2411,264vsow.dll
1999-08-3014:2410,752vspbm.dll
1999-08-3014:249,216vspcl.dll
1999-08-3014:2412,800vspcx.dll
1999-08-3014:2413,824vspdx.dll
1999-08-3014:2423,552vspfs.dll
1999-08-3014:2490,112vspgl.dll
1999-08-3014:2410,752vspic.dll
1999-08-3014:2417,920vspict.dll
1999-08-3014:2429,184vspng.dll
1999-08-3014:249,216vspntg.dll
1999-08-3014:2441,472vspp2.dll
1999-08-3014:2445,568vspp7.dll
1999-08-3014:24169,984vspp97.dll
1999-08-3014:2419,968vsppl.dll
1999-08-3014:24108,544vspsp.dll
1999-08-3014:2414,336vsqa.dll
1999-08-3014:2444,544vsqad.dll
2004-04-0609:1453,248vsqp6.dll
1999-08-3014:2433,792vsras.dll
1999-08-3014:2416,384vsrbs.dll
1999-08-3014:2419,968vsrft.dll
1999-08-3014:2413,312vsrfx.dll
1999-08-3014:24116,736vsrtf.dll
1999-08-3014:2413,312vssam.dll
1999-08-3014:2416,384vssc5.dll
1999-08-3014:2415,360vssdw.dll
1999-08-3014:2412,800vsshw3.dll
1999-08-3014:2412,288vssmd.dll
1999-08-3014:2412,800vssms.dll
1999-08-3014:2443,008vssmt.dll
1999-08-3014:2513,824vssnap.dll
1999-08-3014:2540,448vsspt.dll
1999-08-3014:2556,320vstaz.dll
1999-08-3014:2525,088vstext.dll
1999-08-3014:2512,288vstga.dll
1999-08-3014:2547,616vstif6.dll
1999-08-3014:2545,056vstw.dll
1999-08-3014:2521,504vstxt.dll
1999-08-3014:2536,352vsvcrd.dll
1999-08-3014:2540,960vsvw3.dll
1999-08-3014:2588,064vsw6.dll
1999-08-3014:25101,376vsw97.dll
1999-08-3014:2577,312vswg2.dll
1999-08-3014:2596,768vswk4.dll
1999-08-3014:25122,368vswk6.dll
1999-08-3014:2528,160vswks.dll
1999-08-3014:2513,824vswm.dll
1999-08-3014:2522,528vswmf.dll
1999-08-3014:2563,488vsword.dll
1999-08-3014:2518,944vswork.dll
1999-08-3014:2550,688vswp5.dll
1999-08-3014:2562,464vswp6.dll
1999-08-3014:2516,384vswpf.dll
1999-08-3014:2534,816vswpg.dll
1999-08-3014:2586,016vswpg2.dll
1999-08-3014:2519,456vswpl.dll
1999-08-3014:2541,472vswpw.dll
1999-08-3014:2520,480vsws.dll
1999-08-3014:2514,848vsws2.dll
1999-08-3014:25173,568vsxl5.dll
1999-08-3014:2521,504vsxy.dll
2004-04-0609:1421,504vszip.dll
1999-11-1700:5228,672vxxxstacktrace.dll
2000-02-0419:1958,368WizOSD.dll
2002-08-0922:004,082,688qtintf70.dll
2004-04-0609:0023oracle.key
2000-02-0912:06481,120SQLPLUS.EXE
238个文件38,967,905字节
2个目次21,490,073,600可用字节

===========================================================================
1.下面的文件复制到c:ora81

2.
etworkADMIN        nsnames.ora文件设置（SERVICE_NAME=服务器的毗连）
ORCL=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=orcl)
)
)

3.注册Oracle主目次
[HKEY_LOCAL_MACHINEOFTWAREORACLEHOME0]
"ORACLE_HOME"="C:Ora81"

4.注册体系情况变量
[HKEY_LOCAL_MACHINEYSTEMControlSet001ControlessionManagerEnvironment]
"path"="C:Ora81"




无疑希望员工得到系统、有深度的培训，显然MySQL在这一点上还做得很不够。

理解了存储结构，再阅读下性能优化的章节基本上会对sqlserver有个清晰地认识

很多书籍啊，不过个人认为看书太慢，还不如自己学。多做实际的东西，就会遇到很多问题，网上搜下解决问题。不断重复这个过程，在配合sql的F1功能。

作了些试验，发现使用CLR的存储过程或函数在达到一定的阀值的时候，系统性能会呈指数级下滑！这是非常危险的！只使用几个可能没有问题，当一旦大规模使用会造成严重的系统性能问题！

对于微软系列的东西除了一遍遍尝试还真没有太好的办法

仓酷云

我们学到了什么？思考问题的时候从表的角度来思考问

分区表效率问题肯定是大家关心的问题。在我的试验中，如果按照分区字段进行的查询（过滤）效率会高于未分区表的相同语句。但是如果按照非分区字段进行查询，效率会低于未分区表的相同语句。

很多书籍啊，不过个人认为看书太慢，还不如自己学。多做实际的东西，就会遇到很多问题，网上搜下解决问题。不断重复这个过程，在配合sql的F1功能。