Author: Steve

Who’s blocking my java?

Hanging java applications can be a system architects worst nightmare. There are so many pieces in the stack, finding where the true issue lies can be a daunting task. Fortunately, you can dump all threads in a JVM to see…

Renaming an ASM diskgroup in 10g

Since their is no “alter diskgroup rename” command, I tried this on a test system and it works.  Pretty cool, but this not even remotely supported by oracle, so use at your own risk 🙂 With everything down… cd $ORACLE_HOME/rdbms/lib…

Using v$sql_bind_capture

This is a very useful view in 10g. When a user came to me with a performance problem, I used to find myself asking, “What value did you use for the search?”. Not very professional, although it could work. I…

Migrating from raw devices to ASMLIB

Oracle’s Automatic Storage Management (ASM) technology was introduced with releases 10.1 of its flagship database product. It was designed to remove from the database administrator’s task list the need to decide on which disks to place which datafiles. It is…

Generating values from block dumps

Today, I had to identify all rows on a given block. I used DBMS_ROWID, but initially I wasn’t using it correctly. I figured out what I should have been doing (below)… select work_id from xwc.frbr_holding_display partition(FRBR_HOLDING_DISPLAY_P12) where dbms_rowid.ROWID_BLOCK_NUMBER(rowid,’BIGFILE’) > =…

CPU used by service

What is below will query AWR and print CPU for a given service in a three instance cluster. This hardcodes the three instances, as well as eight processors with half hour AWR samples (14,400 seconds of CPU available). set serveroutput…