Oracle Concurrency Wait Event Solution: library cache lock cursor and pin S wait on X

Hi, I will explain how to solve Concurrency Wait Event ( library cache lock cursor and pin S wait on X )

Read more

OGG-01172 OGG-01668 Discard file Exceeded max bytes (500000000) PROCESS ABENDING

Hi, You can get ” OGG-01172 Discard file (/data/Goldengate/discard/REP01_discard.txt) exceeded max bytes (500000000) ” error while Replicat is running.

Read more

Restore Any Lost Datafile with Flashback Database Technology -2

Hi, I will continue to explain datafile restore with Flashback Database Technology in Oracle in this article.

Read more

Restore Any Lost Datafile with Flashback Database Technology -1

Hi, I will explain datafile restore with Flashback Database Technology in Oracle in this article.

Read more

Flashback Data Archive in Oracle Database

Hi, I will explain what is the Flashback Data Archive feature in Oracle in this article.  

Read more

Flashback Query Version in Oracle Database

Hi, I will explain what is the Flashback Query Version feature in Oracle in this article.  

Read more

Kill All Processes Belonging to Any User in Linux

Hi, Sometimes you need to kill all processes of any user in linux.

Read more

ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage

Hi, You can get ” ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage” error

Read more

Oracle Exadata Tutorials for Beginners – Magic Database Machine

Hi, I will share with you Step by Step Oracle Exadata Tutorials for beginners.    

Read more

Flashback Query in Oracle Database

Hi, I will explain what is the Flashback Query feature in Oracle in this article.  

Read more