How to Compare Data Between Two Databasesby Ed ChenJune 25, 2017November 14, 2021Several years ago I made a stored procedure for comparing table row counts between two databases after migration, which can output a very clear and… Read More »How to Compare Data Between Two Databases
How to Take Parallel Jobs to Background in One Lineby Ed ChenJanuary 10, 2016March 29, 2018Suppose you're a SA. In the beginning of the year 2016, you have to execute multiple system analysis reports parallelly for every month last year.… Read More »How to Take Parallel Jobs to Background in One Line
How to Backup RMAN Configuration Dailyby Ed ChenOctober 28, 2015December 11, 2022Backup RMAN Configuration RMAN can backup almost everything at any state of execution time, includes data, archive logs, even control file and spfile, but I… Read More »How to Backup RMAN Configuration Daily
3 Replace-Equivalent Commands on Linuxby Ed ChenJune 29, 2015March 30, 2018Here are several ways to do replacement on Linux:Output the replacing result to the same file by sed with option -i[oracle@test ~]$ sed -i 's/Ed… Read More »3 Replace-Equivalent Commands on Linux