by mawundaga | Jan 9, 2018 | oracle Administration, Patching
Patching  is one  of  the  most  common  task  performed  by  DBA’s  in  day-to-day  life  . Here , we  will discuss  about  the various  types  of  patches  which  are  provided  by  Oracle  . Oracle  issues  product fixes  for  its  software called  patches....
by mawundaga | Jan 9, 2018 | MSSQL, MSSQL Backup & Recovery, MySQL
Finding and Terminating SQL Server Blocking Processes – Dead Locks in MSQL We can free or release or remove or delete or check all locks on the sql server 2008,2012 and 2014 objects like table etc by killing the process id which is keeping the locks on the...
by mawundaga | Jan 9, 2018 | Dataguard, oracle Administration, oracle Backup & Recovery
Find the LAD (log_archive_dest_n) and the db_unique_name for the Standby that is being removed: show parameter log_archive_dest_ Take note of those that have values such as: log_archive_dest_1                  string     LOCATION=+RECOC1 VALID_FOR=(AL...
by mawundaga | Jan 9, 2018 | MSSQL, MSSQL Backup & Recovery, Uncategorized
How to detect if the disk space is running low on SQL Server. There are two different ways to do the same. I personally prefer method 2 as that is very easy to use and I can use it creatively along with database name. Method 1: EXEC MASTER..xp_fixeddrives GO...
by mawundaga | Jan 9, 2018 | Uncategorized
Question:Â Is there a way to copy maintenance plans from one SQL Server 2012 to another? Both servers are not accessible via the same copy of Management Studio at the same time (on different networks). Yes: Go to the server where the jobs exist, in Management...
