Slideshare won’t let you update slide decks anymore, so I just uploaded my latest version as a new offering. All of the Performance Tuning Features in Oracle SQL Developer, 2018 Edition from Jeff Smith I’ll be presenting this topic at UKOUG this week. if you’d like me to present this to your group of the developers and administrators, drop me …
Scheduling Exports of Your Data Using the Cart
This post won’t show you how to acutally do the scheduling bits – I’m going to assume you know how to use contrab or Windows Scheduler -but I will show you how to get SQL Developer setup so that you can call it from the command-line to do your export. Our requirements – from an AskTom question – I want …
INFO vs DESC – Learning About your Oracle Schema Objects at the Command Line
Here’s an 8 minute video walk through of using INFO and DESC in Oracle SQLcl. You can decide what works better for you – hey, maybe you’ll decide to use both! INFO shows more info INFO+ shows more info with more stats You can INFO a package OR a package.procedure Enjoy! PS – I made this on my new rig …
Oracle SQL Developer Version 18.4 Sneak Peek
So someone asked us on Twitter this morning about a new Document that opens on an Export of a query result set. How can I prevent the "Export Tool" log in SQL Developer 18.3?I get it whenever I create some DDL over the navigation [email protected] @OracleSQLDev #sqldeveloper pic.twitter.com/8zyfquqxZ6 — Tobias Arnhold (@tobias_arnhold) November 15, 2018 The short answer is, that …
Query Builder: Where Are My Joins?
One of the improvements for version 18.3 was a much improved, performant query builder. Of course, not all things are free. Or in fact, nothing is free. So who paid for these performance gains? We disabled one of its primary features. But first, let’s take a step a back and explain the scenario. How it Was, Pre 18.3 The query …
Video: What’s New in Oracle SQL Developer for 2018
This was one of my 3 sessions at Open World last week. None of them were recorded, but I figured you might find this one interesting, so I ran through the slides again here. If you search this blog for things like ‘18.1’, ‘18.2’, and ‘18.3’, you can find all the blog posts I put together showing some of these …
All of Your Objects: Reports
Today’s question: I am looking for a way to list out all and count all objects by all schema, any idea? So the connection tree is nice in that it makes it easy to see specific types of objects by schema – but if you want a FLAT view of a schema, it’s not so great. Ok, so what’s a …
Modeling JSON in Oracle Database Tables, Part 2
In case you haven’t figured this out by now, 90% of my material here is generated by questions from folks like you out there. So thanks for the never ending supply of content! And it gives me an opportunity to keep learning as well! So the question: I believe this json data type in MySQL would probably map to either …
Yes, SQL*Loader is Faster at Loading Records
Someone asked on StackOverflow how to get loading a 1,000,000 records to be faster in SQL Developer. My answer was basically, don’t use SQL Developer to load 1,000,000 records, use SQL*Loader. Now, I also reminded folks that you can USE SQL Developer to build your SQL*Loader scenario. There’s 2 ways actually: Query existing records, export to Loader (Keep Reading this …
Data Modeler Tip: Assigning a SCHEMA to Your Objects
Was helping someone on Stackoverflow this morning, and thought you might enjoy seeing this process as well. PROBLEM: You’ve created a schema script, you’ve generated the DDL, and you ran it on your brand-spankin’ new database. Except. Except, you ran that script as SYS, and your schema scripts didn’t have a SCHEMA defined. So you’ve corrupted your SYS schema!!! How …