TweetShareSharePin0 SharesA recent post talked about setting up a Base DB Service in OCI and finished with logging into the OS of the srvice and there connecting to the DB. What we often want to do is to be able to connect to it directly from our own computer to use the tools and workflow we have in place. This post is about how to set that up. First you head back into OCI and look at the properties of […]
TweetShareSharePin0 SharesYou may already have one or two free autonomous databases at OCI. Why then would you want a lower tier database offering, a database that is not autonomous? It turns out there are many reasons why you may want this. No matter what your reason is, setting it up is pretty easy. One thing before you start though, you canot stop it to stop spending money. You have to then terminate the service and later recreate it if you […]
TweetShareSharePin0 SharesGetting an AWR can sometimes be difficult. If you are on an autonomous database you cannot log in to the database server and run your trusty old script for it. Other times you may not have the access and cannot get the DBA to find time to help you with it every time you want to look at one. Fortunately you can leverage your PL/SQL skills and just get it through any tool you want to use. The first […]
TweetShareSharePin0 SharesI read Daniel’s recent blog about five ways to grab the sql_id and remembered reading Connor’s about getting it before you run a SQL. At the time it hit me that one ought to be able to use this to simplify the workflow. Often we run a SQL and then use some marker – typically in the form of a comment in the SQL – to look up the sql_id to then use for other lookups. It would of […]
TweetShareSharePin0 SharesSometimes you’ve looked briefly at a product and when you return a couple of years later it is like opening a kinder egg. All sorts of new impressive things show up and you are left to wonder “are these old and I missed them or have they been added”. Oracle Developer Tools extension for Visual Code is one such product. I’ve looked at it before and have always had it installed, but have not looked at what it can […]
Unable to debug due to clouds or firewalls in your datacenter? No more, SQL Developer 20. 2to the rescue.