A few more blogs!

3 Database Admins walked into a NoSQL bar.

A little later, they walked out because they couldn’t find a table.

Enjoy the latest news and blogs!

Blogs of the week

  1. Selecting Optimal Parameters for XGBoost Model Training

Andrejus Baranovskis shared “There is always a bit of luck involved when selecting parameters for Machine Learning model training. Lately, I work with gradient boosted trees and XGBoost in particular. We are using XGBoost in the enterprise to automate repetitive human tasks. While training ML models with XGBoost, I created a pattern to choose parameters, which helps me to build new models quicker. I will share it in this post, hopefully you will find it useful too.”

2. OAC – BI: Custom Numeric Formatting

Wayne D Vans Sluys said, “At a Client we had a use case to show values in pivots and tables scaled to Thousands and Millions. Instead of dividing by 1,000 or 1,000,000 my client looked into format masking.”

He then shares what they came up with!

3. Simple integration of Data Visualization in OBI Dashboard

Boris Dahav begins by saying, “In OBIEE and OAC (Oracle Analytic Cloud) we can easily integrate Data Visualization projects with Dashboard Prompt capabilities. That works both with Subject Areas and Data Visualization Data Sources.  Let’s do 2 examples. Subject Area based and Data Source Based.”

4. Monitoring Performance of your Autonomous Data Warehouse (ADW) in Oracle Cloud Infrastructure (OCI)

Y V RaviKumar opens his blog by saying, “Managing and Monitoring Performance of Autonomous Data Warehouse (ADW) through Service Console in Oracle Cloud Infrastructure (OCI). Using the Overview and Activity tabs to get real-time and historical information
about the utilization of the service and we will scale up your Oracle Autonomous Data Warehouse (ADW) service to have more CPUs.”

5. Parallel Madness

Neil Chandler writes, “I’ve noticed at a few clients with data warehouses recently that the Developers and, upon occasion, Business Users have a real fondness for hinting the SQL they are producing with one particular hint. PARALLEL.”

6. Oracle Magazine

Connor McDonald shares, “Generally my blog is just snippets of tech content that take my interest as I encounter them (most commonly when looking at AskTOM). If I think they’ll be useful, I’ll just plonk them out right there and then. If you prefer your content in longer (and more structured Smile) form, then also I publish longer form articles on Oracle Magazine every couple of months. Below is a consolidated list of my articles. I’ll try to keep this list updated as I add new ones.”

7. Final Elimination

David Fitzjarrell begins by saying, “Occasionally a join using primary key columns in a query can be eliminated because of the data involved. If Oracle determines that all of the ‘required’ data is available in a single table the optimizer will rewrite the query to eliminate the ‘unnecessary’ join. Oracle has been doing this for years, with the limitation that the primary keys involved were single-column keys. In versions 12.2 and later multi-column primary keys can be used, however there are cases where the join elimination isn’t complete and that can depend on table order in the FROM clause or on the join syntax in use. Let’s look at an example that illustrates these points.”


Jonathan Lewis writes, “A few months ago Franck Pachot wrote about a recursive SQL statement that kept appearing in the library cache. I discovered the note today because I had just found a client site where the following statement suddenly appeared near the top of the “SQL ordered by Executions” section of their AWR reports after they had upgraded to 18c.

select domain# from sys.im_domain$ where objn = :1 and col# = :2

I found Franck’s article by the simple expedient of typing the entire query into a Google search – his note was the first hit on the list, and he had a convenient example (based on the SCOTT schema) to demonstrate the effect, so I built the tables from the schema and ran a simple test with extended SQL tracing (event 10046) enabled.”

9. Storage IO Performance Testing with ORION (Part 1)

Ron starts off by writing, “When a DBA gets the request to perform a storage IO test most will probably look to use the extremely poplar, and excellent SLOB (Silly Little Oracle Benchmark) by Kevin Closson, or maybe HammerDB or Dominic Giles’sSwingBench for Transactional / TPC-DS type tests. However, if you find yourself under time or other constraints ORION (ORacle IO Numbers) maybe a good option for a recently built system.”

10. Validating Dates and Numbers in Oracle 12.2

Martin Giffy D’Souza says, “Prior to 12.2 validating dates and numbers was a bit of a pain as you had to write your own custom PL/SQL function. OOS-Utils has a quick solution to this issue and I recommend using oos_util_validation.is_number and oos_util_validation.is_date. If you’re using Oracle 12.2 or above you can (and should) use validation_conversion instead. Here are some examples of how to use it along with results.”

This week on Twitter

Liron Amitzi posted Strange Index Behaviour 

Oracle Magazine shared “How ODTUG leaped from spreadsheets to SaaS—and how to take advantage of change”

Connor McDonald shared:


Stories from www.biconnector.com and thatjeffsmith.com

Videos such as: