Archive for author: dekamedia

sql
Quick Tips

Query Tuning With EM SQL Monitoring

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 ...

601796-636437460632363927-16x9
Quick Tips

Restore point and tablespace level flashback

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 ...

duplicate
Quick Tips

Duplicate target database for standby backup location

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...

timeout-1508x706_c
Quick Tips

resumable_timeout

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...

database
Success Stories

Executing MySQL Query from SQL Server without Using Linked Server

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...

reflection-of-three-men-PXDYH77(1)
Success Stories

Install and Configure Master – Master Replication on Hateregonous MySQL Environments

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...

Success Stories

Generate MSSQL Linked Server Scripts with Remote Users Password

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...