16 Jan
Executing SQL Scripts Against Multiple Database Targets Using 10G OEM Grid Control R2
Last week, we discussed 10G Grid Control R2’s feature that allows us to run host commands against multiple targets at the same time. 10G Grid Control R2 also provides an easy-to-use panel that allows administrators to run SQL scripts against multiple database targets simultaneously. Just like its host command counterpart, all we need to do is code up a SQL statement, choose a set of database targets, run the SQL against the multiple targets and review the output. Simple as can be.