AWR Warehouse

AWR Warehouse is a central repository configured for long term AWR data retention. It stores AWR snapshots from multiple database sources. Increasing AWR retention in the production systems would typically increase overhead and cost of mission critical databases. Hence, offloading the AWR snapshots to a central repository is a better idea. Unlike AWR retention period of default 8 days, the AWR Warehouse default retention period is "forever". However, it is configurable for weeks, months, or (more...)

Schema Consolidation – Setup

Schema as a Service provides database consolidation by allowing administrators to host multiple application schemas within a single database. This offers Database as a Service to possibly hundreds of application users without creating database sprawl. Users can perform day-to-day actions like provisioning, monitoring, and backup, all from a single Self Service console. Schema as a […]

New AWR Report Format: Oracle and 12c


This is a post about Oracle Automatic Workload Repository (AWR) Reports. If you are an Oracle professional you doubtless know what these are – and if you have to perform any sort of performance tuning as part of your day job it’s likely you spend a lot of time immersed in them. Goodness knows I do – a few weeks ago I had to analyse 2,304 of them in one (long) day. But for anyone (more...)

Delphix 4.1 releases! Oracle 12c PDBs, Sybase, Amazon AWS and Developer Jetpack

Delphix 4.1 just came out last week. It may sound only like a point release but there is an amazing amount of new technology:

I’m most excited about Amazon AWS support, Oracle 12c PDB support and developer jet pack , aka Jetstream. More coming on these features in upcoming blogs.

AWS (more...)

Plagiarism and Posting

I received an interesting question as a comment on another post (which I’ll approve as soon as I post this one) and I thought it was interesting enough to add a completely separate post on my thoughts. In essence, the comment was along the lines of this: “With so much content and articles do you […]

Say Hello To Oracle Linux 7.0….

Seems like it’s going to be a week of new releases only. Last night only, I downloaded and installed Oracle database 12c patchset(12102) and today, Oracle Linux’s latest release OL7 is released. The download is available from E-Delivery portal and mine is going on. I don’t think it would take long before 12c would be certified for Oracle Linux 7 but I would do the installation of both, database and Linux, as soon as my (more...)

The Customer Experience

The Apple Experience

I’m going to kick this post off by taking sides in a long-standing feud.

Apple is amazing.

There. Edgy, right? Okay, so maybe you don’t agree with me, but you have to admit that a whole lot of people do. Why is that?

NOT part of the Customer Experience. Image from

Image from

Sure, there’s the snarky few that believe Apple products are successful due to an (more...)

EID Holidays and things to do

Looking forward to a much anticipated 9 day EID holiday break to complete the to-do-list which I have been carrying for a while now. Determined to complete some of the writing assignments that I have kept pending for a long period of time now. At the same time, will have to seek the possibilities to exploring the new features of v12.1.0.2 and Exadata as we might we going for the combination in (more...)

Oracle Database 12c Release 1 ( New Features

1. Advanced Index Compression

Advanced Index Compression works well on all supported indexes, including those indexes that are not good candidates for the existing prefix compression feature; including indexes with no, or few, duplicate values in the leading columns of the index.

Advanced Index Compression improves the compression ratios significantly while still providing efficient access to the index.

2. Approximate Count Distinct

The new and optimized SQL function, APPROX_COUNT_DISTINCT(), provides approximate count distinct aggregation. Processing (more...)

12c Threaded Execution Test

I did a quick check of some facts I’m studying about Oracle 12c and its new threaded execution mode.  I set this parameter:

alter system set THREADED_EXECUTION=true scope=spfile;

I had to connect SYS as SYSDBA with a password to get the system to bounce.

Then it had these processes only:

oracle    1854     1  0 09:17 ?        00:00:00 ora_pmon_orcl
oracle    1856     1  0 09:17 ?        00:00:00 ora_psp0_orcl
oracle    1858     1  2 09:17 ?        00:00:00 ora_vktm_orcl

REGEXP_LIKE: strange unspecified value in parameter “modifier”

Today I noticed strange thing in predicate section of execution plan for simple query with regexp_like, where was not specified 3rd parameter “MODIFIER”:

SQL> select * from dual where regexp_like(dummy,'.');


SQL> select * from table(dbms_xplan.display_cursor);

SQL_ID  97xuqf9cmjsta, child number 0
select * from dual where regexp_like(dummy,'.')

Plan hash value: 272002086

| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |

That’s … Huge!

Recently I’ve noticed the occasional thread in Oracle newsgroups and lists asking about hugepages support in Linux, including ‘best practices’ for hugepages configuration. This information is out on that ‘world-wide web’ in various places; I’d rather put a lot of that information in this article to provide an easier way to get to it. I’ll cover what hugepages are, what they do, what they can’t do and how best to allocate them for your particular (more...)

Oracle 12c( Has Arrived….

Just checked Tim’s latest post and guess what, Oracle database 12c’s latest release, is available now for download. It is available as an OTN download as well as from E-Delivery. Seems like that there is no documentation update available yet as the New Features guide still doesn’t have included in it. But I am sure that it’s coming soon!

So grab your copy now and happy downloads :=).

Oracle Database – New Features

The world around us is changing and new stuff in the Oracle database arena is nowadays released on patch level. Although not many new features...

Read More

Oracle Database 12c Release 1 [] Patch Released

Oracle Patch 17694377 for Linux and Solaris has been released on Metalink and edelivery a few minutes ago. Happy upgrading!

The post Oracle Database 12c Release 1 [] Patch Released appeared first on VitalSoftTech.

Macros and parameter passing macros with #goldengate

Replicating data can be a time consuming process to setup.  Fortunately, Oracle GoldenGate provide a few tools to help ease the  complexity of setup.  One of these tools is the “macro”.  Macros are used to simplify and automate the work associated with setting up and replicating data.  So what exactly is a macro?  Oracle defines a macro as:

A macro is a built-in automation tool that enables you to call a stored set of processing (more...)

Using the Self Service Portal with PDBaaS in EM

Following on from my earlier blog post on setting up Pluggable Database as a Service (PDBaaS) in EM, this post will cover how you actually use the Self Service Portal to create on demand an empty pluggable database within the container database I created for that earlier post. You’ll no doubt be pleased to […]

Advance your career contest

Want to advance your career ?

We’ve seen DBAs become managers, managers become directors, directors become VPs and CIOs go from lesser known companies to some of the best known in the world. Why did they get promoted? Because they brought in Delphix.

Delphix increases the speed, the agility of IT often enabling development teams to go twice as fast, an increase that is unprecedented.

Companies that have this advantage will outperform the competitors.

How do you (more...)

Understanding and using tokens in Oracle #GoldenGate

Recently, I’ve been doing some work with a client where tokens need to be used.  It came to my attention that the basic usage of tokens is misunderstood.  Let’s see if I can clear this up a bit for people reading.

In Oracle GoldenGate, tokens are a way to capture and store data in the header of the trail file (more info on trail headers here).  Once a token has been defined, captured and (more...)

Implications of threaded_execution = true in 12c

I had an interesting discussion as part of my latest presentation at the UKOUG RAC CIA & Database Combined SIG. Part of my talk was about the implications of the new threaded execution model in Oracle.

Since “we do not use Windows” (except for gaming) I can’t compare the Windows thread model to the new 12c implementation on UNIX. There are however interesting implications when switching to the new model, some of which I’d like (more...)