Capture DDL statements in Oracle DB

There are many cases where we need to capture the ddl statements in our production environment where application team have direct access for create or drop any object in the application schema in the production database . What is DDL ?? DDL (Data Definition Language) is a language used by a database management system that allows users to define the database and specify data types, structures […]

Read More

How To Resize the Online Redo Log files

Today we are going to work on the steps used for Resize the online Redo Logfiles.  Let’s follow the steps:- Single Instance: 1. First, see the size of the current logs: sqlplus /nolog SQL> connect / as sysdba SQL> select group#, bytes, status from v$log; GROUP# BYTES STATUS ———- ———- —————- 1 1048576 INACTIVE 2 […]

Read More

Oracle Cloud Infrastructure 2019 Architect Professional (1Z0-997)

Hi Readers Finally, I’ve successfully passed 1Z0-997, Oracle Cloud Infrastructure 2019 Architect Professional. It was almost more than 3 years that I’ve been working in OCI starting from OCI classic, Gen1, & Gen2. To clear this exam you must have good hands-on on OCI. OCI Classic – 1Z0-337 Oracle Infrastructure as a Service Cloud 2017 Implementation […]

Read More

Oracle Cloud Infrastructure Developer 2020 (1Z0-1084-20)

Hi Readers Finally, I’ve successfully passed 1Z0-1084-20, Oracle Cloud Infrastructure Developer 2020 Associate. It was almost more than 4-6 months that I’ve been preparing for this. The Exam contains 60 questions related to OCI which includes OCI Functions, OCI Kubernetes, OCI API Gateways etc.. To earn this certification you need to get 70% marks. This was the […]

Read More

Oracle Cloud Infrastructure 2019 Operations Associate (1Z0-1067)

Hi Readers Finally, I’ve successfully passed 1Z0-1067, Oracle Cloud Infrastructure 2019 Cloud Operations Associate. It was almost more than 2-3 months that I’ve been preparing for this. The Exam contains 60 questions related to OCI which includes OCI CLI, Ansible, Terraform, Cost, Security etc.. To earn this certification you need to get 70% marks. This […]

Read More

Oracle Database Cloud Service 2019 (1Z0-998)

Hi Readers Finally, I’ve successfully passed 1Z0-998, Oracle Database Cloud Service 2019. It was almost more than 1-2 months that I’ve been preparing for this. The Exam contains 74 questions related to Database service on OCI which includes cloud concept, backup, recovery, patching etc.. To earn this certification you need to get 67% marks. This was […]

Read More

List of Cloud Certification (OCI, AWS, GCP, Alibaba, Azure)

In this post, I covered detail of cloud certificaton from different cloud service providers. So, you can choose the certification as per your role and interest. List of certification in Oracle Infrastruture Cloud (OCI). Level Certification Exam Associate Oracle Cloud Infrastructure Classic 2018 Associate Architect (Retired) 1Z0-337 Associate Oracle Cloud Infrastructure 2018 Architect Associate 1Z0-932 […]

Read More

Oracle Cloud Infrastructure Foundations 2020 (1Z0-1085-20)

Hi Readers Finally, I’ve successfully passed 1Z0-1085-20, Oracle Cloud Infrastructure Foundations 2020 Associate. It was almost more than 2-3 weeks that I’ve been preparing for this. The Exam contains 60 questions related to OCI which includes cloud concept, core OCI services etc.. To earn this certification you need to get 68% marks. This was the result […]

Read More

Oracle Cloud Infrastructure 2019 (1Z0-1072)

Hi Readers Finally, I’ve successfully passed 1Z0-1072, Oracle Cloud Infrastructure 2019 Architect Associate. It was almost more than 2-3 months that I’ve been preparing for this. The Exam contains 66 questions related to OCI which includes storage, VCN, IAM, Compute, DNS etc.. To earn this certification you need to get 65% marks. This was the result of […]

Read More

Oracle Database Administration 2019 Certified Professional (1Z0-083)

Hi Readers Finally, I’ve successfully passed 1Z0-083, Oracle Database Administration 2019 Certified Professional. It was almost more than 3 months that I’ve been preparing for this. The Exam contains 85 questions related to Oracle Database 18c & 19c. To earn this certification you need to get 57% marks. Even with low passing score, it is most […]

Read More