Category Archive: DBMS

Aug 01

Tracing an Oracle EXPDP

With the EXPDP command, you can add the TRACE= parameter. The TRACE parameter takes a 7-digit hexadecimal mask.  The first three digits enable tracing for a specific Data Pump component, while the last four digits are usually: 0300. Normally, TRACE=480300 is sufficient. To trace EVERYTHING (main component plus worker threads), use TRACE=1FF0300.   Taken from …

Continue reading »

Jul 29

Oracle EXPDP metrics

Is your Oracle EXPDP performing poorly?  Oracle has included an undocumented option called METRICS in the EXPDP command.  Simply add METRICS=Y to your EXPDP command line, and you will get performance data in your logfile.   ;;; Export: Release – Production on Thu Jul 28 20:24:45 2016 Copyright (c) 1982, 2011, Oracle and/or its …

Continue reading »

Jun 12

Read-consistent backups in Oracle

In order to get Read-Consistent backups in Oracle, you need to add the following line to your parameter file or command line: flashback_time=systimestamp   Otherwise, you can get inconsistencies in your SDE versioning state-tree.

May 15


— create logon trigger for one user; CREATE OR REPLACE TRIGGER sde.logon_trace_trig AFTER LOGON ON sde.SCHEMA BEGIN dbms_session.set_identifier(‘SDE’); END ; / show errors; — create logon trigger for all users: CREATE OR REPLACE TRIGGER logon_sess_id_trig AFTER LOGON ON database BEGIN dbms_session.set_identifier(substr(user, instr(user, ‘\’) + 1)); END ; / show errors; — to use these, two …

Continue reading »

Mar 26

MongoDB Series, Part 1: Installation and Configuration

With the surging popularity of NoSQL options, Geographic Database Consulting will take a deeper look at utilizing MongoDB with ArcGIS. This chapter will focus on the installation and configuration of MongoDB on an Oracle/RedHat linux server. Create a YUM Repository The easiest method of installing MongoDB on Oracle/RedHat Linux is via the 10Gen YUM repository. …

Continue reading »

Mar 07

PostgreSQL Series, Part 2: Learning the Basics

Continuing with our series of utilizing PostgreSQL for your Geodatabase storage needs. Part 1 covered the installation and configuration of creating an empty geodatabase. Part 2 is focused on learning some of the basics: data access, how to backup/restore, and general database maintenance. Geographic Database Consulting highly recommends installing the version of PostgreSQL from …

Continue reading »

Feb 01

PostgreSQL Series, Part 1: Installation and Configuration

Geographic Database Consulting is running a multi-part series on utilizing PostgreSQL for your Geodatabase storage needs. This chapter will focus on the installation and configuration of PostgreSQL for hosting a Geodatabase. For this blog, I will be installing PostgreSQL on a Virtual Machine running Oracle Linux 64-bit, which is binary compatible with Redhat. You can …

Continue reading »

Jan 20

Life in the Fast Lane

Geographic Database Consulting president Jeff Buturff recently wrote a guest blog post for You can view that blog post here:

Jan 09

UDL Properties on 64-bit Windows

Since ArcGIS is still a 32-bit application, it requires that you install the 32-bit Oracle client. If you are trying to use a UDL file on 64-bit windows, and want to use the 32-bit Oracle Provider for OleDB, you need to open the UDL file with the 32-bit Ole DB Providers properties. Do that using …

Continue reading »

Jan 04

Direct Connect made EZ at ArcGIS 10.1

As ESRI pushes more customers toward using Direct Connect, the biggest push back I see is the complexity of dealing with the Oracle client. Installing the full Oracle client on every client machine can be a daunting task, as well as configuring TNSNAMES entries. Oracle recently introduced their “Instant Client” package, which greatly simplifies the …

Continue reading »

Older posts «