All I want for Christmas is VirtualBox 5.1.12…
It’s a maintenance release, containing lots of lovely bug fixes, mince pies and eggnog.
I’ve only done the installation on my Windows 7 desktop at work, which was fine. I’ll do the macOS and Oracle Linux 6 installs when I get home and update this post with the results.
VirtualBox 5.1.12 was first (more...)
The Enterprise Manager AWR Warehouse is designed to hold performance data from multiple databases for long-term analysis. It promoses that it will save storage and improve performance on your production systems. In that it is indeed correct. However the warehouse itself does not seem to be performant when taking in multiple sources and retaining them long-term – 400 days in our case. Why 400 days is an obvious question that might be asked. Primarily because (more...)
I spent some time on two totally unrelated things at the weekend.
Old Database Sessions
We’ve been having some problems with old database sessions recently. One of our reporting servers seems to grab loads of sessions and just not let go. In many cases they seem to remain active for a long time, while doing trivial tasks. My first thought was it was a problem with the database, but there doesn’t seem to be any evidence (more...)
This is the presentation for Oracle Advanced PL/SQL session I did in Oracle Week 2016, a few weeks ago.
I wrote about the Oracle Week conference in the previous post so I won’t go over that again…
This presentation was all about PL/SQL. Most of it are things that are quite some old, but for some reason people seem to miss out on them. The presentation is divided into 3 parts.
The first one is (more...)
In the official backup and recovery documents of Oracle Enterprise Manager Cloud Control, when omsca tool is used for recovery, it is used with “-as” and “-ms” parameters but they are not well documented. For example:
<OMS_HOME>/bin/omsca recover –as –ms –nostart –backup_file <exportconfig file>
Some parameters have no need any explanation but what are “-as” and “-ms”? Can we use (more...)
In my previous 2 blogposts i explained how to setup a Vagrantfile that deploys 2 virtualbox machines that can be used as a basis for a RAC cluster and how you could use Ansible to deploy RAC on those VM’s. In this post i want to dive a bit deeper into how i setup Ansible and why, keep in mind that this just one way of doing this.
The Github repository containing all the files (more...)
I am currently interested in managing storage on our Exadata platform which is primarily used for running a data warehouse.
The ongoing challenge is that most of the large tablespaces use a bigfile datafile and we insert data using append. That causes data gaps within the datafile and it is constantly growing. A recent example showed a 7Tb datafile containing only 2Tb of data and yet the ASM diskgroups were reporting we were running out (more...)
I added a few larger updates to my Oracle Image Copy backup scripts.
- Now it also has built in support for Netapp NAS storage
- In addition to autorestore script there now is restore.py script that you can use to spin off cloned databases restored to a specified point in time
This is the presentation for Oracle Advanced Querying session I did in Oracle Week few weeks ago.
Since most of my readers aren’t from Israel, let explain a bit about this event. Oracle Week is by far the biggest Oracle oriented conference/event in Israel. It’s a 5 days conference that is being organized by John Bryce Education (a technology schooling company) and has around 1500 participants each year. It’s an educational event – meaning, as (more...)
I was having a play around with Fedora 25 last weekend and I just noticed there was no associated blog post about it, so here goes.
First the warning I always have to include. Do not install Oracle on Fedora before reading this! With that out of the way, let’s continue.
Since Fedora is the proving ground for future releases of Red Hat Enterprise Linux (RHEL) and I’m a fan of running Oracle on (more...)
You log in to your favorite web app and it takes a little while to get your login validated, or your password consumed, depending on your take on things,
You log in to your favorite APEX application, and after every 3rd shot, it takes a bit longer to retry
You are sure what you are doing and you are surely not drunk, but just mistyped the ****-password.
It is annoying, but is it?
We recently undertook a two-week Proof of Concept exercise for a client, evaluating whether their existing ETL processing could be done faster and more cheaply using Spark. They were also interested in whether something like Redshift would provide a suitable data warehouse platform for them. In this series of blog articles I will look at how we did this, and what we found.
The client has an existing analytics architecture based primarily around Oracle (more...)
I’ve recently been involved in quite a few database migrations to Oracle RDS. One thing that I had noticed when dealing with post-migration performance issues was related to queries that used
TABLE SCAN FULL in their execution. It seemed, that in many cases, it just took a single query to max out the allocated IOPS (IOs per second) or bandwidth, which in turn would caused overall slowness of the RDS instance.
The search in documentation (more...)
It’s time to announce the next webinar in the Gluent New World series. This time I will deliver it myself (and let’s have some fun :-)
Richard Foote has published a couple of articles in the last few days on the new (licensed under the advanced compression option) compression mechanism in 12.2 for index leaf blocks. The second of these pointed out that the new “high compression” mechanism was even able to compress single-column unique indexes – a detail that doesn’t make sense and isn’t allowed for the older style “leading edge deduplication” mechanism for index compression.
In 12.2 (more...)
So the conference season is all over for another year. I have had a bumper crop of conferences and have been a very lucky man to attend and present and learn.
This is one of those posts where my hat comes off as a previous Oracle employee, same with my Delphix hat. I am here only as a board member and representative of my Oracle REGIONAL user group community and have a bone to pick with a few people at Oracle.
I’ve been the conference director for Rocky Mountain Oracle User Group’s, (RMOUG) Training Days conference since 2012. This (more...)
The time has come for me to plan the upcoming 2017 UKOUG Special Interest Groups.
I am chairman of the RAC, Cloud, Infrastructure and Availability (RAC-CIA) SIG and I’m after presentations for the 3 joint SIGs we will be putting on with the RDBMS SIG, plus the stand-alone SIG will we will having in the autumn.
A SIG is a single day one-or-two stream conference which we take around the UK to make it (more...)