Free space can be managed automatically or manually.
Free space can be managed automatically inside database segments. The in-segment free/used space is tracked using bitmaps, as opposed to free lists. Automatic segment-space management offers the following benefits:
- .Ease of use
- Better space utilization, especially for the objects with highly varying row sizes
- Better run-time adjustment to variations in concurrent access
- Better multi-instance behavior in terms of performance/space utilization
You specify automatic segment-space management when you create a locally managed tablespace. The specification then applies to all segments subsequently created in this tablespace.
第3,4点不太明白是什么意思
运行时调整？ 多实例行为?
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/94384/viewspace-1010939/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
块空间释放与压缩
请登录后发表评论
登录
全部评论
最新文章
- Windows WMIC命令详解 (Windows Management Instrumentation Command-line)
- 为monitor打PSU4 (10.2.0.4.4)的步骤
- 重建控制文件 recreate control file
- 停库前执行alter system checkpoint 很重要!
- 参加oracle 数据中心优化高峰会
- 用RMAN迁移文件到ASM或从ASM迁出
- 常用sql
- 分区操作常用sql
- How to Get a 10046 trace for a Parallel Query [ID 1102801.1]
- Master Note Parallel Execution Wait Events [ID 1097154.1]
