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 »dbtut
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 »How To Mount and Unmount ZFS Mount Points on Exadata
Before reading this article, you might want to read the article “How To Create a FileSystem on ZFS (Mount Point)” to create a mount point on …
Read More »How to Find The Size of all Databases in PostgreSQL
In Postgres you could be managing many databases on a Cluster. In some cases you may need to query the size all of these databases. …
Read More »How To Shrink SQL Server Transaction Log
Before shrinking the SQL Server log file, I recommend you read articles “What is SQL Server Transaction Log” and “What is Database Recovery Model” that …
Read More »How To Create a FileSystem on ZFS(ZFS Mount Point)
When we create filesystem on ZFS, mount process happens by default and mount point created. This mount point can then be mounted on the linux …
Read More »What is SQL Server Transaction Log
SQL Server Transaction Log is the log file with .ldf extension. Every transaction that occurs in SQL Server and database modifications performed by these transactions …
Read More »