Deferred Segment Creation

Beginning in Oracle Database 11g Release 2, when creating a non-partitioned heap-organiz[......]

继续阅读

Table Compression

Compression saves disk space, reduces memory use in the database buffer cache, and can s[......]

继续阅读

show_space() by xzh2000

原文链接:
create or replace procedure show_space
(
p_segname_1 in varchar2,
p_space     in v[......]

继续阅读

Shrinking Database Segments Online

Segment shrink is an online, in-place operation. DML operations and queries can be issue[......]

继续阅读