Oracle Shell Scripting: Another 5-star review!

Well, I’m glad to see that people are liking my book Oracle Shell Scripting: Linux and UNIX Programming for Oracle. Another 5-star review showed up on Amazon last week:

Jolly writes:

Great book!

A well written book. A great way to learn shell scripting. Relevant and useful examples throughout the book (downloadable code).

Thanks for the review Jolly!

Oracle Shell ScriptingFor more information like this check out my book Oracle Shell Scripting, only $34.95 from Rampant TechPress.

Buy it now!


Oracle Locator Express – Manage Multiple Oracle Homes in Windows

If you administrate Oracle databases on Windows or even just have a few installations of Oracle on your desktop (I personally have 4) then you probably have noticed that changing Oracle Homes in Windows isn’t necessarily as easy as it should be.

There used to be a tool called Oracle Home Selector but it seems to have gone the way of the buffalo. Enter Oracle Locator Express.

Oracle Locator Express

This little application runs as a normal exe and puts an icon into the notification area of your Windows taskbar. A click will show the current Oracle home location (very handy) and a right click will let you select from installed Oracle homes.

The OLE application is less than 200kb and the best part is it’s free! DbMotive has some other tools which might be worth looking at while you’re at their site, but I can tell you right now that Oracle Locator Express is well worth having!

oracle, dba, database, database administrator

I receive an Oracle ACE award!

Here’s a nice surprise that came up last month (and unfortunately I’ve been too busy to write about it until this month,) I’ve been presented with an Oracle ACE award! What is it? In the Oracle ACE Program FAQ it’s described like this:

The Oracle ACE Program is designed to recognize and reward members of the Oracle Technology and Applications communities for their contributions to those communities. These individuals are technically proficient (when applicable) and willingly share their knowledge and experiences.

The program comprises two levels: Oracle ACE and Oracle ACE Director. The former designation is Oracle’s way of saying “thank you” to community contributors for their efforts; we (and the community) appreciate their enthusiasm. The latter designation is for community enthusiasts who not only share their knowledge (usually in extraordinary ways), but also want to increase their community advocacy and work more proactively with Oracle to find opportunities for the same. In this sense, Oracle ACE is “backward looking” and Oracle ACE Director is “forward looking.”

The ACE award seems like a great way to recognize and encourage people to contribute to the Oracle community as a whole. ACE directors additionally commit to being involved in their local Oracle community, posting to the Oracle forums and a handful of other community-centric activities.

There are currently 159 people in the Oracle ACE program and if you frequently surf for Oracle information you’ll recognize many of the names (e.g. Doug Burns, Steve Karam and Tom Kyte, just to name a few.) I’m thrilled and honored to be part of the program and plan to keep contributing where I can!

oracle, oracle ACE, database, database administration, dba

Oracle 11g, automatic features and a few warnings

If you’re an Oracle DBA like me you are probably wondering how 11g, Oracle’s most recent release, will affect you. Don Burleson who points out some great new features of 11g:

The new Oracle data compression utility promises to save on disk storage up to three times over storing data in an uncompressed format, with relatively small overhead.

SPA [SQL Performance Analyzer] is one of the most exciting features. It’s a holistic tuning tool that allows you to define and replay a representative workload on your database.

And some appropriate warnings:

Oracle has created artificial intelligence to advise on self-healing operations, and these are often misunderstood and misapplied by people without the requisite background.

Check out the whole article, and if you have a chance be sure to catch Don’s 11g New Features presentation! I was lucky enough to see it before my presentation at the North Carolina Oracle User Group meeting a few weeks ago and learned a lot!

oracle, database, dba

What’s in a name?!

I make no secret of the point that I love the webcomic xkcd and if I blogged every strip I like I would basically end up mirroring the entire comic here.

With that in mind, there is no way I could pass up posting this commic:

xkcd - Exploits of a Mom


Next time someone asks you what a SQL injection is you can point them at this, then explain nicely.

sql, oracle, pl/sql, plsql, exploit, security, sql exploit, dba, database, database administration, comic, fun, funny, sql injection