Submitted by dmann on Fri, 07/20/2007 - 16:01
So I took my first hands-on class from Oracle this month.
I'm usually of the 'sit down with a book and computer' camp when I need to learn something new, but where I work we needed RMAN proficiency quickly. I thought it might be better to get out of the office for a few days and buckle down on the topic.
Submitted by dmann on Mon, 06/25/2007 - 15:57
Statspack Reports can be useful for diagnosing performance problems, but they are only useful if they are generated and available!
Submitted by dmann on Wed, 05/23/2007 - 13:33
I found an interesting article by Scott W. Ambler on Doctor Dobbs Journal today called "Questioning Traditional Data Management".
Scott points out 6 assumptions data management professionals often make and points out why he believes they are not valid assumptions. Assumptions like: It's expensive to evolve a database schema and Review and inspections are an effective way to ensure quality.
At this point in my career I have worked as a DBA about as long as I was a Software Developer so I can see both sides of this issue.
Submitted by dmann on Thu, 04/19/2007 - 18:42
So my last post was about administration on Linux. After running Oracle on Windows for way too many years we migrated our Oracle systems to 64-bit Linux over the past year.
Now that we're on Linux I needed a lightweight way to capture and graph some performance data. The performance data was a mix of OS utilities and 3rd party utilities, but all the utilities output text, so I knew I could screen scrape the output, massage it a little, and save the data to a file. After I had the data in a file I knew I could run it through GnuPlot to graph it.
Submitted by dmann on Thu, 04/19/2007 - 14:29
…is not as hard as it is on Windows. I went searching for articles on the topic and couldn't really find any. Now I know why.
In Windows land to move binaries for an instance from one machine to another you have to worry about oradim/registry dependencies. Because of all of this I usually just install Oracle binaries off of the original disks and patch to appropriate level and the move the Database (data files, control files, etc) and recreate the database on the new machine.
Assuming the source and target are the same architecture on Linux I had to:
Submitted by dmann on Thu, 04/19/2007 - 06:42
There may come a time when you need to return an error code from SQLPlus, either to a calling batch file, shell script, or Perl script.
SQLPlus has a WHENEVER directive available for handling errors it encounters. This command controls the behavior of SQLPlus when an OS or SQL error occurs. There are many options for this behavior.
More after the jump…
SQL errors include errors thrown by a single command entered into SQLPlus or an error raised by a PL/SQL block:
Submitted by dmann on Tue, 04/10/2007 - 19:08
Did you know you can make your own Long Running Operation that is available to the V$SESSION_LONGOPS system view?
At the bottom of the Oracle documentation for DBMS_APPLICATION_INFO is some example code: http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_appinf.htm#i999254
In a previous post I posted Perl source code for a script that monitors V$SESSION_LONGOPS and reports progress of all current long operations: TODO
Submitted by dmann on Tue, 04/10/2007 - 19:03
I've recently been working on improving the Database Change procedures and Deployment procedures where I work. We like to turn around releases every 2-4 weeks or so but sometimes the friction of keeping a sane and organized development process slows us down. At this point I would rather be slow than to introduce errors to our production environments but I am always looking for ways to improve accuracy and speed of our processes.
Submitted by dmann on Thu, 03/29/2007 - 18:55
I've been looking for ways to automate running of Oracle SQLPlus PL/SQL scripts.Of course there are always batch and shell scripts but I'm looking for something less OS specific.Our Java build process is controlled by Apache Ant. It would be nice to include running of SQL scripts in this process. Here are some tools to help integrate SQLPLUS with ANT.
This task is best for executing bits of literal SQL. This task doesn't know anything about SQLPlus features such as formatting, variables, spooling, etc.
Submitted by dmann on Fri, 01/26/2007 - 21:45
So I'm 60% of the way to my 9i OCP now. I passed 1ZO-031 today. I already had the 1ZO-007 test and a hands-on class under my belt.
So far I've been using the Certification Candidate Guide, Oracle Press books and of course the Oracle documentation. For my next two exams I got some Sybex books cheap off of Amazon.com that I'll be checking out.