Querying the Oracle REST Data Services for your Oracle Database

thatjeffsmith ORDS 5 Comments

So you’ve installed ORDS, you’ve REST enabled a schema, and you’ve started publishing some RESTful Services. Now, how do we go about seeing what’s what? You could browse… You could search… Or you could query the data dictionary! I’m going to look at USER_ORDS…stuff. We have _MODULES, _TEMPLATES, and _HANDLERS – most of what you’ll want is there. SELECT name, …

Querying Your Oracle SQL Developer Data Modeler Designs

thatjeffsmith SQL Developer 7 Comments

Oracle SQL Developer Data Modeler has a multi-user repository that makes it very easy to control and version changes to your data models and designs. However, it’s stored in a Subversion (think files) repository. Many of our users are accustomed to having EVERYTHING stored in the database. And when something is in a database, then it can be accessed via …

They Just Write SQL Statements

thatjeffsmith Database Stuff 4 Comments

“Those people are fine, they JUST write SQL.” I often hear this in the context of visiting customers and offering to provide training (and yes, software) to their database users. There is a class of people who are deemed unworthy of such productivity tools because they do nothing but ‘just write dumb SQL all day long.’ The only problem is, …

SQL_IDs, Plans, and Baselines, Oh My!

thatjeffsmith Database Stuff 1 Comment

Do you run a 3rd party application that uses Oracle RDBMS under-the-hood? Do you experience performance issues? Frustrated that you do not own the application SQL that is causing the issues? Maybe an upcoming upgrade to 11g might give you some relief. Many of the customers I speak with are unaware of a new 11g feature called ‘SQL Plan Management’ …

Is Your Query Running?

thatjeffsmith Database Stuff 4 Comments

You better run and catch it then! You know you’re getting old when the new crop of kids don’t get this joke, or even worse, don’t understand what a prank phone call is. I’m pretty sure that folks still get phone calls from frustrated people who want to know how much time is left before their query will finish executing. …

Driving Blind?

thatjeffsmith Database Stuff 1 Comment

I travel quite frequently for my job. Number one on my list of ‘must have things’ on the road is a Navigation device. This used to be my trusty Garmin, but now thanks to my new Android device, I have Google Maps. There have been times and places where I don’t have the device available – either the GPS satellites …