hunterjoy的个人空间 http://space.itpub.net/?uid-543979 Copyright(C) hunterjoy的个人空间 SupeSite/X-Space Sun, 20 Jul 2008 17:46:00 GMT statspack报告解读 http://space.itpub.net/?uid-543979-action-viewspace-itemid-399681 参见Metalink:

Subject: Systemwide Tuning using STATSPACK Reports
...]]> blog hunterjoy Sun, 13 Jul 2008 21:35:34 GMT direct path read wait event 的处理办法 http://space.itpub.net/?uid-543979-action-viewspace-itemid-374608 Typically this event occurs if application is doing frequently large sorts and your sort_area_size or pga_aggreagate_target is small.

For finding which object DB is waiting for , find p1 and p2 from v$session_wait and run the following SQL....]]> blog hunterjoy Tue, 08 Jul 2008 21:15:53 GMT CRSCTL和SRVCTL的命令用法 http://space.itpub.net/?uid-543979-action-viewspace-itemid-373141 1. How the crs related services startup when OS startup or reboot:

OS: Linux
From the directory (/etc/init.d), There are four executable shell scripts:
init.crs (Combination of all ...]]> blog hunterjoy Sun, 06 Jul 2008 11:19:55 GMT Plans and the order of execution(执行计划顺序) http://space.itpub.net/?uid-543979-action-viewspace-itemid-373140                      Plans and the order of execution(执行计划顺序)

            &...]]> blog hunterjoy Sun, 06 Jul 2008 11:00:11 GMT statspack报告分析摘录 http://space.itpub.net/?uid-543979-action-viewspace-itemid-364741 取自http://www.chinaunix.net 作者:joelau 

今天晚上看了这篇文章，觉得不错，特保存下来，以便今后参考，谢谢上面的作者。

(1) 调整的先后次序 
blog hunterjoy Tue, 24 Jun 2008 21:53:01 GMT 在RAC中修改ASM实例的sys用户口令 http://space.itpub.net/?uid-543979-action-viewspace-itemid-343176 1、在RAC1的$ORACLE_HOME\dbs路径下修改:

orapwd file=PWD+ASM1.ora password=oracle force=y

2、在RAC2的$ORACLE_HOME\dbs路径下修改:

orapwd file=PWD+ASM2.ora password=oracle force=y

3、关闭两个节点的ASM实例

srvc...]]> blog hunterjoy Mon, 09 Jun 2008 15:37:19 GMT Choosing Composite Indexes http://space.itpub.net/?uid-543979-action-viewspace-itemid-332637
Improved selectivity
Sometimes two or more columns or expressions, each with poor selectivity, can be combi...]]> blog hunterjoy Thu, 05 Jun 2008 20:21:09 GMT RAC安装备注 http://space.itpub.net/?uid-543979-action-viewspace-itemid-277697 安装CLUSTER软件前，先对环境进行检查,执行:

./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -verbose

]]> blog hunterjoy Sun, 18 May 2008 16:22:03 GMT 行链接(Row chaining)和行迁移(Row Migration)的读书笔记 http://space.itpub.net/?uid-543979-action-viewspace-itemid-257599 　　　今天上午，阴云密布，天气很黑，屋外雷雨交加，是个看书的好日子．偶尔在电脑上看到以前下载的CSDN Emag(Oracle)第一期，浏览了一下，发现Coolyl写得<关于Oracle数据库中行迁移/行链接的问题>不错，以前也看过不少有关Row chaining和Row Migration的文章，...]]> blog hunterjoy Sat, 03 May 2008 10:29:02 GMT ORACLE10G认证考试相关问题 http://space.itpub.net/?uid-543979-action-viewspace-itemid-257284 未能收到OCP证书的处理流程
在长时间等待之后，如果还没有能收到证书，不用着急，因为只要通过了考试，得到证书是早晚的事。但由于投递，地址错误等原因，可能需要重新打印邮寄，那么可以使用以下流程来处理。 blog hunterjoy Thu, 01 May 2008 18:18:39 GMT instance_name、db_name、ORACLE_SID、db_name等的区别 http://space.itpub.net/?uid-543979-action-viewspace-itemid-231247 ----------from oracle metalink-----------
The global names is used by the oem product and needs to be in the sid_desc for oem to function&nb...]]> blog hunterjoy Tue, 08 Apr 2008 20:18:39 GMT 升级VMWARE中REDHAT AS4内核 http://space.itpub.net/?uid-543979-action-viewspace-itemid-230934 1.从ftp://ftp.redhat.com/pub/redhat/linux/updates/enterprise/4AS/en/os/SRPMS/上下载

