SQL$HELP72.HLB  —  IMPORT  Arguments  TRACE
    Syntax options:

    TRACE | NO TRACE

    Specifies whether usage statistics are logged by the IMPORT
    statement. The NO TRACE option is the default.

    Some actions taken by the IMPORT statement can consume
    significant amounts of I/O resources and CPU time. These actions
    include the following operations:

    o  Loading data

    o  Defining indexes

    o  Defining constraints

    When you specify the TRACE option with the IMPORT statement,
    SQL writes a message when each operation begins, and writes a
    summary of DIO (direct input/output operations), CPU, and PAGE
    FAULT statistics when the operation completes. When the IMPORT
    statement finishes execution, a summary of all DIO, CPU, and
    PAGE FAULT statistics is displayed. The display also includes
    information on access to the .rbr file, database creation, and
    loading of data. For more information about these statistics, see
    the Oracle Rdb7 Guide to Database Performance and Tuning.
Close Help