ACE Profile

Full Name

ACE Associate

Job Role Chief DBA

Company Aeon Life Insurance Company, Ltd

Country China, People's Republic of

Top Expertise Database 19c

Focus Area Database

About Peng

I’m a database expert, instructor and technical blogger. I have more than 18 years of IT experience, including 13 in Oracle Support and 10 in Oracle Software Development and specialized in Oracle Database Performance Tuning (SQL and DB Tuning) and in the development of Oracle DB IT architectures (highly available, low-maintenance, cost efficient storage of data). During my time at 18 years experience in database, including Oracle8i, 9i, 10g, 11g, 12C, 19C installation, backup, recovery, high availability (ADG RAC) and tuning. Mastering the knowledge of Oracle's architecture, including memory structure, physical storage, SQL Tuning and more.MySQL 5.6, 5.7, 8.0. Mastering the knowledge of the architecture of MySQL, including memory structure, physical storage, SQL Tuning and more. Familiar with using MySQL multisource replication, filtering replication.

Expertises Database 19c MySQL Database .NET Active Data Guard (ADG) SQL Tuning Advisor

Links

Latest Contributions

#SELECTION#

#ICON_HTML#

第58期 MySQL数据库生产级备份XtraBackup备份

Feb 04, 2026 - Blog post -

MySQL Database

#ACTIONS#
#SELECTION#

#ICON_HTML#

第57期如何排查Oracle数据库中某个sql的性能是否退化还是提升了

Jan 20, 2026 - Blog post -

SQL Performance

#ACTIONS#
#SELECTION#

#ICON_HTML#

第56期 Oracle索引的八种使用模式

Jan 16, 2026 - Blog post -

SQL Performance

Database 19c

#ACTIONS#
#SELECTION#

#ICON_HTML#

第55期 Oracle数据库查询有多个执行计划的sql

Jan 14, 2026 - Blog post -

Database 19c

SQL Performance

#ACTIONS#
#SELECTION#

#ICON_HTML#

第54期 NBU rman备份异机恢复

Jan 08, 2026 - Blog post -

RMAN Backup and Recovery

Database 19c

#ACTIONS#
#SELECTION#

#ICON_HTML#

第53期排查分析最近30天内SQL语句性能出现退化的SQL

Dec 17, 2025 - Blog post -

Database 19c

SQL Performance

#ACTIONS#
#SELECTION#

#ICON_HTML#

第52期 Oracle 19c 时区升级TSTZ 42 TO TSTZ 43

Nov 10, 2025 - Blog post -

Database 19c

#ACTIONS#
#SELECTION#

#ICON_HTML#

第51期 OGG执行Send Extract Showtrans在数据库中不存在 XIDs

Nov 06, 2025 - Blog post -

GoldenGate

Database 19c

#ACTIONS#
#SELECTION#

#ICON_HTML#

第50期 OGG在现有进程中新增一个同步表的流程

Oct 30, 2025 - Blog post -

GoldenGate

#ACTIONS#
#SELECTION#

#ICON_HTML#

第49期 OGG同步延时问题排除

Oct 29, 2025 - Blog post -

GoldenGate

#ACTIONS#
#SELECTION#

#ICON_HTML#

第48期 OGG 实现 MySQL 数据库数据实时迁移

Oct 28, 2025 - Blog post -

GoldenGate

#ACTIONS#
#SELECTION#

#ICON_HTML#

第47期 OGG DownStream 部署

Oct 09, 2025 - Blog post -

GoldenGate

#ACTIONS#
#SELECTION#

#ICON_HTML#

第46期 DataPump Export (EXPDP) Fails With Errors ORA-31693 ORA-31617 ORA-19505

Aug 13, 2025 - Blog post -

Database 19c

#ACTIONS#
#SELECTION#

#ICON_HTML#

第45期如何在GoldenGate下游配置中删除从源数据库接收到的源数据库上的归档

Jul 15, 2025 - Blog post -

GoldenGate

#ACTIONS#
#SELECTION#

#ICON_HTML#

第44期使用什么命令能删除 FOREIGN ARCHIVED LOG

Jul 14, 2025 - Blog post -

Database 19c

#ACTIONS#

1 - 15

ACE

Top Level Details

About Peng

Latest Contributions