Shooting the DBA isn’t a Silver Bullet to the Cloud

We’ve all been watching numerous companies view value in bypassing the Database Administrator and other critical IT roles in an effort to get IT faster to the cloud.  It may look incredibly attractive to sales, but the truth of it is, it can be like setting up land mines in your own yard.

Having the right people in the right roles, doing the right tasks is essential to having a complete cloud deployment.  (more...)

UKOUG Tech17 : It’s a Wrap!

Just a quick reflection on the UKOUG Tech17 event…

Here are the posts I wrote over the event.

Things went pretty well for me this week. My timetable allowed me to come for two full days, which was nice. It’s a lot less stressful when you are not trying to (more...)

Fusing blobs in Azure…….



If you're reading this as a DBA you might be thinking i've written some plsql code to combine to blob column values into one - you'd be sadly mistaken what I'm actually going to talk about is this thing

https://azure.microsoft.com/en-us/blog/linux-fuse-adapter-for-blob-storage/

What this enables is the mounting of azure blob storage directly as a unix 'filesystem'. Now azure file storage can already be done using the tried and trusted smb protocol (samba) and we (more...)

UKOUG Tech17 : Wednesday

Wednesday started with a quick trip to the doctor, then I got a bus into town for the conference. I kept bumping into interesting people and chatting, so I didn’t manage to get to any of the early sessions.

I missed picking up my Best UK Speaker award and the group photo yesterday, so I picked it up today and did a photo with Linda and Jennifer, two of the ladies that keep the Oracle ACE (more...)

UKOUG Tech17 : Tuesday

Tuesday was a work day for me, so I was in work until the late afternoon, then left for the conference to do my APEX session. A little while later I was sitting in traffic thinking, “I’m not going to make it!” The traffic opened, I got a parking spot really quickly and I made it with 3 minutes to spare… 🙂

The session was based around API first development for APEX. I was quite (more...)

I went to a conference – and all I can post about is this picture

I was on DOAG and UKOUG conferences this year and hold some presentations there.
Of course I attended even more presentations and learned a lot of new things.
But I did not blog about it for some good reasons:
The presentations I attended are done already. Which means the presenters did a lot of research and put it all into great presentations and abstracts - so why should I create a weak copy of their (more...)

UKOUG and Microsoft Marathon Webinar

I’m here for the last day of UKOUG Tech17 and it’s been an awesome event.  This is my first time to this event while in Birmingham and although quite the party town on the weekends, its a great city to have an event like UKOUG’s trio of events during the week.

I was welcomed to great turnouts to both my presentations and then enjoyed numerous sessions by other’s, such as Richard Foote, Jonathan (more...)

Adaptive Query Performance Fixes for #DB12c Release 1

We all know adaptive query feature introduced in Oracle Database Release 1 is a problem. Recently I had the opportunity to review few 12cR1 databases and found that to alleviate the performance problems, the DBA set parameter OPTIMIZER_FEATURES_ENABLE=11.2.0.4 in Oracle Database 12c Release 1 (12.1.0.2). This observation is the catalyst for the blog “Adaptive Query […]

Impdp Resumable Mystery

Resumable operations are operations that can be suspended instead of failing, allowing us to fix the problem and resume the operation. When importing data using impdp, if (for example) a tablespace gets full, instead of failing the entire import (and force us to restart it from the beginning), we can identify that and add some … Continue reading Impdp Resumable Mystery

UKOUG Tech17 : Monday

I couldn’t face the traffic, so I walked to the station and got the train into town. I got to the event in time for the first sessions, but got waylaid meeting people, so the first session for me was the morning keynote, where I got my 30 seconds of fame as they announced the speaker awards.

After the keynote I grabbed a drink and went to watch “Flashback Features in Oracle Database” by Connor (more...)

Oracle Tidbits – November 2017 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in November 2017. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use. […]

SQL Server 2017 on Linux- Processes

So while finishing up my slides for the Microsoft Pass Linux Marathon webinar on Dec. 13th, Tim and I started to discuss the apples vs. oranges comparison of SQL Server on Linux process management vs. an Oracle instance.

We discussed the differences one might expect to see using different tools with the two database platforms and the first question surrounded information pmap would provide.  We commonly use pmap to map out processes, including child (more...)

Goldengate 12.3 Automatic CDR

Automatic Conflict Detection and Resolution

Requirements: GoldenGate 12c (12.3.0.1) and Oracle Database 12c Release 2 (12.2) and later.

Automatic conflict detection and resolution does not require application changes for the following reasons:

  • Oracle Database automatically creates and maintains invisible timestamp columns.
  • Inserts, updates, and deletes use the delete tombstone log table to determine if a row was deleted.
  • LOB column conflicts can be detected.
  • Oracle Database automatically configures supplemental logging on required (more...)

UKOUG Tech17 Dec 3rd-6th

I love the UKOUG Tech conferences, but then I’m biased. It was the first conference I spoke at a few years ago, but I’ve been going to see UKOUG events since the mid 1990’s. At my first event there was a DBA talk about VLDB – the database was 40GB and growing at 1GB per month. We were all amazed at the huge size of the database!

This year I was the lead putting together (more...)

Creating a SQL Plan Baseline from Cursor Cache or AWR

A DBA deals with performance issues often, and having a SQL suddenly performing poorly is common. What do we do? We proceed to “pin” an execution plan, then investigate root cause (the latter is true if time to next fire permits).

DBMS_SPM provides some APIs to create a SQL Plan Baseline (SPB) from the Cursor Cache, or from a SQL Tuning Set (STS), but not from the Automatic Workload Repository (AWR). For the latter, you (more...)

#Accenture #Enkitec Group at #ukoug_tech17

The circus moves on to Birmingham again! You know that this is one of the must-be-there events of the Oracle community, right?

The Accenture Enkitec Group is there with 6 speakers:

Jason Arneil with two talks: Beginners Guide to Oracle IaaS Cloud and An Introduction to Sharding

Martin Bach: The Answer to the Ultimate Question of SQL, Performance Tuning & Everything

Andy Colvin: Deploying Exadata Cloud Machine – What’s it Really Like?

Frits (more...)

Moving SYSAUX from one diskgroup to another

Introduction

This is another of the posts on how I did something to remind me how to do it again, when next the need arises. 🙂

Situation here was a customer who was running out of space in their Production database due to the unified audit trail bug in early versions of 12.1. Their SYSAUX tablespace had blown out to 186 GB, and their ASM diskgroup had run into negative space territory (i.e. if (more...)

Enters Amazon Aurora Serverless

More often than not, database administrators around the technologies have to fight out high load on their databases. It could be ad hoc queries, urgent reports, overflown jobs, or simply high frequency and volume of queries by the end users.

DBAs try their best to do a generous capacity planning to ensure optimal response time and throughput for the end users. There are various scenarios where it becomes very hard to predict the demand. Storage (more...)

Raising a RHEL support request in Azure



We've been using RHEL machines in Azure for a while now but had no cause to actually make use of the support option we're paying for with the licence/support included images we are using.

So how do you do this?

Well it's all integrated into the portal and on the VM screens you get a nice extra button - see pic below (one from bottom)

Clicking this then takes you to this screen

If you (more...)

UKOUG Tech 2017

Its been a couple years since I presented at UKOUG.  After taking last year off to prioritize some projects with Delphix, I’m back to speaking and the event committee was gracious enough to offer a goth girl a couple spots on the schedule this year.

The event is in Birmingham, and although I’ve never been there, I’m told by reports, it’s rather rainy and cold this time of year, so I better prepare, (nothing (more...)