ITPub博客

http://www.itpub.net/thread-1164171-1-1.htmlselect convert('?','ZHS16GBK','ZHS32GB18030') A,convert('?','ZHS32GB18030','ZHS16GBK') B,convert('?','ZHS32GB18030','ZHS32GB18030') C,dump('?') D,dump(convert('?','ZHS32GB18030','ZHS32GB18030')) Efrom dual;-----结果如下---------------------------------------A B C D E？ ?? ? Typ=96 Len=2: 254,159 Typ=1 Len=2: 254,159数据库、客户端和操作系统字符集都是GBK，应用时发现这个字'?'从GB18030转码到GBK有问题，在这里进行实验。从编码看两个字符集这个字都有相同

Windows 7 Starter with SP1 x86 简体中文版File Name：cn_windows_7_starter_with_sp1_x86_dvd_624050.isoDate Published (UTC)：2/21/2011 8:55:44 AMLast Updated (UTC)：2/21/2011 8:55:44 AMSHA1：6F5556ABBEFD828C22AEBBF9FBC15E2E3773F999ISO/CRC：ED8840F4下载：ed2k://|file|cn_windows_7_starter_with_sp1_x86_dvd_624050.iso|2651877376|47588C006F1FC712080A6185044AB156|/Windows 7 Home Basic with SP1 x86 简体中文版File Name：cn_windows_7_home_basic_with_sp1_x86_dvd_620743.isoDate Published (UTC)：2/21/2011 8:49

Microsoft® SQL Server® 2008 R2建立在与 SQL Server® 2008 一起提供的可信的、高生产率的和智能的数据平台的基础之上，它提供了大量的新改进，这些改进将帮助您的组织更加自信地进行扩展、提高 IT 效率和实现良好管理的自助 BI。此 CTP 版本为应用程序和多服务器管理、复杂的事件处理、Master Data Services 和最终用户报告包括多种新的和增强的功能。并且还引入了 PowerPivot for Microsoft® Excel（以前称作“Gemini”项目）来使用户能够使用他们已经很熟悉的 Microsoft® Office 工具来轻松地访问、集成、分析和共

我们在使用VI Client或者Virtual Center管理ESX时，无论是右键虚拟机"编辑设置"手动更改虚拟机的MAC还是在ESX Console下修改虚拟机的*.vmx文件。系统都会返回提示虚拟机MAC地址不能超出"00:50:56:3f:ff:ff"这个范围。 很多企业内部的服务器在没有上虚拟化之前，某些应用需要绑定物理网卡的地址。在迁移到ESX后，可能会出现以上困扰。虽然可以找软件代理商更换绑定的MAC地址，但是可能一大串麻烦的流程或者影响生产业务应用的时间。有什么办法可以快速解决这个问题呢，大家可以参考以下几种方法:1. GUES

参考： /usr/share/doc/kernel-doc-2.6.18/Documentation/networking/bonding.txt 1：首先要看linux是否支持bonding.(2.4版本大部分发行版都支持)# modinfo bonding 如果没有,说明内核不支持bonding,需要重新编译内核编译内核的步骤这里就不多写了,在make menuconfig里面找到Bonding driver support这样的对话框,选中它.如果是模块编译,还需要挂载模块.挂载bonding 模块的方法； [root@localhost#] modprobe bonding如果/sbin/ifenslave没有,我们还需要把它也单独编译出来[root@lin:/home/beinan#] cd /usr/src/linux-2.6.20/Documentatio

ASM was introduced with Oracle 10g and is used as a Volume Manager and a file system. It provides both mirroring and striping of the database files. To use ASM you need to create a Diskgroup and add disks/raw devices to the Diskgroup.Data is allocated in disks in terms of Extents. As per documentation Every ASM disk is divided into allocation units (AU). An AU is the fundamental unit of allocation within a disk group. A file extent consists of one or more AU. An ASM file consists of one or more

