Blogs of the week
Martin Bach starts by saying, “Hopefully this post saves you a few minutes looking the procedure up. I know it’ll save me some time 😉 In this rather lengthy article I’d like to cover how I copied a SQL Plan Baseline from one database to another. If you find this procedure useful, please ensure your system is appropriately licensed for it and test it first!”
Robin Moffatt begins with, “In v5.5 of Confluent Platform, the REST Proxy added new Admin API capabilities, including functionality to list, and create, topics on your cluster.”
To start with, you need the cluster ID
Julian Dontcheff shares six new features of Data Pump in Oracle Database 20c including:
- Oracle Data Pump checksums support for cloud migrations
- Oracle Data Pump exports from Autonomous Database
- Oracle Data Pump includes and excludes in the same operation
- Oracle Data Pump parallelizes transportable tablespace metadata operations
- Oracle Data Pump provides optional index compression
- Oracle Data Pump resumes transportable tablespace jobs
Kate Helmer shared: “had an interesting use case for EDMCS come up recently, and wanted to share some of the process of designing EDMCS objects/features to support a business process.”
Jonathan Lewis writes: “This note is an index to the articles I’ve written about Subquery Factoring (aka Common Table Expressions / CTEs, aka “with” subqueries).”
Mohamed Houri asks this question! He starts his blog by saying, “While waiting for Tanel Poder’s hacking session about sql hint invalidity which I encourage everyone to subscribe and to follow, here are a few particular cases where hints are not obeyed by the Oracle Cost Based Optimizer. It happens when the hint asks the CBO to do something which is either impossible or not yet implemented in its algorithm. When two hints are contradictory one of them will be ignored by the CBO to the detriment of the other one. We will see that the victim hint seems not to be cost based dependent but rather rule based.”
Satishbabu Gunukula writes, “Oracle 18c allows RMAN backups created before the non-CDB or PDB was migrated into a different target CDB can be used for recovery operations. The COMPATIBLE parameter of the source and Oracle Cloud must be set to 18.0.0 or higher. The RMAN commands used to backup and recovery CDBs and PDBs are the same as those used for non-CDBs, with few variations in the syntax.
Part 3 begins by saying, “Today I’ll continue with the Oracle always free cloud offering and we’ll finally start to provisioning a VM in our environment. If you want to know more about how it works (Part 1) or the overview about the Dashboard (Part 2) please check my previous posts. The first thing we need to do is check for the best practices and see if everything in our environment is adequate.”
Quest Software shared a link to their new webcast series on Data Preparation Made Easy.
Their third session is July 9, 11:00 a.m. ET featuring Product Manager Julie Hyman, Julie will be presenting Toad Data Point Workbook 101: The Ins and Outs.
Jeff Smith shares, “Stepping through your PL/SQL code is fun – but often you want to be able to ‘jump to’ a specific iteration of a loop or maybe when a certain condition evaluates to true.”
He concludes by saying, “I’ll have some more exciting debugger news once version 20.2 of SQL Developer is released – so stay tuned!”
This week on Twitter
Donatello Settembrino tweeted ‘Strange Oracle Performance Optimizer Behaviour with Merge‘
Roberto Arteta shared ‘Enhance Your Data Preparation Using Oracle Analytics‘.
Connor McDonald posted ‘Read Only Partitions‘.
Videos and slides, such as: