These are my Oracle DBA related scripts. Contribute to robkoltai/DBA_scripts development by creating an account on GitHub.

File metadata and controls Code Blame 31 lines (28 loc) · 1.7 KB Raw Finding Implicit Column Conversions in the Plan Cache SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SET @dbname = QUOTENAME ...

sp_BlitzCache: This free script analyzes the SQL Server's plan cache to identify queries that are using significant CPU resources. By sorting the results based on CPU usage, you can pinpoint ...