Select Page


Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.

Category: All
Browse All Categories

ORA-04031 and ASMM

Oracle E-Business Suite customer was reporting ORA-04031 errors being returned by the database. There were a number of ORA-04031 shared pool errors generated in the alert by background processes: ORA-04031: unable to allocate 168 bytes of shared memory (“shared pool”,”select t.ts#,t.file#,t.block…”,”Heap0: KGL”,”kglob”) I checked the shared pool and saw that the majority of it was used by KGH: NO ACCESS, which according to oracle Metalink note 451960.1 is.

Steven Kolev | January 28, 2009

Monitor the X display for E-Business Suite

Those running Oracle’s E-Business Suite on Linux/UNIX environments are probably familiar with a dependency on some X display technology to render graphics.  One could use a VNC Server or Xvfb, for example, to fill this need.  XML Publisher and OPP depend on an X display to create rich reports/documents with images & graphics such as […]

R Harwood | January 28, 2009

Using Checksums to Ensure Table Consistency in MySQL

If you’re using MySQL replication, chances are your master and slave databases aren’t entirely consistent. There are a number of reasons for this. Some MySQL functions like UUID() don’t replicate properly with statement based replication. Poor network connectivity can sometimes result in corrupted relay logs. Misconfigured software can accidently write to the slave database.

Mike Hamrick | January 26, 2009

Phase in the Sun JRE plug-in

By now you probably know error correction support ends for JInitiator for E-Business Suite on July 31, 2009 (see Metalink note 552692.1). There has been a lot of strong encouragement from Oracle to migrate to the Sun JRE Native plug-in prior to the de-support date: Note 393931.1: Deploying Sun JRE (Native Plug-in) for Windows Clients […]

Chuck Edwards | January 24, 2009

Request for simpler E-Business Suite diagnostics

A few weeks ago Steven Chan posted an open question on his blog asking how support for the E-Business Suite techstack could be improved.  Specifically, he wanted to know how interaction with Oracle Support could improve.  I sent a suggestion, but it didn’t make the cut; he didn’t post it.  🙁 Since I spent a bit of […]

Chuck Edwards | January 19, 2009

Proactive Maintenance for Oracle E-Business Suite

As a remote services provider, often we are often asked to provide proactive maintenance support for clients. For the purposes of this discussion, I’m going to separate operational support form maintenance support.

Chuck Edwards | December 8, 2008

Exploring Oracle 11g Tablespace Encryption

Tablespace encryption encrypts data at the datafile level to keep people from being able to peek at the oracle datafiles directly. Oracle 10 allowed us to encrypt certain columns, and starting in Oracle 11, tablespace encryption is made available. First we’ll need to setup oracle wallet.

Mark Hammingh | December 2, 2008
1 2 98 99

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.