Management Views

V$ views and GV$ views - management views and global management views

Management views V$… and global management views GV$… are common management views for memory, instance, and process management

DBA_ views - management views

DBA_ views are management views for database and database objects management.

other management views


X$ views - internal views

X$… views are internal views, which are the base table of v$… tables and usually are oracle internal arrays structure in memory.

Dictionary base ...$ tables - dictionary base tables

…$ tables are base table of database object dictionary, usually are tables in system schema.