OCI Bastion Service has a very meaningful name. Just like the 16th -19th centuries bastions provided extra protection for castles, the OCI Bastion Service provides improved security and additional layers of defense for your private resources in OCI. No mission-critical …
You created yourself an OCI account, a tenancy, a few compute instances and possibly a database as well. You got around the console pretty fast, however you want more: more control. That is where the CLI comes into place. The …
Have you ever wondered what is happening behind the scene in a Data Guard environment? How and who is sending the logs from the primary to standby? What process is applying the changes on the standby side? How is it …
Setting up Oracle Data Guard for a database might be daunting for many DBAs. The process involves creating a standby database from the primary database and it seems complicated and convoluted, but is it really? When we come across something …
The built in code editor in APEX is missing a very useful thing: the ability to automatically format the code. If you are using a tool like VSCode, Toad or SQL Developer to write your SQL or PL/SQL code, everything …
Oracle Multitenant Architecture is the only way to go in version 21c. Are you ready for it? With version 12c the traditional, non-CDB architecture was deprecated, and with version 20c this architecture was de-supported. This means going forward Multitenant is …
Did you know that when you create an Oracle Cloud Infrastructure (OCI) compute instance (aka a virtual server in the Oracle Cloud), it will have a boot volume of 50GB. If you want to add another volume to your compute …
ORDS version 21 was released in May, we tested and rolled it out in June. But once live, a problem popped up: numerous executions of this statement, SELECT COUNT(1) FROM SYS.ALL_SYNONYMS WHERE OWNER = ‘PUBLIC’ AND SYNONYM_NAME = ‘APEX_RELEASE’ AND …
Sometimes one gets the feeling that something is needlessly difficult. This is one of these things, and the difficulty has some history. Apache FOP is probably as close as one can get to an industry standard facility for creasting PDFs. …
What block size should you use? For what purpose? How about tablespaces in different block sizes? Any opinions? When support for multiple block sizes was introduced, I was working for Oracle Uni and did have some (very restricted) access to …
Database release 19.7 (ie, 19c with the April 2020 RU) is at last certified for OL8, but there may be some hacking needed to get it installed. This certification is long overdue: our security admin has been pushing for the …
Recently I’ve been working on tuning some distributed queries. This is not always straightforward. This is not a comprehensive discussion of the topic, rather a description of how one might approach the problem. The query I’m using for this demonstration …
Now available! https://docs.oracle.com/en/database/oracle/oracle-database/20/books.html Going through the New Features guide, there is a shed load of wonderful enhancements. Then you look at the Licensing guide, and most of them require Exadata or Oracle Cloud or both.
Many times I’ve seen the question on forums “How can I move a table from one schema to another?” and the answer is always that you can’t. You have to copy it. Or export/import it. Well, here’s a way. It …
A very nice licensing change in 19c: you can now have up to three PDBs in a Standard Edition Multitenant database. Apart from the obvious advantage of being able to do some database consolidation, it gives SE2 users the ability …