Today, customer said one of batch is blocked and doing nothing last 3 hours. First we look at the active session history of that session,SELECT sql_id, SELECT sql_id, COUNT (*) FROM gv$active_session_history ...
Last week, we had an application level migration rehearsal on a billing test database. There would be huge changes in tables. Unfortunately, there was no rollback plan on the application side. So we decided to ...
We are installing a standby database for DR side. One of our database is about 10TB and generating daily 500-700Gb archive logs. Taking tape backups, duplicating them, sending to another city and then finishing...
Today, one of our test guys said that their process was hang up and waited for a log time. The process is was very simple: parse the file, do some calculation and insert the Oracle database. when we look up wit...
You can query MySQL tables from SQL Server with creating and using Linked Server. Another method (but not usual) is using mysql client in SQL Server query with using xp_cmdshell. Creating Test Table on MySQL In...
In a recent Indeed survey of more than 1,000 hiring managers and recruiters, more than half (53 percent) of respondents have hired tech talent despite candidates not meeting the job description requirements. Th...
When migrating SQL Server instances to the new Servers or taking backups of the Linked Servers creation scripts, it is not possible generating passwords of users which are using on Linked Server definition with...