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…
Category: Analytics
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…
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…
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…
Analytics
Read more
November News
Blogs 1. ORA-00479: RVWR process terminated with error followed by ORA-479 Mahmmoud Adel posted about an error that occurs on a 19c DB, when trying to enable the FLASHBACK mode on a standby DB. He gives an analysis and solution. 2. Natural Selection & Converged Databases (Oracle finds good solutions…
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…
Analytics
Read more
Latest blogs and videos
Just a few for these chilly October/November evenings … Blogs of the Week 1. Announcing Oracle APEX 20.2 Joel Kallman shares (the original post is here) : “This release of APEX introduces several new features and enhancements to help developers be more productive than ever before. From the all new Cards…
A Conditional, Data-Driven Action Link
The initial release of this functionality was seen as a positive step towards tighter integration of the Siebel and Analytics applications. Since then, many versions onward the functionality has moved on little and there are still limitations which continue to frustrate developers. The ‘so-called’ increased usability of action links available…