8 Documentation Corrections and Additions

These topics contain corrections and additions to documentation.

8.1 Oracle Database 2 Day + Performance Tuning Guide (E83714)

In Section 9.3 “Using the AWR Compare Periods Reports” in Chapter 9 “Resolving Performance Degradation Over Time”, the following two new subsections have been added to the Automatic Workload Repository (AWR) Compare Periods report in 18.1:

  • Top Process Types by Wait Class

    This section shows the top process types ordered by wait class.

  • Top Process Types by CPU Used

    This section shows the top process types ordered by CPU time.

8.2 Oracle Database Utilities (E89587)

Oracle Database Utilities for Oracle Database 18c has been updated with the following restrictions:

  • For the ACCESS_METHOD parameter for Data Pump Export (Chapter 2):

    "The ACCESS_METHOD parameter for Data Pump Export is not valid for transportable tablespace jobs."

  • For the TRANSPORT_TABLESPACES parameter for Data Pump Export (Chapter 2):

    "Transportable tablespace jobs do not support the ACCESS_METHOD parameter for Data Pump Export."

  • For the ACCESS_METHOD parameter for Data Pump Import (Chapter 3):

    "The ACCESS_METHOD parameter for Data Pump Import is not valid for transportable tablespace jobs."

  • For the TRANSPORT_TABLESPACES parameter for Data Pump Import (Chapter 3):

    "Transportable tablespace jobs do not support the ACCESS_METHOD parameter for Data Pump Import."

8.3 Oracle Automatic Storage Management Administrator's Guide (E83779)

Note the following changes with regard to the Oracle Automatic Storage Management Administrator's Guide, part number E83779.

8.3.1 Oracle ACFS Restriction

Oracle Automatic Storage Management Cluster File System (Oracle ACFS) does not support encryption or replication with Oracle Database data files, tablespace files, control files, redo logs, archive logs, RMAN backups, Data Pump dumpsets, or flashback files.

8.3.2 Chapter 4: Administering ASM Disk Groups

Note the following with regard to Chapter 4 of the Oracle Automatic Storage Management Administrator's Guide (E83779).

8.3.2.1 Section: Performance and Scalability Considerations for Disk Groups

In the subsection titled "Oracle ASM Storage Limits", the following needs to be updated:

The maximum number of disks cross all disk groups is 65,530 disks. However, the total number of disks that can be in one disk groups is limited to 10,000 disks.

8.3.2.2 Section: Managing Oracle ASM Flex Disk Groups

In the subsection titled "About Oracle ASM Flex Disk Groups", the following needs to be added:

If a disk group with FLEX REDUNDANCY has only two regular failure groups and one quorum failure group, then only two copies of the data are stored, even if HIGH REDUNDANCY is selected for a database file in the flex disk group. This behavior is a consequence of having only two regular failure groups. However, if an additional regular failure group is added later, then a third copy of the data is created automatically. After the addition of the regular failure group, if one failure group is lost and a rebalance completes successfully, then the disk group can remain mounted after a second failure group goes offline.

8.3.3 Chapter 17: Understanding Oracle ACFS Advanced Topics

Table 17-1 "Maximum file sizes for Oracle ACFS file systems/Oracle ADVM volumes", in the section titled "Oracle ACFS Disk Space Usage", should be corrected as follows:

  • The heading for the third column should be changed from "Disk Group with COMPATIBLE.ASM = 12.2.0.1" to "Disk Group with COMPATIBLE.ASM >= 12.2.0.1".
  • The fourth column "Disk Group with COMPATIBLE.ASM = 18.1.0.0" should be removed.