分类目录归档:未分类

code highlighter test 2

set pagesize 0
set linesize 125
set serveroutput on size 10000
col plan_table_output format a125
undefine hash_value
set verify off feedback off
var hash_value varchar2(20)
begin
:hash_value := '&hash_value';
end;
/
insert into plan_table
(statement_id,timestamp,operation,options,object_node,object_owner,object_name,
optimizer,search_columns,id,parent_id,position,cost,cardinality,bytes,other_tag,
partition_start,partition_stop,partition_id,other,distribution,
cpu_cost,io_cost,temp_space,access_predicates,filter_predicates,
plan_id,OBJECT_ALIAS,DEPTH,PROJECTION,TIME,QBLOCK_NAME
)
select distinct hash_value,sysdate,operation,options,object_node,object_owner,object_name,
optimizer,search_columns,id,parent_id,position,cost,cardinality,bytes,other_tag,
partition_start,partition_stop,partition_id,other,distribution,
cpu_cost,io_cost,temp_space,access_predicates,filter_predicates,
:hash_value,OBJECT_ALIAS,DEPTH,PROJECTION,TIME,QBLOCK_NAME
from v$sql_plan
where hash_value = :hash_value
/
col piece noprint
select distinct 'sql_id:'||sql_id, ' hash_value:'||hash_value, 'plan_hash_value:'||plan_hash_value from v$sql_plan where hash_value=:hash_value
/
select distinct piece,sql_text from v$sqltext where hash_value = :hash_value order by piece
/
@?/rdbms/admin/utlxplp.sql
set linesize 80
set verify on feedback on pagesize 1000

set pagesize 0
set linesize 125
set serveroutput on size 10000
col plan_table_output format a125
undefine hash_value
set verify off feedback off
var hash_value varchar2(20)
begin
:hash_value := '&hash_value';
end;
/
insert into plan_table
(statement_id,timestamp,operation,options,object_node,object_owner,object_name,
optimizer,search_columns,id,parent_id,position,cost,cardinality,bytes,other_tag,
partition_start,partition_stop,partition_id,other,distribution,
cpu_cost,io_cost,temp_space,access_predicates,filter_predicates,
plan_id,OBJECT_ALIAS,DEPTH,PROJECTION,TIME,QBLOCK_NAME
)
select distinct hash_value,sysdate,operation,options,object_node,object_owner,object_name,
optimizer,search_columns,id,parent_id,position,cost,cardinality,bytes,other_tag,
partition_start,partition_stop,partition_id,other,distribution,
cpu_cost,io_cost,temp_space,access_predicates,filter_predicates,
:hash_value,OBJECT_ALIAS,DEPTH,PROJECTION,TIME,QBLOCK_NAME
from v$sql_plan
where hash_value = :hash_value
/
col piece noprint
select distinct 'sql_id:'||sql_id, ' hash_value:'||hash_value, 'plan_hash_value:'||plan_hash_value from v$sql_plan where hash_value=:hash_value
/
select distinct piece,sql_text from v$sqltext where hash_value = :hash_value order by piece
/
@?/rdbms/admin/utlxplp.sql
set linesize 80
set verify on feedback on pagesize 1000

public class Hello {
public static void main(String[] args) {
System.out.println("Hello World!");
}
}

#!/usr/bin/perl
use Txu::Util;
use Data::Dumper;

#SetDebug;

unless (@ARGV >= 2){
print "Usage: ./diff_hd.pl file1 file2\n";exit;
}

open $rpt, '<', $ARGV[0];

my $r = &FileToArray($rpt,'\s*,\s*');

close $rpt;

open $rpt, '<', $ARGV[1];

my $s = &FileToArray($rpt,'\s*,\s*');

close $rpt;

my $c = &NewDiffCfg($r->[0], $s->[0], [0], 2);

my $d = &GetDiffArray(
$c
);

function foo() {
echo "Hello World!\\n";
}
?>

 

 

 

CQN (continuous query notification)

related urls:

26 Database Change Notification
http://download.oracle.com/docs/cd/E11882_01/java.112/e16548/dbchgnf.htm#CACHJFCC

Database Change Notification的一个例子

http://yangzb.javaeye.com/blog/475498

13 Developing Applications with Database Change Notification

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_dcn.htm

google result
http://www.google.com.hk/search?hl=zh-CN&newwindow=1&safe=strict&q=continuous+query+notification&aq=f&aqi=&aql=&oq=

