Configuration of Load Balancing and Transparent Application Failover
Subject: Configuration of Load Balancing and Transparent Application Failover Doc ID: Note:226880.1Type: BULLETIN Last Revision Date: 27-JUL-2005Status: PUBLISHEDConfiguration of Load Balancing and T...
CONTROL_FILE_RECORD_KEEP_TIME & MAXLOGHISTORY
metalink对于control_file_record_keep_time的解释:CONTROL_FILE_RECORD_KEEP_TIME specifies the minimum number of daysbefore a reusable record in the control file can be reused. In the event a new recor...
Control File中备份信息被覆盖情况下的数据库恢复案例 (zt)
http://blog.csdn.net/kamus/archive/2005/01/17/257094.aspx 现场人员报告说误删除了用户(drop user),按照操作文档作RMAN的不完全恢复,但是报错,错误信息显示:RMAN-03002: failure during compilation of c...
省油与安全行车
油价和房价一样,不要指望会有下跌的可能,能省一点是一点,首先要在思想上明确6不(搞得跟领导做报告似的) 1首先,要做到六不:就是不虚荣—微型车够用就好 2不逞强—爬坡时不硬撑 3 不娇气—低速不开空调 ...
Oralce Trigger Before以及After 的差別
我想大概有些寫trigger的人會遇上這個問題..尤其是沒有師父指導..得自己瞎子摸象我花了點時間把這個問題給理清楚希望將來寫oracle trigger的人別犯跟我一樣的錯誤 . BEFORE Specify BEFORE to cause the database ...
Oracle Custom Support Identifier(CSI)
.A valid Custom Support Identifier(CSI) is required to create a MetaLinkaccount. A unique CSI number is usually issued for each Oracle product that is purchased.
Oracle OCM
OCM是Oracle公司在OCP这个项目上又推出的一个更高一级认证,全称是Oracle Certified Master,许多业内人士都把它称作Oracle认证的大师,是现今数据库领域中最高级别的认证。 OCM的定位: OCM是资...
ORACLE FLAHBACK 系列(包含版本9与版本10)(zt)
第一章、前言根据以往的经验,很多操作失误或者用户错误,将导致应用停顿甚至终止,但是,实际上,防止这种误操作的办法是非常用限的。如果没有良好的计划与高超的技术,一个很小的错误将可能导致一个很大的影响,如...
Checkpoint Tuning and Troubleshooting Guide
Purpose: This bulletin provides the Database Administrator a better understanding of incremental checkpoint and a description of four initialization parameters used for checkpoint tuning: ...
Oracle -- Common Performance Tuning Issues
TROUBLESHOOTING GUIDE Common Performance Tuning Issues Table of Contents 1. Introduction 2. Shared Pool and Library Cache Performance Tuning 3. Buffer Cache Performance Tuning 4. Latch Contention ...
Checkpoint触发条件,作用
1、log_checkpoint_timeout達到 2、當前redo日志已經寫夠log_checkpoint_internavl*操作系統塊字節 3、redo log switch 4、alter system checkpoint 5.當咝衋lter tablespace XXX begin backup,end backup的時候6...
Default and Maximum Values of MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXINSTANCES and MAXLOGHISTO
FREQUENTLY ASKED QUESTIONS--------------------------NOTE:-----All questions are related to Oracle for z/OS (OS/390), and the answers are valid for Oracle8, Orale8i, Oracle9i and Oracle10g.[@more@]CONTENTS--------1. What are the maximun number of datafiles ? MAXDATAFILES2. What are the maximun number of redolog groups ? MAXLOGFILES3. What are the maximun number of members for a redolog group ? MAXLOGMEMBERS4. What are the maximun number of instances that can access a database concurrently? MAXINS
ORACLE FLAHBACK 系列(包含版本9与版本10)(zt)
第一章、前言根据以往的经验,很多操作失误或者用户错误,将导致应用停顿甚至终止,但是,实际上,防止这种误操作的办法是非常用限的。如果没有良好的计划与高超的技术,一个很小的错误将可能导致一个很大的影响,如...
Oracle9i 9024安装手册(LinuxAS3.0) (ZT)
1、从网上下载redhat Enterprise Linux Advanced Server3的四个安装文件,安装时swap分区设置为内存的二倍。不要采用DHCP设置主机名和IP地址,而是“手工设置”。否则会在安装oracle的时候出现如下错误: [quote:864...
对“checkpoint not completed!”的理解 (zt)
假设数据库存在两个日志组log1和log2,首先,-->log1-->log2-->log1,此时(log2切换到log1)触发checkpoint,该checkpoint will flush dirty block to datafile,从而触发DBWn书写dirty buffer,等...
RedHat Advance Server上安装Oracle 9204 RAC参考手册(zt)
前言定位本文定位在那些有了一定Linux与oracle基础的,而且对RAC也要有相关了解热人员作为参考手册,而不是所谓的安装向导。所以本文没有详细的安装过程之类的步骤,却有详细的安装错误的解决办法。覆盖范围适合在Re...
Default and Maximum Values of MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXINSTA
FREQUENTLY ASKED QUESTIONS--------------------------NOTE:-----All questions are related to Oracle for z/OS (OS/390), and the answers are valid for Oracle8, Orale8i, Oracle9i and Oracle10g.CONTENTS----...
控制文件相关 -- MAXLOGHISTORY ,control_file_record_keep_time
MAXLOGHISTORY和control_file_record_keep_time这两个参数都和controlfile有关,也都和log file有关。很容易混淆在一起。如果你对这两个参数有不清楚的地方,希望这篇文章可以扫除你的疑惑。这两个参数对应于control...
十大常见错误清凉消暑法
不宜坐木 俗话说:“冬不坐石,夏不坐木”。夏天气温高,湿度大,木头,尤其是久置露天里的木料,椅凳等,露打雨淋,含水分较多,太阳一晒,温度升高,会向外散发出湿热,使人易患皮肤病、风湿和关节炎等。 不宜...
Bugs Fixed for Your Platform
The following table is a cumulative list of the platform-specific bugs addressed in all Oracle9i patch sets to date: Fixed in Release Bug Number Description 9202 2026123 v$session.program displays ’?...