The Do’s and Don’ts of Space & Undo Management：Best Practices for Oracle Database 10g.pdf
50墨值下载
The Do’s and Don’ts of Space &
Undo Management: Best Practices
for Oracle Database 10g
An Oracle White Paper
December 2004
The Do’s and Don’ts of Space & Undo Management:
Best Practices for Oracle Database 10g
Introduction ....................................................................................................... 3
Space Management............................................................................................ 3
Oracle Basics ................................................................................................. 3
Fragmentation ............................................................................................... 5
External Fragmentation........................................................................... 5
Internal Fragmentation............................................................................ 6
Monitoring Space Usage............................................................................ 10
Resumable Statements........................................................................... 11
Server Generated Tablespace Alerts.................................................... 11
Performance Considerations..................................................................... 12
Segment Space Management ................................................................ 12
Extent Management.............................................................................. 14
Default Permanent Tablespace................................................................. 17
Temporary Space Management ................................................................ 18
Undo Management.......................................................................................... 21
Manual versus Automatic Undo Management....................................... 21
AUM Administrative Practices ................................................................. 22
Undo Retention Configuration ............................................................ 22
Undo Tablespace Configuration.......................................................... 25
Proactive Error Prevention and Automatic Problem Handling............... 27
Conclusion........................................................................................................ 29
Acknowledgements ......................................................................................... 29
Appendix A: Examples................................................................................... 30
The Do’s and Don’ts of Space & Undo Management: Best Practices for Oracle Database 10g Page 2
of 35
50墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论