Performance Feedback Optionen in 12c aktivieren und deaktivieren

Christian Antognini erläutert in seinem Blog, welche Schwierigkeiten sich in 12c ergeben, wenn man das "Performance Feedback" aktivieren oder deaktivieren möchte. Zur Erinnerung: das Performance Feedback ist ein adaptives Feature und dient zur automatischen Prüfung, ob ein initial gewählter Parallelisierungsgrad tatsächlich vorteilhaft ist. Relativ harmlos ist bei der Konfoiguration noch der Faktor, dass sich der zugehörige Parameter in 12.1 OPTIMIZER_ADAPTIVE_FEATURES nennt, während er in 12.2 (bzw. auch in 12.1, wenn man den (more...)

Install Oracle’s VirtualBox

If you don’t have the luxury of having a server ready available but you want to do some research and development or training on Oracle, then Oracle’s VirtualBox is a perfect solution.


To be able to use VirtualBox, you need to disable Hyper-V as it blocks all other Hyper Visors from calling VT hardware.  See my post blog on how to do this:
Disabling Microsoft’s Hyper-V to use Oracle’s VirtualBox


You can download (more...)

Jarvis Pizzeria: Using the SOAP interface to start a Process

| Sep 26, 2017
We as old-fashioned SOA/BPM Suite developers, are used to test deployed services using tools like SoapUI. In this blog post, we will show you how to start a Process in the Oracle Process Cloud from the SOAP UI interface.
On premises with SOA or BPM we used to start by obtaining the required wsdl from the Enterprise Manager.
However, for PCS there is no such thing as an Enterprise Manager, so how do we get (more...)

Activating and Deactivating Performance Feedback

Performance feedback is one of the adaptive query optimizer features introduced in Oracle Database 12c. The aim of this short post isn’t to explain how it works, but to simply warn you about a buggy behavior in its configuration.

The parameters that control performance feedback are the following:

  • OPTIMIZER_ADAPTIVE_FEATURES (12.1 only): if set to TRUE (default), performance feedback is enabled. Otherwise, it is disabled.
  • OPTIMIZER_ADAPTIVE_STATISTICS (12.1 with patch 22652097, and 12.2): if (more...)

OOW is just around the corner

Originally posted on HeliFromFinland:
I cannot believe how fast time flies! It has been an exceptionally busy year and that is the reason I have not had time to write blog posts either. I have been speaking in amazing events like BIWA Summit, APEX Connect, Riga DevDays 2017, OTNEMEA Tour in Baku and in Madrid,…

News Regarding Post "bind csid (#) does not match session csid (#)"

Problem "bind csid (#) does not match session csid (#)"

After further investigation and analysis, here some more news regarding the problem with "bind csid (#) does not match session csid (#)"

I wrote: "Reason was - in my case - that an agent, which has connected to a freshly created clone of a production database a little to early, was stuck with an Character Set which was current at the time of the first connect. (more...)

PTC Windchill Success Story: Measuring so they can Manage


A large global customer planned to consolidate their many PTC data management systems into one global Windchill system. End user adoption was going to be a critical factor in a successful deployment and the Creo+Windchill system performance would be a key factor to facilitate end user adoption.  The Windchill team wanted a simple straightforward repeatable method to measure (more...)

Oracle Indexing Myths (Telling Lies)

I’m currently hard at work fully revising and updating my “Indexing Internals and Best Practices” seminar in time for a series of events I’ll be running in Australia in October/November. This has been a highly popular and acclaimed 2 day seminar that is a must for any DBA, Developer, Solutions Architect or anyone else interested […]

This is not an easy Job

According to Leading Clever People by Rob Goffee & Gareth Jones 

"If clever people have one defining characteristic, it is that they do not want to be led"

Well that is how I feel about my role in the EOUC Short Talks at Oracle Open World.

This year we have:

     EOUC Database ACES Share Their Favorite Database Things
     Sunday, Oct 01, 10:45 a.m. - 11:30 a.m. 

Drive down WebCenter Content Storage Costs with Oracle Hierarchical Storage Manager (Oracle HSM) and Oracle Cloud Archive

Fishbowl’s worked with Oracle WebCenter Content customers that have stored as low as 7,000 documents in their content server and as high as 20 million. We are currently working with the customer that has the 20 million documents in their repository to discuss their options of upgrading to Oracle WebCenter Content 12c. The options being discussed include maintaining their on premise instances, or moving their instances to the Oracle Cloud leveraging Oracle Bare Metal.

As (more...)

#GoldenGate Microservices (4 of 5) … Receiver Service

This is post 4 of a 5 part post related to Oracle GoldenGate 12.3 Microservices. This series of posts will provide some details over the new graphical user interface (GUI) that has been built into Oracle GoldenGate 12.3.

The Receiver Serivice is the least complicated of the microservices with Oracle GoldenGate 12.3 Microservices. This service is taking the place of the collectors in classic architectures. When you fist login to the Reciever (more...)

Disabling Microsoft’s Hyper-V to use Oracle’s VirtualBox

If you want to use Oracle’s VirtualBox on Windows 10, you first need to disable Microsoft’s Hyper-V.  I’ve used VirtualBox many times in the past but on the likes of Windows 7, where Hyper-V isn’t installed by default as part of the O/S.  It seem on Windows 10 Enterprise, Hyper-V is installed by default and is started as part of the bootup.

Hyper-V blocks all other Hyper Visors like VirtualBox from calling VT (more...)

IoT Cloud Brewed Beer @ OOW

For the past few months we have worked together with the Oracle Developer Community and Alpha Acid Brewing on a secret IoT project.   Come see (and taste!) it at the Developer Lounge in Moscone West during Oracle Open World.

Hope to see you there!


Mark.Possibly Related Posts:

Too big to fail

There is this saying in the English language that something is “too big to fail”. It can refer to almost anything, a country, an initiative, a company, etc. What it tries to say is that, whatever the subject, is so big by now that there is simply no chance that it will ever go away … Continue reading "Too big to fail"

Using REPL to Simplify ICS Mgmt Tasks – Definitive Top 10

Earlier in 2017 the Oracle A-Team released a Python library that abstracts the ICS REST API to make some management tasks that you may wish to perform easier. For example identifying a set of integrations and activating or deactivating them, or simply importing and exporting them. In this Definitive Tip we will look at the […]

The post Using REPL to Simplify ICS Mgmt Tasks – Definitive Top 10 appeared first on Implementing Oracle Integration (more...)

#GoldenGate Microservices (3 of 5) … Distribution Service

This is post 3 of a 5 part post related to Oracle GoldenGate 12.3 Microservices. This series of posts will provide some details over the new graphical user interface (GUI) that has been built into Oracle GoldenGate 12.3.

The third part of setting up the replication enviornment with Microservices is to understand what the Distributuion Server is. The component is the replacement for the Data Pump Extract in classic architecture. Distribution Server does (more...)

digging into mrskew internals

I'm spending some time working with Method-Rs trace file analyzer mrskew.
As the requirements are beyond simple analyses (here an example about the uncommon things to do) I'm consulting the documentation and all available information in detail. After many readings I started to take this part of the documentation serious:

Wherever mrskew requires an expression (such as in --group and --where option arguments), you may use any valid Perl expression consisting of:

Updating Cloud Foundry CLI using Brew

Need to upgrade the CF CLI using brew it's as simple as below. Go to love brew

pasapicella@pas-macbook:~$ brew upgrade cf-cli
==> Upgrading 1 outdated package, with result:
cloudfoundry/tap/cf-cli 6.31.0
==> Upgrading cloudfoundry/tap/cf-cli
Warning: Use cloudfoundry/tap/cloudfoundry-cli instead of deprecated pivotal/tap/cloudfoundry-cli
==> Downloading
==> Downloading from
######################################################################## 100.0%
==> Caveats
Bash completion has been installed to:
==> Summary
🍺  /usr/local/Cellar/cf-cli/6.31.0: 6 files, 17.6MB, built in 16 seconds

pasapicella@pas-macbook:~$ cf --version
cf version 6.31.0+b35df905d.2017-09-15

Sealing MongoDB documents on the blockchain

As human beings, we get used to the limitations of the technologies we use and over time forget how fundamental some of these limitations are.

As a database administrator in the early 1990s, I remember the shock I felt when I realized that the contents of the database files were plain text; I’d just assumed they were encrypted and could only be modified by the database engine acting on behalf of a validated user. But (more...)

My experiences from the CERN openlab Summer Student Programme 2017

Hello everyone,

Now I am back in Norway, and it is time for looking back and reminisce about my amazing
and memorable summer at CERN. So, today I will tell you about my experiences from my
Summer Internship.