139.4.3 DUMP_HISTORICAL_STATS Procedure
The DUMP_HISTORICAL_STATS procedure dumps the last N
seconds of historical statistics to the NMON trace file or all historical statistics if 0 is
specified.
Syntax
DBMS_NETMON.DUMP_HISTORICAL_STATS ( last_second IN BINARY INTEGER DEFAULT 0 );
Parameters
Table 139-6 DUMP_HISTORICAL_STATS Procedure Parameters
| Parameter | Description |
|---|---|
|
|
The number of seconds of historical statistics to dump. The default is 0 indicating all historical statistics. |
Examples
The following example illustrates how to dump historical statistics for
the past hour to the NMON trace
file:
SQL> execute dbms_netmon.dump_historical_stats(3600);