Gather Fixed Objects Stats in PDBs as well?

Yesterday I received an interesting customer question: "Do we have to gather fixed objects stats inside a PDB as well or only in the CDB$ROOT?" The customer told me he couldn't find anything in the documentation. Neither could I. And I did check also the usual suspects this morning "Best Practices... [Read More]

Reminder: EBS 12.2 Minimum Patching Baselines and Dates

Oracle E-Business Suite 12.2 is now covered by Premier Support to September 30, 2023. This is documented here:

Oracle Lifetime Support table for EBS

Premier Support includes new EBS 12.2 patches for:

  • Individual product families (e.g. Oracle Financials)
  • Quarterly security updates released via the Critical Patch Update process
  • New technology stack certifications with server-based components
  • New certifications for end-user desktops and mobile devices

What are the minimum patching baselines for EBS (more...)

Handy Tools for Working with CSS

Here's an overview of CSS tools in NetBeans that I've found to be quite useful. Below, in the first example, the value of "class" is set to "foo", which does not exist in any of the available CSS stylesheets. NetBeans offers to create the rule in a stylesheet of my choosing and to import that stylesheet into my HTML file:

Below, the value of "id" is "foo", which doesn't exist in any of the stylesheets. NetBeans (more...)

Create an Integration on ICS to expose a REST API for a SOAP Connection for an external web service by Lucas Jellema


In this article, I will show a little bit more of ICS – the Integration Cloud Service. In a previous article, I have introduced some concepts – such as Connection, Integration, Business Identifier. I have shown how to create an integration connecting two connections – an inbound and an outbound one (both of type SOAP).

In picture, that looks like this:

In this article, I will create a new connection (REST API style) and (more...)

Truncating a timestamp to the second

We had an interesting AskTom question recently, about why certain TRUNC commands would generate an error when applied to a TIMESTAMP value.  At first glance, TRUNC seems fine.

SQL> select trunc(localtimestamp,'MM') to_the_month from dual;


1 row selected.

SQL> select trunc(localtimestamp,'YYYY') to_the_year from dual;


1 row selected.

SQL> select trunc(localtimestamp,'DD') to_the_day from dual;


1 row selected.

But the moment you try apply a TRUNC down to (more...)

Reasons to upgrade to Enterprise Manager 13.2

By Sudip Datta-Oracle
Before, during and after the Open World, I have received numerous queries on the release of Enterprise Manager 13.2. This is an important release for Enterprise Manager 12c customers whose Premier Support expires this month and who traditionally wait for the release 2 of any product before upgrading, and for customers who have already upgraded to 13c, but want their critical issues addressed. And there are specific capabilities that are sought for (more...)

User Group Boards, Voting, Oh Yeah and ODTUG

I think we’ve just about all heard enough about voting this election year, but I want to discuss a slightly different angle and that’s when it comes to user groups.  As most people know, I’m pretty passionate about everyone contributing time to your local and national user groups.  I also think it’s important to take pride in and be responsible for the promises you make.


I was sent (more...)

EM13c: Get List of URLs Monitored by Beacons

When you need to monitor web services, you can use EM beacons. A beacon is a target that allows the EM Agent to remotely monitor services. You can add beacons to any EM agent using “Add Non-Host Targets by Specifying Target Monitoring Properties” option in the Add Targets Manually page. After adding a beacon, you can configure it to fetch a web page and test the status of the service according to the result of (more...)

StreamSets Data Collector – New Package Manager in Action

A few days ago, a new  version of StreamSets Data Collector v2.1.0.0 has been announced. It contains a couple of new interesting features.

This blog article shows how to use the new Package Manager to install only the stage libraries in StreamSets Data Collector (origins, processors and destinations) you actually need.

The new StreamSets version provides two distributions:

HugePages speeds up Oracle login process on Linux

We bumped a Linux database up to a 12 gigabyte SGA and the login time went up to about 2.5 seconds. Then a Linux admin configured 12 gigabytes of HugePages to fit the SGA and login time went down to .13 seconds. Here is how I tested the login time. E.sql just has the exit command in it so this logs in as SYSDBA and immediately exits:

