Skip to Main Content
ACE Program
ACE Directory
Become an ACE
ACE Sign In
ACE
Full Name
Mark Ramsay
Full Name
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
Home Page
http://www.oracle-wiki.net
Oracle Community
https://community.oracle.com/tech/developers/profile/Mark%20Ramsay
Links
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#
Oracle Hints - APPEND, APPEND_VALUES and NOAPPEND
Apr 22, 2025 - Blog post -
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#
STAR_TRANSFORMATION and NO_STAR_TRANSFORMATION Hint
Feb 16, 2025 - Blog post -
#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#
1 - 12