by mawundaga | Jan 14, 2018 | Uncategorized
ORA-00060: Deadlock detected while waiting for resource. Transactions deadlock one another waiting for resources. When this happens, these transactions are stuck (deadly embraced) and cannot continue processing. Oracle automatically detects deadlocks and resolves them...
by mawundaga | Jan 12, 2018 | Uncategorized
Blog I am running Oracle rdbms 11.2.0 on Windows Server 2012. I ran into a peculiar issue when I dropped dbconsole schema and then attempted recreating it. emca -config dbcontrol db -repos create -PORT 1521 Error: Enter the following information: Jan 11, 2018...
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...
by mawundaga | Jan 9, 2018 | Uncategorized
The quickest way to capture the SQL being processed by a session is to switch or turn on SQL trace or set the 10046 event for a representative period of time. The resulting trace files can be read in their raw state or translated using the tkprof utility. Explaining...
by mawundaga | Jan 9, 2018 | Uncategorized
Manually Resolving Gaps – Oracle Data Guard 11gR2 For simplicity, Gap is a range of archived redo logs that were created at a time when the standby database was not available to receive them; in many practices, it happens because of the network problems. We have...
Recent Comments