Pages

▼
Sunday, December 26, 2021

Tuning Golden Extract Memory

›
=============== General =============== Golden Gate Extract was running slow, lag increasing, until it was  several days GGSCI (geqaa-1-aps-...
Wednesday, December 22, 2021

Gather Stats Task

›
================================= What Is The Default Gather Stats Task? ================================= Out of the box, Oracle comes wi...
Sunday, December 12, 2021

When working with FETCH cursor BULK COLLECT INTO, where to put the EXIT WHEN cursor%NOTFOUND; ?

›
============== General ============== When working with  FETCH cursor BULK COLLECT INTO, where to put the   EXIT WHEN cursor%NOTFOUND; ? For...
Monday, December 6, 2021

Drop Obsolete Tablespaces and Datafiles

›
=================== General =================== Drop Obsolete Tablespaces and Datafiles In case table is partitioned, and a TBS is assigned ...
Tuesday, November 30, 2021

ORA-23404: refresh group "MY_USER"."MY_TABLE" does not exist

›
============= General ============= Error when running the scheduled refresh for a snapshot BEGIN  DBMS_REFRESH.refresh('"MY_USER...
Sunday, November 28, 2021

Golden gate DATAPUMP is not working

›
  =================== General =================== Golden Gate DATAPUMP is not working In the status, DATAPUMP is RUNNING But no data is gett...

Golden Gate REPLICAT is not working

›
=================== General =================== Golden Gate REPLICAT is not working In the status, REPLICATE is RUNNING But no data is getti...