(Marco Mischke) In my previous blog post I wrote about the MERGE statement and how it can efficiently be used. During the implementation of this solution a colleague stumbled upon some very high values numbers for the sequence he used to generate the IDs.
Tag: Oracle
Patch the 2 node RAC in OCI with DBCLI
(Skant Gupta) In this post, we will perform patching on BM (Bare Metals) and VM ( Virtuals Machine) database systems by using DBCLI on the 2-Node RAC running on Oracle Database 19c.
SQL Developer Keyboard Shortcuts: The Movie!
(Jeff Smith) Short post today, and short video – but the content could save you HOURS of coding and working with your Oracle Database!
Exadata wrong Kernel version after dbnode upgrade
(Stefan) While doing a lot of Exadata Upgrades I get a problem on one of my DB nodes
Upgrade Grid 12.2 to 19.6 Using Gold Image
(mdinh) Quick and dirty OPatch Update for All nodes:
Oracle Restart 19c: silent installation and ASM Filter Driver
(Martin Bach) Oracle 19c is has been getting a lot of traction recently, and I have been researching various aspects around its installation and use.
How to request an (always free!) Oracle APEX Cloud Database
(Matthias Hoys) Last year Oracle released its “Oracle Cloud Free Tier” program. This means that you can get your own Oracle cloud database for free – and what’s more, it’s *always* free, so the offer will not expire after a year and you are charged nothing except if you start using one of the paid o
ORA-1403 during TEXT / CONTEXT post upgrade
(Mike.Dietrich) When you see an ORA-1403 during TEXT / CONTEXT post upgrade phase, regardless of using AutoUpgrade, dbupgrade, catctl or DBUA, no worries.
Estimating DB Time With ASH: Logon Storm Pitfall
(Nenad Noveljic) This blog post is inspired by John Beresniewicz’s presentation DB Time, Average Active Sessions, and ASH Math.
Very first steps in Oracle Cloud Infrastructure as Code with Terraform
(Lucas Jellema) Resources in Oracle Cloud Infrastructure can be managed through the console – the browser based UI. That works great but requires manual steps – no automation – that take time and easily go wrong (and become extremely boring over time).