ACE Profile

Full Name

ACE Pro

Job Role Developer

Company GPI Consult

Country Germany

Top Expertise Procedural Language for SQL (PL/SQL)

Focus Area Database

About Gunther

With nearly 30 years of hands-on experience, I have been working with the Oracle Database since 1997 as an Oracle Database Full Stack Developer.

As an AI Enterprise Architect, I integrate modern AI technologies into Oracle Database environments — from local neural networks and AI Vector Search to LLM integration and Retrieval-Augmented Generation (RAG).

My focus is on data storage and processing: traditionally relational with the Oracle Database, and with modern NoSQL concepts using Oracle NoSQL Database, combined with the development of web applications using Oracle APEX.

As a long-standing member of the German Oracle User Group (DOAG), I have served as a delegate for many years and regularly speak at DOAG conferences and events.

Expertises Procedural Language for SQL (PL/SQL) Structured Query Language (SQL) Oracle APEX Database Cybersecurity Data Warehouse AI Vector Search AI Infrastructure Database Administrator (DBA)

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#

Oracle APEX 26.1 and ORDS 26.1 Standalone with NGINX on Oracle Linux 9 for Production Setup

May 23, 2026 - Blog post -

Oracle APEX

Oracle REST Data Services (ORDS)

ORDS

#ACTIONS#
#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#

Implementing MCP Architecture in the Database with PL/SQL — Serving LLMs Securely from Oracle

May 19, 2026 - Blog post -

Database 26ai

AI Infrastructure

#ACTIONS#
#SELECTION#

#ICON_HTML#

Case study: Smart contract information – AI and APEX combined

May 19, 2026 - Presentation - in-person or virtual - APEX Connect 2026

AI Vector Search

Oracle Text

Oracle APEX

Database 26ai

#ACTIONS#
#SELECTION#

#ICON_HTML#

Oracle 26ai — Solving Data Quality Challenges with FUZZY_MATCH and PHONIC_ENCODE directly in SQL

May 18, 2026 - Blog post -

Database 26ai

#ACTIONS#
#SELECTION#

#ICON_HTML#

Oracle AI Database 26ai: Native Date and Time SQL Features — TIME_BUCKET, Calendar Functions, and CEIL/FLOOR for Datetime Types

May 18, 2026 - Blog post -

Database 26ai

#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#

1 - 15

ACE

Top Level Details

About Gunther

Latest Contributions