Skip to Main Content
ACE Program
ACE Directory
Become an ACE
ACE Sign In
ACE
Full Name
Prashant Dixit
Full Name
ACE Pro
Top Level Details
Job Role
Database Solution Architect
Company
RENAPS
Country
Canada
Top Expertise
Performance Management
Focus Area
Database
About Prashant
A seasoned Database Architect and Senior DBA with over 18 years of hands-on experience, specializing in database performance tuning, advanced troubleshooting, system stabilization, high availability, data replication, and large-scale migrations and upgrades across complex enterprise environments. His expertise spans both traditional and modern platforms, including Engineered Systems (Exadata), Oracle Cloud Infrastructure (OCI), and hybrid on-prem/cloud architectures. He brings a strong analytical mindset combined with practical execution skills, enabling him to design, implement, and operate resilient, scalable, and high-performing database platforms. His core strength lies in Oracle Database technologies, with deep experience in Oracle GoldenGate, Oracle Maximum Availability Architecture (MAA), RAC, Data Guard, Exadata, Oracle Sharding, Oracle NoSQL DBs, and mission-critical workloads such as Oracle E-Business Suite and other COTS and custom applications. Beyond Oracle, he has extensive hands-on experience with MySQL, PostgreSQL, MongoDB, Redis, CockroachDB, and Apache/DataStax Cassandra, supporting transactional, NoSQL, and distributed data platforms. He has helped clients migrate and modernize data workloads from these technologies to Oracle platforms, including Oracle Database/cloud and Oracle NoSQL, using a combination of replication technologies such as Oracle GoldenGate, ETL frameworks, and custom automation and scripting. His approach ensures minimal downtime, data consistency, and performance stability while enabling organizations to adopt Oracle-native solutions with confidence. As a senior technical leader, he guides customers through the entire database lifecycle from architecture and provisioning to deployment, optimization, and long term operations across on-premises, cloud-native, and hybrid environments. He works closely with infrastructure, application, and security teams to ensure end-to-end reliability and performance. Widely regarded as a go-to expert for resolving complex and high impact database issues, he is frequently engaged to troubleshoot obscure performance problems, stabilize critical systems, and support recovery efforts under pressure. In addition to operational excellence, he has a strong foundation in data architecture, data warehousing, and data profiling, making him a trusted advisor for delivering data driven solutions aligned with long-term business and modernization goals.
Expertises
Performance Management
Upgrade / Migration
GoldenGate
Exadata
WebLogic Server
Database Performance Management
MySQL Database
Oracle GoldenGate Service
Extract, Transform and Load (ETL)
Oracle NoSQL DB
Home Page
https://fatdba.com/
Cloud Customer Connect
https://community.oracle.com/hub/profile/discussions/FatDBA
Links
Latest Contributions
#SELECTION#
#ICON_HTML#
When GoldenGate decides to throw OGG-02912 just before New Years Eve.
Dec 31, 2025 - Blog post -
Oracle GoldenGate Service
Oracle Database (EE)
GoldenGate
#ACTIONS#
#SELECTION#
#ICON_HTML#
When Linux Swaps Away My Sleep – MySQL, RHEL8, and the Curious Case of High Swap Usage
Dec 12, 2025 - Blog post -
MySQL
Database Performance Management
Performance Management
Linux
Oracle Linux
#ACTIONS#
#SELECTION#
#ICON_HTML#
How Oracle 23ai Fixes Bad Plans Instantly.. A Live Demo of Real-Time SPM
Nov 23, 2025 - Blog post -
Database 23ai
High-Frequency Automatic SPM Evolve Advisor Task
Database Performance Management
Optimization
#ACTIONS#
#SELECTION#
#ICON_HTML#
From Painful Manual LOB Shrink to Automatic SecureFiles Shrink
Nov 15, 2025 - Blog post -
Database 23ai
Large Objects (LOBs)
#ACTIONS#
#SELECTION#
#ICON_HTML#
A New ACE Chapter…Oracle ACE Apprentice.. and I wasn’t even in Vegas
Oct 18, 2025 - Blog post -
Community
#ACTIONS#
#SELECTION#
#ICON_HTML#
DBMS_ILM HTML Dashboard Script .. The Missing Monitor for Oracle Archiving
Sep 15, 2025 - Blog post -
Advanced Compression
Data Warehouse
Heat Map
#ACTIONS#
#SELECTION#
#ICON_HTML#
Stop Writing Purge Scripts. DBMS_ILM Is the Hidden Hero You Ignored
Sep 14, 2025 - Blog post -
Advanced Compression
Archive Storage
Warehouse Management
Heat Map
#ACTIONS#
#SELECTION#
#ICON_HTML#
MySQL OPTIMIZE TABLE – Disk Space Reclaim Defragmentation and Common Myths
Aug 08, 2025 - Blog post -
MySQL
MySQL EE
MySQL Database
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle AWR Scripts Decoded .. No More Guessing!
Jul 29, 2025 - Blog post -
Automatic Workload Repository (AWR)
Diagnostics & Tuning Pack
Performance Management
#ACTIONS#
#SELECTION#
#ICON_HTML#
fatdba explores Vector Search in Oracle 23ai
Jul 23, 2025 - Blog post -
Database 23ai
Database Performance Management
AI Vector Search
#ACTIONS#
#SELECTION#
#ICON_HTML#
Diagnosing a MySQL database performance Issue Using MySQLTuner
Jul 20, 2025 - Blog post -
MySQL Database
MySQL EE
#ACTIONS#
#SELECTION#
#ICON_HTML#
Demo on how to use Oracle XStream Replication Setup Using Java Client
Jun 15, 2025 - Blog post -
XStreams
Oracle GoldenGate Service
#ACTIONS#
#SELECTION#
#ICON_HTML#
oracle-support-new-ai-powered-search
Apr 08, 2025 - Blog post -
Partner Portal
#ACTIONS#
#SELECTION#
#ICON_HTML#
All new Oracle 23ai new views for enhanced Data Pump troubleshooting
Apr 02, 2025 - Blog post -
Database 23ai
Oracle Data Pump
#ACTIONS#
#SELECTION#
#ICON_HTML#
Leveraging SQLT to transfer execution plans between SQL IDs using coe_load_sql_profile.sql
Mar 11, 2025 - Blog post -
Database Performance Management
Database Tools
Oracle SQL
#ACTIONS#
1 - 15
Next