Submitted by dmann on Wed, 12/13/2006 - 16:31
One of the redeeming qualities of the Java Oracle Enterprise Manager client is the progress bar that comes up when you are viewing the long operations of a session. I wanted this functionality but didn’t want to wake up the big lug to get this info (it takes a long time to start up the OEM client and navigate to the screen to see the long operations progress bar).
So I decided to write a short script to emulate that functionality but take it one step further and show me info about _all_ the longops currently running on an instance.
Submitted by dmann on Wed, 12/13/2006 - 12:00
I recently discovered that someone else is publishing some Perl utilities to monitor Oracle!
I've been using Perl to get things done with Oracle for a while and have found it extremely helpful. The current environment that I work in has a mixture of OSes so sometimes its easier to install Perl and DBI everywhere and write a simple Perl Script than to try to do something in DOS Batch for one client and then do it again in a bash shell script for another.
Sean Hull published a video of his talk about otop, the PowerPoint slides, and the downloadable source on his company's site:
Submitted by dmann on Wed, 12/13/2006 - 11:44
Windows / Apache / MySQL / Php.
This is a diversion from my usual immersion in all things Oracle. Along with my blog at http://www.ba6.us I've got a handful of sites that are quick and dirty custom webapps that I host on BlueHost.com. BlueHost, like many consumer level web hosts offers Apache, MySQL, and Php on the cheap.
I wanted an environment I could use for development and experimentation. Here is how to set up a simple dev environment for Apache / MySQL / Php on a Windows machine…
I'm not going to cover installation of Windows here.
Submitted by dmann on Thu, 12/07/2006 - 15:46
This is for all the database purists out there, what's most important? Forget the implemention, the operating system, the transactions per second. Its the data!
Swivel.com is a website where you can browse or upload data sets. For better or worse you can also compare them.
Submitted by dmann on Sun, 10/22/2006 - 22:04
If you have a lot of LOB data to move around with Oracle import/export utilities this might help you out. The default for the COMMIT parameter is No.
COMMIT=N : For tables that have a LOB column, commit is performed after loading each table
This is much faster but be aware that you will use more Rollback space since each table will be committed in one large transaction.
COMMIT=Y : For tables that have a LOB column, commit is performed after each row (slow!, much overhead added because so many transactions are used to import the data)
Submitted by dmann on Sat, 10/14/2006 - 11:40
The USDA supplies a Nutritional Database. It has about 7300 foods and associated nutritional information. Most of the foods are the simplified components instead of brand names, but its usually easy enough to find equivalents. It can also be used as a jumping off point for a more comprehensive database.
Info about the information supplied: http://www.nal.usda.gov/fnic/foodcomp/Data/SR19/sr19_doc.pdf
Submitted by dmann on Thu, 08/10/2006 - 16:29
Tired of updating scripts by searching and replacing until your fingers fall off? Have a SQL statement you have to run against every table in your schema?
Next to Regular Expressions, this is one of the most useful tools in my arsenal.
Common uses for this are to write SQL statements that can work from a list of objects in the database: