Knowledge Base for DBA

The self-service help desk for Database Administration

How to check mySQL version

Commands to check client and server versions in MySQL Check client version: mysql --version Check server version: mysql> select @@version; […]

How to check Execution Plan in SQL Server

SQL server Performance || SQL Server Execution Plan || Query Execution Plan || SQL Server Blocking SELECT SPID,ER.percent_complete, CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as […]

How to check SQL Server login Password expiration

SQL Server login Password expiration || SQL Server Login Password Enforce Policy || Reset Passwords SELECT SL.name AS LoginName ,LOGINPROPERTY […]

How to identify Version_store in TempDB

Temp DB Issues || SQL Server Temp DB || What is Version_Store ? How to identify Version_store SELECT GETDATE() AS […]

SQL Server Buffer catch Hit Ratio

SQL Server Buffer catch Hit Ratio || What is The Default Settings Of Buffer Catch Hit Ratio SELECT object_name, counter_name, […]

SQL Server Long Running Query

How to check SQL Server Performance issues || SQL Server Long Running Query || SQL Server Query Running Slow SELECT […]

MS SQL Server Notes

1. SQL Server Versions: SQL Server 1.0 SQL Server 4.0 SQL Server 6.0 SQL Server 7.0 SQL Server 8.0 (SQL […]

How to Upgrade TFA in Oracle RAC

TASK: Upgrade TFA to latest version in 2 Node Oracle RAC. High Level Steps: 1. Check the current version and […]

How to do export using network_link in Oracle

Below are the steps to take export backup using the NETWORK_LINK parameter. How to do export using network_link in Oracle […]

How to Remove Orphan Files from Oracle ASM

Use below sql query to identify the orphan files in Oracle ASM and remove them to clear the space. In […]

How to Drop Database in Oracle RAC

Below are the steps to drop the database in Oracle RAC 1. Check and verify the database services: [oracle@dborg01 ~]$ […]

How to Drop Disk in Oracle ASM

Dropping Disk in Oracle ASM 1. Allocate new LUNs to the server, same number and size 2. Rescan server so […]