Change SMTP server name

                   Simple Mail Transfer Protocol or SMTP is what allows you to receive email alerts from your Instance to either yourself, your alerting system or group of people. Now, in order for SMTP to work, it must be configured with a server. Some of our Instances were still using old deprecated SMTP servers so I needed to update all the SMTP servers to the current one. I used the following script to resolve the issue across my multiple servers. FYI this script was executed via my CMS (central management server). If you have CMS  in your environment then great, if you do … Continue reading Change SMTP server name

QUICK & EASY TO USE SCRIPTS

— Schema_names, tables & Size MB select owner, table_name, round((num_rows*avg_row_len)/(1024*1024)) MB from all_tables where owner not like ‘SYS%’ — Exclude system tables. and num_rows > 0 — Ignore empty Tables. order by MB desc — Biggest first. ; –Schema_names, tables & Rows select owner, table_name, num_rows from all_tables where owner not like ‘SYS%’ — Exclude system tables. and num_rows > 0 — Ignore empty Tables. order by num_rows desc — Biggest first. ; –Lock statistics on those newly created tables so when stats run, these tables will be –skipped –Also, you can lock stats on tables you want to avoid … Continue reading QUICK & EASY TO USE SCRIPTS