Originally posted by Sonia
Hi,
Information present in the v$views are basically for the life of the instance.
Does these vies have an underlying table which are present in the data dictionary or on what tables are these views based and where are those tables present.

regards
sonia
Hi sonia!

THe v$ views are dynamic performance viewsactually public synonyms of V_$ views which are based on X$ tables. To view the dynamic performance views you may query v$FIXED_TABLE.

Oracle server is responsible for populating and cleaning of these tables. Don't really know the process., May be it's SMON.