Gather stats on tables with data

Sometimes during support of upgrades of apps we have some tasks to gather statistics on tables. I have tried to implement a procedure which is gathering it. The input is the schema name. As I cannot implement procedures just because it makes things easier I have implemented it on a test database and tested it…

Monitoring redo generation

Sometimes I am checking how much redo is generated during the day to know if I have enough space in the arch destination during reorgs. To check redolog generation I use: break on SUBSTRING skip 1 compute sum label ‘TOTAL’ of MB on SUBSTRING set lines 180 pages 999 select count(1) “Rate” ,trunc(FIRST_TIME,’HH24′) “By Hour”,round(sum(blocks*block_size)/1024/1024,2)…