In today’s article, I will be explaining how we can use the FLASHBACK TABLE statement to restore an earlier state of a table in case …

In today’s article, I will be explaining how we can use the Flashback Version Query to provide a transaction ID that locates the specific transaction …

In today’s article, we will be discussing how to recover deleted data in Oracle after the commit is pressed. With this method, we will not …

In this article, I will try to explain how undo is managed, the purpose of undo tablespace, its place in daily use and its sizing. …

In today’s article, we will be discussing what the Flashback Activation Procedure is in Oracle database. 1. MWRPR replicas must stop. Otherwise, REPLICAT PROCESS will …

In today’s article, I will be giving you information about Oracle Flashback Technologies. In case of Logical Corruptions, it directly resolves corrupted data rather than …

In today’s article, we will be learning the storage structure of Oracle Database. Oracle Database storage structure consists of two structures: physical and logical. The …

In today’s article, I will explain the concept of the Database Writer Process, which retrieves data blocks modified by Insert, Update, or Delete operations from …

In today’s article, we will explain how we can learn the Processes Using Swap Space in Oracle. Processes using swap space: [crayon-67406dfa6d373303931739/] By the way, …

In today’s article, I will be explaining how we can learn about background processes running in the database. Background processes are kept in the v$process …