Tag: oracle

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: , , , , ,

Database Driver’s License

Do you just hand your keys to whoever wants access to your car or your house? Why do so with your database? Just because someone wants to look at ‘your’ data, doesn’t mean you have to let them in without asking a few questions, right? While the person won’t be driving your car, they’ll be […]

Similar Posts by Subject Areas: , ,


After a year of blogging and living out loud on Twitter, I have started to build a nice network and community. One of the people in my new network is Martin Berger (blog | Twitter). Earlier this week, Martin responded to my Toad Challenge with a question about ‘Before Select Triggers’ (conversation) So let’s get […]

Similar Posts by Subject Areas: ,

I Just Wanna Connect to Oracle!

I have had quite a few SQL Server folks tell me their first experience with Oracle (database) was a very bad one. It’s easy to understand why. Microsoft makes it very easy to connect to SQL Server from a Windows OS. If you have installed SQL Server on your machine, you also get a very […]

Similar Posts by Subject Areas: , ,

ORA-03113: end-of-file on communication channel

Don't ignore the warning signs. This crash was completely avoidable.

My database crashed today. My ‘production’ database that is. The one I rely on for product demonstrations, that thing I do that Quest gives me money for. Pretty funny considering in the last few weeks my blogs have included such gems as: Are You a Real DBA – I argue that you are indeed NOT […]

Similar Posts by Subject Areas: , ,

Toad Jobs

A lot of good news this week about jobs here in the United States and a bunch of new hires for the month of April has many people feeling much better about the US economy. After being hammered with depressing reports for the past two years, it’s very nice to see the pendulum swing in […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , ,