Select Page

Blog

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

Author: Jeremiah Wilton
Browse Blog Categories

Too Many Flashbacks

Did I ever tell you the makers of RAC had seven features and named each flashback?

Jeremiah Wilton | January 25, 2012

Finding non-default configuration settings in SQL Server

In our Remote DBA practice, we frequently perform comprehensive system reviews for our customers on their database services.

Jeremiah Wilton | August 25, 2011

Amazon RDS for Oracle: First Impressions

On Tuesday, Amazon announced availability of an Oracle version of their Relational Database Service (RDS). RDS is one of Amazon’s cloud services.

Jeremiah Wilton | May 26, 2011

Determining optimal Amazon S3 transfer parallelism

Amazon’s Simple Storage Service (S3) is a robust, inexpensive and highly-available internet data storage service.

Jeremiah Wilton | April 23, 2011

Oracle tablespace hot backup mode revisited

Here’s a revised version of an old popular article I wrote over ten years ago. I wrote this when I was at Amazon.com, long before I came to work at remote DBA provider Blue Gecko. Enjoy! Oracle’s pre-RMAN hot backup mode is the subject of one of the most pervasive and persistent misconceptions about Oracle.

Jeremiah Wilton | December 9, 2010

YPDNGG: You Probably Don’t Need Golden Gate

Before launching into this, I must give due deference to Mogens Nørgaard’s landmark article, You Probably Don’t Need RAC (YPDNR), available here, but originally published Q3 2003 in IOUG Select Journal.

Jeremiah Wilton | November 22, 2010

Good OCP / Bad OCP

For those contemplating launching a career in Oracle database administration, there are essentially three routes.

Jeremiah Wilton | August 4, 2010

How Incompetence Stimulates the Information Technology Economy

As information technology professionals, we constantly complain about mismanaged projects in which we have the misfortune to be involved.

Jeremiah Wilton | April 8, 2010

Converting Hexadecimal Oracle SCNs to Decimal

Oracle serializes transactions and manages concurrency and recovery using an ever-increasing number called a system change number, or SCN.

Jeremiah Wilton | November 19, 2009

ORA-00054: Resource Busy and Acquire With NOWAIT Specified

Ora-00054 fix! Learn how to resolve Oracle errors, including this truncate error: ORA-00054: Resource Busy and Acquire With NOWAIT Specified.

Jeremiah Wilton | September 22, 2009

ORA-12154: TNS:could not resolve the connect identifier specified

Most people will encounter this error when their application tries to connect to an Oracle database service, but it can also be raised by one database instance trying to connect to another database service via a database link.

Jeremiah Wilton | March 4, 2009

Work with Us

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

CONTACT US

Work for Us

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

EXPLORE JOBS