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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Oracle 23c includes several enhancements to Transport Layer Security (TLS) and wallets, simplifying configuration, and making the database more secure.
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!
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.