Joords Oracle DBA blog

Important is that the storage devices operational, mounted and stamped as ASM device to the machine. Using Management Volume (ACFS) the compatibility level must be at least 11.2. on diskgroup level. See below the created statements from the diskgroups inside the ASM. De disksgroups are created with the compatible.* -> 11.2 . The diskgroup that will be used for ACFS is the diskgroup “ DG_DISK11G_01 ” Steps involved to use ACFS Create Diskgroups Load ACFS Drivers Create Filesystem for ACFS Volume Device Mount ACFS Filesystem ASMCA validation of ACFS Filesystem Automatic startup ACFS Mount Device Oracle ACFS Mount Registry

Oracle Deferred Segment Creation new feature in Oracle Database 11g Release 2. Creating a non-partitioned heap-organized table in a locally managed tablespace, the table segment creation is deferred until the first row is inserted. In addition, creation of segments is deferred for any LOB columns of the table, any indexes created implicitly as part of table creation, and any indexes subsequently explicitly created on the table.