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