This posting covers the Middleware Management sessions at OOW2015. Note that these are middleware management via Enterprise Manager, as opposed to sessions specifically covering middleware features and functions. Also, I have not duplicated here sessions I have already documented under Oracle Management Cloud or Private Cloud / DBLM, so please visit those posts for sessions that fall under both categories. The following sessions fall under this category:
- The Management of Identity and Access: Breaches, (more...)
This posting covers the Database Manageability sessions at OOW2015. Note that these are database manageability via Enterprise Manager, as opposed to sessions specifically covering database features and functions. The following sessions fall under this category:
- Risk-Free Administration for Expert Database Administrators [CON9725] October 26, 4:00 pm – 4:45 pm | Moscone South—104 – The SPA Quick Check, SQL Performance Analyzer, Database Replay, and Concurrent Replay features in Oracle Real Application Testing provide a cost-effective and (more...)
REST or "Representational state transfer" to give it it's full name has been around for a while, i hear lots of people talking about it but to be frank i don't really have a clue what it's really about.
I tried to find a simple explanation by searching the net but couldn't really find one that just explained it in simple terms so i gave up.
Even the 'simple' wikipedia link didn't seem (more...)
Yesterday I posted an entry on what was coming with OOW2015, specifically discussing the Oracle Management Cloud sessions. This post is similar but looking at one of the more “traditional” EM areas that my team is responsible for – Private Cloud and DBLM. The sessions that are of most interest here are:
- Hybrid Cloud Management Using Oracle Exalogic [CON9744] October 26, 11:00 am – 11:45 am | Intercontinental—Intercontinental B (5th Floor) – The latest version (more...)
Delphix Express is available!
Delphix Express is a free version of Delphix
Delphix Express differs from Delphix enterprise in that it is limited to 25 GB of managed storage.
To get a copy of Delphix Express go to
and put “Express” for your title and I’ll send you the download info.
Here is a video on installing Delphix Express on VMware fusion on my Mac.
Delphix Express can also (more...)
On 10 December 2015 I’ll give an online training entitled Oracle Database 12c – New Performance Features. This short post provides key information about it.
With every new release of Oracle Database, a number of features aimed at improving performance are introduced. It goes without saying that 12.1 is no exception to the rule. Notably, it introduces key improvements in three areas.
- The query optimizer has been enhanced not only by the introduction (more...)
Here’s a little note that I drafted (according to its date stamp) in January 2013 and then forgot to post. (Which adds a little irony to the title.)
Here’s an object lesson in (a) looking at what’s in front of you, and (b) how hard it is to remember all the details.
I ran a script today [ED: i.e. some time early Jan 2013] that I’ve have no problems with in earlier (more...)
I did a workshop at ECO 2015 today. It was a lot of fun. I’ve done numerous presentations on SQL Profiles, SQL Patches and Baselines in the past, but this session was a no-slides, hands on demo of some of the scripts I use. I also showed some scripts that can be used to re-write SQL on the fly using a new feature of 12c called SQL Translation Framework. Here is a zip file that (more...)
Hard as it is to believe, yet again it is time for the biggest Oracle conference on the planet (or any other planet for that matter!) Yes, OOW2015 is just around the corner! Unfortunately I won’t be there this year, as I have my eldest daughter’s wedding shortly after it, but nevertheless having seen what’s coming up from the Enterprise Manager side of the house, there are a few sessions I can certainly recommend.
Wow – 5 years have flown by. Five years ago I joined Delphix and five years ago Delphix began the virtual data industry. Like all successful technologies many other vendors have come into the domain. Delphix for me is amazing compared to other virtual data solutions. Delphix is easy, fast and powerful. Check out this video of linking to a RAC database and provisioning a thin clone RAC database. How much work would it take to do the (more...)
Yesterday I thought I’d spend half an hour before breakfast creating a little demonstration of a feature; some time about midnight I felt it was time to stop because I’d found enough bugs to drive me up the wall. Today’s short post is just little warning: be VERY careful what you do with the PL/SQL result cache – if you use the results of database queries in the cache you may end up with inconsistent (more...)
By default, a Replicat process ABENDS when the data being modified doesn’t exist in the target database. Learn how to troubleshoot Oracle GoldenGate Using Exception Handler mechanism. When this happens you need to troubleshoot the issue and correct it before the Replicat process can proceed. But this wouldn’t be easy, as sometimes it can take […]
The post Troubleshoot Oracle GoldenGate Using Exception Handler appeared first on VitalSoftTech.
I’m lazy when I connect to the database, especially on my laptop. Anything that saves a few keystrokes I’m keen on
So rather than type “sqlplus username/password@database” I like to take advantage of a wallet
In my private sqlnet.ora, or the global one if it makes sense to do so, I add the details of wallet
This tells Oracle, that when I begins a connection to the database, we will (more...)
In the previous article I explained that the main requirement for high-speed in-memory data scanning is column-oriented storage format for in-memory data. SIMD instruction processing is just icing on the cake. Let’s dig deeper. This is a long post, you’ve been warned.
I will cover full test results in the next article in this series. First, let’s look into the test setup, environment and what tools I used for peeking inside CPU hardware.
I’m a little late to the party here, but I’ve finally got round to updating the VirtualBox 12c RAC article for Oracle Linux 7.
It’s not hard to do these VirtualBox RAC installations, but I find the process of putting the articles together really tedious. There are so many screenshots. That’s why it’s taken a while to build up the motivation to (more...)
Last night was the big server move. According to my monitoring, the site went down at approximately 23:30 GMT last night and was back again by 01:30 GMT this morning, so the site was offline for about 2 hours.
Everything looks normal to me this morning, so it I guess the move of my server between the racks in their data centre went OK.
Site Maintenance (20th Sept 2015 22:00 GMT) : Update was (more...)
In the last post I presented steps to create Virtual Machine using Vagrant with Virtual Box. It is a native combination but there are other possibilities as well. This post will cover an integration of Vagrant tool with KVM hypervisor and AWS EC2 cloud.
In both cases, an additional plugins has to be installed:
- vagrant-libvirt plugin for KVM - https://github.com/pradels/vagrant-libvirt
- vagrant-aws plugin for EC2 - https://github.com/mitchellh/vagrant-aws
If there is a (more...)
Just a quick heads-up about some work going on tomorrow on the website.
My hosting provider has decided my server needs to be put into a new rack, so somewhere after 22:00 GMT tomorrow (20th Sept 2015) the server will be switched off, moved to a new rack and switched on. They say the process should be complete within 4 hours. I’m hoping this is a massive overestimate.
If you are trying to use the (more...)