How much time to do you spend debugging database application problems? Probably more time than you want. How much of that time is spent capturing the SQL that is being submitted by your application to the database? I’m going to guess that it’s a significant amount. Asssuming you have access to production (or a test [...]
oracle
Toad Trick: Filtering Schemas in Oracle
In five minutes see how you can save yourself a few seconds every time you want to switch from one schema to another in Toad. You can read more about filtering in Toad in my blog post from several years ago – Finessing Filters and Other Fun Features. More Toad Videos Liked this but looking [...]
Putting the Cart in Front of the Horse
People are always asking me, ‘Jeff, what’s going to be in the new version of X?’ or ‘Jeff, what’s new in X?’ or ‘Jeff, what’s wrong with you?!?’ If I’m feeling particularly chippy, I’ll reply something along the lines of ‘How well do you think you’ve mastered the current version of X?’ If you haven’t [...]
Oracle 12g This Fall?
Post Updated on November 10, 2011. 11gR2 was supposed to be 12g..or so the story goes. You can read tons of posts on OTN from several years ago where 12g is referenced. Nothing recent though. So… Oracle Open World 2011 is coming soon, and you know the Big Red Machine will want to have a [...]
How Many Rows will my Query Return?
You want to know how much pain you are going to inflict on the server and network before you run that ad hoc query? An explain plan can give you an idea of how long it might take to run, and tell you how much data it thinks will be involved. Cardinality – Fancy Word, [...]
Twitter
RSS
GooglePlus
Facebook