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...
技术文章列表
512 篇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...
Extended Statistics (Oracle Optimizer)
« Oracle OpenWorld… | Main | How do I know what… » Extended Statistics By Maria Colgan-Oracle on Mar 17, 201...
EXPDP_IMPDP 中的并行度PARALLEL参数
如果设置 EXPDP parallel=4 必须要设置4个EXPDP文件，不然PARALLEL是有问题的，同时EXPDP会使用一个WORKER进程导出METADATA，其他WORKER进程会同时出数据，如果EXPDP作业很于250M 只会启...
EXPDP_IMPDP running slow on 11g or above _ STREAMS AQ: ENQUEUE BLOCKED ON LOW MEMORY” WHEN REDUCING STREAMS_POOL_SIZE
SYMPTOMS The import with DataPump of tables into an Oracle11g Release 11.2.0.4 database takes almost 45 minutes, while t...
EXP-00003: no storage definition found for segment(0, 0)解决办法 – zhasir的专栏 – 博客频道 – CSDN.NET
Oracle11gR2中空表是不会分配segment的。当含有空表，使用exp导出整个用户的时候报EXP-00003: no storage definition found for segment(0, 0)错误。 解决办法： 方法一：如...
Execution failed: Can’t locate Env.pm in @INC (Perl script (roothas.pl)) – Mohammad Nazmul Huda
评论 | [root@testdb1 ~]# /opt/grid/product/11.2.0.3/crs/install/roothas.pl -deconfig Can't locate Env.pm in @INC (@IN...
Error ORA-31655 On DataPump Import (IMPDP) With Privileged
Applies to: Oracle Database – Enterprise Edition – Version 10.2.0.5 to 11.2.0.3 [Release 10.2 to 11.2] Infor...