by mawundaga | Jan 9, 2018 | MSSQL
You could use SQL Server Management Studio to backup the databases or even use Maintenance Plans, but using T-SQL is a much simpler and faster approach. With the use of T-SQL you can generate your backup commands and with the use of cursors, you can cursor through all...
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