Archive for December 2008

timesten log 解析

, 23:48 pm December 25 2008

我有一个timesten实例,处于ASP模式

偶认为跟踪tt的日志对于进一步的了解tt的工作机制是很有好处的.
以下为active和standby两台的日志,大概每隔3秒左右刷新一次日志

—Active support log
2008-12-25 23:20:40.83 Info: ORA: 1097892: ora-1097892-2314-eporter00387: object_id 110409, bookmark 7
2008-12-25 23:20:40.84 Info: ORA: 1097892: ora-1097892-2314-eporter00387: object_id 611296, bookmark 44674
2008-12-25 23:20:40.85 Info: ORA: 1097892: ora-1097892-2314-eporter00387: object_id 597997, bookmark 22945 Continue reading ‘timesten log 解析’ »

Tags:
Category: Oracle技术  |  Comment

表调优之碎片过多一例

, 12:36 pm December 22 2008

开发商发映某映查询巨慢,而该表只有区区几千条记录.

以下这句查询需要15秒：
select count(*) from PMS.SUP_SUPPLIER this_ where (1=1) order by this_.SUP_CODE asc;
以下这名查询45秒还没有反应：
select * from SUP_SUPPLIER where name like ‘%消防%’ ;

处理过程如下:

1.分析执行计划:该表为全表扫描

2.查询该表耗时近30 sec Continue reading ‘表调优之碎片过多一例’ »

Tags:
Category: Oracle技术  |  Comment

如何和公交车上邻座的女孩攀谈?

, 0:24 am December 22 2008

你：可以问个路吗？
她：可以啊！
你：怎么才能走到你的心里？
她：……

———————————————————-

某BBS上看到的，很有才的说。

Category: 幽默一下  |  2 Comments

大夫山公园游记

, 0:55 am December 15 2008

周六和邻居大哥,还有几个MM一起去大夫山骑单车。邻居带了一个很好的DC，这天狂拍照。秀了几张

IMG_4068

Continue reading ‘大夫山公园游记’ »

Category: 旅游摄影  |  1 Comment

珠海出差记

, 22:31 pm December 14 2008

08.12.14 OCE 割接,出差珠海。

虽不是第一次出差珠海，但漫步在珠海边的情侣路上，吹吹海风，感觉还是很不错的。

以前出差总是去珠海电信，现在出差就去珠海移动……..

无限瑕想中………..

Tags:
Category: 旅游摄影  |  Comment

团队合作一例

, 1:01 am December 12 2008

晚上和同事一起去打雨猫球，一共4个人，刚好可以2v2

4个人中我的球技最好，于是我和最弱的同事做搭档，于是开始比赛

第一场：我们输了

我们输了，大概15:21左右的样子。主要是我们失误太多。

第二场：反败为胜

我们总结第一场的经验，制定以下规则： Continue reading ‘团队合作一例’ »

Category: 键盘涂鸦  |  Comment

10g Real Application Clusters Architecture and Oracle Clusterware Processing

, 21:14 pm December 8 2008

1.Oracle Clusterware Software Component Processing Details

  • Cluster Synchronization Services (CSS)—Manages the cluster configuration by controlling which nodes are members of the cluster and by notifying members when a node joins or leaves the cluster. If you are using third-party clusterware, then the css process interfaces with your clusterware to manage node membership information.
  • Cluster Ready Services (CRS)—The primary program for managing high availability operations within a cluster. Anything that the crs process manages is known as a cluster resource which could be a database, an instance, a service, a Listener, a virtual IP (VIP) address, an application process, and so on. The crs process manages cluster resources based on the resource’s configuration information that is stored in the OCR. This includes start, stop, monitor and failover operations. The crs process generates events when a resource status changes. When you have installed Oracle RAC, crs monitors the Oracle instance, Listener, and so on, and automatically restarts these components when a failure occurs. By default, the crs process makes five attempts to restart a resource and then does not make further restart attempts if the resource does not restart. Continue reading ‘10g Real Application Clusters Architecture and Oracle Clusterware Processing’ »

    • Tags: ,
    Category: Oracle技术  |  Comment

    rman异机恢复一例

    , 23:24 pm December 7 2008

    环境:9i for sun 5.8

    把rman全备异机恢复重建实例，假设从source主机到target 主机

    主要步骤如下：

    1.拷贝同样的ORACLE_HOME到target主机，设置一样的环境变量和用户名
    2.startup nomount
    3.restore control
    4.alter database mount
    5.restore all datafile & rename datafile
    6.restore archive log
    7.recover database until cancel
    8.rename logfile to new dest
    9.resetlog database open
    10.recreate tempfile Continue reading ‘rman异机恢复一例’ »

    Tags: ,
    Category: 键盘涂鸦  |  Comment