Skip to Main Content
ACE Program
ACE Directory
Become an ACE
ACE Sign In
ACE
Full Name
Gunther Pippèrr
Full Name
ACE Pro
Top Level Details
Job Role
Developer
Company
GPI Consult
Country
Germany
Top Expertise
Procedural Language for SQL (PL/SQL)
Focus Area
Database
About Gunther
I have a year-long experience as Oracle full stack developer and work with the Oracle database as since 1997. My focus is on data storage and processing, traditionally relational with the excellent Oracle database and with modern NoSQL concepts like Oracle NoSQL database and the development of web application with Oracle APEX. As a member of the German Oracle User Group I work there as a delegate and participate regularly as a speaker at the events of the DOAG.
Expertises
Procedural Language for SQL (PL/SQL)
Structured Query Language (SQL)
Database
Data Warehouse
Database Administrator (DBA)
Cybersecurity
Oracle APEX
AI Vector Search
Home Page
https://www.pipperr.de/dokuwiki/doku.php
Oracle Community
https://community.oracle.com/tech/developers/profile/Gunther%20Pippèrr
Cloud Customer Connect
https://community.oracle.com/people/Gunther+Pipp%C3%A8rr
Links
Latest Contributions
#SELECTION#
#ICON_HTML#
AI agent architecture in PL/SQL – Implementing MCP servers in the database
May 20, 2026 - Presentation - in-person or virtual - APEX Connect 2026
Database 26ai
Oracle PL/SQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
Managing SSL Certificates for the Oracle Enterprise Manager 24ai Console — Architecture, Common Pitfalls, and Step-by-Step Wallet Setup
Apr 17, 2026 - Blog post -
Oracle Enterprise Manager (OEM)
Secure Sockets Layer (SSL)
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle 19c / 26ai — Controlling SYSAUX Tablespace Growth: Analyzing Advisor Space Usage and Preventing Overflow
Apr 15, 2026 - Blog post -
Database 19c
Automatic Workload Repository (AWR)
High-Frequency Automatic SPM Evolve Advisor Task
SQL Tuning Advisor
Database 26ai
#ACTIONS#
#SELECTION#
#ICON_HTML#
Apache Guacamole 1.6 on Oracle Linux 9 — Secure Browser-Based Access Gateway for Oracle Database and WebLogic Environments
Apr 15, 2026 - Blog post -
Oracle Linux
Security
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle Database 26ai - Hybrid Vector Search - Understanding Transaction Behaviour - ORA-04036: Solving PGA Memory Problems
Feb 26, 2026 - Blog post -
AI Vector Search
Oracle Text
Autonomous Database
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle 26ai ADB – Autonomous AI Database – Importing Oracle DataPump Exports: Troubleshooting & Pitfalls
Feb 25, 2026 - Blog post -
Database 26ai
Oracle Data Pump
Database Cloud
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle 26ai – Named Entity Extraction (NER) with CTX_ENTITY for analyzing collective bargaining agreement inquiries using a hybrid vector approach
Feb 05, 2026 - Blog post -
AI Vector Search
Oracle Text
Database 26ai
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle Database 26ai – Vector Search: Refine results through re-ranking and minimise noise
Feb 03, 2026 - Blog post -
OML4Py
AI Vector Search
Database 26ai
#ACTIONS#
#SELECTION#
#ICON_HTML#
The VECTOR data type and its indexing options for DBAs and architects in detail
Nov 18, 2025 - Presentation - in-person or virtual - DOAG Conference 2025
AI Vector Search
Database 26ai
#ACTIONS#
#SELECTION#
#ICON_HTML#
Hybrid Search with Oracle Text and Al Vectors – Classic meets AI
Nov 18, 2025 - Presentation - in-person or virtual - DOAG Conference 2025
AI Vector Search
Database 26ai
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle Reports / Oracle APEX / ORDS 25 / Tomcat 9 with Java 21 / Nginx on Windows Server
Nov 14, 2025 - Blog post -
Oracle Forms and Reports
Oracle REST Data Services (ORDS)
Oracle APEX
Microsoft WIndows
#ACTIONS#
#SELECTION#
#ICON_HTML#
TSPITR (Tablespace Point-in-Time Recovery) - Restore a tablespace to the past - Oracle 19c / 23ai
Jul 17, 2025 - Blog post -
RMAN Backup and Recovery
Recovery Manager (RMAN)
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle Unified Auditing - Mandatory in 23ai - Conversion from classic/mixed auditing to unified auditing in 19c as preparation for the 23ai migration
Jun 25, 2025 - Blog post -
Database Security
Database 23ai
Database 19c
Database Administrator (DBA)
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle APEX - Call a local desktop app in the Interactive Grid report with the values of the current row as parameters
May 16, 2025 - Blog post -
Oracle APEX
#ACTIONS#
1 - 14