How to add or drop redo log groups in Oracle RAC
Hello friends, this week we are going to add a Redo log group, also steps to drop redo log groups. In RAC, each instance has a redo thread; when you …
Latches Oracle
Hello everyone, today we are going to talk about latches, an Oracle lock in memory. What are Latches? Latches provide a low-level serialization mechanism that protects shared data structures in …
Connectivity to Oracle database using TNSPING
Hello everyone, today we are going to talk about an Oracle tool that we use to know if we have connectivity with the instance of the Oracle database to which …
Oracle 12 IDENTITY Columns
Hello everyone, today we wanted to discuss with you a feature of Oracle 12.1 that is very powerful and rarely used, the IDENTITY columns. This functionality is implemented in most …
OCI CLI: Installation and configuration on Linux
Hello everyone. Today we are going to talk about the installation and configuration of OCI CLI on Linux. This OCI tool will be useful to have installed if you are …
Migration with impdp. Problems in 19c creating procedures.
Hello everyone, today we wanted to comment with you about a very curious thing that happened to us with a migration through expdp / impdp in 19c. Migration consists of …