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
| Attachment | Size |
|---|---|
| deathmatch.pdf | 2.12 MB |
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.
| Attachment | Size |
|---|---|
| new_treeview.zip.doc | 10.42 KB |
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.
| Attachment | Size |
|---|---|
| Rac_Syncro.zip | 171.14 KB |
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.
| Attachment | Size |
|---|---|
| Sane_SAN_WP.pdf | 641.75 KB |
A simple script for enchancing the functionality of dbms_stats to gather optimizer statistics.
| Attachment | Size |
|---|---|
| dbstat.rename | 9.68 KB |
$ 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
| Attachment | Size |
|---|---|
| ascii.rename_to_sh | 2.81 KB |
Recent comments
1 week 12 hours ago
1 week 18 hours ago
4 weeks 28 min ago
11 weeks 6 days ago
14 weeks 6 days ago
19 weeks 2 days ago
19 weeks 3 days ago
19 weeks 5 days ago