System Tables of Secondary Importance

Table 1-2 shows the name and description of the remaining system tables. The majority of the tables in this section store data about statistics, privileges and the query optimizer plan.

Table 1-2 System tables of secondary importance

Name	Description
SYS.COL_STATS	Stores data about column statistics
SYS.DUAL	Special one row and one column table that is useful in SELECT statements
SYS.MONITOR	Stores data about system statistics. The SYS.SYSTEMSTATS table contains more data and should be used instead. Query the SYS.V$MONITOR view rather than the system table.
SYS.PLAN	Stores data about the query plan of the optimizer
SYS.SYSTEMSTATS	Stores data about system statistics Query the SYS.V$SYSTEMSTATS view rather than the system table.
SYS.TBL_STATS	Stores data about table statistics
SYS.TCOL_STATS	Stores data about temporary table column statistics
SYS.TINDEXES	Stores data about indexes on temporary table columns
SYS.TTABLES	Stores data about temporary tables
SYS.TTBL_STATS	Stores data about temporary table statistics