Skip to Main Content
ACE Program
ACE Directory
Become an ACE
ACE Sign In
ACE
Full Name
Arsalan Dehghanisariyarghan
Full Name
ACE Pro
Top Level Details
Job Role
Senior DBA
Company
Independent Consultant
Country
Turkey
Top Expertise
Database Performance Management
Focus Area
Database
About Arsalan
A highly accomplished Senior Oracle Database Administrator with 23 years of experience in the strategic optimization and management of complex, business-critical Oracle Database ecosystems, primarily on UNIX-based platforms, offers expertise that began with Oracle version 6 on SCO UNIX and progressed from an Oracle Developer role to a Managing DBA position. Core competencies include inclusive database systems direction, comprehensive database administration across the entire lifecycle (from logical and physical design to performance tuning and maintenance), directing complex database upgrades and migrations (including phased transitions from Oracle 11g to 12c, 18c, and 19c with near-zero downtime), and ensuring robustness and availability through high-availability architecture engineered with Oracle Data Guard and RAC. Proficient in performance optimization, automation via custom UNIX shell scripts, and providing expert consultation to development teams for SQL optimization, the administrator also leverages Oracle Enterprise Manager (OEM) for real-time monitoring, diagnostics, and performance analysis. Knowledge dissemination is demonstrated through the authorship and delivery of intensive technical training courses, complemented by professional affiliations, certifications, and recognition as a six-time Oracle Support Most Valued Contributor. - Professional Affiliations and Certifications: . Member of the Independent Oracle Users Group (IOUG). . Professional Member of the Oracle Quest Community. . ACM Senior Member. . Oracle My Oracle Support Community (MOSC) - Six-time recipient of the Oracle Support Most Valued Contributor award. . Oracle Certified Professional (OCP). . Oracle Real Application Clusters (RAC) Certified Expert (OCE). . Oracle Performance Tuning Certified Expert (OCE).
Expertises
Database Performance Management
Exadata
Oracle RAC
Oracle Data Guard
High Availability
Zero Data Loss Recovery Appliance (ZDLRA)
Backup and Recovery
Home Page
http://www.arsalandehghani.com
Oracle Community
https://community.oracle.com/mosc/profile/discussions/Arsalan%20Dehghanisariyarghan
Links
Latest Contributions
#SELECTION#
#ICON_HTML#
Can we send RMAN backups from a SPARC-based Oracle database to a Zero Data Loss Recovery Appliance (ZDLRA) while simultaneously using Real-Time Redo transport to that ZDLRA?
Sep 09, 2025 - Blog post -
Zero Data Loss Recovery Appliance (ZDLRA)
SPARC Servers
Backup and Recovery
Cybersecurity
#ACTIONS#
#SELECTION#
#ICON_HTML#
Automatic Materialized Views (AMV) in Oracle Database 23ai
Aug 24, 2025 - Blog post -
Database 23ai
Oracle Database (EE)
Materialized Views
Materialized View Query Rewrite
#ACTIONS#
#SELECTION#
#ICON_HTML#
Anatomy of a Silent Write
Aug 15, 2025 - Blog post -
Oracle Database (EE)
Database Performance Management
SQL Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
The Evolution of Non-Volatile Memory in High-Performance Data Storage
Jul 25, 2025 - Blog post -
Exadata
RDMA Fabric
Storage
#ACTIONS#
#SELECTION#
#ICON_HTML#
Beyond Recovery: The Hidden Logic of Transaction Isolation in Oracle 23ai
Jul 20, 2025 - Blog post -
Database 23ai
Oracle Database (EE)
Automatic Transaction Rollback
#ACTIONS#
#SELECTION#
#ICON_HTML#
Redefining Recovery: A Deep Dive into the Oracle ZDLRA
Jul 14, 2025 - Blog post -
Zero Data Loss Recovery Appliance (ZDLRA)
Oracle Database (EE)
Backup and Recovery
Exadata
#ACTIONS#
#SELECTION#
#ICON_HTML#
Leveraging Oracle Database Smart Flash Cache for Optimal Performance
Jul 05, 2025 - Blog post -
Performance Management
Oracle Database (EE)
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle 19c Connecting to ASM Instance via SCAN
Jul 03, 2025 - Forum contributions -
Oracle Cloud Infrastructure (OCI)
Oracle Database (EE)
Oracle RAC
Automatic Storage Management (ASM)
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle Exadata Fault Isolation with Quarantine
May 29, 2025 - Blog post -
Exadata
Exadata Database Machine
Engineered Systems
#ACTIONS#
#SELECTION#
#ICON_HTML#
which type of auditing is better to audit the application user in oracle 19c non cdb
May 25, 2025 - Forum contributions -
Fine-Grained Auditing
Database Security
#ACTIONS#
#SELECTION#
#ICON_HTML#
ORA-02041 - no transaction- Error in Oracle Distributed Transactions
May 09, 2025 - Blog post -
Database 23ai
Distributed Database / Sharding
#ACTIONS#
#SELECTION#
#ICON_HTML#
Incomplete execution plan?
May 09, 2025 - Forum contributions -
Oracle Database (EE)
Performance Management
#ACTIONS#
#SELECTION#
#ICON_HTML#
Updating DB_FILES parameter for Primary and Standyby Databases
May 08, 2025 - Forum contributions -
Database
#ACTIONS#
#SELECTION#
#ICON_HTML#
How to Patch Oracle Database Using Out-Of-Place Switch Home ,standalone server ASM
May 08, 2025 - Forum contributions -
Installation / Patching
Oracle Grid Infrastructure Patching
#ACTIONS#
#SELECTION#
#ICON_HTML#
Using Restore backup validate or recover backup validate header for Ransomware detection
May 08, 2025 - Forum contributions -
Backup and Recovery
Database
#ACTIONS#
1 - 15
Next