#Kscope19 week

Why do Java developers wear glasses? Because they cant C#.

Cats spend two thirds of their lives sleeping, and the other third making viral videos.

If you’re at #Kscope19 this week – enjoy!!! Here’s some of the latest blogs and posts we’ve been reading this week:

Blogs of the week

  1. Running Oracle JET as Progressive Web App

Andrejus Baranovski begins his blog by saying, “Progressive Web Apps (PWA) topic is a hot thing in web development these days. Read more about it – Progressive Web Apps. The beauty and power behind PWA – user can install a web app to his mobile device, without going through the app store. This simplifies update process too, when a new version of the app is available, the user will get it straight away, because it is essentially a Web page, wrapped to look like an installed app.”

2. See APEX Debug info in PL/SQL and SQL Developer

Dimitri Gielis writes, “When developing Oracle APEX apps I like to instrument my code with APEX_DEBUG and/or Logger. With our APEX Office Print (AOP) PL/SQL API and APEX Plug-in we did the same, we use APEX_DEBUG and Logger behind the scenes to allow you to see what it going on. But when I tried to view the APEX debug messages in SQL Developer, I didn’t see any. ”

3. Oracle Database 19c for Windows and Linux on System z available

Dirk Nachbar writes, “Since this weekend the latest Oracle Database 19c (19.3) are also available for Windows (64-bit) and Linux on System z. The Installation sources can be found under https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

4. Oracle RAC + ASM + NFS home lab

Gary Gordhamer says, “Many people look for ways to emulate enterprise hardware in their home labs in order to get good hands on experience with Oracle products.  One of the harder ones to get working is Oracle RAC due to the need of multiple networks and shared storage. With the plethora of virtualization software out now, this has gotten much easier.  For my job I needed a two node RAC setup to do some testing of DBCA (Database Creation Assistant) scripts.  I’ve done 100’s of RAC installs, so other than the time, I didn’t foresee any issues.  Well, as usual, what can go wrong will go wrong.”

5. Oracle Grid Infrastructure 19c does not configure the local-mode automaton by default. How to add it?

Ludovico Caldara begins his blog by saying, “I have been installing Grid Infrastructure 18c for a while, then switched to 19c when it became GA. At the beginning I have been overly enthusiast by the shorter installation time.”

6. Importance of setting Fetched Rows size for Database Query using Golang

Brendan Tierney says, “When issuing queries to the database one of the challenges every developer faces is how to get the results quickly. If your queries are only returning a small number of records, eg. < 5, then you don’t really have to worry about execution time. That is unless your query is performing some complex processing, joining lots of tables, etc. Most of the time developers are working with one or a small number of records, using a simple query. Everything runs quickly. But what if your query is returning several tens or thousands of records?”

7. SMON_SCN_TIME and ORA-8161? Digging deeper

Connor McDonald says, “In the recent versions of the Oracle database, we’ve had the ability to convert between a System Change Number (SCN) and the approximate time to which that SCN pertains. These functions are unsurprisingly called SCN_TO_TIMESTAMP and TIMESTAMP_TO_SCN. The only potential misnomer here is that even though the functions are called “timestamp” and return a datatype of timestamp, on most platforms you are going to notice that the granularity doesn’t run down into fractions of seconds.”

8. Azure Application Insights Overview

Eric Anderson writes, “In the Add Application Insights to an Existing ASP.NET Core Application post from last week, we got Application Insights up and running. This week my plan was to show off some of the features of Application Insights. It turns out this is hard to do in a meaningful way when your application isn’t getting any usage. While I have next to no data for most of the screenshots I still want to point out some of the areas of Application Insights that seem like they would be very useful.”

9. Can’t Unnest

Jonathan Lewis says, “In an echo of a very old “conditional SQL” posting, a recent posting on the ODC general database discussion forum ran into a few classic errors of trouble-shooting. By a lucky coincidence this allowed me to rediscover and publish an old example of parallel execution gone wild before moving on to talk about the fundamental problem exhibited in the latest query. The ODC thread started with a question along the lines of “why isn’t Oracle using the index I hinted”, with the minor variation that it said “When I hint my SQL with an index hint it runs quickly so I’ve created a profile that applies the hint, but the hint doesn’t get used in production.”

10. Database Authentication and REST Data Services

Jeff Smith writes, “We don’t recommend database authentication for protecting your RESTful Services in ORDS.


A few reasons, but often because database accounts aren’t always treated as securely as they SHOULD BE, and also by giving this set of credentials to someone, you’re giving them access to REST services AND to the source database. That being said, we found enough customers that really needed this to be implemented due to existing app stacks (MOD_PLSQL) that relied on database authentication. And towards the end of this article you’ll see another reason why supporting DB Auth became relevant.”

This week on Twitter

Vertical Edge CG shared What’s New in BI?

UKOUG asked for submissions to the new look magazine #PTK, formerly known as #OracleScene


Stories from blog.redpillanalytics.comthatjeffsmith.com and stewashton.wordpress.com 

Videos such as: