Recently a customer asked if it was possible to promote unmanaged targets automatically without any interaction. They were already using auto-discovery.
The answer is yes, and of course as soon as you see words like “without any interaction” you know there’s going to be scripting involved. In the Enterprise Manager world, scripting is handled by the EM Command Line Interface, better known as EMCLI. I’ve posted some example scripts of using EMCLI a while back (more...)
The whole Sangam15 experience is over for me now!
Here are the posts I put out during the trip.
I did my thank you messages in the Day 2 post, but once again I would like to say a big thank you to AIOUG for inviting me, to the Oracle ACE Program for getting (more...)
The night before a morning flight is always a little tricky for me. I lie in bed thinking, “What if I oversleep?”, which winds me up and makes it really hard to relax and drop off. I dozed on and off, but eventually gave up, turned the TV on and watched some films for a few hours.
I grabbed a quick breakfast and got the taxi to the airport. The hotel staff advised leaving (more...)
I’ve often found that while I’m investigating one Oracle feature I get waylaid by noticing anomalies in other parts of the code. I was caught by one of these events a little while ago while experimenting with the new (220.127.116.11) Inmemory Columnar Store. After reading a posting by Martin Bach I asked the question:
“If you have a partitioned table with a local index and one of the table partitions has (more...)
Last week, I gave presentations at DOAG (German Oracle User Group) conference and BGOUG (Bulgarian Oracle User Group) autumn conference about Oracle Enterprise Manager Command Line Interface. It was my first time at these conferences, and both of them were wonderful.
Before each session at DOAG Conference, there was a video showing “how they prepared the last year’s DOAG conference”. What a professionalism! What a great team work! You know Germany is known for their (more...)
I have created a new youtube channel – and have uploaded some videos there already! Bookmark & Subscribe here:
More stuff is coming over the next weeks & months :-)
NB! After a 1.5 year break, this year’s only Advanced Oracle Troubleshooting training class (updated with Oracle 12c content) takes place on 16-20 November & 14-18 December 2015, so sign up now if you plan to attend this year!
iAdvise presented the APEX 5.0 roadshows in the first half of 2015. Besides the presentation about the new features, we provided 3 tutorials which helped the visitors to explore Oracle Application Express 5.0. Now we offer these tutorials through our blog. In this article the second tutorial is presented.
This tutorial helps you step by step through the process of migrating an application to the Universal Theme
of Oracle Application Express 5.0
. In this tutorial we talk about (more...)
I wanted to add an append hint to some code but realised that there are known restrictions when either triggers or referential integrity are involved.
That does make sense as potentially rows would be inserted that either did not fire a trigger or broke RI constraints.
I decided to produce a test case to prove that the restrictions did work and were still in place.
Test append with trigger created
set lines 240
set pages (more...)
My session on Day 2 started at 11:10, where I spoke about running Oracle Databases in the Cloud. This included a quick run through of the Oracle DBaaS offering and AWS RDS for Oracle amongst other things.
The session generated a lot of interest. In fact, I spent the next 5 hours answering questions and taking photos with people. It sounds kind-of crazy, but it was really good fun. As a result, I didn’t get to (more...)
Just returned from Berlin, where, amongst other things, I visited restaurant called Dunkel.
Dunkel Unsicht Restaurant is where you are seated, served, and eat in total darkness (Dunkel means dark in German).
To begin with, you order from a set menu, in the light. Then, your assigned server appears, asks you to put your hands on their shoulders and to follow you downstairs into the darkness of the restaurant itself.
Into total blackness. (more...)
I was up at about 04:00 on Saturday and waiting for breakfast to open at 06:30. Pretty much as soon as I ate something I felt really tired again. That after a day of sleeping…
I headed on down to the conference and instantly saw a bunch of friendly faces, including lots of people I had met on the OTN Yathra 2014 Tour.
After the keynotes, I got to have a quick chat about User Groups (more...)
So, some of you may have noticed that I took “real” job this week. I am now the Senior Technical Evangelist for a cool startup company called Snowflake Computing. Basically we provide a data warehouse database as a service in the cloud. Pretty cool stuff. (If you want to know more, check out our site […]
I previously blogged about using the IBM Bluemix Secure Gateway Service as followshttp://theblasfrompas.blogspot.com.au/2015/11/ibm-bluemix-secure-gateway-service-step.html
I decided I would extend on this and Connect a Spring Boot Application to Oracle and consume Oracle data using the Secure Gateway Service.
The full demo is as followshttps://dl.dropboxusercontent.com/u/15829935/bluemix-docs/secure-gateway-oracle/index.html
The day started pretty early. I was packing at 00:00 and the alarm went off at 05:00. Nothing like last minute packing to focus the mind.
The taxi to the airport was good. The driver was interesting, speaking to me about his visits to India and Pakistan. It certainly helps pass the time when the driver is chatty.
I wasn’t able to check-in online, but there was no queue at the check-in desk, so that was quick. (more...)
Some references on extents dealing with extent trimming, initial extent for parallel load, tablespace fragmentation, etc…
ASM AU Size And LMT AUTOALLOCATE
Parallel Load: Uniform or AutoAllocate extents?
Tom Kyte covers this problem in great details in his post Loading and Extents
Initial Extent Size of a Partition Changed to 8MB from 64KB After Upgrade to 18.104.22.168 or Later (Doc ID (more...)
After the presentation about EMCLI at DOAG 2015, someone asked me how we can list database targets based on their operating systems. In my presentation, I told that there are more than 70 verbs which starts with “get_” and help you fetch information about EM objects, and if you can’t find what you’re looking for, you can use the “list” verb which is probably the most powerful verb of EMCLI. Now I try to show (more...)
Snappy title, huh?
Aka: Why a sql plan baseline may be no guarantee of stability.
The other day, a problematic plan flip…
Cue much discussion about plan flips etc.
My thoughts on stability are that the priority for most application owners is stability and predictability but that does not tally with the defaul CBO behaviour and potentially you have to turn off a helluva lot to even get close.
I have (more...)