Oracle Midlands : Event #9

oracle-midlandsThe 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...)

Writing Tips : Backfill

writingI 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...)

Oracle #DB12c New – PGA_AGGREGATE_LIMIT

Program Global Area (PGA) in Oracle database is a private memory region that contains the data and control information for a server process. PGA is allocated per server process, used for storing run-time area of cursor, sorting, bitmap merge, etc. Automatic PGA management in Oracle Database was managed by two parameters up until 11gR2 – […]

Delphix Data as a Service (DaaS)

The capabilities of Delphix can be differentiated from snapshot technologies through the following hierarchy:


Screen Shot 2015-05-19 at 4.39.57 PM
  1. Data as as Service (DaaS) (Delphix approach to data management)
  2. Virtual Data (end-to-end collection and provisioning of thin clones)
  3. Thin Cloning
  4. Storage Snapshots
On top we have the most powerful and advanced data management features that enable fast, easy, secure, audit-able data flow through organizations.
Screen Shot 2014-05-21 at 8.08.47 AM
DaaS is built on top of other technologies. On the bottom we have the minimal building (more...)

Installing Enterprise Manager 12c For Testing

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...)

Speaking at UKOUG Systems Event and BGOUG

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...)

If you use swingbench take note of sbutil

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...)

Writing tips

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 Winking smile.

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...)

Approaching a car park barrier : What it says about you!

parking-barrierWhich of these describes you?

Option 1:

  1. Drive up to the barrier.
  2. Open the car window.
  3. Rummage through your bag or glove compartment looking for your parking pass.
  4. Swipe your pass.
  5. Put your card away. Probably in a random place each time.
  6. Pull away from the barrier.

Option 2:

  1. Approach the barrier with your card in hand and the car window already open.
  2. Swipe the card immediately.
  3. Pull away, almost without stopping because you were so (more...)

Writing Tips : How often should I write?

writingThe 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...)

Indexing and Transparent Data Encryption Part I (The Secret Life of Arabia)

Database security has been a really hot topic recently so I thought I might write a few posts in relation to indexing and Transparent Data Encryption (TDE) which is available as part of the Oracle Advanced Security option. To protect the database from unauthorized “backed-door” accesses, the data within the actual database files can be encrypted. […]

First Impression for Evodesk Desktop Unboxing

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.

badpackaging2

I hope my desktop is okay.

badpackaging1

Taking a look inside. Is that a tiny scratch I see?

badpackaging3

After opening the desktop, this is the torn location – (more...)

SQL ID Specific Performance Information

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...)

Fixing my iPhone with my Backside

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.

Dreaded "out of battery" icon

Dreaded “out of battery” icon

Last week I was in the English Lake District, (more...)

Migrated rows

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 11.2.0.4.

In his researches he had (more...)

Perception Is Everything


"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...)

Roll up! Roll up! This week’s events!

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...)

Writing Tips : Should I go back and rewrite/revise/remove old posts?

writingThe 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...)

TIMESTAMP to DATE Conversion with Online Redefinition

Online redefinition is a great way to make structural change on "big" tables having "lots of" DML. Using online redefinition, partitioning-nonpartitioning, adding-dropping columns, changing column data types, moving to another tablespace and more can be done with a very small unavailability of the table when compared with direct operations.  Here are some online redefinition MOS notes which

Standby Database SCN – x$kcvfh

The case was to roll forward a physical standby with an RMAN SCN incremental backup taken from primary. The standby database was just restored and necessary archived logs was missing somehow (That's another story). It was something i already did in the past so we set to work with my previous notes. Took the backup, copied files to standby server and recovered standby database. But the problem