(Connor McDonald) There has always been a bit of a Catch-22 with some of the really cool options in the Oracle Database. You want to explore the value of them, but you don’t want to draw the ire of any licensing implications of doing so.
Tag: Oracle
GoldenGate Monitoring With User Separation
(mdinh) Typically, GoldenGate monitoring is performed by GoldenGate user.
Syntax Highlighting With SQL Developer
(Philipp Salvisberg) A customer asked me if it is possible to show unused identifiers in SQL Developer. Since there is no PL/SQL compile warning for that, you might be tempted to say no. But you can always use PL/SQL Cop for static code analysis.
The Oracle database museum: running old versions of the Oracle database
(Frits Hoogland) All Oracle database professionals know the current versions of the Oracle database (12.2, 18, 19, 20 at the moment of writing), and we also know the pace Oracle corporation keeps is so high that a lot of companies are having a hard time keeping up with the current versions.
Automatic Indexing in Oracle 19c Autonomous Database
(Nimish Garg) With Oracle Database 19c, The Automatic Indexing feature automates the index management by allowing Oracle Database to automatically create, rebuild and drop indexes based on application workload.
ORDS 101 Video and Slides
(Jeff Smith) In this video, I spend 40 minutes talking HTTP, REST, & JSON and how Oracle REST Data Services takes advantage of all of this for delivering RESTful Services for an Oracle Database.
Fresh install: Autonomous Health Framework for single instance Oracle 19c
(Martin Bach) I have been deploying Tracefile Anlyzer (TFA) to every system I’m looking after, whenever possible.
Implementing Glue ETL job with Job Bookmarks
(Anand) AWS Glue is a fully managed ETL service to load large amounts of datasets from various sources for analytics and data processing with Apache Spark ETL jobs.
Migration methods to Autonomous Database (ADB) – Part I (Data Pump)
(Syed Jaffar Hussain) In this part of on-premise Oracle database migration to ADB series, we will focus on set of tools to migrate your on-prime database to Autonomies database (ADB).
Adding columns to external tables…idiocy?
(Connor McDonald) Let me start with the idiotic part first. That part would be…. me! Smile