Skip to Main Content
ACE Program
ACE Directory
Become an ACE
ACE Sign In
ACE
Full Name
Piotr Sajda
Full Name
ACE Associate
Top Level Details
Job Role
Performance Tuning Expert / Senior Oracle DBA
Company
Deutsche Bank
Country
Poland
Top Expertise
Optimization
Focus Area
Database
About Piotr
25+ years Oracle related experience Core : Oracle Performance Tuning - very advanced in (SQL) optimization of Enterprise environments with focus on (Exadata) Oracle databases Others areas: DB Administration: senior level of database administration with Oracle RAC, Exadata, Data Guard, ASM, Golden Gate, SAN technologies, RMAN backup and recovery Architecture: logical and physical schema design, design implementation and testing of high availability (HA) and DR solutions in Enterprise based on Oracle Real Application Clusters (RAC), Exadata, Data Guard, ASM, Golden Gate, SAN technologies Migration/Replication: planning and implementing of database migrations with very short/no downtime Integration: thorough understanding of complete data flow beginning from the (front end) application serversβ layer, Eth. network layer, (back end) databases, operating systems, down to high-end storage layer Leading technical seminars and trainings, speaker on technical and business conferences Sectors: banking, telecommunication, public, airline/travel, industrial Languages: English (fluent), German (fluent), Polish (native) Interests: windsurfing, skiing, low level performance (SQL) tuning of Oracle databases
Expertises
Optimization
Performance
Exadata
Real Applications Clusters (RAC)
Active Data Guard (ADG)
Backup and Recovery
Links
Latest Contributions
#SELECTION#
#ICON_HTML#
Converting of CPU Costing in the Cost Based Optimizer 10053 Trace File
Mar 23, 2025 - Blog post -
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
Why this extra physical read while performing index scan?
Mar 15, 2025 - Blog post -
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
Clustering Factor - true price of high CLUF on elapsed time, SGA and CPU (part4)
Mar 02, 2025 - Blog post -
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
Clustering Factor β tests with 10046 (part3)
Mar 02, 2025 - Blog post -
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
Clustering Factor - theory (part1)
Mar 02, 2025 - Blog post -
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
Clustering Factor β tests with block dumps (part2)
Mar 02, 2025 - Blog post -
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
Cartesian Join β the usual suspect (part2) - Analysis of joins with 10053 CBO trace
Feb 05, 2025 - Blog post -
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
Resp in the CBO 10053 Trace File
Feb 03, 2025 - Blog post -
Performance
#ACTIONS#
1 - 8