How to Increase SCN
ACID：ORA-600 [2662] ORA-600 [4000] 1.通过adjust_scn 2.通过_minimum_giga_scn 3.通过oracdebugoradebug poke <address> <l...
技术文章列表
466 篇How to find Sessions generating high redo_archives in Oracle
12345678910111213141516171819202122232425262728293031323334 Run the below query tofind out the archive generation/hour f...
How to disable SSH timeout
SSH clients will automatically be disconnected from the server and prompt the below message after being idle or inactive...
How to Close and Expire Database Link
How to Close and Expire Database Link [ID 473635.1] Modified 09-DEC-2009 Type HOWTO Status PUBLISHED In this Document Go...
How to Clean Up After a Failed 10g or 11.1 Oracle CRS(Clusterware Installation)
Thursday, May 6, 2010 How to Clean Up After a Failed 10g or 11.1 Oracle CRS(Clusterware Installation) Runing following s...
How to avoid ORA-02153 when creating database links on 11.2.0.4 (the unsupported way) | DBA survival BLOG
Posted on August 31, 2015_Disclaimer (wow, most of my recent posts start with a disclaimer, I guess it’s bad): this post...
How ORACLE Uses Memory on AIX. Part 1: Processes « Intermediate SQL
7Mar/1066## ![1756814666425-46379b41-cef5-400d-bce5-8cd87f8d5259.pngHow !1756814666485-3eef5442-7073-4bf9-8ab2-639e3b580...
How Migrate All Files on ASM to Non-ASM (Unix_Linux)
I’ll use PL/SQL scripts and RMAN commands to accomplish this. I don’t like to use Oracle Managed File (OMF) for filesyst...
How many checkpoints in Oracle database _
Well, the answer is 7 (as per my knowledge). Oracle does 7 different checkpoints at various stages. Lets check out what ...
How do I know what extended statistics are needed for a given workload_ (Oracle Optimizer)
By Maria Colgan-Oracle on Mar 24, 2011 In our previous post we introduced extended statistics, which help the Optimizer ...
How Convert full Database 10g Linux-x86-64bit to AIX-64bit different Endian Format
In this post I’ll show you how to migrate full Oracle Database 10g on Linux (Little Endian) for AIX (Big Endian).I choos...
hanganalyze 分析 dbms_ijob.broken无效的问题
前几天机房迁移前计划先停掉一些dbms_job防止停机时“填乱”，结果有一台服务器在同事的toad以dba role 用户执行dbms_ijob.broken job,执行成功未报错，但发现job broken 状态未发现改变，重启toad...
goldengate 故障及解决方法汇总
1.数据库thread与sid不对应问题描述： GGS ERROR 500 抽取进程extu1起不来，提示找不到thread2的归档（没有保留哪天具体的报错信息） 问题分析：rac数据库曾经删除又重建一个节点，故thread2对应的实例已经...
Goldengate实现在线数据迁移
Goldengate的一大卖点就是可以实现在线的数据迁移，这意味着在整个过程中我们无需关闭数据库，甚至于无需停止应用。在<How to create a GoldenGate uni-directional target databa...
GoldenGate在Oracle数据库复制环境下aftercsn与atcsn的选取测试
实验说明： 熟悉Ogg实施过程的伙伴们都应了解，实施步骤中初始化的步骤尤为关键，通常可以使用rman或者exp两种方式，而开启复制进程时也有atcsn（大于或等于该scn的事务将被apply），aftercsn（大于该scn的事务将被app...
goldengate supports sync data from no-partition table to partition table(OGG同步非分区表到分区表)
2013/01/07 Goldengate 311 views goldengate supports sync data from no-partition table to partition table(OGG同步非分区表到分区表)已...
GoldenGate Replicat 进程延迟问题处理案例
概要 Oracle GoldenGate软件是一种基于日志的结构化数据复制软件，它通过解析源数据库在线日志或归档日志获得数据的增量变化，再将这些变化应用到目标数据库，从而实现源数据库与目标数据库同步。但在OGG日常维护的过程中有经常遇到OG...
gc cr request等待事件
Fixed Table STATS Issue after Gathering Fixed Object STATS
Fixed Table STATS Issue after Gathering Fixed Object STATS Posted on March 15, 2015 by Weidong Zhou 3 Recently we were w...
Find a session which are generating more archive logs
To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount o...