ThatJeffSmith

Tag: oracle

Hint Abuse: SQL Server vs Oracle

I’ve overheard the SQL Server folks talking about the challenges of support applications where the NOLOCK (or is it NO_LOCK?) hint has been deployed to make transactions and queries go faster. This probably causes more problems than it solves, and rather trying to rehash what I’ve heard second hand, I suggest you go listen to […]

Similar Posts by Subject Areas: ,

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

I Hate it When Toad Gets in My Way!

This week was ‘visit customers and show off Toad’ week. I didn’t get a lot of questions, but one question did come up in almost every meeting – “How do we turn off that annoying popup thingy in the editor?!? I just want to type and Toad gets in my way!” The good news is […]

Similar Posts by Subject Areas: , ,

Why Did You Steal/Hide My Favorite Button!?!

Sometimes we get bored and change stuff in Toad just to mess with people. I’m pretty sure there are people out there that really believe that. In our defense, I will say that we do change things pretty frequently, but it’s always in the pursuit of improving the user experience. However, sometimes there are unintended […]

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

Row, Row, RowID Your Record, Gently Update the Table

You may have heard the term ‘ROWID’ many times without really stopping to think about what purpose it serves. The end user – or even the application developer themselves – will rarely have a need to interface with a ROWID. Even so, ROWIDs do a lot of cool things. According to Oracle, ‘They are the […]

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

Watching Paint Dry or V$SQLTEXT_WITH_NEWLINES

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

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

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