That's a wrap - Certifications 2022

Hi all,I decided to take all the 2022 OCI exams to check what changed and guide people taking these certifications.Well, not all exams. I did only the ones that I did in 2019/2020/2021 and are the things that I work on a day-to-day basis. 🙂I also did some other Cloud Vendors Certifications and of course my preferred certifications (Oracle Database 🙂)Here, you can find a list of links to help you achieve these certifications.OCI:How to study for...

Read More

How to study for 1z0-106 - Oracle Linux 8 Advanced System Administration Exam

Hi all,I have 3 vouchers(Now, it's called "Oracle Exam Attempts") to use until December/18 (I won participating in the Oracle Cloud World) and I decided to take the Linux 8 exam as my third exam.After a few weeks of studying Oracle Linux 8, especially the changes from previous versions, I cleared the exam.The exam consists of 60 questions (very well elaborated) and you have 1.5 hours.This exam is intended for people who use OEL 8 in their day-to-day...

Read More

How to study for 1z0-078 - Oracle Certified Professional, Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administrator

 Hi all,I have 3 vouchers(Now, it's called "Oracle Exam Attempts") to use until December/18 (I won participating in the Oracle Cloud World) and I decided to take the RAC 19c exam as my second exam.After a few weeks of studying Clusterware/ASM/RAC, especially the new features, and reviewing many concepts, I cleared the exam.The exam consists of 77 questions (very well elaborated) and you have 2 hours.If you have ULS, this is a good starting point:https://learn.oracle.com/ols/learning-path/oracle-database-19c-high-availability/38560/85282If...

Read More

How to study for 1Z0-076 Oracle Certified Professional, Oracle Database 19c: Data Guard Administrator

Hi all,I have 3 vouchers(Now, it's called "Oracle Exam Attempts") to use until December/18 (I won participating in the Oracle Cloud World) and I decided to take the DG19c exam.After a few weeks of studying DG, especially the new features, and reviewing many concepts, I cleared the exam.The exam consists of 74 questions (very well elaborated) and you have 2 hours.I submitted the exam when I had only 4 minutes and didn’t have time to review the marked...

Read More

SQL Monitor Report is your best friend

Hi all,One of the quickest ways to help with the SQL tuning is by getting the SQL Monitor Report.You have a lot of options to get this, like SQL Developer, OEM, command line, etc.To get this using the command line, you can use:set linesize 1000 pagesize 100 verify off trimout on trimspool on echo off head off feed off timing off termout off long 1000000 longchunksize 1000000 set serveroutput on size 1000000 spool sqlmon.html replace clear scr select dbms_sqltune.report_sql_monitor( sql_id => 'YOUR_SQL_ID', report_level=>'ALL', ...

Read More

How to study for 1z0-149 - Oracle Database PL/SQL Developer Certified Professional

Hi all,I had 2 vouchers(Now, it's called "Oracle Exam Attempt") to use until the end of September and I decided to take the PL/SQL 19c exam.My first thought was " I'll give it a try, I don't think much has changed since 11g".And I was completely wrong!I didn't study, just scheduled the exam and got a really bad result!After a week of studying the new features and reviewing many concepts, I got a good score :)If you have ULS, this is a good starting...

Read More

Upgrade From 11.2.0.4: Slow Performance Adding Nullable Columns With Default Values To AWR Tables

Hi all,I was in a project where the customer upgraded a large production database from 11g to 19c.Phase 0 of the upgrade process took almost 4 hours and the DDLs responsible for all that time were related to new columns on AWR tables (WRH$ tables).I was talking to Rodrigo Jorge (PM for upgrades and migrations) and he pointed me to this patch: 30387640For example, these 2 DDLs took about 2 hours to run:alter table WRH$_SQLSTAT add (obsolete_count...

Read More

Downgrading Oracle Database to an Earlier Release

Hi all,I was in a project where the customer had one database in a training environment to upgrade from 11g to 19c.The customer requirement was to have a fallback option in case of any issue in the next few days.The fallback option during the upgrade is to create a GUARANTEE RESTORE POINT. But after a few days, you can lose data in case you go back to the restore point.To be honest, I have never seen a downgrade in all my Oracle life, but it was...

Read More

Row Count + DBMS_COMPARISON - Logical Replication

Hi all, I was in a project where logical replication was in place.It was going from 11g non-exa to 19c on Exadata and they ran into some issues during their last migration attempt a year ago.At that time OGG was sending data from 11g to 19c and another third-party tool was sending from 19c back to 11g (in case of rollback needed). The problem was that this tool is based on triggers to capture and DML commands to replicate, but you can imagine how bad it is when you have a large number of transactions and 2 database nodes.Now, they decided to use...

Read More

How to study for 1Z0-997-22 - Oracle Cloud Infrastructure 2022 Architect Professional

Hi all,I decided to take all the 2022 OCI exams to check what changed and guide people in taking these certifications.Well, not all exams. I will do only the ones that I did in 2019/2020/2021 and are the things that I work on a day-to-day basis 🙂On this test, I was expecting to see some new things(comparing the course topics with the previous years). And that's true, I got a lot of new questions.Of course, I don't remember the question from...

Read More

Database Migration/Upgrade - Performance Advice

Hi allI was on a project where logical replication (OGG) was used to move a critical database from 11g non-exa to 19c on Exadata with the smallest downtime possible.In terms of performance, for the top 100 SQLs, we had 96 improvements including SQLs running 40x faster due to smart scans. But, we had 6 regressions.One SQL went from 0.2 ms to 0.6 ms.I know you are thinking: “not a big deal”.But when this SQL is executed in a batch process millions of times, the batch time goes from 42 minutes to 126 minutes and it can cause a lot of problems for...

Read More

How to study for 1z0-931-22 - Oracle Autonomous Database Cloud 2022 Professional

Hi all,I decided to take all the 2022 OCI exams to check what changed and guide people in taking these certifications.Well, not all exams. I will do only the ones that I did in 2019/2020/2021 and are the things that I work on a day-to-day basis 🙂On this test, I was expecting to see a few new things(comparing the course topics with the previous years). I don't remember the question from the 2021 exam (did it one year ago), but I was not...

Read More

How to study for 1z0-1093-22 - Oracle Cloud Database Services 2022 Professional

Hi all,I decided to take all the 2022 OCI exams to check what changed and guide people in taking these certifications.Well, not all exams. I will do only the ones that I did in 2019/2020/2021 and are the things that I work on a day-to-day basis 🙂On this test, I was expecting to see a few new things(comparing the course topics with the previous years). I don't remember the question from the 2021 exam (did it one year ago), but I was not...

Read More

How to study for 1z0-1094-22 - Oracle Cloud Database Migration and Integration 2022 Professional

Hi all,I decided to take all the 2022 OCI exams to check what changed and guide people in taking these certifications.Well, not all the exams. I will do only the ones that I did in 2019/2020/2021 and are the things that I work on a day-to-day basis 🙂On this test, I was expecting to see a few new things(comparing the course topics with the previous years). I don't remember the question from the 2021 exam (did it one year ago), but I was...

Read More

How to study for 1Z0-1072-22 - Oracle Cloud Infrastructure 2022 Architect Associate

 Hi all,I decided to take all the 2022 OCI exams to check what changed and guide people in taking these certifications.Well, not all the exams. I will do only the ones that I did in 2019/2020/2021 and are the things that I work on a day-to-day basis 🙂On this test, I was expecting to see some new things(comparing the course topics with the previous years). And that's true, I got a lot of new questions.Of course, I don't remember the question...

Read More

How to study for 1Z0-1084-22 - Oracle Cloud Infrastructure 2022 Certified Developer Professional

Hi all,I decided to take all the 2022 OCI exams to check what changed and guide people in taking these certifications.Well, not all the exams. I will do only the ones that I did in 2019/2020/2021 and are the things that I work on a day-to-day basis 🙂On this test, I was expecting to see a few new things(comparing the course topics with the previous years). I don't remember the question from the 2021 exam (did it one year ago), but I was...

Read More

How to study for 1Z0-1104-22 - Oracle Cloud Infrastructure 2022 Security Professional

Hi all,I decided to take all the 2022 OCI exams to check what changed and guide people in taking these certifications.Well, not all the exams. I will do only the ones that I did in 2019/2020/2021 and are the things that I work  on a day-to-day basis 🙂A good starting point is here:https://learn.oracle.com/ols/learning-path/become-a-cloud-security-professional/35644/108608Reading the Official documentation is always a plus for the exams:https://docs.oracle.com/en-us/iaas/Content/Security/Concepts/security_guide.htmhttps://docs.oracle.com/en-us/iaas/Content/Security/Concepts/security_overview.htmI...

Read More

How to study for 1z0-1067-22 - Oracle Cloud Infrastructure 2022 Cloud Operations Professional

Hi all,I decided to take all the 2022 OCI exams to check what changed and guide people in the process of taking these certifications.Well, not all the exams. I will do only the ones that I did in 2019/2020/2021 and are the things that I work on a day-to-day basis 🙂On this test, I was expecting to see a few new things(comparing the course topics with the previous years). I don't remember the question from the 2021 exam (did it one year...

Read More

How to study for 1z0-1085-22 - Oracle Cloud Infrastructure 2022 Certified Foundations Associate

Hi all,Usually, May is the month of the year to start renewing OCI Certifications to the latest version!Oracle University took a little longer this year, but now, it's time :)This is a simple test (only generic concepts) and you have about 11+ hours of videos to watch and 2 PDFs to read.The starting point is here: https://learn.oracle.com/ols/learning-path/become-an-oci-foundations-associate/35644/108448I hope Oracle is planning to allow us...

Read More

How to study for 1Z0-902 - Oracle Exadata Database Machine X9M Implementation Essentials

 Hi all,About the level of the exam, it's hard! Much harder than I expected (compared with previous Exadata exams)!Maybe that explains why we are seeing a few people with this certification!I hope Oracle is planning to allow us to download the PDFs again because the online reader is really bad. From 0 to 10, the usability of this tool is -1, especially on mobile devices.A good starting point is here:https://learn.oracle.com/ols/learning-path/earn-the-oracle-exadata-x9m-certified-impl-specialist-credential/38560/95058You...

Read More