Search

OakieTags

Who's online

There are currently 0 users and 14 guests online.

Recent comments

Affiliations

Database Deathmatch: Oracle vs. SQL Server

Recently I presented my new live demo pitting Oracle against SQL server under full load enduring a series of catastrophic ordeals.  These are my slides.  I will present it again at the Michigan Oak Table Symposium and Oracle Closed World in September. -Jeremiah

AttachmentSize
deathmatch.pdf2.12 MB

10053 Viewer

The attached file is a zip file containing the 10053 trace file viewer written by Hans-Peter Sloot of Atos Origin and Robert van der Erde.
 
Warning - when I uploaded the file as a .zip file it seemed to get corrupted, so I've added a .doc extension to the filename. When you download it you need to save it without the .doc extension before you try to unzip it.
 
 

AttachmentSize
new_treeview.zip.doc10.42 KB

RAC Synchonous Alert File Reader

So you have 3 alert files from your 3 node RAC and you are trying to see what happened in the cluster as a whole. The Rac Synchro Reader will let you view the alert files of all 3 nodes side by side, with the timestamps aligned. When you scroll one alert file the others will scroll to a matching timestamp.

Windows executable. Others have found it works with the Listener logfiles, too. Tested for alertfiles from version 9 and 10.

{------------------
  Read alert-log files from RAC from several instances.
  Scrolling will scroll the text synchronised by the timestamps

  Usage:
    Open at least two ordinary alert files (up to 8 supported)
    Use the scroll bar.
      The marked filewindow will scroll according to the scrollbar
      The other files will scroll trying to match the visible timestamp
    Using the scrollbar in a filewindow will scroll that file
      without the others moving.

  Version beta 0.4 - (under development)

  Usage features To Be Implemented
    MouseWheel scroll to work for main scroll bar.
      (Or enable/disable individual scroll (Shift?) )
    ?Specify a time offset +/- factor to each file's timestamps
    Find string

   Known bugs - or "Will work or crash or do funny things"
      A zero byte in text files (stops input)
(The bug wih the "nul"-byte occurs in some unix based alert files, so 
strip nul bytes when trasnferring to you window machine. It is a bother 
for me to fix as the file is parsed by a delphi library routine.)
      No matching time found at all. (scrolls to EOF on slaves.)
        Should be TOF/EOF appropiate to best timestamp fix
      ?Start scrolling action(s) before >=2 files loaded. (Block until ready?)
      ?small files, huge files (Huge: CPU processing! avoid reparse)
      Non-alert files (parse trace files?!)
  The current search implementation it is "Quick and VERY dirty and CPU waste"
  ----------- } 

This program was written in Delphi (v4) This is the first "proof of concept" version (thus the 0.x version) where it does a brute force scan of the input files every time anything is scrolled. With the large computing power of any laptop/desktop this was sufficient to get the job done (for alertfiles < 1Mb) and the fancy version with parsing and mainting index pointers and other optimizations never got written.

One of these days I'll make a Java version so the linux people can se it, too.

 

AttachmentSize
Rac_Syncro.zip171.14 KB

Sane SAN pdf

 In a world of SAN-based insanity, seek refuge in a few logical thoughts on how to regain predictable, measured performance, and simple maintenance of your SAN.

AttachmentSize
Sane_SAN_WP.pdf641.75 KB

A simple script for enchancing the functionality of dbms_stats to gather optimizer statistics.

 A simple script for enchancing the functionality of dbms_stats to gather optimizer statistics.

AttachmentSize
dbstat.rename9.68 KB

Translate hex into ascii

$ ascii.sh 5458 
T X 

ie in HEX, the string "TX" is 5458 

like wise you can pipe an Oracle Trace file with HEX dumps in it and get some interesting output 
$ cat ora_88008.trc | ascii.sh 
 
 

AttachmentSize
ascii.rename_to_sh2.81 KB