In Oracle databases tables are stored in logical entities called Tablespaces. Each Tablespace consists of physical files called Datafiles. In Oracle, however, each datafile can have a maximum size of up to 32GB, because of this... read more
How to restore a table to a point in time in Oracle Database with RMAN
In this article we will see how in Oracle Database we can restore a table at a specific time. The data to carry out the process comes from RMAN backups and during the process they are temporarily restored automatically to... read more
How to replicate tables from Oracle Database to SQL Server using GoldenGate
In this article we will see how we can copy table records from Oracle Database that is on Unix to SQL Server that is on Windows using Oracle GoldenGate. What is GoldenGate Oracle GoldenGate… read more
How we enable Oracle Data Guard with automatic failover for High Availability
In a previous article we saw how we activate Oracle Data Guard in physical standby. Now we will take the installation one step further with a modern commit that will allow us to enable automatic failover from primary to standby... read more
How do we find the longest running queries in an Oracle database
In Oracle databases we have the ability to find statistical data for queries using the ASH and AWR reports. But to activate this feature we must have Enterprise version. At Standard we can do… read more
How can we connect SQL Server to Oracle Database using Linked Server
SQL Server enables us to be able to connect and execute queries on remote Database Instances that do not have to be in the same RDBMS. In this article we will see specifically how it is done by instance... read more
How do we install Oracle Data Guard as a Physical Standby for Disaster Recovery?
In this article we will see step by step how to install Oracle Data Guard as Physical Standby on Unix. By using it, we have the possibility that changes made on the primary base are automatically transferred to another standby... read more
How to do a fresh installation of Oracle Database on Linux
In this article we will see step by step how to install Oracle Database 19c on Unix and more specifically on Oracle Linux / Red Hat. The prerequisites To begin with, we should have a graphical environment either with the… read more
How can we get email whenever we have blocking session in Oracle database
In an Oracle database, every time a session updates the elements of a table, it becomes locked to ensure that no other session will be able to modify the same table at the same time. But when… read more
