Tag: oracle

Oracle Discovery Tool?

My employer has a freeware utility you can run on your network to find and document instances of SQL Server. One of SQL Server’s primary advantages is also one of its primary disadvantages – you can spin one up in a manner of minutes. To grow deals at a company buying our SQL Server software, […]

Similar Posts by Subject Areas: , ,

We’re Gonna Need a Bigger TEMP Tablespace

It’s one of the most iconic scenes in American film – Roy Schneider’s character is chumming the water and sees the shark they are hunting. The massive size of the fish causes him to comment, “We’re gonna need a bigger boat!” It’s shark week, and I was struggling with inspiration for blog posts, so apologies […]

Similar Posts by Subject Areas: , ,

Truncates ARE Logged

Someone asked me yesterday where do I get my blog topics and ideas from. Usually it’s from watching too much TV, but often it’s an actual question or topic that is raised by a co-worker or customer. Yesterday I was asked by my boss about how to find out when TRUNCATEs have been issued because […]

Similar Posts by Subject Areas: , ,

Support – Start Your Local Oracle User Group

I am noticing a very disturbing trend in the Southeast US – the local Oracle User Groups are withering away. One of the questions I like to end a presentation with is to inquire about the presence of a local Oracle User Group. More frequently than not, the answer is, “Well, we used to have […]

Similar Posts by Subject Areas: ,


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 […]

Similar Posts by Subject Areas: , , ,

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 […]

Similar Posts by Subject Areas: , , ,

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 […]

Similar Posts by Subject Areas: ,

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, […]

Similar Posts by Subject Areas: , ,

On Real-Time SQL Monitoring and the /*+MONITOR*/ Hint

Oracle 11gR1 Enterprise Edition with the Diagnostic and Tuning packs has a very compelling new feature, Real-Time SQL Monitoring. Oracle thinks enough of the feature that it was highlighted prominently in whitepaper by ACE Directory Arup Nanda titled “Oracle Database 11g: The Top Features for DBAs and Developers” (read it here) Long story short: Too […]

Similar Posts by Subject Areas: , , , , ,

Moving Data to Oracle with Migration Workbench

I’ve been referring customers to SQL Developer’s Migration Workbench for a few months now. I thought it might be a good idea to give it a try myself before I send any more children out to play with the wolves. This is NOT a formalized review. This is a quick glance at a cool tool […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , ,