Database Geek Blog

Using Bind Variables

Lewi — Thu, 03 Nov 2011 19:19:24 +0000

Using Bind Variables is a post from: Database Geek Blog

LewisC’s An Expert’s Guide To Oracle Technology

Ok, I know you you’ve heard of them. Heck, in some cases, you’ve been beaten over the head with them. So why aren’t you using them?

I’ve heard some people saying that it’s easier to code without bind variables. Really? Concatenating strings, potentially with embedded quotes and/or varying formats, is easier than using bind variables?

I got… Read the rest!

Oracle DBMS_SCHEDULER Part 3 – Job Chains

Lewi — Sun, 20 Mar 2011 22:26:54 +0000

Oracle DBMS_SCHEDULER Part 3 – Job Chains is a post from: Database Geek Blog

A job chain is a series of jobs chained together via dependencies. Today’s post walks through creating a 3 job chain.

The first step is to create our programs. I described creating dbms_scheduler programs in the previous entry, Oracle DBMS SCHEDULER Part 2 – The API.

These are very simple programs with no arguments. You can use SQL Developer to create… Read the rest!

Oracle DBMS_SCHEDULER Part 2 – The API

Lewi — Mon, 14 Feb 2011 16:32:00 +0000

Oracle DBMS_SCHEDULER Part 2 – The API is a post from: Database Geek Blog

In Part 1 of this series, I introduced you to the basic components and some information you need to know before using the scheduler. Today’s post will cover using the API to create some basic objects. I’ll show how to use SQL Developer to simplify some of these tasks.

Today’s post will cover creating programs and jobs.

Programs

As I said… Read the rest!

OCFS – Oracle Cloud File System

Lewi — Sat, 12 Feb 2011 16:19:26 +0000

OCFS – Oracle Cloud File System is a post from: Database Geek Blog

OCFS? That sure sounds familiar! OFS, OCFS? Where have a I heard that before? Oh yeah, Oracle Cluster File System! So, now Oracle has a cloud file system? Cool!

OCFS is based on ASM Cluster File System (ACFS) and ASM Dynamic Volume Manager (ADVM). It looks like the marketing material also refers to OCFS as CloudFS. The idea is to use ASM… Read the rest!

Oracle DBMS_SCHEDULER Part 1–The Basics

Lewi — Sun, 30 Jan 2011 15:47:06 +0000

Oracle DBMS_SCHEDULER Part 1–The Basics is a post from: Database Geek Blog

DBMS_SCHEDULER is Oracle’s full featured scheduling solution that runs inside the database. Think of it as a complete replacement for DBMS_JOB (which I do still use occasionally but am using less and less over time). DBMS_SCHEDULER has a lot of benefits over DBMS_JOB – ability to stop a job, ability to reuse code, ability to reuse schedules, ability to chain jobs into a… Read the rest!

Hilarious Ad/Post Collision

Lewi — Fri, 17 Dec 2010 02:05:55 +0000

Hilarious Ad/Post Collision is a post from: Database Geek Blog

I stopped by my blog today to upgrade the version of wordpress and some plug-ins. On the front page I got this hilarious ad and it seemed to really be appropriate to the very silly post it was shown with.

I wrote a very silly post about a data architect and a biz guy (really silly geek humor) and the ad is “Why can’t I… Read the rest!

So a Data Architect and a Biz Guy walk into a bar.

Lewi — Mon, 06 Dec 2010 19:48:11 +0000

So a Data Architect and a Biz Guy walk into a bar. is a post from: Database Geek Blog

Biz Guy (BG): What do you do?

Data Architect (DA): I’m a data architect.

BG: What’s a data architect?

DA: Well, a company is like a big hill and the business people are at the bottom of the hill. Data starts at the top. It looks and smells a lot like poop. As a matter of… Read the rest!

Parallel Operations in Oracle 11g

Lewi — Sun, 14 Nov 2010 17:34:30 +0000

Parallel Operations in Oracle 11g is a post from: Database Geek Blog

Parallel processing is using more resources, specifically CPU but also memory and I/O, to finish an operation faster. An operation might be doing an inventory in a warehouse. One person can do the inventory, walking row by row adding up the inventory. A faster way would be to hire a team of people. Each person would take one or two rows and when… Read the rest!

A few good posts for MySQL and Postgres

Lewi — Thu, 29 Jul 2010 13:37:16 +0000

A few good posts for MySQL and Postgres is a post from: Database Geek Blog

Thought I would share a few links that I read this morning. I don’t do a lot of link posts but these three came off my RSS, one after the other, and all three are worth sharing.

The first is Will Oracle kill MySQL? Come on people! I can’t believe people are still stuck on this FUD. Ronald gives some… Read the rest!

Agility and Analysis

Lewi — Tue, 20 Jul 2010 12:35:56 +0000

Agility and Analysis is a post from: Database Geek Blog

As developers, analysts, adminstrators, etc, I think most of us tend towards perfectionism. We want to do the job right and we want to do the job right the first time around.

Agility means being able to move forward with less than perfect information. Sometimes it means moving forward with information that is known to incomplete or even potentially inaccurate.

So what does that mean… Read the rest!

Twitter Weekly Updates for 2010-07-13

Lewi — Tue, 13 Jul 2010 20:23:00 +0000

Twitter Weekly Updates for 2010-07-13 is a post from: Database Geek Blog

Got my OCP card in the mail today. http://twitpic.com/230ilr #
DB Geek says: Twitter Weekly Updates for 2010-07-06:
Blogged "ODTUG Kaleidoscope 2010 – The Journey So Far" htt… http://bit.ly/bVYwF2 #
Cloud Comments: Comment on A quick overview of PuTTY and SSH for AWS Newbies by Installing a headless GeoServer on… http://bit.ly/d1jO66 #
Interesting. Oracle Adds Support for Open-source R (the language)

… Read the rest!

Twitter Weekly Updates for 2010-07-06

Lewi — Tue, 06 Jul 2010 20:23:00 +0000

Twitter Weekly Updates for 2010-07-06 is a post from: Database Geek Blog

Blogged "ODTUG Kaleidoscope 2010 – The Journey So Far" http://it.toolbox.com/trd/46/2/39672/3 #
#odtug #
ODTUG Kaleidoscope 2010 – The Journey So Far http://it.toolbox.com/trd/73/2/39672/3/twitter #
#odtug265 pigs, chickens and agile development with Maggie Tompkins. Maggie has made 14 consecutive kaleidoscopes. Wow! #
I'm not a chicken or a pig. I'm more like a bacon flavored poultry product. #odtug295 #
#odtug295 a scrum master

… Read the rest!

Twitter Weekly Updates for 2010-06-29

Lewi — Tue, 29 Jun 2010 20:23:00 +0000

Twitter Weekly Updates for 2010-06-29 is a post from: Database Geek Blog

Blog Talk: Comment by Christopher Hamilton on Yahoo Sucks! Google wins. http://bit.ly/cb7OVe #
@datachick I always thought waterboarding sounded like fun. Like dragging you around behind a boat on board. Wheeee! in reply to datachick #
DB Geek says: Twitter Weekly Updates for 2010-06-22:
Blogged "Stupid Proc Tricks -The Weird and Wonderful Overl… http://bit.ly/bdSH3i #
Blog Talk: Comment by jonesr on

… Read the rest!

Twitter Weekly Updates for 2010-06-22

Lewi — Tue, 22 Jun 2010 20:23:00 +0000

Twitter Weekly Updates for 2010-06-22 is a post from: Database Geek Blog

Blogged "Stupid Proc Tricks -The Weird and Wonderful Overload" http://it.toolbox.com/trd/46/2/39311/3 #
My 2 year old turned off the refrigerator and unscrewed the light bulb. I fear what he will do when he discovers the screw driver. #
DB Geek says: Stupid Proc Tricks -The Weird and Wonderful Overload: <!–
google_ad_client = "pub-4372398370642959"… http://bit.ly/bPVMI2 #
Blog Talk: Comment by harishkumar on

… Read the rest!

Yahoo, you are dead to me.

Lewi — Sat, 19 Jun 2010 13:16:40 +0000

Yahoo, you are dead to me. is a post from: Database Geek Blog

Yea, I know. Quite the dramatic title. Work with me for a sec.

I’m pissed. Really pissed. Advance warning: I will rant now.

I forget the exact year but in the early 90s (I think 1993 or 94), I signed up for a novel service. Online email. Remember this is the early 90s. I was an early adopter even back then.

The… Read the rest!