Author's details

Date registered: March 6, 2017

Latest posts

  1. Tracing an Oracle EXPDP — August 1, 2016
  2. Oracle EXPDP metrics — July 29, 2016
  3. Read-consistent backups in Oracle — June 12, 2015
  4. Using python to repair data sources — April 30, 2015
  5. Using DBMS_MONITOR — May 15, 2014

Most commented posts

  1. SQL Server 2008 Spatial Indexes and ArcSDE 9.3 — 6 comments
  2. Open Source GIS Stack — 4 comments
  3. Python and GeoProcessing on Linux, part 1 — 2 comments
  4. Direct Connect made EZ at ArcGIS 10.1 — 1 comment
  5. Find recent files via python — 1 comment

Author's posts listings

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.

Apr 30

Using python to repair data sources

This is really here for me to remember these.  But two lines of python code can be used to change the data source of your current MXD.  Thanks to Malcolm Lobley of Delo Solutions for this tip.   mxd = arcpy.mapping.MapDocument(“CURRENT”) mxd.replaceWorkspaces(“”, “”, r’Database Connections\Connection To SDE.sde’, “SDE_WORKSPACE”)    

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 EnterpriseDB.com. …

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 SSPInnovations.com. You can view that blog post here: http://www.sspinnovations.com/blog/2013/01/14/life-fast-lane

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 »

Older posts «