停止空想

参考  http://pradagu.itpub.net/post/216/12681

released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 12/30/2004 11:21:05
ORA-19506: failed to create sequential file, name=”cf_TJNPM_8_1_546261663″, parms=”"
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSAValidateFeatureId: Failed with error:
Server Status:  unexpected message received

阅读全文 »

今天发现一条语句导致latch free，而该条语句之前没有任何问题。

语句如下：

select * from t where  reverse(a.report_id) like ‘_9859009002623000209%’)

本来应该利用上该表上的反序索引。但是因为下划线在sql里面是特殊字符，所以选择了全表扫描。

如果要使用该index，select * from t where reverse(a.report_id) like ‘\_9859009002623000209%’) escape ‘\’;

进行转义。

如何根据不同的语言环境的设置，让程序显示不同的application name

Here’s an alternative way to do it using the localization features of OS X:

1. Create an en.lproj directory if your project doesn’t already have one. 
2. Inside the en.lproj directory create a file called InfoPlist.strings.
3. Add this line to the file: ”CFBundleDisplayName” = “YourNewAppName”;