What is Vlf(Virtual Log File)? Vlf (Virtual Log File) is a virtual file, as the name implies. The Transaction Log file with the ldf extension in …
Read More »device is busy
You can receive “device is busy” error when you want to unmount a mount point in Linux operating system. For unmount operation, you may want …
Read More »What is MVCC(Multi Version Concurrency Control) in PostgreSQL
Before reading this article, I would recommend you to reading article titled “Introduction to PostgreSQL and PostgreSQL Architecture“. What is MVCC? MVCC is the method …
Read More »Introduction to PostgreSQL and PostgreSQL Architecture
I am writing this article in order to be a guide for beginners. This article will be an introduction to PostreSQL. Before I get started …
Read More »SQL Server Delete Transaction Log File
Can I Delete SQL Server Transaction Log File? We can not delete primary transaction log file, but we can delete secondary log files in SQL …
Read More »How To Change The Password Of The Oracle User
You may want to change an Oracle user’s password for a number of reasons. Sometimes this process may be needed for the user to forget …
Read More »How To Add an Oracle Database To The Cloud Control(OEM)
Oracle databases need to be added to oracle cloud control as a target in order to be able to monitor and manage them through Oracle …
Read More »How To Grant Super Admin Privilege To a User On Oracle Cloud Control
In this article, we will see how to grant super admin privilege to a users to track and manage all Cluster Resources on Oracle Cloud …
Read More »How To Add Second Log File To The Database
Why we want to add second log file? It is a process that we usually perform when there is no free space in the disk …
Read More »How To Shrink SQL Server Data File
I wanted to write this article because it has been mentioned in the topic “How To Shrink SQL Server Transaction Log” and there are some …
Read More »