This year, 2016, is turning out to be an amazing year again, with #OOW16 being once again on of the apices!
After the discovery of the Oracle community in 2012, as a result of a very first trip to downtown San Francisco in 2010 for #OOW10, an amazing chain of events was set in motion. This very first introduction in the Oracle World was as ‘a mere participant’ in this awe-inspring, large (more...)
Here is another example (besides the fact that Adaptive Cursor Sharing only gets evaluated during a PARSE call
(still valid in 12c) and supports a maximum of 14 bind variables) I've recently come across at a client site where the default implementation of Adaptive Cursor Sharing fails to create a more suitable execution plan for different bind variable values.Broken down to a bare minimum the query was sometimes executed using non-existing values
for a (more...)
up a series of questions around setting timers in the Oracle Community
forums, I decided to write this article to try and guide their use and
how these can be used to control process execution.
The Use Case
We’ll begin by setting up the scenario in which we’ll have to control our process flow.
that you want to have a part of your process that executes immediately
if the current time (more...)
A really great thing about being part of the Oracle community is the networking and access to information it gives you. In my current job I have to do a number of things that are not really my forte. I know how to learn new stuff, but it’s always nice to get some feedback from people who know more than you. Over the last few years there have been a number of specific cases that (more...)
This is a series of 8 short videos explaining how to create a
BPM application using Oracle Process Cloud Services. Part 1 will show
how to login and create a new application:
SOA & BPM Partner Community
regular information (more...)
The APEX Development Team recently mentioned that not only the Data Visualisations part of JET will be included in APEX 5.1, but the complete installation of JET. The whole package. That won't do the size of the downloadable install file any good, but more important is: what can we do with (more...)
There are many map components in the world out there—and I have documented how to integrate several of them in an Oracle JET application, e.g., 3DCityDB, Mapbox, Leaflet, and LuciadRIA.
Oracle Fusion Middleware MapViewer is a development toolkit for incorporating interactive maps and spatial analyses. It is (more...)
Session ID: UGF3110
Advanced Active Session History Analytics
09/18/16, 03:30:00 PM – 04:15:00 PM
A coworker passed a test script on to me that was failing with the following memory error:
ORA-04030: out of process memory when trying to allocate 4088 bytes (PLS CGA hp,pdzgM64_New_Link)
The error occurred when initializing a PL/SQL table variable with 7500 objects. Here is my sanitized version of the code:
CREATE OR REPLACE TYPE ARRAY_ELEMENT
n4 NUMBER );
CREATE OR REPLACE TYPE MY_ARRAY
As I want later build Oracle docker images, some of this need a swapfile.
Per default my used Vagrantbox, does not have one, so later steps will fail.
As in the last blog I use a Vagrant shell provider.
# add swapfile to the box
config.vm.provision :shell, :path => "add_swap.sh"
This calls the script add_swap.sh in the created VirtualBox machine.
Make sure, that you create your swapfile on a supported (more...)
Written by Iulia Pantelimon, OPN
Partners can take certification exams during Oracle OpenWorld at no cost, only at the OPN Test Fest.
The OPN Test Fest runs from Monday, September 19 - Thursday, September 22 at the Courtyard San Francisco Downtown Hotel.
It’s an exceptional opportunity for partners to take Oracle PartnerNetwork exams for FREE!
the benefits when achieving certification successfully. Candidates
earn an OPN Certified Specialist credential, a digital badge to promote
Let's start by looking at the result of a small (more...)
In my post on the differences between ADD TRANDATA and ADD SCHEMATRANDATA, I highlighted the differences between the two ways of adding supplemental logging to tables. One of the things I pointed out was that ADD SCHEMATRANDATA doesn’t add any supplemental log groups (SLG). Without SLGs then how does ADD SCHEMATRANDATA work? That was the question I was left with. So I started digging around to find the answer and I think you may be (more...)
Pushed applications to CF or PCF you would of most likely used a manifest.yml file and at some point wanted to use variable substitution. manifest.yml files don't support that and a feature request has been asked for this as follows
With a recent customer we scripted the creation of a manifest.yml file from a Jenkins job which would inject the required ROUTE to the application by creating the manifest.yml (more...)
We are glad to announce the release of a new Education & Research 2016 Industry Specialist Training Guided Learning Path targeted at your sales and sales consulting teams so that they can understand Oracle’s key messages within the industry, articulate Oracle’s key solutions for the sector and be able to position our products to their respective customers and prospects.
Gain proficiency in positioning and selling the Oracle Education and Research Industry solutions and contribute towards (more...)
Jump-start your MySQL knowledge with this in-depth webinar that will assist you in learning the building blocks for creating a centralized service offering with MySQL Enterprise Edition.
This webcast will be offered in 3 languages: English (9/13), Spanish (9/14), and Portuguese (Brazil) (9/14).
TimeClock Plus (TCP), a Gold level member of Oracle PartnerNetwork (OPN), announced it has achieved Oracle Validated Integration of TCP Direct with Oracle's PeopleSoft Time and Labor 9.2. This validation is a major milestone in the evolution of TCP and its relationship with Oracle. The company continues to grow its presence in the Enterprise Resource Planning (ERP) space and with Oracle Validated Integration for PeopleSoft Time and Labor, the company is even better positioned (more...)