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 these related views rather than the system table: SYS.GV$MONITOR and SYS.V$MONITOR
SYS.PLAN	Stores data about the query plan of the optimizer
SYS.SYSTEMSTATS	Stores data about system statistics Query these related views rather than the system table: SYS.GV$SYSTEMSTATS and SYS.V$SYSTEMSTATS
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