MYSQL网页编程之ORACLE关于bin目次下各文件的意义及利用...

一个相关的问题是第三方支持的资格问题，尽管直接来自厂商的支持和服务可以一定程度上减缓这个问题，但是，对于有的企业来说，通过强有力的本地化支持显然更有吸引力。oracle
$ORACLE_HOME/bin下的utilities注释BinaryFirstAvailableDescription-------------------------------------------------------------------adapters(7.3.4)InstalledNetworkAdaptersagentctl9.0.1AgentControlUtilityagtctl8.1.5AgentControlUtilitybulkmodify8.1.6OracleInternetDirectorybulkmodifycmadmin8.1.6ConnectionManagerAdministratorcmctl8.1.6ConnectionManagerControlUtilitycmgw8.1.6ConnectionManagerGatewaycoraenv(7.3.4)OraenvcommandforCshellCSScan8.1.7CharacterSetScannerctxkbtc8.1.5InterMediactxload(7.3.4)InterMediactxsrv(7.3.4)InterMediacursize8CursorSizeTooldbca9.0.1DatabaseCreationAssistantdbfmig8.1.5DatafileMigratordbfsize(7.3.4)DatafileSizedbhome(7.3.4)displaysOracle$HOMEdbshut(7.3.4)shutsdownOracledbsnmp8IntelligentAgentdbsnmpj9.0.1IntelligentAgentJobProcessor(notJavaorJRE)dbsnmpwd9.0.1IntelligentAgentdbstart(7.3.4)StartsOracledbua9.2.0DatabaseUpgradeAssistantdbv(7.3.4)Verifiesdatafilesdebugproxy8.1.7OracleJVMDebuggingdemobld(7.3.4)TableBuildforOracleDeveloperdemodemodrop(7.3.4)TabledropforOracleDeveloperdemodeploync8.1.7JARfiledeploymentdgmgrl9.0.1DataManagerdropjava8.1.5Dropsjavaobjectsdumpsga9.2.0DumpsSGAcontentsechodo(7.3.4)Echocommandandprintitela9.0.1EnterpriseLoginAssistantemca9.0.1(EnterpriseManager?)emwebsite9.0.1(EnterpriseManager?)Esm9.2.0EnterpriseSecurityManagerCommandLineUtilityexp(7.3.4)Exportextproc8ExternalProcessAgentextractlib(7.3.4)Extractobjectsfromalistoflibrariesfmputl9.2.0Filemappingfmputlhp9.2.0Filemappinggenagtsh8.1.5Agentsharedlibrarygenerationgenclntsh(7.3.4)GeneratesharedclientlibraryforOCI,Pro*CandXAgenksms8Generateksms.storelocateSGAgennfgt8Generatelistofnativenetworklibraries-nnfgt.ogennttab8GeneratelistofSQL*Netprotocoladapters-Outputwrittentontcontab.sgenoccish9.2.0GenerateOCCIsharedobjectgensyslib(7.3.4)Generatelistofoperatingsystemlibrariestobelinkedintoexecutables.Outputwrittento$ORACLE_HOME/lib/sysliblisthelpins(7.3.4)InstallSQL*Plushelpsystemhsalloci8.1.5HeterogeneousAgenthsdepxa8.1.5HeterogeneousAgenthsodbc8.1.6HeterogeneousServicesODBChsots8.1.5HeterogeneousServicesOracleTransactionServiceimp(7.3.4)Importisqlplus9.2.0BrowserbasedSQL*Plusinterfacejpub8.1.5PublishJavaclasseskgmgr8.1.6NetConfigurationAssistantkgpmon8.1.5Unknownldapadd8.1.6LDAPmanagementldapaddmt8.1.6LDAPmanagementldapbind8.1.6LDAPmanagementldapcompare8.1.6LDAPmanagementldapdelete8.1.6LDAPmanagementldapmoddn8.1.6LDAPmanagementldapmodify8.1.6LDAPmanagementldapmodifymt8.1.6LDAPmanagementldapsearch8.1.6LDAPmanagementldifmigrator9.2.0OIDMigrationToolldifwrite8.1.6OracleInternetDirectory-writeLDIFfilelmsgen8.1.5Binarymessagefilegenerationloadjava8.1.5loadsjavaobjectsloadpsp8.1.6loadspl/sqlserverpageslsnrctl(7.3.4)Listenercontrollxchknlb(7.3.4)NetConfigurationAssistantlxegen(7.3.4)NLSCalendarlxinst(7.3.4)NLSDataInstallmapsga9.2.0ProvidesSGAmapmaxmem(7.3.4)DisplaysRAMstatsmig(7.3.4)Migratemigprep8.1.5MigratePreparemodada9.2.0names8.1.6OracleNamesnamesctl8.1.6OracleNamesControlncomp8.1.7NativeCompiler(Java)netca8.1.5NetConfigurationAssistantnetmgr9.0.1NetAssistantNid9.2.0SetnewdatabaseIDNmu7q289.0.1OracleIntelligentAgentnmudg9.0.1OracleIntelligentAgentnmumigr89.0.1OracleDataGathererociconv8ConvertOCIsourcefromshort(8.0.1)tolong(8.0.2)functionnamesocm9.0.1OracleChangeManagerodisrv9.0.1OracleInternetDirectoryodisrvreg9.0.1OracleInternetDirectoryoemLaunchOms9.0.1OracleMgmt.Serveroemapp8.1.6OracleEnterpriseManageroemctl9.0.1OEMControlOemevent8.1.5OracleIntelligentAgentoerr(7.3.4)ErrorLookupoidadmin8.1.6OracleInternetDirectoryoidctl8.1.7OracleInternetDirectoryoidldapd9.2.0OracleInternetDirectoryoidmon8.1.7OracleInternetDirectoryoidpasswd8.1.6OracleInternetDirectoryoidprovtool9.2.0OracleInternetDirectoryoidreconcile8.1.7OracleInternetDirectoryoidrepld9.2.0OracleInternetDirectoryojspc9.0.1JSPCompilerokdstry8.1.7DeleteKerberosticketokinit8.1.7NewKerberosticketoklist8.1.6CheckKerberosticketonrsd8OracleNamesoracg9.0.1ClassGeneratororacle(7.3.4)Oracleexecutableoradism9.0.1DynamicISMoraenv(7.3.4)Managesenvironmentorapwd(7.3.4)Managespasswordsoratclsh8TCLShelloraxml9.0.1XMLProcessororaxsl9.0.1XSLTProcessorosh8Calledfromoraenvotrccol(7.3.4)Oracletracecollectorotrccref(7.3.4)Oracletracepurgecollect.datfileotrcfmt(7.3.4)Oracletraceformatotrcrep(7.3.4)Oracletracereportott8ObjectTypeTranslatorott89.0.1ObjectTypeTranslatorowm8.1.6OracleWalletManagerpasswdconvert9.2.0Unknownproc(7.3.4)Pro*Cprocob(7.3.4)Pro*COBOLprocob188.1.6Pro*COBOLProfor8.1.6Pro*Fortranrelink8.1.5Relinkexeutablesrman8RecoveryManagerrtsora(7.3.4)COBOLRuntimeSystemrunInstaller8.1.5NetConfigurationAssistantsbttest8.1.5MediaManagerschema9.0.1XMLvalidationschemasync9.2.0synchronizesschemaelements;usedwithOracleDirectoryServersqlj8.1.5SQLJsqlldr(7.3.4)SQL*Loadersqlplus(7.3.4)SQL*Plusstatusnc8.1.7NativeCompilationStatussymfind(7.3.4)Symbolicfindsysresv8.1.5SharedMemory/Semaphorestkprof(7.3.4)Traceoutputformattertns2nis8.1.6TNSNISMappingtnslsnr(7.3.4)TNSListenertnsping(7.3.4)Listenerpingertransx9.2.0XMLtrcasst8TraceAssistanttrcroute(7.3.4)Networkanalysiststshm(7.3.4)Sharedmemoryumu9.2.0LDAPunzip9.2.0Unziputilitywrap(7.3.4)PL/SQLencrypterxml9.0.1XML/XSLprocessingxmlcg9.2.0XMLprocessingxsql9.0.1XSQLPageszip9.2.0ZipUtility
MySQL采用双重授权(DualLicensed)，它们是GPL和MySQLAB制定的商业许可协议。

是要和操作系统进行Socket通讯的场景。否则建议慎重！

而SQLServer如果能像Oracle一样可以为登陆分配如：5%的cpu，10%的内存。就可以解决这个漏洞。

对于数据库来说，查询是数据库的灵魂，那么SQL查询效率究竟效率如何呢？下文将带对SQL查询的相关问题进行讨论，供您参考。

groupby子句可以将查询结果分组，并返回行的汇总信息Oracle按照groupby子句中指定的表达式的值分组查询结果。

微软对CLR作了大篇幅的宣传，这是因为数据库产品终于融入.net体系中。最开始我们也是狂喜，感觉对象数据库的一些概念可以实现了。

也可谈一下你是怎么优化存储过程的?

总感觉自己还是不会SQL

分区表是个亮点！从分区表也能看出微软要做大作强SQLServer的信心。资料很多，这里不详细说。但是重点了解的是：现在的SQLServer2005的表，都是默认为分区表的。因为它要支持滑动窗口的这个特性。这种特性对历史数据和实时数据的处理是很有帮助的。