15 minutes overview of how to use these features in Oracle SQL Developer: Get an Explain Plan Customize the display of the plan Get a cached plan Use DBMS_XPLAN Compare Plans Use Real Time SQL Monitoring Use AutoTrace. And if you want an awesome video, MUCH more in depth about how to read a plan, then I suggest this from …
How to Open your PL/SQL Objects…With the Keyboard in SQL Developer
I have some code… BEGIN give_raises(); END; / I can guess that GIVE_RAISES is a procedure of some kind. But now I want to open it, or ‘go to it’ or ‘step into it.’ And I want to do so without having to pick up my mouse. So I could tell you about the Ctrl+Click trick, but that’s all mouse. …
Loading data from OSS to Oracle Autonomous Cloud Services with SQL Developer
Ok that title has a TON of buzz and marketing words in it. But, we have the Oracle Cloud. And available there is a service where we take care of your database for you – Autonomous. We make sure it’s up, and that it’s fast. We have 1 autonomous cloud service today and will have and second one coming SOON. …
Easier Execution Plans in Oracle SQL Developer
SQL tuning can be fun. The database gives us MANY things to help with this. There is even a nice set of views that contain everything we need to know about our SQL and their exectution plans. And, we have a really cool PL/SQL package, DBMS_XPLAN for generating reports on our troublesome queries. The not-fun part, is going from a …
Oracle SQL Developer version 18.2 – Faster!
So two areas of major performance improvements in Oracle SQL Developer version 18.2: Importing from Excel Using the Query Builder Importing from CSV was generally always pretty fast. Working with Excel consumes a lot of memory, and it took a lot of time to load an Excel file to be imported. Well, it still uses a lot of memory – …
Version 18.2 Is Now Available (SQLDev, SQLcl, DataModeler, ORDS)
It’s that time of year again, we have just released updates to all of our tools! Downloads Here: Oracle SQL Developer Oracle SQLcl SQL Developer Data Modeler REST Data Services (ORDS) Let’s Talk about SQL Developer It’s a minor release, no new major features have been introduced. But, we fixed a TON of bugs. And more than several of those …
VIDEO: Importing from Excel Table
It’s a bit long at 17 minutes, but I go through the process of: creating a new table based on an Excel/CSV defining the columns checking the column names checking the column definintions is the column wide enough? defining DATEs running the export fixing errors saving the scenario so you can run it on demand Remember, if you prefer to …
Where Desktop and Web Collide – Sharing Data Modeler Diagrams
You might have heard we now have a new SQL Developer in the family: SQL Developer Web. If that’s news to you, here’s a quick video recap: Hopefully you noticed that one of the main features of SQL Developer Web (and SQL Developer Desktop!) is data modeling. We were thinking: wouldn’t it be nice if could pull up a diagram …
Easier Preferences…Digging
We have a LOT of application preferences. And users have a funny habit of asking us to add MORE to every release. So, it’s great that we make it very easy to customize their SQL Developer experience via a few clicks and toggles. But, it’s kind of hard to find the RIGHT switch when you want to go change something. …
SQL Developer Reporting: Video Demo & Slides
As a feature: Been there forever On the desktop by default 80% of you aren’t using it I think it’s a feature that can really turbo charge your experience with the database and SQL Developer – so I did a 10 minute talk on the subject. So if you’re curious about what you might be missing, here you go! And …