blog搬迁到ixiezi免费空间

hawkhost的空间要到期了,续费没有半价优惠了。

算算一年来基本上只用了wordpress,其他网站功能用的很少,索性迁移到免费的ixiezi空间。

这个空间也在美国,国内访问速度一般。

搬家很方便,用工具->导出从hawkhost导出,然后再ixiezi用工具->导入导入,选择下载附件。这样就会自动把blog内容和所有附件,图片全部都导入到新的wordpress网站。

然后在ixiezi绑定域名,在域名控制面板修改3qs.com和www.3qs.com的A记录ip即可。

٩(●̮̮̃●̃)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶٩(͡๏̯ ͡๏)۶٩(-̮̮̃•̃)۶

QQ个性签名特殊字符。
٩(●̮̮̃●̃)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶٩(͡๏̯ ͡๏)۶٩(-̮̮̃•̃)۶

1. ٩(●̮̮̃●̃)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶٩(͡๏̯ ͡๏)۶٩(-̮̮̃•̃)۶

2. ٩(●̮̮̃•̃)۶٩๏̯͡๏)۶

3. ¸¸.•´´¯`•*̡͌l̡*̡̡ ̴̡ı̴̴̡ ̡̡͡|̲̲̲͡͡͡ ̲▫̲͡ ̲̲̲͡͡π̲̲͡͡ ̲̲͡▫`•.¸¸.•´´¯`

4. ﴾͡๏̯͡๏﴿ (͡๏)(͡๏)

5. ҉_҉

6. ̿ ̿̿’̿’̵͇̿̿=(•̪●)=/̵͇̿̿/’̿̿ ̿ ̿ ̿

7. ̡̡̡ ̡͌l̡̡̡ ̡͌l̡*̡̡ ̴̡ı̴̴̡ ̡̡͡|̲̲̲͡͡͡ ̲▫̲͡ ̲̲̲͡͡π̲̲͡͡ ̲̲͡▫̲̲͡͡ ̲|̡̡̡ ̡ ̴̡ı̴̡̡ ̡͌l̡̡̡̡.

8. ♨

٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶٩(`̮̃`)۶ ٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶ ٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶٩(`̮̃`)۶ ٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶ ٩(-̮̮̃•̃)۶٩(`̮̃`)۶٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶٩(•̮̮̃•̃)۶ ٩(-̮̮̃-̃)۶ ٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶٩(`̮̃`)۶٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶ ٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶ ٩(`̮̃`)۶ ٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶٩(`̮̃`)۶ ٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶٩(`̮̃`)۶ ٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶٩(`̮̃`)۶٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶ ٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶٩(`̮̃`)۶٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶٩(`̮̃`)۶ ٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶ ٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶ ٩(`̮̃`)۶٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶٩(`̮̃`)۶٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶٩(•̮̮̃•̃)۶ ٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶٩(`̮̃`)۶ ٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶ ٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶ ٩(`̮̃`)۶٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶ ٩(-̮̮̃•̃)۶٩(`̮̃`)۶ ٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶٩(`̮̃`)۶٩(●̮̮̃●̃)۶٩(͡๏̯͡๏)۶ ٩(•̮̮̃•̃)۶٩(-̮̮̃-̃)۶٩(●̮̮̃•̃)۶٩(-̮̮̃•̃)۶٩(`̮̃`)۶

重瓣矮牵牛的掐尖(掐心)

苗的掐心,基本上保留10cm即可,如下面2图所示

pinch_petunia_1-1

pinch_petunia_2-1

假值之后,定植之后的掐心,我一般保留10cm左右,在如下图状态的时候掐第一次,然后等分枝10cm左右再掐一次。
因为没有太多时间照料,所以基本就掐2次。如果你有时间,可以一直掐下去,直到出现满意的株型为止。

在株型未达到期望值之前,发现花苞一律摘掉,避免消耗养分。

pinch_petunia_2-1

pinch_petunia_2-2

pinch_petunia_2-3

Oracle 11.1.0.7 , Single Instance, Clusterware, Giving up: Oracle CSS stack appears NOT to be running.

今天恢复旧的11.1.0.7单机ASM数据库环境,用来恢复原有的11.1.0.7的数据库备份,按照以前的方法操作如下:

1.清空当前clusterware环境:

rm -rf /etc/oracle
rm -rf /var/tmp/.oracle/*
rm -rf /tmp/.oracle
rm -rf /home/user01/oracle/11g/Clusterware
rm -rf /home/user01/oracle/11g/checkpoints

# vi /etc/inittab ,去掉最后的crs启动命令。

# init q;

# mv $ORA_CRS_HOME to a new location

# reboot

2.重新配置11.1.0.7 single instance clusterware [为了使用ASM]

#/home/user01/oracle/11g/crs_11gProd/bin/localconfig reset

这一步运行出错,报错如下:

Successfully accumulated necessary OCR keys.
Creating OCR keys for user ‘root’, privgrp ‘root’..
Operation successful.
Configuration for local CSS has been initialized

Cleaning up Network socket directories
Setting up Network socket directories
Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process…
Expecting the CRS daemons to be up within 600 seconds.
ls /home/user01/oracle/11g/crs_11gProd/cdata/localhost/local.ocrGiving up: Oracle CSS stack appears NOT to be running.
Oracle CSS service would not start as installed
Automatic Storage Management(ASM) cannot be used until Oracle CSS service is started

ps -ef|grep crs, 没有进行在运行。

查看 $ORA_CRS_HOME/log/hostname/alertxxxx.log文件,未发现错误。查看Crsd和cssd目录的log,没有发现错误。

重新清空环境,再次操作,错误依旧。

查看/var/log/message文件,发现如下log:

Apr  7 05:30:08 host01 logger: Waiting for filesystem containing /home/user01/oracle/crs_11gR2/bin/crsctl.
Apr  7 05:31:08 host01 logger: Waiting for filesystem containing /home/user01/oracle/crs_11gR2/bin/crsctl.

怀疑是以前历史记录没有清除干净,造成运行root后,查找的是旧的crsctl。

crs_11gR2目录已经删除,不应该再被引用。

检查配置文件和脚本,查找原因。

到/etc/init.d/目录

grep crs_11gR2 *

发现init.ohasd和ohasd两个文件中包含上述路径,删除这两个文件。

#nit q;

发现后台仍然报

host01 logger: Waiting for filesystem containing /home/user01/oracle/crs_11gR2/bin/crsctl.
错误,

#reboot

reboot后message里面的错误提示消失,重新运行配置命令。

#/home/user01/oracle/11g/crs_11gProd/bin/localconfig reset

Successfully accumulated necessary OCR keys.
Creating OCR keys for user ‘root’, privgrp ‘root’..
Operation successful.
Configuration for local CSS has been initialized

Cleaning up Network socket directories
Setting up Network socket directories
Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process…
Expecting the CRS daemons to be up within 600 seconds.
Cluster Synchronization Services is active on these nodes.
        host01
Cluster Synchronization Services is active on all the nodes.
Oracle CSS service is installed and running under init(1M)

配置成功。

重瓣矮牵牛 移植方法

1.假植

用10cm或12cm盆,泥炭+少许珍珠岩+控释肥。将花苗的穴盆边缘剪开一点,然后从这一点撕开。取出花苗后,在盆中间挖一个比花苗大一些的洞,放入花苗,把四周的土稍微压实。 然后浇透水,放阴凉处2天后就可以晒太阳了。

 

2.直接定植。

to to continued.

用Microsoft LiveWriter远程发布WordPress文章

这篇文章是使用Microsoft LiveWriter远程发布的。

感觉很方便啊。

live writer下载地址:http://download.live.com/writer

到后台 设置->撰写, 勾选“启用 WordPress,Movable Type,MetaWeblog和Blogger 的 XML-RPC发布协议。 ”

装好后,启动livewriter,会问你blog类型,给出网址和用户,密码后,live writer会自动判断blog类型,能认出来是wordpress。发布,修改文章方便多了。据说插入图片更方便啊。

justhost的主机在哪里?

这几天在晚上看到几次有人问:“justhost的主机在哪里?是不是在西雅图,是不是softlayer?”

记得前面livechat问过justhost的客服,说实在芝加哥。

Google了一下,“justhost data center”,从结果来看,至少官方宣称他们的主机是在Chicago, :-)  。而softlayer在Chicago没有机房。所以justhost主机不是在 Seattle ,也不是Softlayer的。

from www.web-hosting-top.com , justhost reviews.

JustHost Data Center
Just Host has its main data center based in Chicago and promises its customers 99.9% network uptime!

不过根据我的使用经验来看,justhost的主机路由比较复杂,目前已经看到有四种不同路由路径了,有些连国内的出口都不同,蛮奇怪的。以后有时间再来分析tracert。