Found 1 new persistent data failures – Cloud Control Event/error

Enterprise Manager / Cloud Control 13c raised this event: EM Event: – Checker run found 1 new persistent data failures.   By default the database runs the Health Check periodically to find: File corruptions, Physical and logical block corruptions, Undo or redo corruptions, data dictionary corruptions If any failures are detected then a message […]

Sql Server loop through databases

How can I run the same command on all SQL Server databases without cursors The stored procedure sp_MSforeachdb allows us to iterate through each database in a SQL Server instance without a loop statement. It’s usage is similar than sp_MSforeachtable; simply execute the stored procedure, passing it the command that you’d like to execute as […]