Basicfile LOBs 4

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...)

G-Cloud – Moving Your Oracle System to Amazon Web Services

G-Cloud was awarded a few weeks ago and we're glad to say that clckwrk were selected as a supplier in the areas of Infrastructure as a Service and Specialist Services.

The services we have on G-Cloud are specifically curated for implementing, moving and managing Oracle systems to the cloud. This is a quick guide for how to combine those services to migrate to the cloud. For public sector users of Oracle technology and applications this is the set (more...)

Becky’s BI Apps Corner: OBIA Back-to-Beginnings – Naming Conventions and Jargon

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...)

Columns Affected by Extended Data Type

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...)

Database Triggers : Use at your own risk!

error-24842_640I 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...)

ServiceCloud Rightnow Integration, XSLT Transformations! By Fabio Persico

clip_image002

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.

Here I just want to share the complex XSLT Transformation which we have implemented to communicate with the OSC WebServices, (more...)

7 Reasons Why You Should Take a Live Virtual Class

Have you heard about Oracle's Live Virtual Classes?

If you've got a busy schedule and don't have time to commute to a physical classroom, this online training format may be a great match for you.

You can watch live Oracle University classes as they're happening, in real-time, from anywhere with an internet connection.

Here are 7 reasons why you should take a Live Virtual Class (LVC).

1. You can take the course in your pajamas.

(more...)

My OOW Experience, the Prequel

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...)

Book Review: Oracle Database Cloud Cookbook with Oracle Enterprise Manager Cloud Control 13c

13cCoverLatest 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...)

Why to Attend OOW?

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 […]

HCM Cloud – Bulk Integration Automation Using SOA Cloud Service by Jack Desai

clip_image002

Introduction

Oracle 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)

HDL is a powerful tool for bulk-loading data from any source to Oracle Fusion HCM. It supports (more...)

Enterprise Manager Cloud Control 13c : It’s Alive!

ItsAlive

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...)

It’s That Time Again! Time for OOW2016!

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...)

BPM 12c Subprocesses (Part 3 of 3): Event Subprocess by Antonis Antoniou

clip_image001

In 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” subprocess.
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 the (more...)

Converting Crontab to Enterprise Manager Jobs

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...)

Basicfile LOBS

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...)

Set all WebLogic log levels to “Inherit” via WLST

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.

#!/usr/bin/python
execfile('get_environment.py')
 (more...)

Oracle OpenWorld 2016 : Come and Play!

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 Plugin for PostgreSQL

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...)

Stop Constantly Adding Disks To Your ASM Disk Groups. Resize Your ASM Disks On All-Flash Array Storage. Adding Disks Is Really “The Y2K Way.” Here’s Why.

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...)