When inserting data into the database, it is occasionally forgotten (especially by English-speakers) that we need to take steps to ensure we are inserting data correctly and without unexpected character translation.
For example, in SQL*Plus we need to ensure we set the NLS_LANG environment variable to the correct setting for our database before we initiate SQL*Plus.
Here’s a quick example showing what can go wrong:
[oracle@ORA122 ~]$ echo $NLS_LANG
[oracle@ORA122 ~]$ sqlplus neil/neil
SQL*Plus: Release (more...)
Upgrading is always stressful – be it a computer, an Oracle database or an iPhone. There’s always a good chance for lost data and lost time dealing with complications.
So yesterday I picked up a new iPhone 7 from Verizon. The pickup was seamless. I had signed up for an upgrade program when I got the iPhone 6, so now I just walked in, gave them my old iPhone 6 and they gave me an (more...)
This is the presentation for Rapid Cluster Computing with Apache Spark session I did in Oracle Week few weeks ago.
I wrote about the Oracle Week conference in a previous post so I won’t go over that again – this was my 3rd session of that week.
Although Oracle Week was for years about Oracle related products, this year they decided to open it up for other technologies as well. They had NoSQL sessions, Hadoop (more...)
12 Days of #Cloud: Day 8 It is very easy to stand up a new DBaaS instance as a replica or clone of an existing instance. In this demo, I am going to create a new instance as a copy of CLDB4ACED DBaaS instance. First, need to create a snapshot using the DBaaS instance menu. […]
We’re being asked to store more and more data, yet keep backup windows, query performance and the like unchanged, no matter how much we store. As a result, more and more database shops are needing to partition their data. The problem is – partitioning data is a significant restructure of the data, which thus incurs a large outage and the accompanying planning and coordination.
Unless you’re on 12.2.
Here’s a demo where we can (more...)
I finally managed to install and test patch 22652097 (PROVIDE SEPARATE CONTROLS FOR ADAPTIVE PLANS AND ADAPTIVE STATISTICS FEATURES). Actually, I installed and tested two patches. The first was installed on top of “Oracle Database Patch 23054246 – Database Patch Set Update 220.127.116.11.160719” (from now on, 18.104.22.168.160719 PSU). The second was installed on top of “Patch 24448103 – Database Proactive Patch 22.214.171.124.161018” (12. (more...)
“Don't you know anything at all about numbers?"
"Well, I don't think they're very important," snapped Milo, too embarrassed to admit the truth.
"NOT IMPORTANT!" roared the Dodecahedron, turning red with fury. "Could you have tea for two without the two — or three blind mice
without the three? Would there be four corners of the earth if there weren't a four? And how would you sail the seven seas without a seven? (more...)
All I want for Christmas is VirtualBox 5.1.12…
Downloads and changelog are in the usual places.
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.
was first (more...)
For people interested, here the slide desks used internally to debrief my colleagues regarding Oracle…
Here the presentation slide deck (100+) used during the oGH Dutch Usergroup session and (partially…
The internet is full of information about indexes, and for a reason. Indexes in a database is probably the most important performance related topic. There are so many cases, properties, and different ways to use indexes that there is simply a lot to write about. In this post I’d like to talk about a specific … Continue reading Scanning an Index
In the past I gave a number of 1-day seminars about the new performance features available in Oracle Database 12c Release 1. On the 23rd of January, for the first time, I’ll give an updated version of that seminar with content about both Release 1 and Release 2. Note that because there is more content, I extended it from one day to two days.
The seminar in January is a Live Virtual Class organized by (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:
Run omsca in recovery mode specifying the export file taken earlier to configure the OMS:
<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...)
12 Days of #Cloud: Day 7 There are three types of storage expansion possible on Oracle #DBaaS instance. 1. Increase Default File Systems Increasing the default file systems that hold data files (/u02), FRA and backup (/u03) is easy. These file systems can be increased by using the menu item “Scale Up / Down Service” […]
For the last couple of years I’ve been involved in “Oracle Scene”, the UKOUG magazine about all things Oracle. Click the link to see the current edition, which is free to view to everyone, member of the UKOUG or not.
I take of my OS hat – and they give me one to keep
I first became involved by writing an article for Oracle Scene. In fact it was the first thing I’d written (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...)