In the past month, Oracle ACEs from all around the world shared insights and knowledge in over 250 blog posts and articles. We have selected 10 of them for you to read and enjoy, focusing on GenAI, OCI, APEX, 23c and more.
A new year, a new product! Yesterday, Oracle announced the general availability of the OCI Generative AI (GenAI) service. In my final blog post last year, I briefly looked at the beta information that was available to the public, and suggested how you can quite easily add powerful GenAI capability in Oracle APEX applications by calling the REST APIs using APEX_WEB_SERVICE. With the service in GA, I am now finally able to take a deeper dive and hopefully, help you get started.
Whilst on the box, using Oracle Integration Cloud (or OCI Integration) appears very simple – it’s just drag & drop right?! - It’s important to understand the basics (and understand them well) to ensure that your design is robust.
The Oracle Database Security Assessment Tool (DBSAT), currently in version 3.1.0 (January 2024), is a command-line tool focused on detecting potential security vulnerabilities. Its greatest scope occurs within the database but it also inspects operating system and network components (listener) in search of failures.
The November 2023 Update for Oracle Analytics Cloud came out a few weeks ago, and this article describes the enhanced Restore Deliveries options related to enabling or disabling agents in your instances.
Oracle Cloud Infrastructure Identity and Access Management (IAM) provides identity and access management features such as authentication, single sign-on (SSO), and identity lifecycle management for Oracle Cloud as well as Oracle and non-Oracle applications, whether SaaS, cloud-hosted, or on-premises. Employees, business partners, and customers can access applications at any time, from anywhere, and on any device in a secure manner.
APEX_WEB_SERVICE is by far my favorite APEX Pl/SQL API. It dramatically reduces the effort of calling external Web Services from the Oracle Database. In this post, I will first cover the key concepts you need to know and then review several use cases where I have used APEX_WEB_SERVICE to make my life easier.
Over the past couple of years, we have witnessed a sea of change in how our clients are utilizing Oracle Enterprise Data Management (EDM). The question has shifted from “should I make the leap to Oracle EDM” to “how best can I deploy Oracle EDM in my cloud journey?” No longer am I asked “Is EDM ready for prime time?” Instead, others want to know best practices to use EDM effectively.
Gathering object statistic in Oracle is important. The optimizer needs metadata about the object, such as the amount of rows and number of distinct values in a column, to help it decide the optimum way to access your data. This takes effort, and takes place automatically in scheduled windows, both overnight or at the weekend. These windows have a limited duration, and if there’s a lot of data to analyse to get the requisite metadata, it may run out of time.
In my years as a Data Scientist, and working with data in general, I’ve picked up a lot of tips and tricks along the way. My latest blog series is looking to share some of those I’ve found particularly helpful, with the hope that you could apply some of these to make your day-to-day work life a little easier.
Bonus:
Check out these videos if you prefer listening rather than reading: