During June, 2023, more than 60 worldwide Oracle ACEs shared insights and knowledge on their blog posts or podcasts and videos. We have selected from over 170 blogs and podcasts some of them for you to enjoy – so we invite you to browse the list below and discover more on the Oracle ACE Program, Exadata, running E-Business Suite on OCI, tricks for DBAs in Oracle Database 23c, the AOUG User Conference and more.
There are some techniques that are really basic to what we do everyday as PL/SQL developers. There is a tendency to automatically do these basic things in the same way without considering the alternatives that the particular situation might merit. In this post and the next we will explore one of these basic techniques in order to develop a deeper understanding. Read more.
It’s essential to have a proper backup mechanism for virtualization infrastructure. Also, we need to test the backup and recovery method at least once in 3 months to validate that everything is working as expected. Read more.
Eduardo Claro: How I solved a real world problem using a RECURSIVE WITH clause, and a detailed explanation of how this feature works
Some days ago one of my fellow colleagues came up with a problem that he was trying to solve using pure SQL, to replace a very costly PL/SQL procedure. His client has an application that needs to send messages to clients, but these messages need some transformation before being ready for sending. Read more.
Fernando Simon: Exadata, REQUIRED_MIRROR_FREE_MB and GRID 19.19
I already wrote about the issue introduced with GI 19.16 in my previous post where (only at Exadata) more space was allocated/reserved by Oracle to guarantee mirror/rebalance. Fortunately, after some months of discussion, they rollbacked the change and released one patch that can be applied at GI 19.19. Read more.
Jim Marion: Enabling Search Framework Real Time Indexing (RTI)
As we prepare our HCM PUM 46 training servers, we decided to enable Real Time Indexing (RTI). We found several great sample videos and resources but still made a few mistakes. We are sharing our adventure to help you as you implement RTI. Read more.
Johannes Michler: Running E-Business Suite on OCI Hands On Lab with Identity Domain enabled Tenancies
Recently for a customer demo, I had to run/demo the Hands-on Lab on a tenancy that has IAM Identity Domains enabled and is no longer using the “classic” IDCS integration. Overall, the procedure is way more convenient with Identity Domains; it is now no longer necessary to have two users (one in OCI, one in IDCS) for each Cloud Manager administrator. Read more.
Julian Dontcheff: 3 small tricks for DBAs in Oracle Database 23c
Although the new Oracle Database 23c Free is in fact a Developer Release, there are still some interesting and useful DBA features. Read more.
Malik Sikandar Hayat: Oracle ACL and Oracle APEX | ACL concepts for Oracle APEX Developer
Oracle ACL (Access Control List) and Oracle APEX (Application Express) are two different components of the Oracle technology stack that serve different purposes. Let’s understand each of them separately. Watch the video.
Paul Guerin : Developer desktops with the Oracle Linux Cloud Developer image
Sometimes you need something with more grunt than a basic laptop. So why not run develop and test your application in the cloud? Read more.
Peter Finnigan: Proxy Connections and the SQL Firewall in Oracle 23c
I still have a lot of notes around the new SQL Firewall in Oracle 23c that I captured whilst testing so I was going to release a bigger part 4 but I have decided to create a simple short post here because I wanted to discuss the use of Proxy with the SQL Firewall. Read more.
Philipp Hartenfeller : How to share Template Components on apex.world – Oracle APEX 23.1
Watch the video to see how to share Template Components on apex.world.
Rafał Grzegorczyk : Essential tips for freeing up storage in Oracle Database XE
I will share some practical tips and scripts that helped me to reclaim valuable space in my Oracle Database XE environment (12 GB limited space). It worked on one of my environments that can not be upgraded to a higher Oracle DB (yet). Read more.
Ron Ekins: Oracle Database 23c Free Developer Release on OKE with Portworx Essentials – part 1
In this 3 part blog series I am going to share how to get started with Oracle Database 23c Free Developer release on the Oracle Cloud Infrastructure (OCI) using Oracle Container Engine for Kubernetes (OKE) and the Portworx Essentials forever free edition. Read more.
Stefan Oehrli: AOUG User Conference 2023 Recap in a Nutshell
I had the opportunity to participate in the AOUG User Conference as a speaker and presenter. Like in previous years, the conference took place at the Austria Trend Hotel Savoyen. The theme for this year was “Everything Cloud?”. Read more.
Tim Hall: Oracle REST Data Services (ORDS) : Basic and Digest Authentication on Tomcat using DataSourceRealm
This article demonstrates the use of the Tomcat DataSourceRealm to control authentication to Oracle REST Data Services (ORDS) web services. Read more.
LVM (Logical Volume Manager) is nothing more than an intelligent disk manager that works through volumes managed by the Linux Kernel – its objective is flexibility so that we can add, remove or resize hot swap volumes, it can work by grouping several disks creating single or multiple volumes similar to what we are used to with storage using RAID0 or RAID1. Read more.