kernel-2.6.9-42.EL.src.rpm

2启动REDHAT AS4的ftp功能

#...]]> blog hunterjoy Sun, 06 Apr 2008 15:54:49 GMT 有用的Linux网络资源 http://space.itpub.net/?uid-543979-action-viewspace-itemid-229952 http://learn.tsinghua.edu.cn/homepage/2001315450/index.html
http://debian.ustc.edu.cn 中科大的Debian镜像
http://www.linuxfans.org
http://www.linuxsir.org
http://www.linuxeden.com
http://www.linuxforum.net
http://www.linuxaid...]]> blog hunterjoy Sat, 05 Apr 2008 20:36:57 GMT Oracle ASM on Linux with single Hard Drive http://space.itpub.net/?uid-543979-action-viewspace-itemid-198179 Automatic Storage Management (ASM) is a feature in Oracle Database 10g that provides the database administrator with a simple storage management interface that is consistent across all server and storage platforms. As a vertically integrated file sy...]]> blog hunterjoy Sat, 01 Mar 2008 16:39:35 GMT Oracle Net服务　－－　理论 http://space.itpub.net/?uid-543979-action-viewspace-itemid-171167 目标：

控制数据库

  • 启动和关闭Oracle Listener

Oracle Net服务

  • 使用Database Control创建另外的监听器
  • 使用Database Control创建Oracle Net服务别名
  • 使用Database Control配置连接时间故障切换...]]> blog hunterjoy Sun, 17 Feb 2008 11:55:20 GMT 有助于Oracle学习的网站 http://space.itpub.net/?uid-543979-action-viewspace-itemid-170117 http： blog hunterjoy Tue, 12 Feb 2008 09:37:34 GMT 如何修改backupset路径 http://space.itpub.net/?uid-543979-action-viewspace-itemid-102806 (源自论坛http://www.itpub.net/viewthread.php?tid=191100)

    问题描述：

    从b机器上做对a机器上的db做rman备份.
      但备份后的backupset文件会默认放到a机器上?设目录为机器...]]> blog hunterjoy Sat, 05 Jan 2008 15:09:17 GMT 用户管理的几种场景的数据库恢复 http://space.itpub.net/?uid-543979-action-viewspace-itemid-64630 用户管理的几种场景的数据库恢复 blog hunterjoy Mon, 31 Dec 2007 18:03:07 GMT 开博客的初衷 http://space.itpub.net/?uid-543979-action-viewspace-itemid-64629       今天心情很high,因为在全国最有影响力的数据库网站ITPUB上开博客了.

          开博客的初衷,很简单,就是想不断提高自己的计算机技术-数据库水平.分享数据库知识.

         ...]]> blog hunterjoy Mon, 31 Dec 2007 17:30:01 GMT Oracle中用户管理的不完全恢复简介 http://space.itpub.net/?uid-543979-action-viewspace-itemid-64628 Oracle中用户管理的不完全恢复简介

    用户管理的不完全恢复必须满足下面三个条件才可以使用: 　　a) 归档模式
    　　b) 要有所有datafile在误操作之前的备份
    　　c) 要有自要使用的备份以来的所有归档
    　　<...]]> blog hunterjoy Mon, 31 Dec 2007 17:14:22 GMT