Monthly controls and actions according to controls provide healthy databases and management facilities. So i strongly recommend monthly control for all junior dba's becoming senior dba.
- Check the undo segment size for last month. You could find check undo tablespace size sql from metalink.
- Check max undo segment size for last month.
- Check the dba objects which are owned by schema accounts but created at SYSTEM or SYSAUX or USERS tablespace.
- Check the average connection count per user monthly
- Check the database size and compare it previous size
- Check tablespace status
- Check index and constraints status, contact the software developer for dropping disabled indexes or constraints
- Check the datafiles autoextensible and If they are auto extend then disable it.
- Check the analyze objects or GATHER_STAT JOBS status ( at night)
- Check the default or temporary tablespace for each user
Hiç yorum yok:
Yorum Gönder