The importance of the GLOBAL_STATS statistic on partitioned tables

I am currently working in a team alongside a gentleman known as Roberto Rigliaco. You are unlikely to have heard of Roberto as he is not (yet) a blogger and not (yet) known on the conference circuit.

Nevertheless, Roberto has done some excellent work recently analyzing the use of object statistics in partitioned tables. I haven’t seen his findings published anywhere else and so I am glad to say that Roberto has accepted my offer (more...)

5 Things I wish I knew about APEX when I just started (part 4)


Ever deleted or changed something by accident in your application and wished you could get it back?

You can! The oracle database has a feature called flashback, and APEX can take advantage of this feature. (Flashback needs to be enabled on the database, if you are not sure if it is enabled on your database, you can always ask your DBA).

Today I will show you some of the different places, where you can (more...)

What Does Your EM Agent Have Planned?

The EM agent’s scheduled activities can be listed using emctl status agent scheduler, like this:


You’ll see a regular cycle of Response calls (anybody home?), metric uploads, and heartbeats.

X-Window Fun

When ssh -X to another host, I am able to use X-Windows.

[dinh@ca01ts~]$ ssh -X dinh@
dinh@'s password:
Last login: Fri Aug 21 11:55:47 2015 from
/usr/bin/xauth: creating new authority file /home/dinh/.Xauthority
[dinh@arrow ~]$ xclock
Warning: Missing charsets in String to FontSet conversion

However, sudo to another user and X-Windows breaks.

[dinh@arrow ~]$ sudo su - oracle
[sudo] password for dinh:
[oracle@arrow ~]$  (more...)

Fishbowl Solutions is now a Google for Work Premier Partner

As of August 1, 2015, Google promoted Fishbowl Solutions to Premier Partner status! This elevation is a testament to our commitment to selling and servicing Google Search Solutions, and we are very excited to be counted among the select companies to attain this level of partnership. Kim Negaard, the Google Product Manager at Fishbowl, took some time to talk about our history with Google and what being a Premier Partner means.


The post Fishbowl (more...)

The Real Future of Oracle Forms – Not the Demise of Forms! Response to LinkedIn Thred

There is quite a debate going around based on Simon’s linkedin post regarding the future of Forms; but when you read it you’ll see, he doesn’t actually talk about the future of Forms – he talks about the demise of Forms and its replacement with Oracle APEX. As someone who does believe in the future of forms, there are several things  I wanted to clarify.

Firstly, it mentions that despite the release of Oracle Forms 12c, Oracle (more...)

How to Remove an Exadata Server from OEM

Just like everything else in Enterprise Manager, an Exadata is a target and all of its components are targets.  All of these pieces can be removed through the 12c console.

Select Exadata from the bottom of the main Targets drop-down to display a list of Database Machines in your environment.  Highlight the row containing the subject machine and press the Big Red X to take you into the detail page.


The left panel shows you the (more...)

After startup trigger on RAC

Recently, a colleague of mine had some problems with pinning application procedures into the shared pool. His database was upgraded to RAC and he wanted to pin the application procedures and packages into shared pool upon the database startup.
The non-RAC version of the database was using a shell script, something like $ORACLE_HOME/local/scripts/ in the script that was starting DB when the system was booted
However, RAC starts the database automatically and no user (more...)

Success Factor: Framework Longevity

I just read an interesting article about  Longevity (or Lack Thereof) in JavaScript Frameworks, and Brian Moschel makes the same recommendations I make to my customers.

Mainly: You do not want to pick the tool that’s hot this year.

hot_js_frameworks(picture from blog above)

The reason is that choosing this year’s hot framework is an unnecessary leap of faith that places your project at risk. What happens if you choose wrong? You’ll watch your application (more...)

dbms_redefinition houskeeping

dbms_redefinition actually is a nifty, but powerful little toolkit that let’s you change table-definitions without actually locking the table in such a manner that it would prevent regular operations from being interrupted.

You can read loads about it in the Oracle documentation or in the wealthy library by Mr. Tim Hall.

housekeepingOne thing I noticed, and which I want to share here has lots to do with the house keeping that is automatically done by (more...)

Porting Installation Files to Different tmp Directory

If a full /tmp directory is blocking you from running an installer script, try this:


Matching Your Database to Your Application

I’ve just been troubleshooting an ADF application that ran fine on one environment and not on another. After some searching, I discovered that a script had not been run on one of the environments so the database was different.

That reminded me of a simple database check that I often include in my applications: I simply calculate a hash value of all tables and views with an SQL statement like this:

select sum(
+ (more...)

Modernizing New Jersey: One Forms System at a Time

Last week I had the pleasure of presenting at the New Jersey Government Oracle User Group (NJOUG).

It was incredible to see such a dedicated group of people; almost 50 people came out just from the government to hear all different types of topics with regards to database, middleware, etc.

I was actually asked to speak on a range of topics to basically map out what I see as the future for Oracle Forms from (more...)

ASM 12c, OCR and voting devices II

I finished the installation of 12c cluster and noticed that I haven’t been asked for voting and registry devices as was previously the case. I had to create a single disk group. John Franklin, from LinkedIn RAC SIG suggested running ocrcheck command, so I did:

[grid@rac1 ~]$ ocrcheck -details
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 409568
Used space (kbytes) : 1612
Available space (kbytes) : (more...)

ASM 12c – no voting/quorum device and OCR?

I installed my first 12c ASM (database is still and I made the 11G disk layout: 2GB for voting/quorum, 2 GB for OCR. However, the installation procedure did not ask me for the voting and OCR devices. ASM came right up without them. So, the devices are not needed for 12c? What about upgrading from 11g, which did need the devices? The “crsctl” utility confirms that voting and OCR devices are (more...)

Oracle 12 and latches, part 2

In my previous post, I looked at non shared latches and how the latching is done by Oracle. This post is a description on how the latching works for shared latches.

The information is quite internal, if you landed on this page it might be a good idea to start with my first post on this topic: first post.

A famous example for shared latches is the ‘cache buffers chains’ latch.

For the sake (more...)

My picks for UKOUG_Tech15

I went over the agenda for UKOUG_Tech15 and took my picks & suggestions.
Then I thought, why not share these…


Is Oracle the Best Language for Statistics
Brendan Tierney – Oralytics

Standard Edition Something for the Enterprise?
Ann Sjökvist – SE – JUST LOVE IT

Looking for Performance Issues in Oracle SE – Check what OraSASH Can do for You
Marcin Przepiorowski – Delphix

Silent but Deadly : SE Deserves Your Attention
Philippe Fierens (more...)

Oracle 12 and latches

Oracle DBAs who are so old that they remember the days before Oracle 11.2 probably remember the tuning efforts for latches. I can still recall the latch number for cache buffers chains from the top of my head: number 98. In the older days this was another number, 157.

But it seems latches have become less of a problem in the modern days of Oracle 11.2 and higher. Still, when I generate heavy (more...)

Oracle APEX 5.0.1 now available

Oracle Application Express 5.0.1 is now released and available for download. If you wish to download the full release of Oracle Application Express 5.0.1, you can get it from the Downloads page on OTN. If you have Oracle APEX 5.0.0 … Continue reading

Managing identity information from multiple sources with Oracle Identity Manager, Part 2

Consolidating identity information in Oracle Identity Manager

In part 1 one this article we saw several options for managing identities in an environment where multiple sources for identity information are used. In this part, you’ll find more information on how to set up Oracle Identity Manager in a scenario like the one described in the Swift&Safe Inc. use case.

First of all, the identities based on the input from CUST1 will be placed in dedicated (more...)