主题: How to Setup IPMP as Cluster Interconnect 文档 ID: 368464.1 类型: HOWTO 上次修订日期: 14-JAN-2009 状态: MODERATEDIn this Document Goal Solution ReferencesThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.Applies to:Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7Sun Solaris SPARC (64-b

Subject: Configuring Linux for the Oracle 10g VIP or private interconnect using bonding driver Doc ID: 298891.1 Type: BULLETIN Modified Date : 02-APR-2008 Status: PUBLISHED PURPOSE-------In order to avoid the public LAN from being a single point of failure, Oracle highly recommends configuring a redundant set of public network interface cards (NIC's) on each cluster node. Network redundancy can be achieved On Linux platforms using NIC Teaming (configuring multiple interfaces to a team o

Subject: Configuring non-raw multipath devices for Oracle Clusterware 11g (11.1.0) on RHEL5/OEL5 Doc ID: 605828.1 Type: HOWTO Modified Date : 04-MAR-2009 Status: PUBLISHED In this Document Goal Solution Udev and Device Name Persistency Multipath and Udev Configuring non-raw multipath devices for Oracle Clusterware 11g (11.1.0) on RHEL5/OEL5 Assumptions 1. Configure SCSI_ID to Return Unique Device Identifiers 1a. Whitelist SCSI devices 1b. List all SCSI (Clu

http://topic.csdn.net/u/20100109/13/6a10c168-f190-4766-b838-adbf03c4ac7b.html?179651.使用视图create or replace procedure row_to_col(tabname in varchar2, group_col in varchar2, column_col in varchar2, value_col in varchar2, Aggregate_func in varchar2 default 'max', colorder in varchar2 default null, ro

http://www.speedguide.net/analyzer.php MTU 通信术语 最大传输单元(Maximum Transmission Unit,MTU)是指一种通信协议的某一层上面所能通过的最大数据报大小(以字节为单位) MTU 不行太大也不能太小 要刚刚合适 比如:一个数据总长是 2999字节 MTU 为1500时 这个数据被 拆成 1500 为标准的一段 分 1500+1499 2段 传送完毕 MTU 为1400 时 这个数据被 拆成 1400 为标准的一段 分 1400+1400+199 3段 传送完毕 所以太小了 传送就不效率了... 比如:一个数据总长是 9999字节 MTU 为15000时 这个数据被 拆成 15000 为标准的一段 分 1

MTU设置 MTU，即Maximum Transmission Unit(最大传输单元)，此值设定TCP/IP协议传输数据报时的最大传输单元。设置合适的MTU值可以解决“部分网站打不开”、“上网速度慢”等问题，并且可以适当提升上网速度。 设置多大的MTU值取决于你的上网方式，不同的上网方式支持不同的MTU，下面列出了一些上网方式的MTU值： EtherNet(一般上网方式，默认值):1500 PPPoE/ADSL:1492 Dial Up/Modem:576 问题一：知道了我的上网方式，如何设置MTU值？ 1. 在 『开始』>『运行』中，键入regedit，点确定； 2. 选择『HKEY_Local_Machine』

Cursor Usage and Parsing Every developer wants his or her code to run as fast as possible. For code with SQL statements, that means cursor access must be fast. The fastest possible access of a cursor is through the open cursor cache in the session memory of the server session. Every open cursor in the open cursor cache has a pointer to the SGA memory location of that cursor handle. To execute the cursor, the pointer is used; parsing is not required. An open cursor has already been pars

今天开始在OU参加为期四天的Oracle 10g OCM考 试的培训，这个培训是第一次在OU举办，并不是对OCM中牵涉 到Oracle数据库技术进行培训而是专门针对如何应对OCM考 试的培训。 OCM考试全称为Oracle Certified Master（Oracle认证大师），是在OCA（Oracle认证专员Oracle Certified Associate）、OCP（Oracle认证专家Oracle Certified Professional)之后更高一级的Oracle技术认证，也是Oracle技术认证最高的一个级别。 考试是两天的时间，全部为实际操作的考试，第一天是创建数据库和安装Grid Control，第二天是创建RAC以及部署D

This event appears when a PQ slave has nothing to do, but is not allowed to go idle. One scenario where you can see large values for the event is when (for example) you have a large data set coming out of a parallel ORDER BY. The last layer of PX slaves in the query will receive a ranged set of rows and sort them. The QC will then request ALL the rows from the first PX slave, then the second, then the third and so on. When the first slave has supplied all its rows, it wil

Trace file /opt/oracle/diag/rdbms/business/BUSINESS4/trace/BUSINESS4_ora_1300.trcOracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsORACLE_HOME = /opt/oracle/product/11gR1/dbSystem name: LinuxNode name: DC-CLUSTER-04Release: 2.6.16.60-0.21-smpVersion: #1 SMP Tue May 6 12:41:02 UTC 2008Machine: x86_64Instance name: BUSINESS4Redo thread mounte

v$fixed_table：所有的动态视图log_checkpoints_to_alert：参数，将checkpoint记入警告日志[@more@]

create or replace procedure dump_csv(p_query in varchar2, p_separator in varchar2 default ',', p_dir in varchar2, p_filename in varchar2) AUTHID CURRENT_USER is l_output utl_file.file_type; l_theCursor integer default dbms_sql.open_cursor; l_columnValue varchar2(2000); l_status integer; l_colCnt number default 0; l_separator varchar2(10) default ''; l_c

lxm4545 发表于 2009-8-27 00:41 哪家的电源最安静？[i=s] 本帖最后由 lxm4545 于 2009-8-27 00:42 编辑 [/i] 最近留意些中高端的电源……实在下不了手！对噪音极其敏感的我想找个安静的电源，可是实在太难了！ 一会听某论坛编辑说“安耐美电源的噪音控制一直是有口皆碑的……” 一会看某专版的评论说“海韵的电源一向安静……” 一会又见一堆帖子说“海盗电源到处都是是有理由的，你看那个风扇……” …… 还有诸如康舒，银欣，TT的，也有不少好评的。可是差评却也有，以上每个牌子都有人埋怨吵死人的……究竟我该听谁的啊！

Oracle® Database Data Cartridge Developer's Guide,10g Release 2 (10.2)User-Defined Aggregate Functions The methods in this section are implemented as methods in an object type. The CREATE FUNCTION statement is used to actually create the aggregate function. Table 22-1 summarizes these functions. Table 22-1 Summary of User-Defined Aggregate Functions Function Description ODCIAggregateInitialize() Initializes the aggregation context and instance of the implementa