At the end of the previous installment we saw that a single big batch delete would (apparently) attach all the “reusable” chunks into a single freepool, and asked the questions:
- Why would the Oracle developer think that this use of one freepool is a good idea ?
- Why might it be a bad idea ?
- What happens when we start inserting more data ?
(Okay, I’ll admit it, the third question is a clue about the answer (more...)
It's easy to talk about a technology using only jargon. It's much harder to talk about a technology without using jargon. I have seen many meetings between business and IT break down because of this communication barrier. I find it more discouraging when I see this communication breakdown happen between advanced IT staff and new IT staff. For those of us in any technological field, it's easy to forget how long it took to learn (more...)
I am not going to post how to convert to extended data type since there are many blogs on that already.
Just a reminder, there’s no going back; hence have backup and possibly minimize changes during testing to be able to restore (which is ideal and may not be feasible).
Before reverting to MAX_STRING_SIZE=STANDARD, columns affected by extended data type need to be identified.
From Oracle documentation, MAX_STRING_SIZE controls the maximum size of VARCHAR2, NVARCHAR2, (more...)
I wrote a Tweet about triggers yesterday that seemed to get a strong reaction, so I thought I would clarify some things. 🙂
Guns don’t kill people, people do (or is that rappers). In the same way, triggers are not inherently evil, but their misuse is. Toon Koppelaars, of Helsinki Declaration fame, wrote some posts about triggers, which amongst other things highlights the problem of stigmatising something because it is being misused. With all that (more...)
I've just roll out to a live environment, a SOA Integration project with Oracle Service Cloud Rightnow.
The customer needed to migrate from a in-house CRM to Oracle Service Cloud and with my company Infomentum we have helped them in taking this big step. Since that I have made lots of experience with OSC WebServices.
I just want to share the complex XSLT Transformation which we have
implemented to communicate with the OSC WebServices, (more...)
On the first or second year after I became a DBA (somewhere in the year 2000, give or take), I heard about this magical event that is taking place in the Oracle realm. All the top Oracle DBAs and professionals in the world (and maybe a couple of unicorns, I’m not sure) are gathering in a small but beautiful village by the name of San Francisco – and talk about databases. I found this story (more...)
Last week, I had a chance to read the latest book of my friend Porus Homi Havewala. If you’re interested in Oracle Enterprise Manager, you already knew him or at least read one of his articles/blog posts. He’s a Subject Matter Expert (SME) on Oracle Enterprise Manager Technology, Oracle Certified Master (OCM) and Oracle ACE Director. Porus created one of the world’s first blogs dedicated to Enterprise Manager (http://enterprise-manager.blogspot.com), and he (more...)
I tweeted and mentioned reasons why people should attend Oracle Open World, but apparently I haven’t written an actual post about it, so I decided to do that now. This post won’t be too long, but it will contain the things I like most in this amazing conference. I divided the experience of OOW to […]
Human Capital Management (HCM) Cloud provides a comprehensive set of
tools, templates, and pre-packaged integration to cover various
scenarios using modern and efficient technologies. One of the patterns
is the batch integration to load and extract data to and from the HCM
cloud. HCM provides the following bulk integration interfaces and tools:
HCM Data Loader (HDL)
is a powerful tool for bulk-loading data from any source to Oracle
Fusion HCM. It supports (more...)
I wrote some blog posts about Enterprise Manager Cloud Control 13c a little over 6 months ago.
Since those posts we’ve had bigger fish to fry, so I pretty much put 13c on hold until now. I’ve just built a new 13c server and in the coming weeks will be (more...)
Yes, it’s that crazy time of the year again, when the city of San Francisco turns red – it’s Oracle Open World (OOW) 2016! If you’re planning on going this year, I hope you have your hotel room booked, because they disappear very, VERY quickly!
Every year just before OOW, the product teams produce what we call Focus On documents, that show you all the sessions (both customer and Oracle presented) around a particular area. (more...)
this third and last part of a three part series on subprocesses we will
explore a special type of subprocess referred to as an “Event”
This type of subprocess is triggered by an event that
can occur anytime during the execution of a process flow that allows you
to interrupt the normal flow of an instance.
Such capability can be
applicable in various use cases. For example, an error might occur in
A customer recently asked me about whether they can convert numerous cron jobs to EM’s Job System. It reminded me that a former manager of mine had posted an article on just how to do this conversion. That manager has since left Oracle, and since his posting was on his own website, I wanted to make sure the intellectual capital wasn’t lost to us if he decided to remove it. The article was written in (more...)
In the previous article in this mini-series I described how the option for setting freepools N when defining Basicfile LOBs was a feature aimed at giving you improved concurrency for inserts and deletes that worked by splitting the LOBINDEX into 2N sections: N sections to index the current LOB chunks by LOB id, alternating with N sections to map the reusable LOB chunks by deletion time.
In this article we’ll look a little further into (more...)
Logging is a very useful feature of WebLogic.
Unfortunately the log levels, which are set after a clean install of WebLogic or some of the Fusion Middleware product creates a lot of noise and therefore it costs I/O performance.
Additional after analyzing an issue with logging often resetting the log level is forgotten.
Here you get a script to reset the log levels at regular intervals or after a trace session.
In a few short weeks I’ll be jetting off to Oracle OpenWorld 2016. It’s pretty crazy to think this will be my 11th visit to OOW and San Francisco…
The rough itinerary for the trip will be…
New York City. I’m going to break my flight in NYC for a few days on my way to San Francisco. I’ve only recently confirmed my flights, but as soon as I did I reached out to NYOUG (more...)
Oracle Enterprise Manager supports 3rd party plugins which can help you to extend its monitoring and manageability capabilities. There are already developers and companies specialized in plugin development. Blue Medora is one of them (and probably the most famous one). In this blog post, I’ll show you how we can use Blue Medora’s EM PostgreSQL plugin, which is part of their True Visibility Suite for Oracle. I’ll download and deploy the plugin on the OMS (more...)
This blog post is centered on All-Flash Array(AFA) technology. I mostly work with EMC XtremIO but the majority of my points will be relevant for any AFA. I’ll specifically call out an array that doesn’t fit any of the value propositions / methods I’m writing about in this post.
Oracle Automatic Storage Management (ASM) is a very good volume manager and since it is purpose-built for Oracle Database it is the most popular storage presentation (more...)