Oracle Database Support News – your monthly guide to Database support information

| Dec 16, 2014
Oracle Database Support News - your monthly guide to Database support information

Want to keep up-to-date with the latest Database Support News as well as accessing interesting technical Database articles?

Check out the monthly Oracle Premier Support - Oracle Database Support News (Document 230.1) for content such as
  • Feature Article: discussing a technical topic, best practice, new support tool or new features in a release
  • Database Technology Updates: providing up-to-date information about (more...)

UKOUG Tech14 – APEX Highlights




Last week I spent 4 days at the annual UK Oracle User Group conference, this time around called Tech14.  It was my first UKOUG conference in a number of years and I set out with the intention of treating it like an all you can eat buffet of APEX presentations and workshops.

So, what were the APEX highlights of Tech14? Well, I have to start with the presentations given by Joel KalmanDavid Peake (more...)

Standards Corner: IETF SCIM Working Group Reaches Consensus

SCIM Logo

Today’s standards corner is an update about SCIM Protocol (System for Cross-domain Identity Management), its current status, and its use in relation to LDAP directory services.

In late October, the SCIM Working Group of the IETF wrapped up discussions on SCIM 2.0 and the proposed standards drafts are now considered Working Group Consensus Documents. As editor and on behalf of the working group, I’m proud to say that the specifications are now going through (more...)

Oracle’s Journey to Customer Centricity


Oracle got deadly serious about customer-centricity in 2004. Back then we were famous for our database products, were just wrapping up the acquisition of PeopleSoft and quickly expanding our applications business. Our approach since has been two-pronged, consisting of acquiring new technologies through many further acquisitions and expanding internal R&D efforts to broaden the company’s “solution footprint.”

The aggressive pace of acquisitions, starting with PeopleSoft, meant (more...)

Oracle database operating system memory allocation management for PGA – part 2: Oracle 11.2

This is the second part of a series of blogpost on Oracle database PGA usage. See the first part here. The first part described SGA and PGA usage, their distinction (SGA being static, PGA being variable), the problem (no limitation for PGA allocations outside of sort, hash and bitmap memory), a resolution for Oracle 12 (PGA_AGGREGATE_LIMIT), and some specifics about that (it doesn’t look like a very hard limit).

But this leaves out Oracle version (more...)

BPM Award 2014 Winners

| Dec 16, 2014

Great News! Oracle Customers Seattle City Light and Chicago Parks District are both Winners of the 2014 WfMC Awards for Excellence in BPM and Workflow. These prestigious Global Awards for Excellence in BPM & Workflow recognize user organizations that have demonstrably excelled in implementing innovative business process solutions to meet strategic business objectives.

Check out www.bpmf.org

For more information contact Gwen Richardson (gwen.richardson@oracle.com) or Linus Chow (linus.chow@oracle.com)

TROUG Day Ankara 2014

poster_ankara14As Turkish Oracle User Group (TROUG), we will organize our second meeting in Ankara on December 23rd. The event will be held at the Chamber of Electrical Engineers (EMO). The main theme of the meeting is Oracle 12c. There will be 4 sessions about new features of Oracle 12c (Database In-Memory, Active Data Guard, RAC and Flex ASM and Multitenancy). I usually do presentations about Enterprise Manager but this time, I have picked a more (more...)

Oracle database operating system memory allocation management for PGA

This post is about memory management on the operating system level of an Oracle database. The first question that might pop in your head is: isn’t this a solved problem? The answer is: yes, if you use Oracle’s AMM (Automatic Memory Management) feature, which let’s you set a limit for the Oracle datababase’s two main memory area’s: SGA and PGA. But in my opinion any serious, real life, usage of an Oracle database on Linux (more...)

Develop against the versions in the Yum repositories!

I saw a tweet by Simon Haslam at the weekend that read,

“I’m v surprised to read that @Atlassian Stash needs newer git than in the latest RHEL/OL6 repos!”

I had a similar experience at the weekend too, but this time with Oracle REST Data Services (ORDS) 3.0 EA. According to the documentation, it requires the following version of Tomcat.

“Apache Tomcat Release 7.0.56 or later”

So let’s have a look (more...)

Fedora 21 : Oracle 11g and 12c Installations

