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…
Tag: obiee
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…
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
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…
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…
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…
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…