Throughout February 2024, Oracle ACEs from all around the world shared insights, tips and tricks and knowledge in more than 300 blog posts and articles. We have selected 17 of them for you to read and enjoy, focusing on EPM, OCI, APEX, Data Guard, 23c and more.

1. Arun Raj 
Associate
What is in Oracle EPM March 2024 (24.03) Updates

Hello everyone. I am usually one of the many who waits for the last week of every month; to check out the updates that are included as part of the EPM Updates. This time around, I am even more excited to try out many features and functionality that are coming as part of the March 2024 (24.03) updates.

2. Bobby Curtis 
Pro
Oracle Vector Datatype – Updating table data

In my last blog post on Oracle’s Vector data type, I simply showed you how the datatype is used within an Oracle table. In this blog post, we are going to dive a bit deeper and provide some context with it regardiing to updating a table with existing data.

3. David Kurtz 
Director
What PS/Query is that?

Sometimes, performance analysis will turn up a problem SQL query that is probably a PS/Query. However, I need to know which PS/Query it is should I wish to alter it or talk to the user who wrote it.

4. Gustavo René Antúnez Berdejo 
Pro
OCI,TERRAFORM & IAC : CODING MYSELF OUT OF A JOB

I haven’t written a blog in a while, and I feel that I have made a couple of mistakes lately that could have easily been avoided if I had done my tasks as IaC ( Infrastructure as Code). So I will start a series of IaC and Terraform. I know there are many blogs about this, but hope you find this helpful.

5. Harish Vummidi 
Associate
Streamlining Interview Scheduling: Personalize Calendar Events with Oracle Recruiting Cloud

In today’s fast-paced recruitment environment, it’s crucial to streamline every aspect of the hiring process. Oracle Recruiting Cloud introduces a feature that enhances communication and organization for both candidates and interviewers.

6. Ilmar Kerm 
Pro
Oracle Data Guard Snapshpt Standby

Snapshot Standby is a feature that allows temporarily to open existing physical standby database in READ WRITE mode – for example running some tests – and then convert it back to physical standby, discarding all the changes that were made during the testing. Another key feature is that the standby also retains some of the standby functions while it is open in READ WRITE mode, the snapshot standby keeps receiving redo from the primary database – just receiving, not applying. So even when you perform some testing on the standby, your data is still being protected by Data Guard. Although applying the shipped changes to the standby could take extended amount of time later.

7. Ionut Balosin 
Associate
–  JVM Performance Comparison for JDK 21 

The current article describes a series of Java Virtual Machine (JVM) benchmarks with a primary focus on top-tier Just-In-Time (JIT) compilers, such as C2 JIT, and Graal JIT. The benchmarks are structured in three distinct (artificial) categories.

8. Mark Daynes 
Pro
Oracle APEX 23.2 New Image Upload Facility

On a recent customer project I was able to use Oracle APEX 23.2.2 which has a significant number of new capabilities. One facility was the new Image Upload, which provides a wide range of options to allow users to easily take/select images and crop, format and upload and then tag them to records in a bespoke application.

9. Matt Mulvaney 
Pro
Connect VSCode to Oracle Cloud Compute for Seamless Remote Development

These Steps allow you to work within VSCode and save directly to your Oracle Compute Box. The Terminal window also allows you to run commands directly on your Oracle Compute Box.

10. Philip Godfrey 
Associate
–  Effortless Machine Learning Infrastructure: Deploy Kubeflow on Oracle OCI with Terraform

In today’s data-driven world, running machine learning workloads efficiently and at scale is crucial for organizations seeking to leverage the power of AI.

11. Prasanta Kirtaniya
Associate
  – Oracle Audit Vault and Database Firewall (AVDF)

AVDF audits databases and monitors network-based activities to help manage the security posture of Oracle and non-Oracle databases, hosted in the cloud or on-premises.

12. Radu Parvu 
Pro
Setting up Oracle Base Database Service on OCI

Oracle Base Database service is a for pay offering on OCI but it is quite reasonably priced and suitable for setting up test environments. Still the setup is relatively complex and the scope of this article is the out line the main steps used.

13. Shoumadip Das 
Associate
Understanding Oracle External Tables

External tables are read-only tables that allow Oracle to query data that is stored outside the database in flat files. You can use external table feature to access external files as if they are tables inside the database.

14. Timo Herwix 
Associate
Enabling Passwordless Authentication in APEX using Oracle Identity and Access Management

In the previous blog posts, we’ve walked you through setting up the Authentication and Authorization process, as well as implementing Multi-Factor Authentication (MFA) for extra security. Now, we want to demonstrate a passwordless solution that offers greater convenience and security compared to traditional password-based authentication methods.

15. Tim Hall
Director
TLS and Wallet Enhancements in Oracle Database 23c

Oracle 23c includes several enhancements to Transport Layer Security (TLS) and wallets, simplifying configuration, and making the database more secure.

16. Yvonne Bakx – van Dorst 
Associate
Oracle APEX – Calendar tips

Lately I’ve been exploring all the options of the Oracle APEX Calendar, also known as the FullCalendar version 5. I would like to share some of my findings and tips with you!

17. Zoran Tica 
Associate
Oracle APEX – DML on Collections

APEX Collections are introduced in the Oracle APEX since… forever. They provide a really nice replacement for Global Temporary Tables and can be very useful in a wide range of scenarios and use cases.