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…
Category: Analytics
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…
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…
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…