SQL Server and Distributed Transaction Tuning
Users complained that a monthly financial report would no longer run SQLServer Reporting Services, (SSRS.) Upon investigation, it was found
Read More
Making Technology Bulletproof
Author: Kellyn Gorman
Keep it Simple and Other Superman Challenges
“Oh what tangled web we weave when complexity is added we can’t see…” How many times has complexity of design
Read MoreDisaster Recovery and Other Sacrifices
If you desire a subject that will invoke deep passion and often combined with disgust from a group of DBA’s,
Read MoreTempfile Read /Writes and ASM
I truly believe that database myths are the scourge of the database world. With that said, I have to blame
Read MoreA Tale of Session Parameter Settings
This is another blog post about how TEMP can kill you in performance. The Program Global Area, aka PGA, is
Read MoreWarp Speed with Temp Tablespace Groups
The introduction of the temp tablespace was a crucial step in the RDBMS to separating the “work area” for sorting
Read MoreThe Care and Feeding of Good, Skilled Employees
A blog post by Simon Cooper sent up a reminder of a subject that has been at the forefront of my
Read MoreYou Know You’re Doing Too Much Database Work When…
This is when I know I’ve been doing too much database work in one day. I awoke from a dream,
Read MoreAddressing a Deadlock
I’ve always had a *thing* for trace files. They serve me well- I like them and they seem to really
Read MoreFast Parallel Rollback and Large Transactions
The SMON spit out this error after the cycle of the db on the rollback of the huge insert into the
Read MoreOracle Open World Official Blogger Pass Acceptance
Like Chet, from OracleNerd, I received my official Blogger Approval for Oracle Open World yesterday! This will be my first
Read MoreRound Robin and Parallel Forced to Serial
So we have a parallel process, coordinator 739 running, just not very well… I have an ugly pink section in
Read MoreRMOUG Board of Directors
I started to write this blog post almost two months ago and finally updated it to post to the site.
Read MoreBlogger Registration Complete for OOW 2011
Thanks to Chet Justice of OracleNerd, I’m now registered for Oracle Open World 2011 with the Blogger’s registration. I will
Read MoreOracle Streams and Performance Considerations
Although Streams is a goner, (Golden Gate taketh over…) My notes on performance considerations when utilizing streams as I work
Read MoreReasons Behind Collecting SQL Baselines Before an 11G Upgrade
Jeff Smith, via Twitter, asked a very good question about my previous post regarding baseline plans when upgrading from 10g
Read MoreConsistent Performance for 10g Upgrades to 11g
When involved in an 11g upgrade of a 10g database, one of the important goals for a DBA is to
Read MoreAWR for RAC
Another little known set of AWR reports are ones that are RAC specific and cluster wide versions, giving the RAC
Read More