(Jack Vamvas) Question: I’m working on an Enterprise application upgrade and have hit some problems. As part of the debugging process I’m inspecting the sql queries executing. The program is currently running SELECT 1 FROM TABLE. (replace TABLE with actual table name).
Other News
Oracle 18c Autonomous Health Framework (AHF) – Part 1
(Syed Jaffar Hussain) Recently I had to present at eProseed AnualTech conference in Luxembourg and I was requested to present a topic something about Oracle18c.
Java Challengers #2: String comparisons
(Rafael Chinelato Del Nero) In Java, the String class encapsulates an array of char. Put simply, String is an array of characters used to compose words, sentences, or any other data you want.
Java & Struct/Value Type Benefits & How to Obtain Them
(Member 13797506) If you are familiar with structs (value types), you may have wondererd why Java does not support them yet. While objects in Java are great for common usage, in those cases where performance and memory really matters, structs would be ideal.
A look into oracle redo, part 10: commit_wait and commit_logging
(Frits Hoogland) The redo series would not be complete without writing about changing the behaviour of commit. There are two ways to change commit behaviour:
Oracle API Platform Cloud Service: using the Management Portal and creating an API (including some policies)
(Marc Lameriks) At the Oracle Partner PaaS Summer Camps VII 2017 in Lisbon last year, at the end of august, I attended the API Platform Cloud Service & Integration Cloud Service bootcamp.
Using the STRING_SPLIT Function in SQL Server
(Srinath M S) SQL Server 2016 provides a way to split a string that is concatenated with a separator.
Tips for using indexed views in SQL Server 2017
Tips for using indexed views in SQL Server 2017 Keep the indexes on the views as narrow as possible. Because each index takes up disk space try to minimize the index key’s size to avoid using superfluous disk space. This reduces the number of reads required to read the index and boost overall index performance. Try to create indexes on...
How do I get High Availability in my Azure Storage Accounts?
(Denny Cherry) This question actually comes up a lot. With the new managed storage it’s less of an issue as Managed storage takes care of the high availability for you.
IBM Redbook: Db2 12 for z Optimizer
(Troy L Coleman) I was recently asked about the Db2 zparm, NPGTHRSH. Admittedly, I knew little about it. The first place I always go to learn about zparms is the Db2 installation and migration manual.