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 …
Come Join us at Kscope21! Our APEX Experts Tyson Jouglet and Lino Schildenfeld will be delivering these presentations virtually at Kscope21!! June 21 – July 1 https://kscope21.odtug.com/ Tyson Jouglet (@TysonJouglet) Lead APEX Developer and Instructor, SkillBuilders Presentations: Five Easy Ways …
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 …