Mostly SQL Developer Tips & Tricks, Mostly
I was using the Instance Viewer today and ran into the drill down for Storage. Let’s take a closer look at that report. I like this report enough, that I want to be able to run it in SQLcl. SQLcl is a command-line interface, so I’ll have to make a few changes. The links won’t work, boo. Those are easy …
A follower reached out to me late yesterday with this request: And the answer is yes, we can pretty much get there. I’ve noticed a few things by looking at his hand-formatted code on the bottom section. He prefers: everything lowercase right-aligned keywords no line breaks for the sub query ()’s no line breaks after SELECT/FROM/WHERE keywords So let’s go …
I’m always a bit surprised when I find a SQL Developer user who does NOT know about the Instance Viewer! Of course you loyal readers know all about it. But you’re busy – you don’t have time to tell your friends. So just send them this video, and I’ll tell them about it. In a nutshell: it’s a performance dashboard …
I don’t normally blog on a Sunday, but I’m confined to my bed/couch for the next few days, so I might as well answer another question! This from the YouTube: “Hi Jeff, Can you please share similar example where REST service is calling a package.procedure with IN and OUT parameters and we can pass IN parameters to get the result?” …
I’ll show you 3 cool tips and tricks for working with PL/SQL in SQL Developer…in under 7 minutes! In-code navigation – click into where your objects are declared Test Query – see if your SQL is gonna work BEFORE you compile it Using the Code Outline For those that can’t do video, basically you can Ctrl-Mouse-Hover Navigate ANYWHERE Not just …
We recently (18.2) added a new way to generate execution plans in SQL Developer – we generate a call to DBMS_XPLAN for the SQL ID at your cursor position. DBMS_XPLAN is a package, and one of it’s procedures is ‘DISPLAY_CURSOR’: This table function displays the explain plan of any cursor loaded in the cursor cache. In addition to the explain …
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 …
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. …
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. …
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 …