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 工具来轻松地访问、集成、分析和共

参考： /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

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

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

1.direct+parallelalter session enable parallel dml;insert /*+ append parallel(XXXX,default)*/ into XXXX select * from YYYY;2.direct+parallelcreate table XXXX parallel as select * from YYYY;3.direct+parallelalter session force parallel dml;alter session force parallel ddl;create table XXXX as select * from YYYY;4.directcreate table XXXX as select * from YYYY; insert /*+ append */ into XXXX select * from YYYY;[@more@]

Rman备份不兼容 10.2.0.4的压缩备份集无法用10.2.0.1的Rman恢复，运行过程中报错。 al32utf8字符集转utf8（迁移RAC，可传输表空间准备） al32utf8是utf8的超集，文献库未使用al32utf8的特殊字符，可以无损转换字符集。[@more@]