RSORASNP

Definition

RSORASNP collects snapshot-like database statistics (e.g. number of user calls, long table scans etc.). For this, it reads the current database statistics from the Oracle table V$SYSSTAT and stores them in table DBSNP. Obsolete entries are simultaneously deleted from this table. The number of entries deleted depends on the setting for parameter STATS$TABLES_DAYS_TO_KEEP in table TSEXC; the default value is 120 days.

For Oracle this report is called indirectly via report RSDBPREV which means you do not need to schedule it directly in table TCOLL.