In the last blog post, How To Find the SQL_ID of a SQL Statement, we talked about finding the SQL_ID of statements that were run in the past, or by other users. Today I’ll show you two tricks to get …
Have you ever been in a situation where a user comes to you and says “My report is running slow” or “My query used to run fast, and now it’s slow”? If you are a DBA, you most likely have! …
For most tuning exercises, the tuning happens at the SQL Statement level. When a user complains about a report being slow, you as a DBA, have to first identify the SQL Statement and then the execution plan. Today’s post is …
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 …
We recently helped a client migrate from Oracle Database XE to SE2. There was no choice – they had reached the XE 12GB data limit. Going to SE2 is effectively a downgrade because XE has all the EE features, so …
We just hit a silly problem with ORDS 22.x. When deploying ORDS to Tomcat, you have to create a version of the ords.war file that has the location of the ORDS configuration directory embedded within it. You do this by …
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 …
I first configured a WAF a couple of years ago, and I thought it was a splendid product offering all the features and counter measures you might want to help protect and enhance your web site against Layer 7 threats. …
Three upcoming Oracle APEX webinars from SkillBuilders APEX Experts Tyson Jouglet and Lino Schildenfeld: November 3rd, 2021 – 1:00pm – 2:00pm ET Five Easy Ways the Actions Interface Can Make Your APEX Applications More Enjoyable for Users November 10th, 2021 …
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 …