Pages

▼
Monday, February 9, 2026

DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC procedure

›
- Info: Automatic optimizer statistics collection gathers optimizer statistics by  calling the DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC pr...

Oracle Autotask - auto space advisor

›
Info: The  auto space advisor Calculates stats regarding space usage. The  auto space advisor  Auto Task in Oracle can be very CPU and I/O i...
Wednesday, February 4, 2026

Using Golden Gate logdump utility, line by line and summary mode

›
Logdump 1 >ghdr on Logdump 2 >detail on Logdump 3 >detail data Logdump 4 >open ep000000003 Current LogTrail is /software/ogg/191...

Golden Gate issue in Oracle 19 - LOGICAL_REPLICATION

›
Issue In Oracle 19, a new field was added to USER_TABLES: logical_replication In addition to running ADD TRANDATA and having the table supp...
Tuesday, December 2, 2025

du vs df giving wrong disk usage results

›
du vs df giving wrong disk usage results In OS, oracle is reported as using 168 Gb While in oracle, the usage is only 78 Gb How can that be?...
Wednesday, November 5, 2025

ORA-39346: data loss in character set conversion for object COMMENT

›
Error in impdp Processing object type SCHEMA_EXPORT/TABLE/COMMENT ORA-39346: data loss in character set conversion for object COMMENT:"...
Tuesday, September 16, 2025

Purpose: Purge specific sql_id from Shared Pool.

›
Purpose: Purge specific sql_id from Shared Pool. It could be useful if a sql have too many child cursors, which can cause "library cac...
1 comment: