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…
Tag: Oracle Database
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…
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…