Skip to Main Content

ACE

ACE Pro ACE Pro

Top Level Details

Job Role Principle Database Engineer
Company YNAP
Country United Kingdom
Top Expertise Database
Focus Area Cloud

About Mark

Mark is an IT practitioner with 36 years experience and has been working with database technologies for last 30 years; 24 of those with the Oracle RDBMS. He has worked for a number of FTSE-100 companies in various sectors such as Food Retail, Fashion Retail, Pharmaceuticals, Banking and Health Care. Currently based in London working for a fashion retailer he is known in the Oracle community for his contributions to various forums and his work on Oracle RDBMS, Cloud and Performance Tuning, examples of which can be found published on his Wiki. Recent projects include working on a major digital transformation project for a high end global fashion retailer. Markโ€™s main areas of expertise include Database/System Design Database performance tuning, Grid Control implementations and Oracle Licensing.

Expertises Database Cloud Performance Management Database Development Database Administrator (DBA) Real Applications Clusters (RAC) Architecture
Links Linkedin      Blog  

Latest Contributions

  • #SELECTION#
    #ICON_HTML#

    Oracle Hint - QB_NAME

    May 08, 2025 - Blog post -
    Database 23ai
    Database Performance Management
    Database Development
    Structured Query Language (SQL)
    Database Administrator (DBA)
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Oracle Hint - CURSOR_SHARING_EXACT

    May 08, 2025 - Blog post -
    Database 23ai
    Database Performance Management
    Database Development
    Structured Query Language (SQL)
    Database Administrator (DBA)
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Oracle Hint - DRIVING_SITE

    May 08, 2025 - Blog post -
    Database 23ai
    Database Performance Management
    Database Development
    Structured Query Language (SQL)
    Database Administrator (DBA)
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Oracle Hint - PUSH_SUBQ and NO_PUSH_SUBQ

    May 07, 2025 - Blog post -
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Oracle Hint - PUSH_PRED and NO_PUSH_PRED

    May 07, 2025 - Blog post -
    Structured Query Language (SQL)
    Database Performance Management
    Database Development
    Database 23ai
    Database Administrator (DBA)
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Oracle Hints - CACHE and NOCACHE

    Apr 30, 2025 - Blog post -
    Database 23ai
    Database Performance Management
    Database Development
    Structured Query Language (SQL)
    Database Administrator (DBA)
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#
    Database 23ai
    Database Administrator (DBA)
    Performance Management
    Structured Query Language (SQL)
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Oracle Hints - UNNEST and NO_UNNEST

    Apr 04, 2025 - Blog post -
    Oracle Database (EE)
    Structured Query Language (SQL)
    Database Performance Management
    Database 23ai
    Database Administrator (DBA)
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    MERGE and NO_MERGE Hint

    Feb 16, 2025 - Blog post -
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    REWRITE and NO_REWRITE Hint

    Feb 16, 2025 - Blog post -
    Database 23ai
    Database Performance Management
    Application Development
    Structured Query Language (SQL)
    Database Administrator (DBA)
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    USE_CONCAT Hint

    Feb 10, 2025 - Blog post -
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Oracle Hint - PQ_DISTRIBUTE

    Jan 10, 2025 - Blog post -
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Hash-Joins - The what, why and when

    Nov 29, 2024 - Blog post -
    Database 23ai
    Optimizer
    Database Performance Management
    Database Administrator (DBA)
    #ACTIONS#