The traffic on the way to Oracle Midlands Event #9 was a complete nightmare! There are a bunch of roadworks around the city that are making the traffic movement really problematic at the moment. Added to that, the always slow M6 was causing tailbacks along the Aston Express Way into the city. The traffic islands were all blocked, with people blocking exits and jumping red lights in a desperate attempt to get on them. Fortunately (more...)
I encouraged one of my former colleagues to start writing a blog (SnapDBA). He had lots of notes he had built up over the years, so he started to transfer some of them to his blog and described these notes as “backfill”. He used the term to indicate it was not a particularly new subject, but he wanted to write about it anyway.
Especially when you become more popular, it is easy to get a (more...)
The capabilities of Delphix can be differentiated from snapshot technologies through the following hierarchy:
- Data as as Service (DaaS) (Delphix approach to data management)
- Virtual Data (end-to-end collection and provisioning of thin clones)
- Thin Cloning
- Storage Snapshots
A question I get asked fairly often when I’m at conferences, either during the Q&A for my sessions or in general chit chat (a.k.a. networking) afterwards is “I want to play around with the features in Enterprise Manager 12c but don’t want to do that in our Production environment. How do I go about installing a copy of Enterprise Manager 12c somewhere else in the easiest way as a test environment?” The (more...)
I’m pleased to say that I will be speaking at the UKOUG Systems Event 2015, held at Cavendish Conference Center in London, 20 May 2015. My session “Oracle Exadata Meets Elastic Configurations” starts at 10:15 in Portland Suite. Here is the agenda of the UKOUG Systems Event.
In a month time I’ll be also speaking at the Spring Conference of the Bulgarian Oracle User Group. The conference will be held from 12th to 14 (more...)
This is going to be a very short post for a change. I have used Swingbench extensively and really love the tool. Many thanks to Dominic Giles!
Recently he announced a new tool on his blog that you can use to inflate your data volume. So instead of using the “-scale” argument when executing oewizard you can just keep the defaults and later on create as much data as you like. Here is an example, (more...)
Tim Hall has written some brilliant posts about getting going with writing (blogs, whitepapers etc). This post is the result of inspiration from there only. Tim says that just get started with whatever .
If you are into blogging and no so active or even if you aren’t you may want to take a look at all the posts to get some inspiration to document the knowledge you gain on day to day basis.
Here is (more...)
Which of these describes you?
- Drive up to the barrier.
- Open the car window.
- Rummage through your bag or glove compartment looking for your parking pass.
- Swipe your pass.
- Put your card away. Probably in a random place each time.
- Pull away from the barrier.
- Approach the barrier with your card in hand and the car window already open.
- Swipe the card immediately.
- Pull away, almost without stopping because you were so (more...)
The true answer to this is to write as (in)frequently as you want, but in my motivation post I suggested writing little and often. I think this is really important when you first start. Like anything, writing takes practice. It takes a while to get into the right head-space and even longer until you are happy with the way you express yourself. I imagine that is even worse if you are trying to writing in a second (more...)
Disclaimer: I am not being paid by anyone to write positive or negative review.
Opinions are my own based on my limited engineering background.
First, packaging is somewhat poor and could be much better for a desk costing close to $1,000 ($886 for my configuration).
Tape coming off.
I hope my desktop is okay.
Taking a look inside. Is that a tiny scratch I see?
After opening the desktop, this is the torn location – (more...)
When you need to have information about one SQL_ID and don’t need everything and the kitchen sink, there are a few different ways to collect this via Oracle. I’m surprised how rarely this is covered in performance tuning/optimization, (whatever the current “acceptable” term is for fixing a database when there are performance issues arise… J) classes, manuals and documentation. I’d like to cover two of my favorite here and know, there are other options (more...)
Working with Oracle often involves fixing things – not because of the Oracle software (well, occasionally it is) but because of how it is used or the tech around it. Sometimes the answer is obvious, sometime you can find help on the web and sometimes you just have to sit on the issue for a while. Very, very occasionally, quite literally.
Last week I was in the English Lake District, (more...)
I received an email recently describing a problem with a query which was running a full tablescan but: “almost all the waits are on ‘db file sequential read’ and the disk read is 10 times the table blocks”. Some further information supplied was that the tablespace was using ASSM and 16KB block size; the table had 272 columns (ouch!) and the Oracle version was 126.96.36.199.
In his researches he had (more...)
"There is much worth noticing that often escapes the eye." - Norton Juster, The Phantom Tollbooth
Using BULK COLLECT in PL/SQL blocks and procedures can drmatically speed array processing, but it can, if the DBA isn’t prepared, ‘hide’ any errors that occur in the bulk processing list. A ‘plain vanilla’ EXCEPTION handler may not report all errors that are thrown. Let’s look at an example intentionally set up to fail inserts based on data (more...)
Here’s a quick reminder of a couple of events happening this week.
On Tuesday evening it’s Oracle Midlands Event #9 in Birmingham. First up is Joel Goodman, who is practically a walking Oracle Encyclopaedia, speaking about “Oracle Distributed Transactions”. Next up is Richard Harrison, a regular Oracle Midlands attendee and returning speaker, this time presenting about “Data Pump Tips & Tricks”. It’s going to be a good evening, so please come out and show your support! It’s (more...)
The answer to this is very much dependent on the content and context of the material. If you have said something really bad in a legal sense, then you should definitely consider deleting it, or deal with the consequences. Assuming we are not talking about those naked pictures of you at a stag/hen party, what do I think?
I do rewrite old articles if I’m sufficiently motivated by a drastic change in my understanding of (more...)