alter table source_data add clustering by linear order(object_id);führt zu einem erfolgreichen Clustering, während das Kommando:
alter table source_data clustering by linear order(object_id);
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...)
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 184.108.40.206.160719” (from now on, 220.127.116.11.160719 PSU). The second was installed on top of “Patch 24448103 – Database Proactive Patch 18.104.22.168.161018” (12. (more...)
A few weeks before the first ever Oracle sponsored Maker Faire, I was experimenting with some of the cognitive (vision) recognition APIs available. Google Vision API, Watson Visual Recognition and Microsoft Computer Vision API are some of the biggest players in this field right now.
“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...)
Sure it's in the documentation, but not listed under new features.
|Where to find declarative favicon setting in APEX 5.1|
Amanda for APEX 4.2;
Christian if you're still using APEX Listener;
Now we have an dedicated attribute. Neat.
I've always thought APEX does a really good job of leaving our applications alone during upgrades. It normally depends on how much the boundaries have been pushed, and how much the theme (more...)
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 corresponding My Oracle Support Note 2216342.1 can be found here: https://support.oracle.com/epmos/faces/DocContentDisplay?id=2216342.1
In the GitHub Repository of Oracle the related README is also updated to reflect the support for Oracle Database 22.214.171.124.0 and later on Docker.
All required files to build such a supported Oracle Database Instance on Docker can be found here: https://github.com/oracle/docker-images/tree/master/OracleDatabase
Little reminder :
bpel file uses the next :
xsl file used to be using the next :
<xsl:variable name="dossier" select="dvm:lookupValue ('../Dvm/actie.dvm', 'sourceActie', /ns0:notificatie/ns0:entiteit, 'targetActie', 'ongeldige actie mapping' )"/>
this will fail (the location of the dvm file isn’t relative to both the .bpel file and the .xsl file), correct path to the dvm file will be
<xsl:variable name="dossier" select="dvm:lookupValue ('Dvm/actie.dvm', 'sourceActie', /ns0:notificatie/ns0:actie, 'targetActie', 'ongeldige actie mapping' (more...)
Some of the results were presented at the Swedish Oracle meetup in Summer '16. But the final application was made for DOAG 2016.
What leads me (more...)