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 @sqlmaria.
I have some code… 68052886669bfbbb399b9d_000001 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. So what’s a child of the 80’s to do? Define a keyboard shortcut for ‘Open Declaration’ and then…
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 SQL statement to the SQL_ID. Now, SQL Developer has for a few releases made it…
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 – an Excel file is basically a zipped set of XML files, and this will always…
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 were reported on the FORUMS. Thanks again to everyone in the community who pitches in…
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 read vs watch/listen – I have these two posts: Import from Excel to a New…
This past week we were at KScope – the premier all things Oracle conference here in the United States. The Database team were very well represented, and we did 15 minute lighting talks. Maria has already shared her slides/talks here – they were AWESOME! Here are mine. Let’s Go Shopping It’s all about the Cart. Oracle SQL Developer: The Cart from Jeff Smith Social Media – Why a Database Person Should Care Plus 3 quick…
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. Well, a few releases ago – Bad Jeff for not talking about this sooner!! -…
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 for folks that would like the slides: Oracle SQL Developer Reports from Jeff Smith
This year the KScope conference is in sunny Orlando, Florida. Do you live in the area? Do you work with Oracle technology? Then I’d like to invite you to come hang out with us for a very special week. On Sunday, we have 6 dedicated hours to talk about all things Oracle Database, in a series of lightning talks. In 15 minutes or less, we are tasked to entertain and educate you on various Oracle…
