Tag: Oracle

How to Test an Oracle Database Upgrade using a Physical Standby

It was a Thursday morning. I started my day at work and found out that I was tasked with running a test upgrade to 11.2.0.4 right on Friday. This is just to make clear that I did not have much…

Read More >

Shutdown while upgrading to 18c

My colleague and friend Gleb Otochkin has already blogged about installing 18c – Installing Oracle 18c using command line – but I thought that I would share my experience. My plan was to upgrade my 12.2 pluggable database to 18c…

Read More >

MySQL Plugin For Oracle Enterprise Manager 13c Cloud Control

This is the same plugin that Alex Gorvachev created back in the day. I’ve simply modified it to be compatible with both 12c and 13c versions. I created this in response to a comment on the blog about issues deploying…

Read More >

Oracle Autonomous Transaction Processing – A Good Start

It has been almost a year since the last Open World where Oracle CTO and founder Larry Ellison proclaimed the new upcoming fully autonomous cloud database service. It created a lot of attention and almost everybody in the Oracle community…

Read More >

Oracle Parallel Query Hints Reference – Part 6: USE_PARTITION_WISE_GBY

Welcome to Part 6 of the series. The USE_PARTITION_WISE_GBY hint is “brand new,” introduced in 12.2. I personally welcome this hint as I’ve cursed many times in the past due to the lack of control for this aspect of parallelism…

Read More >

Log Buffer #554: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Cloud, Oracle, and MySQL. Cloud: Google Cloud is announcing an easy way to back up and replay your streaming pipeline events directly from the Cloud Console via a new collection of simple import/export templates. If…

Read More >

HugePages for Oracle Database in Azure Cloud

So, what’s up? In case you don’t know, my co-worker Gleb Otochkin has written a couple of blog entries about HugePages’ support in different cloud providers here and here. Given that I am preparing a presentation about HugePages, I reached…

Read More >

Oracle DBSAT Discoverer Feature

Oracle’s Database Security Assessment Tool (DBSAT) is a nice and powerful free tool that performs Database and OS Security Audits and provides recommendations based on the findings. The tool and documentation can be downloaded from the following Oracle link (although…

Read More >

Oracle Parallel Query Hints Reference – Part 5: PQ_DISTRIBUTE_WINDOW

Welcome to Part 5 of the series. First, some background: if you want to skip to the reference part, scroll down. This hint was introduced relatively recently – in Oracle 12.1 – where for the first time, SQL Windowing functions are…

Read More >

Oracle Parallel Query Hints Reference – Part 4: GBY_PUSHDOWN

Welcome to Part 4 of the series. The GBY_PUSHDOWN is a very interesting hint, introduced in 10.2 – it doesn’t have the PQ prefix, but nevertheless plays a crucial role in Parallel query plans. Purpose: When GBY_PUSHDOWN is activated, an…

Read More >
Page 1 of 15212345...10...Last Page »