Taking Systemstate Dumps when You cannot Connect to Oracle

PURPOSE
——-
The purpose of this note is to provide a method for taking system state [......]

继续阅读

Creating an Index Online

You can create and rebuild indexes online. This enables you to update base tables at the[......]

继续阅读

Invisible Indexes

Beginning with Oracle Database 11g Release 1, you can create invisible indexes or make a[......]

继续阅读

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[......]

继续阅读