1. gather schema statistics regularly weekly once -full
2. gather schema statistics daily - atleast 10%
3. rebuild the fragmented indexes regularly - 15 days
4. coalesce the tablespaces monthly once
5. purge the unwanted data weekly once
6. pin the db objects into SGA with dbms_shared_pool package
7. find the objects which have become invalid and then validate them .
8. purge workflow runtime data
9. check the seeded alerts
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/133041/viewspace-438535/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
