Uncategorized Archive

SASH 2.2

Simulation – v2.2 V2.2 – Installs on Windows or Unix on Standard Edition New version of S-ASH package has been published. It can be downloaded from SourceForge project OraSASH . New features: – improved configuration setup and internal error logging – support for Oracle RAC – it has been tested on Oracle SE RAC 11.2 [...]

Lab 128

If you have never heard of lab128, it’s worth checking out: http://fwww.lab128.com/lab128_screens.html lab128 is one of the few tools on the market to harness ASH data. The tool spectrum as I see it is OEM 10g/11g – $10,000 up to millions of dollars !  ($5000 per CPU AFAIK ) , slow, big install but has [...]

ASHMON on 64bit Oracle 11gR2

It’s been years since I’ve changed any ASHMON code though I have used ASHMON whenever I didn’t have access to DB Optimizer or when I wanted to specifically access v$active_session_history graphically. Yesterday, though, I just got a new laptop that is 64bit and I couldn’t get ASHMON to run! So after only sleeping 4 hours [...]

SASH 2.1 released

New SASH 2.1 now available! See http://ashmasters.com/ash-simulation/simulation-v21/ Thanks to Marcin Przepiorowski for these improvements. NOTE: people are encouraged to improve the code. I wrote the original 2 versions and now Marcin has stepped up with 2.1. I can no longer change the code and give it away for free as I’m full time at Embarcadero and [...]

Jonathan Lewis is my favorite presenter on Oracle performance and tuning and so I’m both excited and nervous that Embarcadero is hosting a free live webinar co-presented Jonathan Lewis and myself. I’m excited about the webinar because Jonathan and I will be talking about how query diagram visualizations can aid in the tuning of SQL queries and [...]

test

test

Spam Filter

Finally installed a spam filter so you can now post questions here as well as http://db-optimizer.blogspot.com/ThanksKyle

Contacting ASHMASTERS

For all questions reguarding content on http://ashmasters.com, please post them at: http://db-optimizer.blogspot.com/2009/10/ashmasterscom.html The questions posted here at ashmasters.com are not being addressed currently, due to the inordinate amounts of spam.  If you have any questions on the content at ashmasters.com or would like to update or add new scripts, please post your ideas and and [...]

New Tool ! and new Directions

As some of you might now, I joined Embarcadero Technologies in July to pursue my dream of building a production version of  ASHMON.  It’s now ready and will be released March 17th, 2009.If you act within  the next two weeks you can still get in on the beta testing program. More information on: http://sites.google.com/site/embtdbo  Beta versions [...]

Oracle Analyitcs Explained

 Thanks to Jared Still who posted this one on Oracle-l: Oracle Analyitics