$ time sqlplus /  (more...)

Pass Summit 2016 and Old School MSSQL DBA Skills

I’ll be attending my very first Pass Summit next week and I’m really psyched!  Its an amazing event and for those of you who are my Oracle peeps, wondering what Summit is, think Oracle Open World for the Microsoft SQL Server expert folks.


I was a strong proponent of immersing in different database and technology platforms early on.  You never know when the knowledge you gain in an (more...)

Google’s “Material design”

materialdesign_principles_metaphorAs a “born again UX/UI” enthusiast I was quite interested when some of my Google services started telling me about the new UI they were introducing. As part of the “do you want to see more” links they pushed me across to Google’s Material design pages.

I had a bit of mixed reaction to a lot of it. Some of the stuff was straight from the ministry of the bleedin’ obvious, while other stuff was more (more...)

Did you know #15 – Role Based Stuff

If you are using Data Guard and standby databases, you probably need to do stuff based on the database role. For example, have some services start on the primary database, whichever that is. You might want to update some tables upon failover/switchover and more. There are two mechanisms for that in Oracle databases: For services, … Continue reading Did you know #15 – Role Based Stuff

While upgrading to I faced error ORA-01830 / ORA-06512

The other day I was running an upgrade for a client that is using ACLs ( Access Control Lists) from to If you have been doing upgrades to 12c, you know that when running the -n 4 catupgrd.sql it entails 73 steps. So this upgrade failed in step 65 with the following error (I have trimmed the output for reading purposes) :

Serial   Phase  (more...)

Data Visualization Desktop Data Flow Component

My previous post contained a brief description of Data Visualization Desktop (DVD) new features in, in terms of sources, visualisations and components. In this post we're going to simulate a typical analyst use case and understand how DVD can support the process.

Data Visualisation Desktop is a tool aimed at departmental analysis, with data coming from different sources and results that need to be delivered quickly. Given the ad-hoc nature of (more...)

Conjuctive Normal Form

I recently tweeted about a comment I’d picked up at the Trivadis performance days regarding tablescans and performance.

“If you can write your SQL in conjunctive normal form it can help the optimizer to offload more predicates”

Inevitably someone asked me if I had an example to demonstrate this – I didn’t, and still don’t really, but here’s an interesting demo based on an example from the Oracle In-Memory blog showing how the optimizer will (more...)

Oracle EMPTY_CLOB Function with Examples

In this article, I’ll explain what the EMPTY_CLOB function does and show you an example of how to use it. Purpose of the Oracle EMPTY_CLOB Function The EMPTY_CLOB function is used to initalise a CLOB column to EMPTY. It can be used in several places: In an INSERT statement In an UPDATE statement Initialising a […]

AWR Summary Data Extracts

A long time ago (in a galaxy far away) I wrote a series of blog posts about directly extracting useful sets of data from the AWR snapshots in the DBA_HIST tables for subsequent analysis and graphing using things like Excel. This post is to summarise where I got to on this, and provide links back to the main posts for future reference.

A guiding principle of my approach was that I wanted to avoid the (more...)

Congratulations to Certus – Thank you to everyone who Voted

Back in August I asked for your vote in The UKOUG Partner Awards. I always say how important these are because they are voted for by end users.

It is a hard process for me, I am not allowed to do anything for PYA by UKOUG because I am a partner and there has to be a total separation. Most people understand that but my boss rang me 3 times on the day asking (more...)

Real Time Ambient Display at OpenWorld: The Software (for the Hardware)

This is part 2 of my blog post series about the Ambient Visualization hardware (part 1).  Also, please read John’s post on details about the creation of the actual visualization, from concept to build.  In the first part, I focused on the hardware, a sonar sensor connected to a NodeMCU.  In this second part, the focal point will be the software.

When I started working with ESPs a few years ago I was all (more...)