A few of the latest…

Did you hear of the mathematician who avoided negative numbers?

He’ll stop at nothing to avoid them…

This event is definitely worth a mention.

“Bringing experts in the community together to #PASSTHEKNOWLEDGE on analytics & reporting. Submit your content now on Oracle Analytics Cloud, data warehousing, visualisation, finance, AI, and any other topics of your choice. Tell us your stories, solutions and tips to share with your peers.”

Content needs submitting by 12th August!

Venue London. Millennium Gloucester Hotel, London Kensington

When: October 8th

Blogs of the week

DV Series: Extensions

Opal begins by saying: “Extensions (also called “plug-ins”), for those of you who don’t use a lot of super techie, coding software, are basically software enhancements that can be added in easily like plug and play. Smart View also utilizes the concept of “extensions” for many of the Oracle EPM Cloud products. DV extensions are written by 3rd parties (not Oracle) and also by Oracle. …Let me just start by saying that within the Oracle Analytics suite of tools, DV comes in both desktop and Cloud flavors. And since DV is the base product and the end user product, it comes with every licensing tier. Extensions can be added to either desktop or Cloud, but are required to be installed to both environments if projects utilizing an extension are used on both platforms.”

2. How To Delete MGMTDB And MGMTLSNR Using Emcli

Michael Dinh writes, “Problem: MGMTDB and MGMTLSNR are running on only one host at a time and when relocated, will be paged unnecessarily. One team member`s suggestion is to relocate MGMTDB and MGMTLSNR back to its original host. It does not make sense having to identify and relocate MGMTDB and MGMTLSNR to its original host. As it turns out, Doc ID 1933649.1, MGMTDB and MGMTLSNR should not be monitored. Here I will provide an example for how to delete monitoring for MGMTLSNR using emcli.”

3. It’s Back!

Connor McDonald shares this link.

4. Dbvisit Standby 9.0.02 and Automatic Failover

Dbvisit starts this blog, “At the end of May 2019 Dbvisit Standby Version 9 (9.0.00) was released and what an exciting new release. It includes a number of excellent new features as well as internal improvements. During this release we delayed one new feature, which we are now super excited to announce. As of version 9.0.02 you have the option to configure an Automatic Failover for a particular configuration. Now for some this might sound strange, what does Automatic Failover mean? Let me quickly explain…”

5. Install and configure CMAN 19c in the Oracle Cloud, step by step

Ludovico Caldara says, “Installing and configuring CMAN is a trivial activity, but having the steps in one place is better than reinventing the wheel.”

Prepare for the install
Install CMAN
Basic Configuration
Preparing the Start/Stop script
Add the service in systemctl
Open Firewall ports

6. Oracle 18c quick tipp: How to change ini_trans

Sven Weller links to this post and says, “Rebuilding tables in 18c is so easy now!”

7. MIN/MAX Optimization and Asynchronous Global Index Maintenance

Christian Antognini says, “In this short post I would like to point out a non-obvious issue that one of my customers recently hit. On the one hand, it’s a typical case where the query optimizer generates a different (suboptimal) execution plan even though nothing relevant (of course, at first sight only) was changed. On the other hand, in this case after some time the query optimizer automatically gets back to the original (optimal) execution plan.”

8. Making Lists

Stew Ashton writes, “Strings that contain multiple values violate first normal form, which mandates “one value per column per row”. People still ask how to make or massage lists of values. This post is about aggregating values into lists.”

9. GoLang: Inserting records into Oracle Database using goracle

Brendan Tierney begins by saying, “In this blog post I’ll give some examples of how to process data for inserting into a table in an Oracle Database. I’ve had some previous blog posts on how to setup and connecting to an Oracle Database, and another on retrieving data from an Oracle Database and the importance of setting the Array Fetch Size.”

10. How to Save 7 Keystrokes with dbms_xplan

Dani Schnider writes, “In one of his presentations at the Kscope19 conference, Kim Berg Hansen mentioned an interesting detail about the syntax for table functions. The call of a table function in SQL was simplified in Oracle 12.2. Instead of “SELECT … FROM TABLE(<function_name>)“ we can now use the syntax “SELECT … FROM <function_name>“. I did not know that, and to be honest, I don’t like it so much because it is harder to see from the SQL statement that a PL/SQL function is called in the FROM clause.”

This week on Twitter

Martin Berger shared ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 1

Tim Hall tweeted Video : Oracle Linux 8 Installation