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…
Category: Oracle Database
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 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…
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…
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…
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…
Conference
Read more
Back to School
Have you had a good Summer? Here’s a round up of the blogs that have caught my eye over July and August: Why you simply can’t upgrade from Oracle 11g or 12c to Oracle 23c Mike Dietrich shares why this isn’t just a simple upgrade. You MUST upgrade to Oracle…
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…
Oracle
Read more
April’s Blogs
Blogs of the Month Building a REST API with ORDS, PL/SQL Functions, & Arrays Jeff Smith shares how to build a REST API that return a JSON array list of strings. 2. Configuring Nginx on AWS EC2 for Oracle GoldenGate 21c This blog begins with: “When installed, Oracle GoldenGate (Microservices) will…