Oracle SQLcl – Stop Emailing TNS Entries: CONNMGR Gets Export/Import in 26.1….. I’m fully aware I stated in an earlier blog post that we had reached the final part of the SQLcl series. Turns out I can’t quite stick to that statement. SQLcl is so powerful, and Oracle keeps releasing new amazing features with every…
Oracle Database Vault: The Answer to “Who Watches the DBA?”….. Is your database filled with sensitive data? Can this data be viewed by people with access to highly privileged accounts? Do you need to protect this data from being accessed and viewed through those accounts? If your answer to any of the above is yes,…
SQL Diagnostic Reporting: Out with SQLHC, In with DBMS_SQLDIAG.REPORT_SQL Have you ever needed to produce a comprehensive, easy-to-read diagnostic report for a specific SQL statement while troubleshooting poor performance? Before 26ai, you most likely reached for the SQL Tuning Health Check, better known as SQLHC. In 26ai, a new function has been added to the…
Oracle SQL Firewall: The Allow List That Will Bite Back. Protecting the database and the data housed within it against attacks and intrusion should be a top priority for every Oracle DBA. The data in the database is, in many organizations, by far their most valuable asset. Hence, working to protect this data should not…
Oracle SQLcl – Run It Again: Putting the REPEAT Command to Work….. We have now reached the final post in my series covering the SQLcl commands I find most useful and reach for on a daily basis. This post will cover the REPEAT command. It does only one thing and is very simple to use….
Another Round of SQLcl Ammo: The HISTORY Command….. So, we still haven’t reached the last post in my blog series describing powerful commands in Oracle SQLcl. Today’s focus will be on the command “HISTORY”. This command is a strong feature built into the SQLcl utility, and I use it many times during the week —…
Oracle SQLcl – Stop Typing and Start Aliasing….. I’ve realised it’s good I didn’t decide a fixed number of posts to write on this topic beforehand. I wouldn’t have been able to stick to the decided amount. The tool is so rich and provides so many amazing new features that really increase my productivity. Moving…
Using SQLcl DDL command to fetch DDL for Database Objects.…. In part one of my post about SQLcl I voiced my opinion that SQLcl is a powerful command-line tool that brings a wide range of capabilities to both DBA’s and Developers. This second part dives into one of those capabilities that will be appreciated by…
Supercharging Data Movement with SQLcl’s LOAD and UNLOAD….. As many of you SQLcl users probably already know, it is a very powerful command line tool putting very useful and time-saving tools right at your fingertips. It has many advantages over SQL*Plus. It is built on Java, which gives it capabilities SQL*Plus could never have. With SQLcl,…