I've read its a view from several texts, including ORA based publications.
I do believe its base tables relate to X$, and Oracle database automatically compiles information into the DBA/USER etc views for system maintenance/optimization.
I want to know why when i select a view I'm using
where TABLE_NAME = 'etc'
here it mentions a table_name. Do they use the
where table_name
convention for views because it is easier. Why not something like where view_name = 'etc'
maybe it's a dumb question, thought I'd throw it out there though.