-
I am in the process of maintaining a 50 Gig Production Database 8.0.5 . I want to run the below task , I want to make sure that I don't blow anything , do I have to run them after hours and what is the other concerns , for example I know that for ANALYZE TABLE task I need a big TEMP Tablespace . Right? What elase is importnat, Please advice!
## Chained Rows Report
select 'analyze table NUMS.' || table_name || ' list chained rows;'
from dba_tables
where upper(owner) = 'NUMS'
/
## Rebuild indexes
select 'alter index NUMS.' || index_name || ' rebuild;'
from dba_indexes
where upper(owner) = 'NUMS'
/
## Analyze and/or compute database statistics
SELECT 'analyze table '||owner||'.'||table_name||' '||
decode(sign(10485760 - initial_extent),1,'compute statistics;',
'estimate statistics;')
FROM sys.dba_tables
WHERE owner != 'SYS'
An ounce of prevention is worth a pound of cure
-
I have run all of these during working hours with no problems whatsoever. The rebuild indexes will not delete the current index until the new rebuilt index is created, so this will cause no problem for users accessing the system. In my experience, the two analyze commands have not caused any overhead that has caused a problem for us in our environment.
My only concern would be the size of the system. It might possibly cause an additional amount of overhead that I do not see because my databases are considerably smaller. I'll be interested to see other's comments on this.
-
But i the DB have heavy transaction workload , I think I will experience some grief!! For example I know rebuild takes a long time, any comment! Temp and RB and Redo should be big or doesn't matter?
An ounce of prevention is worth a pound of cure
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|