Wrapping up Oracle AI World Connor McDonald writes that there was lots of buzz around AI but it was great to still see the high level of interest in the core database tech. Read his wrap up here. Implementing the Model Context Protocol (MCP) in Oracle Database 26ai Bruno Reis writes:…
Tag: Oracle Analytics
Analytics
Read more
July News
1. Using Spatial Studio to Extend / Enhance Dimensions for OAC Wayne D Van Sluys writes, “Oracle Spatial Studio is a great tool that can be leveraged to extend or enhance location based data you may already be working with in your analytic projects.” He walks us through an example…
Weekly News
Read more
May News
1.SQL Server Vulnerability: Audit Failure for SERVER_PERMISSION_CHANGE_GROUP in SQL Server 2022 This blog begins by saying, “Important Disclaimer: This vulnerability was reported to Microsoft. After assessment from Microsoft side they concluded that this is a low impact vulnerability and will fix it in a future “cumulative update” patch.” It concludes with “security…
Cloud
Read more
February News
Stew Ashton writes, “Finding the difference between two dates or timestamps is hard! I am not fully satisfied with any of the solutions I have already proposed (or read), but I think this time I may have a decent answer.” 2. Step-by-Step Guide to Creating a New Forms Server in…
Analytics
Read more
January Reading
This blog opens with: “A couple of my students wanted me to write a switch and parameter handler for Python scripts. I wrote it just to show them it’s possible but I also show them how to do it correctly with the Python getopt library, which was soft-deprecated in Python 3.13 and replaced…
Analytics
Read more
Some Pre-Christmas Reading
1. Oracle ASM Filter Driver (AFD) Filtering and 5.15 UEK7 kernels Ron shares the background: “As a long time fan of the Oracle ASM Filer Driver, one of the major benefits for Oracle ASM Filter Driver (AFD) is AFD Filtering. AFD can ensure writes are only performed by trusted and…
Analytics
Read more
December Musings
1. Lock Control in Database Onur Ardahnli began with, “In today’s article, we will discuss checking for LOCKs in the database, which is one of the checks we perform when there is a problem in the database.” 2. Spring Cleaning This blog goes through two different scenarios and concludes with: “Wrangling…
Oracle
Read more
November Reading
Recent Blogs I’ve Read: 1. How Can a Data Breach of an Oracle Database be Managed and Analysed? Pete Finnigan asks, “If you become the latest victim of a data hack and your Oracle database is compromised then what do you do?” 2. Applying the first Monthly Recommended Patches (MRP)…
Analytics
Read more
End of Summer Reading
1. Staging Tables in Oracle 23ai Dani Schnider begins this blog saying, “Browsing through the Oracle 23ai New Features Guide, I once again discovered a small, inconspicuous feature that I had previously overlooked: There is a new option to create stage tables. What is the advantage of this enhancement?” 2. Separating…
Analytics
Read more
Some Summer Reading
1. Installing Xfce on Oracle Linux 9 Martin Bach shares, “This post explains how to install Xfce on Oracle Linux 9.4 x86-64 using the EPEL (Extra Packages for Enterprise Linux) repository. I’m fairly sure the same applies to ARM64 as well, but I didn’t have time to test. The article is based on…
Analytics
Read more
The Best of May
1. Compatibility Issues David Fitzjarrell begins with: “Oracle can be set to use a broad range of version settings, controlled by the compatible setting. Normally upon install this is set to the current version of the database that’s been installed. There may be times, however, when a lower compatibility setting…
Analytics
Read more
April’s Best Blogs
1.Configuring Shared Global Area (SGA) in a Multitenant Database David Kurtz shared, “I have been working on a PeopleSoft Financials application that we have converted from a stand-alone database to be the only pluggable database (PDB) in an Oracle 19c container database (CDB). We have been getting ORA-4031 (unable to…
Analytics
Read more
April News
1.Connection to Oracle Autonomous Database In this blog, Selvakumar Nagulan explains how to connect to an Oracle Autonomous database using SQL developer, SQL plus or other tools. He refers to this document in his blog. 2. Reading a LOB in another session Martin Berger begins by saying, “Reading a LOB in…
APex
Read more
Weekly Update w/c 4th March 2024
Maria Colgan shared, “The longer an application has been successfully run, the more likely you are to have indexes that are no longer used or beneficial. Removing these indexes not only saves space but can also improve the performance of any DML operations. But knowing which indexes can be safely…
Analytics
Read more
Weekly Update – w/c February 19th
In this blog, Atul Kumar covers: 2. Using server-side JavaScript in APEX processes Martin Bach writes, “In this installment of the mini-series you will learn how to write more complex server-side logic using MLE/JavaScript ECMAScript modules.” He goes through: 3. Oracle Sharding methods compared to YugabyteDB Franck Pachot begins his blog…
Analytics
Read more
Weekly update
Neil Chandler begins this blog with, “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…
Analytics
Read more
Monthly Round Up
This blog by Federico Venturin links to his article ‘Handling Fine-Grained Data Visualization Permissions in Oracle Analytics Cloud.’ It goes through: In his conclusion, he writes, “Until now, the all-or-nothing approach for handling permissions in Data Visualization posed a significant hurdle to its widespread adoption since administrators understandably preferred to…
Monthly News
Read more
Monthly Round Up – December 2023
Some of the best blogs I’ve read in the last month or so: This blog begins with, “I started some home lab cleanup this long weekend, and one of the first steps was to set up a separate DNS server for the lab. This is really just to make it…
Cloud
Read more
Monthly Round Up – October 2023
Blogs of the Week This blog centres around the new Oracle Cloud Infrastructure (OCI) Product Tours page. This is the analytics section The page also features links to useful YouTube videos. 2. Extract OCI Monitoring Metrics Using REST APIs Alfredo Krieg shares how you can list metric definitions and how…
Monthly News
Read more
Monthly Round Up
Blogs of the Month 1.How to study for 1z0-1067-23 – Oracle Cloud Infrastructure 2023 Cloud Operations Professional In this blog, Alex Zaballa gives some vital tips on what to focus on for the Oracle Cloud Infrastructure 2023 Cloud Operations Professional. He suggests you focus on: He also includes some handy…
Analytics
Read more
Monthly Round Up
Blogs of the month Here’s 10 of the best from the last few weeks: 1.Enabling Search Framework Real Time Indexing (RTI) Jim Marion writes, “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…
Analytics
Read more
Installing Analytics Server 2023 – Windows
Install Oracle Analytics Server 2023 Release, in Windows
Analytics
Read more
Recent Blogs and News
Blogs This blog begins with: “Today when checking a recently installed server with Oracle Linux 7.9 and ASM 19.17 with ASMLib, we found that when performing any reboot on the server, ASM could not mount the disks.” Read how the fix was applied! 2. Health Check for DB Nikhil shares…
Installing Oracle Analytics – 6.4 in Windows
This post series is part of the installation series, which will attempt to add to the standard instructions Preparation This article will focus on the Manual OAS installation on windows, including the required weblogic install, therefore you will need already prepared: An Oracle Database, one of the supported ones for…
Monthly News
Read more
What’s New?
Blogs of the month 1. OEM: ASH Package Version Status – manual update In the Performance Hub page, it can show a yellow warning sign (⚠️) Read the blog to find out how to fix it! 2. Document Data Extraction – Data Mapping for Donut Model Fine-Tuning Dataset (Document AI)…
Monthly News
Read more
What’s going on this February?
Blogs of the month Patching my environments with the January 2023 Bundle Patches Mike Dietrich shares information about January’s Security Alert and gives a quick overview of the patch bundles he intends to apply to his 19c and 21c environments. 2. Fixing up oem 11g This blog begins with, “Although oracle enterprise…
Analytics
Read more
Pre-Christmas Blog
I’d love to take this opportunity to wish you a wonderful festive season – and all the very best for 2023. If you’ve got a few moments amongst the mince pie eating, here are some great blogs and videos to read and watch: Blogs of the month Star Schema Design…
OBIEE
Read more
Mid-October News
Blogs of the week 1. indirect partition pruning This blog begins with, “During one of the discussions, <at POUG2022> I claimed Oracle can – under specific circumstances – do a partition pruning, even when the partition key isn’t somewhere defined as a filter. It’s probably easiest to show it by a…
Analytics
Read more
News from May 2022
Blogs of the Month qgis with Oracle Cloud Database “One of these complex situations is the connection to an Always Free Autonomous Database. Oracle tries to secure the database access, so by default it does not allow a simple connection with host, port, service_name and username/password. Instead a wallet is provided…
APex
Read more
Best of last year
Here is my take on the good reading stuff from last year. Obviously there is a bit of a covid theme to a lot of the blogs I read, but also some great tech updates. Learn how Oracle used APEX to quickly launch its COVID-19 therapeutic app Read about how…
OBIEE
Read more
A mid-September blog
Blogs of the Week 1.OBIEE – SSO — Integrating with a third party login with AD authentication / passing user and pass in URL Erman Arslan begins by saying, “Implementing SSO or Windows Native authentication in OBIE is something we do frequently. Basically, we integrate OBIEE with Microsoft Active Directory…
APex
Read more
End of Summer…
Today is the last working day of August (It’s a UK Bank Holiday Monday on 31st August…) next week we will be into the beginnings of September and Autumn. Slow down over the Bank Holiday and read some of the latest blogs and articles or watch some videos…. Blogs of…
APex
Read more
An early July blog…
Blogs of the Week 1. Announcing SQL Developer, SQL Developer Data Modeler, & SQLcl versions 20.2 Jeff Smith says, “However, there are bug fixes that we need to get into your hands, and our developers have never stopped working on new features, so we ARE releasing version 20.2, TODAY.” He…
Weekly News
Read more
A bit of light reading…
Blogs of the week 1. Copying a SQL Plan Baseline from one database to another Martin Bach starts by saying, “Hopefully this post saves you a few minutes looking the procedure up. I know it’ll save me some time 😉 In this rather lengthy article I’d like to cover how I…