(Ankit Kumar) There could be various requirements at application end which need realtime slaves. Let me introduce a solution to a problem we used to face how can we monitor whether our slaves are real time or they are lagging in Milliseconds.
Other News
Managing API Gateway Costs with Oracle API Platform
(Phil Wilkins) The Oracle API Platform adopted an intelligent pricing model by basing costs on API call volumes and Logical gateway node groupings per hour.
Houston, we’ve got a problem with JSON PUT method
(Flavio Casetta) In brief, in Oracle 12.2.0.1 there is some problem with PUT method of JSON_OBJECT_T, for some reason numbers are not recognized as such, but they are stored as scalar.
Old Locked Optimizier Stats? Collect in Pending area, Compare and Redeploy
(Natik Ameen) Want to move stats from a development environment?
SQL SERVER – List All Frequently Ran Stored Procedure From Server Cache
(Pinal Dave) Earlier this weekend, I had an urgent product to help. One of my clients reached out to me as their application stopped running in the middle night on Saturday. The issue was indeed a strange one as they have very little traffic on weekends and particularly during the night.
GraphQL: Evolution of Modern Age Database Management System
(David Cuelogic) The word GraphQL keeps popping up a lot around the web. It has been mentioned in many technical events as well, the most recent being the AWS re:Invent 2017, where they announced AppSync, a fully managed GraphQL service.
Why do DBAs dislike loops?
(Kenneth Fisher) If you started out as a developer you were probably taught how important loops are.
Batch Mode Bitmap Demos
(Paul White) This is a companion post to my main article Batch Mode Bitmaps in SQL Server. This post provides demos and illustrations to supplement the technical article.
Autobind failures now issue console messages in Db2 12
(Chris Crone and Randy Nakagawa) One of the current Db2 for z/OS Ideas with the most votes (RFEs are now Ideas) is to provide a message when an autobind fails and a package goes inoperative. We are happy to announce that we have now satisfied that requirement.
Running a Java class as a subprocess
(Dan Newton) Running a Java class (not a jar) as a subprocess is something I needed to do this week. More precisely, I wanted to spawn a new process from within a test, instead of running it inside the test directly (in-process).