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
<p>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.</p>
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#
List Installed RDBMS Components
Mar 26, 2026 - Blog post -
Database Administrator (DBA)
Structured Query Language (SQL)
Oracle Database (EE)
#ACTIONS#
#SELECTION#
#ICON_HTML#
List All Database Parameters
Mar 26, 2026 - Blog post -
Database Administrator (DBA)
Database 23ai
Structured Query Language (SQL)
Database 19c
Oracle Database (EE)
#ACTIONS#
#SELECTION#
#ICON_HTML#
Find the Cause of Invalid Objects
Mar 26, 2026 - Blog post -
Database Administrator (DBA)
Structured Query Language (SQL)
Oracle Database (EE)
#ACTIONS#
#SELECTION#
#ICON_HTML#
Check to see if a Data Pump Job is Hung
Mar 26, 2026 - Blog post -
Database Administrator (DBA)
Database 23ai
Structured Query Language (SQL)
Database 19c
Oracle Database (EE)
#ACTIONS#
#SELECTION#
#ICON_HTML#
Useful Date Manipulation SQL
Mar 26, 2026 - Blog post -
Database Administrator (DBA)
Structured Query Language (SQL)
Oracle Database (EE)
#ACTIONS#
#SELECTION#
#ICON_HTML#
List of PL/SQL Code Blocks that Contain a Specified Word
Mar 26, 2026 - Blog post -
Database Administrator (DBA)
Database 23ai
Structured Query Language (SQL)
Database 19c
Oracle Database (EE)
#ACTIONS#
#SELECTION#
#ICON_HTML#
List Service Info
Mar 26, 2026 - Blog post -
Database Administrator (DBA)
Database 23ai
Structured Query Language (SQL)
Database 19c
Oracle Database (EE)
#ACTIONS#
#SELECTION#
#ICON_HTML#
List All Hidden Database Parameters
Mar 26, 2026 - Blog post -
Database Administrator (DBA)
Database 23ai
Structured Query Language (SQL)
Database 19c
Oracle Database (EE)
#ACTIONS#
#SELECTION#
#ICON_HTML#
List of PL/SQL Code Blocks that Contain a Specified Word
Mar 26, 2026 - Blog post -
Database Administrator (DBA)
Database 23ai
Structured Query Language (SQL)
Database 19c
Oracle Database (EE)
#ACTIONS#
#SELECTION#
#ICON_HTML#
Read Information from the Alert Log via SQL
Mar 26, 2026 - Blog post -
Database Administrator (DBA)
Oracle Database (EE)
Database 26ai
Database 23ai
Structured Query Language (SQL)
#ACTIONS#
#SELECTION#
#ICON_HTML#
List High Water Mark Stats for Database Components.
Mar 26, 2026 - Blog post -
Database Administrator (DBA)
Database 23ai
Structured Query Language (SQL)
Database 19c
Oracle Database (EE)
#ACTIONS#
#SELECTION#
#ICON_HTML#
Show RDBMS Feature Usage
Mar 26, 2026 - Blog post -
Database Administrator (DBA)
Database 23ai
Structured Query Language (SQL)
Database 19c
Oracle Database (EE)
#ACTIONS#
#SELECTION#
#ICON_HTML#
Read the Alert Logs via SQL on RAC
Mar 26, 2026 - Blog post -
Database Administrator (DBA)
Structured Query Language (SQL)
Oracle Database (EE)
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle Hint - QB_NAME
May 08, 2025 - Blog post -
Database 23ai
Structured Query Language (SQL)
Database Administrator (DBA)
Database Development
Database Performance Management
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle Hint - CURSOR_SHARING_EXACT
May 08, 2025 - Blog post -
Database 23ai
Structured Query Language (SQL)
Database Administrator (DBA)
Database Development
Database Performance Management
#ACTIONS#
1 - 15
Next