.prm
(1)
19c
(1)
ACID
(1)
ADG
(2)
AMM
(1)
ASM
(1)
ASMM
(1)
Background Process
(2)
Can not use asmca
(1)
Classic Extract
(1)
Configuration Management
(1)
DBA
(3)
DBT-00007
(1)
DBWn
(1)
DRY Principle
(1)
Data Replication
(1)
Database
(3)
Database Architecture
(1)
Database Backup
(1)
Database Recovery
(1)
Database deployment
(9)
Database maintenance
(9)
Database optimization
(9)
Disaster Recovery
(2)
ERP outage
(1)
Error 12609
(1)
Error 16063
(1)
Extended Data Types
(1)
Extract
(1)
Full Table Scan
(1)
GGSCI
(1)
GoldenGate
(2)
High Waits
(3)
Index
(1)
Index Skip Scan
(1)
Instance
(1)
Integrated Extract
(1)
JDBC Driver
(1)
LGWR
(1)
Library Cache Lock
(1)
Logical Replication
(2)
MAA
(1)
MAX_STRING_SIZE
(1)
Modular Configuration
(1)
OBEY File
(1)
ODA Power Supply
(1)
OGG
(3)
OGG Best Practices
(1)
ORA-00257
(1)
ORA-00600
(1)
ORA-03137
(1)
ORA-04030
(1)
ORA-04031
(1)
ORA-12609
(1)
ORA-15041
(1)
Oracle
(6)
Oracle Architecture
(2)
Oracle Concepts
(1)
Oracle GoldenGate
(1)
Out Of Process Memory
(1)
PGA
(1)
PGA Memory Operation
(1)
PMON
(1)
PRVF-7595
(1)
PRVG-2043
(1)
Parameter File
(1)
Performance Tuning
(2)
Physical Replication
(2)
RAC
(1)
RMAN
(1)
RPO
(1)
RTO
(1)
Replicat
(1)
Reusability
(1)
Rollback Plan Design
(1)
SCAN Fail
(1)
SGA
(2)
SMON
(1)
SQL
(1)
SYSTEM.LOGMNR_LOG$
(1)
Specification
(1)
TNS-12516
(1)
V$PROCESS
(1)
V$SYSTEM_EVENT
(1)
Wait Event
(2)
X7-2L
(1)
X8-2L
(1)
abend
(1)
active-active
(1)
archive log full
(1)
archivelog
(1)
asmca failed to access oracle
(1)
awr
(1)
backup strategy
(1)
batchsql
(2)
best practice
(1)
best practices
(1)
best-practices
(1)
big data
(1)
breakpoint resume
(1)
business continuity
(1)
capacity planning
(1)
cdb
(1)
cdc
(1)
checkpoint
(1)
cpe
(1)
cpr
(1)
cpt
(1)
critical system
(1)
data conflict
(1)
data consistency
(2)
data guard
(1)
data integration
(1)
data migration
(1)
data replication
(3)
data synchronization
(1)
database HA
(1)
database configuration
(1)
database hung
(1)
database monitoring
(1)
database upgrade
(1)
datapump
(1)
dba
(4)
dbms_xplan
(1)
diagnostics
(1)
dirprm
(1)
disaster recovery
(1)
discard
(1)
encryption
(1)
endianness
(1)
error 12752
(1)
error handling
(1)
error_value=00000000
(1)
execution plan
(1)
explain plan
(1)
force logging
(1)
go
(1)
goldengate
(4)
grouptransops
(1)
handlecollisions
(1)
handler
(1)
high availability
(1)
hung on an I/O
(1)
incident response
(1)
interactive debug
(1)
json
(1)
kafka
(1)
kclantilock_17
(1)
lag
(1)
latency
(1)
library cache load lock
(1)
logdump
(1)
masterkey
(1)
mismtch for password
(1)
monitoring
(2)
multitenant
(1)
ogg
(9)
open-source
(2)
oracle
(32)
oracle 10g
(1)
oracle 11g
(1)
oracle 12c
(1)
oracle 19c
(1)
oracle goldengate
(1)
pdb
(1)
performance
(2)
performance tuning
(3)
power supply fails
(1)
process hung
(1)
rac
(3)
real-time data
(1)
reperror
(2)
replicat
(4)
security
(1)
showsyntax
(1)
sql debugging
(1)
sql optimization
(1)
sql tuning
(1)
ssl
(1)
stats
(1)
supplemental logging
(1)
terminating the instance
(1)
tkprof
(1)
tls
(1)
trail file
(1)
uppercase hostname
(1)
v$pga_target_advice
(1)
v$sga_target_advice
(1)
v$sql
(1)
wallet
(1)
zero-downtime
(1)
# .prm
# 19c
# ACID
# ADG
# AMM
# ASM
# ASMM
# Background Process
# Can not use asmca
- Sep 2, 2025 ORACLE ASMCA Command Failed To Access On AIX 7.2
# Classic Extract
# Configuration Management
# DBA
- Sep 1, 2025 An In-Depth Guide to Oracle Background Processes: The Roles and Synergy of DBWn, LGWR, SMON, and PMON
- Aug 28, 2025 Demystifying Oracle Memory Management: A Practical Guide to Optimizing SGA and PGA
- Aug 26, 2025 A Deep Dive into Oracle Database Architecture: The Secrets of Instance and Database Interaction
# DBT-00007
# DBWn
# DRY Principle
# Data Replication
# Database
- Aug 26, 2025 A Deep Dive into Oracle Database Architecture: The Secrets of Instance and Database Interaction
- Jul 2, 2025 Oracle Performance Core: A Deep Dive into the Four Major Data Access Paths
- Jun 26, 2025 Breaking the 4000-Byte Shackles! Oracle MAX_STRING_SIZE=EXTENDED Ultimate Guide: Theory, Scenarios & 19c Hands-On
# Database Architecture
# Database Backup
- Jul 21, 2025 ORACLE Database Backup and Recovery (Multi-Scenario)
# Database Recovery
- Jul 21, 2025 ORACLE Database Backup and Recovery (Multi-Scenario)
# Database deployment
- Jul 14, 2025 Best Practices and Recommendations for RAC databases with SGA size over 100GB
- Jul 9, 2025 Gathering Other Types of Statistics
- Jul 8, 2025 When Not to Gather Statistics
- Jul 4, 2025 Gathering Statistics More Quickly
- Jul 3, 2025 Assuring the Quality of Optimizer Statistics
- Jun 23, 2025 When to Gather Statistics
- Jun 16, 2025 Best Practices - How to Gather Statistics with Oracle Database
- Jun 6, 2025 Introduction and Recommendation of ORACLE Database Indexes
- May 27, 2025 ORACLE 19C Database Architecture and Operation and Maintenance Guide
# Database maintenance
- Jul 14, 2025 Best Practices and Recommendations for RAC databases with SGA size over 100GB
- Jul 9, 2025 Gathering Other Types of Statistics
- Jul 8, 2025 When Not to Gather Statistics
- Jul 4, 2025 Gathering Statistics More Quickly
- Jul 3, 2025 Assuring the Quality of Optimizer Statistics
- Jun 23, 2025 When to Gather Statistics
- Jun 16, 2025 Best Practices - How to Gather Statistics with Oracle Database
- Jun 6, 2025 Introduction and Recommendation of ORACLE Database Indexes
- May 27, 2025 ORACLE 19C Database Architecture and Operation and Maintenance Guide
# Database optimization
- Jul 14, 2025 Best Practices and Recommendations for RAC databases with SGA size over 100GB
- Jul 9, 2025 Gathering Other Types of Statistics
- Jul 8, 2025 When Not to Gather Statistics
- Jul 4, 2025 Gathering Statistics More Quickly
- Jul 3, 2025 Assuring the Quality of Optimizer Statistics
- Jun 23, 2025 When to Gather Statistics
- Jun 16, 2025 Best Practices - How to Gather Statistics with Oracle Database
- Jun 6, 2025 Introduction and Recommendation of ORACLE Database Indexes
- May 27, 2025 ORACLE 19C Database Architecture and Operation and Maintenance Guide
# Disaster Recovery
# ERP outage
# Error 12609
- Jul 31, 2025 ADG Standby Database Hung I/O
# Error 16063
- Aug 25, 2025 Alert Log of the Primary Database Shows Error 16063
# Extended Data Types
# Extract
# Full Table Scan
# GGSCI
# GoldenGate
# High Waits
# Index
# Index Skip Scan
# Instance
# Integrated Extract
# JDBC Driver
- Aug 6, 2025 JDBC Connections Using SCAN Fail With ORA-12516
# LGWR
# Library Cache Lock
# Logical Replication
# MAA
- May 23, 2024 Oracle High Availability: More Than Just Buzzwords
# MAX_STRING_SIZE
# Modular Configuration
# OBEY File
# ODA Power Supply
# OGG
- Aug 21, 2025 Mastering Oracle GoldenGate OBEY Files: Building Modular and Maintainable Data Synchronization Configurations
- Jul 16, 2025 Discussion on Application Architecture Technologies for ADG, OGG, and Data Warehouse Systems at Bank
- Jul 7, 2025 Classic vs. Integrated Extract: A Deep Dive into Oracle GoldenGate
# OGG Best Practices
# ORA-00257
# ORA-00600
# ORA-03137
- Aug 6, 2025 JDBC Connections Using SCAN Fail With ORA-12516
# ORA-04030
# ORA-04031
# ORA-12609
- Jul 31, 2025 ADG Standby Database Hung I/O
# ORA-15041
# Oracle
- Sep 1, 2025 An In-Depth Guide to Oracle Background Processes: The Roles and Synergy of DBWn, LGWR, SMON, and PMON
- Aug 28, 2025 Demystifying Oracle Memory Management: A Practical Guide to Optimizing SGA and PGA
- Aug 26, 2025 A Deep Dive into Oracle Database Architecture: The Secrets of Instance and Database Interaction
- Jul 7, 2025 Classic vs. Integrated Extract: A Deep Dive into Oracle GoldenGate
- Jul 2, 2025 Oracle Performance Core: A Deep Dive into the Four Major Data Access Paths
- Jun 26, 2025 Breaking the 4000-Byte Shackles! Oracle MAX_STRING_SIZE=EXTENDED Ultimate Guide: Theory, Scenarios & 19c Hands-On
# Oracle Architecture
# Oracle Concepts
# Oracle GoldenGate
# Out Of Process Memory
# PGA
# PGA Memory Operation
# PMON
# PRVF-7595
# PRVG-2043
# Parameter File
# Performance Tuning
# Physical Replication
# RAC
# RMAN
# RPO
- May 23, 2024 Oracle High Availability: More Than Just Buzzwords
# RTO
- May 23, 2024 Oracle High Availability: More Than Just Buzzwords
# Replicat
# Reusability
# Rollback Plan Design
# SCAN Fail
- Aug 6, 2025 JDBC Connections Using SCAN Fail With ORA-12516
# SGA
# SMON
# SYSTEM.LOGMNR_LOG$
# Specification
# TNS-12516
- Aug 6, 2025 JDBC Connections Using SCAN Fail With ORA-12516
# V$PROCESS
# V$SYSTEM_EVENT
# Wait Event
- Jul 31, 2025 ADG Standby Database Hung I/O
- Jul 29, 2025 PGA Memory Operation Wait Event Caused by Different Table Data Volumes
# X7-2L
# X8-2L
# abend
# active-active
- May 23, 2024 Oracle High Availability: More Than Just Buzzwords
# archive log full
# archivelog
# asmca failed to access oracle
- Sep 2, 2025 ORACLE ASMCA Command Failed To Access On AIX 7.2
# awr
# backup strategy
# batchsql
# best practice
# best practices
# best-practices
# big data
# breakpoint resume
# business continuity
- May 23, 2024 Oracle High Availability: More Than Just Buzzwords
# capacity planning
# cdb
# cdc
# checkpoint
# cpe
# cpr
# cpt
# critical system
# data conflict
# data consistency
# data guard
- May 23, 2024 Oracle High Availability: More Than Just Buzzwords
# data integration
# data migration
# data replication
# data synchronization
# database HA
- May 23, 2024 Oracle High Availability: More Than Just Buzzwords
# database configuration
# database hung
# database monitoring
# database upgrade
# datapump
# dba
- Aug 18, 2025 Oracle SQL Execution Plans: A Deep Dive from Estimation to Real-World Application
- Jul 21, 2025 Don’t Underestimate Data Pump: More Than a Mover, It’s the Key to OGG Architecture Optimization
- Jul 17, 2025 ggutil: Modernizing Oracle GoldenGate Management with Go
- Jun 19, 2025 The Ultimate Oracle Inspection Tool: Say Goodbye to Tedium and Hello to Efficiency with Inspect4Oracle!
# dbms_xplan
# diagnostics
# dirprm
# disaster recovery
- May 23, 2024 Oracle High Availability: More Than Just Buzzwords
# discard
# encryption
# endianness
# error 12752
# error handling
# error_value=00000000
- Sep 2, 2025 ORACLE ASMCA Command Failed To Access On AIX 7.2
# execution plan
# explain plan
# force logging
# go
# goldengate
- Jul 21, 2025 Don’t Underestimate Data Pump: More Than a Mover, It’s the Key to OGG Architecture Optimization
- Jul 17, 2025 ggutil: Modernizing Oracle GoldenGate Management with Go
- Jun 5, 2025 Essential Oracle GoldenGate Configurations Across Different Oracle Database Versions
- May 21, 2025 Introduction to Oracle GoldenGate: Real-Time Data Replication Solution
# grouptransops
# handlecollisions
# handler
# high availability
# hung on an I/O
- Jul 31, 2025 ADG Standby Database Hung I/O
# incident response
# interactive debug
# json
# kafka
# kclantilock_17
# lag
# latency
# library cache load lock
# logdump
# masterkey
# mismtch for password
# monitoring
# multitenant
# ogg
- Aug 14, 2025 Deep Dive into OGG `SHOWSYNTAX`: The Ultimate Guide from SQL Generation to Problem Solving
- Aug 11, 2025 Demystifying OGG `HANDLECOLLISIONS`: A Deep Dive from Firefighting to Data Consistency
- Aug 7, 2025 The Heartbeat of Replication: A Deep Dive into Oracle GoldenGate Latency Monitoring and Performance Diagnostics
- Aug 5, 2025 Hardening Your Data Pipeline: The Ultimate Guide to Oracle GoldenGate Security Practices
- Jul 31, 2025 Streaming Oracle CDC to Kafka with OGG for Big Data: A Configuration Guide
- Jul 28, 2025 Don't Let Replicat Abend Easily: Achieving Fine-Grained Error Handling with REPERROR
- Jul 24, 2025 Demystifying OGG BATCHSQL: The Underlying Logic from SQL Array Execution to Performance Tuning
- Jul 14, 2025 Demystifying the OGG Checkpoint Mechanism: From CPE/CPR/CPT Files to Breakpoint Resume Principles
- Jul 10, 2025 Demystifying the OGG Trail File: From Binary Structure and Version Compatibility to Cross-Platform Migration Pitfalls
# open-source
# oracle
- Sep 2, 2025 ORACLE ASMCA Command Failed To Access On AIX 7.2
- Aug 29, 2025 ORACLE 12c and 19c Coexistence System, DBCA Reports Error
- Aug 26, 2025 ADG SWITCHOVER Switching to New Standby Reports Password File Mismatch
- Aug 25, 2025 Alert Log of the Primary Database Shows Error 16063
- Aug 18, 2025 Oracle SQL Execution Plans: A Deep Dive from Estimation to Real-World Application
- Aug 15, 2025 How to Replace an Oracle Server X7-2L or X8-2L Power Supply
- Aug 12, 2025 Oracle Production Environment Database Change Specification
- Aug 8, 2025 ORA-00600 Error Causing Database Instance Restart
- Aug 6, 2025 JDBC Connections Using SCAN Fail With ORA-12516
-
Aug 4, 2025
ORA-04030: Out Of Process Memory When Trying To Allocate
Bytes (kxs-heap-w,krvxlogact) When Using Oracle GoldenGate - Jul 31, 2025 ADG Standby Database Hung I/O
- Jul 29, 2025 PGA Memory Operation Wait Event Caused by Different Table Data Volumes
- Jul 24, 2025 How to change the host name from uppercase to lowercase in RAC environment
- Jul 22, 2025 High Library Cache Lock Waits During Concurrent Heavy Mixed PMOPs and DML on Several Partitioned Tables
- Jul 21, 2025 ORACLE Database Backup and Recovery (Multi-Scenario)
- Jul 21, 2025 Don’t Underestimate Data Pump: More Than a Mover, It’s the Key to OGG Architecture Optimization
- Jul 17, 2025 ggutil: Modernizing Oracle GoldenGate Management with Go
- Jul 16, 2025 Discussion on Application Architecture Technologies for ADG, OGG, and Data Warehouse Systems at Bank
- Jul 14, 2025 Best Practices and Recommendations for RAC databases with SGA size over 100GB
- Jul 9, 2025 Gathering Other Types of Statistics
- Jul 8, 2025 When Not to Gather Statistics
- Jul 4, 2025 Gathering Statistics More Quickly
- Jul 3, 2025 Assuring the Quality of Optimizer Statistics
- Jun 23, 2025 When to Gather Statistics
- Jun 19, 2025 The Ultimate Oracle Inspection Tool: Say Goodbye to Tedium and Hello to Efficiency with Inspect4Oracle!
- Jun 16, 2025 Best Practices - How to Gather Statistics with Oracle Database
- Jun 13, 2025 "Database Hung": A Case Study of a Critical ERP Outage Caused by Full Archive Logs
- Jun 6, 2025 Introduction and Recommendation of ORACLE Database Indexes
- Jun 5, 2025 Essential Oracle GoldenGate Configurations Across Different Oracle Database Versions
- May 27, 2025 ORACLE 19C Database Architecture and Operation and Maintenance Guide
- May 21, 2025 Introduction to Oracle GoldenGate: Real-Time Data Replication Solution
- May 23, 2024 Oracle High Availability: More Than Just Buzzwords
# oracle 10g
# oracle 11g
# oracle 12c
# oracle 19c
# oracle goldengate
# pdb
# performance
# performance tuning
- Aug 18, 2025 Oracle SQL Execution Plans: A Deep Dive from Estimation to Real-World Application
- Aug 14, 2025 Deep Dive into OGG `SHOWSYNTAX`: The Ultimate Guide from SQL Generation to Problem Solving
- Jul 24, 2025 Demystifying OGG BATCHSQL: The Underlying Logic from SQL Array Execution to Performance Tuning
# power supply fails
# process hung
- Jul 31, 2025 ADG Standby Database Hung I/O
# rac
- Sep 2, 2025 ORACLE ASMCA Command Failed To Access On AIX 7.2
- Aug 29, 2025 ORACLE 12c and 19c Coexistence System, DBCA Reports Error
- May 23, 2024 Oracle High Availability: More Than Just Buzzwords
# real-time data
# reperror
# replicat
- Aug 14, 2025 Deep Dive into OGG `SHOWSYNTAX`: The Ultimate Guide from SQL Generation to Problem Solving
- Aug 11, 2025 Demystifying OGG `HANDLECOLLISIONS`: A Deep Dive from Firefighting to Data Consistency
- Jul 28, 2025 Don't Let Replicat Abend Easily: Achieving Fine-Grained Error Handling with REPERROR
- Jul 24, 2025 Demystifying OGG BATCHSQL: The Underlying Logic from SQL Array Execution to Performance Tuning