Library /sys$common/syshlp/SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  STATISTICS_COLLECTION
    Syntax options:

    STATISTICS COLLECTION IS ENABLED | STATISTICS COLLECTION IS
    DISABLED

    Specifies whether the collection of statistics for the database
    is enabled or disabled. When you disable statistics for the
    database, statistics are not displayed for any of the processes
    attached to the database. Statistics are displayed using the RMU
    Show Statistics command.

    The default is STATISTICS COLLECTION IS ENABLED. You can disable
    statistics using the ALTER DATABASE and IMPORT statements.

    For more information on the RMU Show Statistics command, see the
    Oracle RMU Reference Manual.

    You can enable statistics collection by defining the logical
    name RDM$BIND_STATS_ENABLED. For more information about when to
    use statistics collection, see the Oracle Rdb7 Guide to Database
    Performance and Tuning.
Close Help