Fedora 21 has arrived and it’s now delivered in three focussed flavours (Workstation, Server and Cloud). This of course resulted in the usual articles from me.

As always, read the warnings before you start down this path.

From (more...)

Tips and Tricks for Installing Ops Center 12c R2 (PSU2)

In one of my old posts, I wrote a step by step guide to install Ops Center on Linux. I still get questions about installation, mostly about installing repository Database. So I have downloaded latest patch set version if anything has changed about installation, and decided to write tips and tricks to help Ops Center users. If you have read my previous blog, or you are already an Ops Center user, you may remember (more...)

Parse Time

Here’s a little query I wrote some time ago to see where my time went while running a query. It’s nothing sophisticated, just one of those simple things you can do with v$active_session_history (or dba_hist_active_sess_history, if you don’t get to the crime scene in time).


set null CPU

select
        sql_exec_id, in_parse, in_hard_parse, event, count(*)
from
        v$active_session_history
where
        sql_id = '{your choice here}'
group by
        sql_exec_id, in_parse, in_hard_parse, event
order by
        sql_exec_id, in_parse, in_hard_parse, count(*)
 (more...)

Riga Dev Day 2015

Over the weekend I booked my flights and hotel for the Riga Dev Day on January 22nd.

It’s my first time in Latvia, so I look forward to seeing everyone out there!

Cheers

Tim..


Riga Dev Day 2015 was first posted on December 9, 2014 at 2:09 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, (more...)

Oracle ACE Program : Thanks Folks!

As you will know from my previous post, I picked up the “UK Speaker Award” at UKOUG Tech 14. I’ve already  done a bunch of thank you messages, but I’d just like to take a minute and thank the Oracle ACE Program for they part they have played in this.

Many of you will know, I was invited to the ACE program because of my online contributions to the Oracle community. Prior to joining (more...)

UKOUG Tech 14 : Monday

The day started with a taxi ride into New Street station to get the 06:01 train to Liverpool Lime Street. I was a little dissapointed that the train was a sprint train, so there were no tables and no power sockets. When the ticket guy came through I asked about an upgrade to first class and it was only £25 for the return journey, so I paid the extra to get a table and a (more...)

Cardinality Change

Here’s an entertaining little change across versions of Oracle, brought to my attention by Tony Hasler during UKOUG Tech 14. It’s a join cardinality estimate, so here are a couple of tables to demonstrate the issue – the only columns needed are the alpha_06 columns, but I reused some code from other demonstrations to create my test case, so there are lots of irrelevant columns in the create table script:


create table t1 nologging as
with generator as (
         (more...)

Treasures From The Road

Reading departure signs in some big airport
Reminds me of the places I've been.
Visions of good times that brought so much pleasure
Makes me want to go back again.
If it suddenly ended tomorrow,
I could somehow adjust to the fall.
Good times and riches and son of a b*****s,
I've seen more than I can recall
                      — From Jimmy Buffett’s "Changes in (more...)

Repost: Oracle Trivia Quiz

All the answers to the quiz are in the November 2014 issue of the NoCOUG Journal . I am the editor of the NoCOUG Journal. What’s NoCOUG, you ask? Only the oldest and most active Oracle users group in the world. If you have not attended a NoCOUG conference in the last 28 years—yes that’s how long NoCOUG has been around—you can attend the winter conference on January 27 for free subject to availability of free (more...)

Securing OHS environments with latest SSL TLS protocols and SHA-2 certificates

Customer case

A while ago I was contacted by a customer about their old Oracle Application and Weblogic Server environment.
They were receiving complaints from users that they can’t connect to the secure site any longer. Most of the complaints came from users that just recently updated their tablet or smartphone.
After a quick look in the logs of the OHS servers, I found out that the problem had to do with the SSL protocols (more...)

Data Pump and AQ_TM_PROCESSES

First things first: Thou shalt not explicitly set AQ_TM_PROCESSES=0 ! Unless, of course, you want to disable the Queue Manager Process (QMNC in Oracle 11.x). Which you may want to do during database upgrades to prevent Streams or Advanced Queueing from interfering with the upgrade process. However, if you don’t reset this parameter afterwards, you might run […]