Prior to Oracle database 12.2.0.1, there could be following types of users in an Oracle multitenant container database (CDB) – Common User – A common user is created in the CDB root and has the same...
Last November saw our first launch of Toad DevOps Toolkit and since then we’ve seen a steady increase in interest and traction. For our latest Toad DevOps Toolkit release 1.1 we wanted to combine ...
Hybrid cloud management is an interestingly hot topic for today’s cloud world, since not all companies want to move everything to the cloud. In this article series, we are looking at the detailed step...
One of the new features of the Autonomous Data Warehouse Cloud (ADWC) service is Oracle Machine Learning. This is a Zeppelin based notebook for your machine learning on ADWC. Check out my previous blo...
It’s not uncommon to observe rampant over reliance of database application code on TEMP tables, most often as a SQL language programming crutch. I have a theory as to why. Programmers are chiefly taug...
In this popular article series, we are exploring the capabilities of Oracle Enterprise Manager Cloud Control 13c for the private Database-as-a-Service (DBaaS) cloud – including the setup of such a clo...
“The Only Thing That Is Constant Is Change “- Heraclitus. Development, new applications, upgrades, patches, maintenance, schema updates…the list goes on and on around ways that changes are introduced ...
On March 27th 2018, Oracle announced the availability of the Oracle Autonomous Data Warehouse Cloud Service (ADWC). The announcement was done via a live webcast with Larry Ellison leading the webcast,...
The Find and Replace feature is handy for replacing text you know already exists in a file. However, sometimes you need to modify text without existing keywords. If this modification is repetitive, it...
Last week I presented 3 sessions at my favorite Oracle conference – the IOUG Collaborate. The slide decks for my presentations are now available: Data Guard for BeginnersASM Conepts, Architecture and...
One of my customers had a problem about logging in to ODI Studio. Their ODI implementation is configured to use external authentication (Microsoft Active Directory). The configuration was done years a...
Learn how to replay workloads for migration testing, SQL performance tuning, and more with Benchmark Factory. Watch this demo of an Oracle Database Replay. You can get started with Benchmark Factory b...
