Oracle - Data Dictionary views Part - 3

USER_SYS_PRIVS, ALL_SYS_PRIVS, DBA_ SYS_PRIVS:
Displays information about object privileges on objects owned by the user or available to the current user, respectively, or all system privileges granted to all users in Oracle.

USER_SOURCE, ALL_SOURCE, DBA_ SOURCE:
Displays the source code for PL/SQL programs owned by the user or available to the current user, respectively, or all PL/SQL source code in entire Oracle database.


USER_TRIGGERS, ALL_ TRIGGERS, DBA_ TRIGGERS:
Displays information about triggers owned by the user or available to the current user, respectively, or all triggers in the Oracle database.

ROLE_TAB_PRIVS, ROLE_SYS_PRIVS ROLE_ROLE_PRIVS:
Displays information about object privileges, system privileges or roles granted to roles in the database respectively.

DBA_TABLESPACES, DBA_TS_QUOTAS:
Displays information about all table spaces in Oracle, as well as space quotas assigned to users in each table space.

DBA_DATAFILES, DBA_SEGMENTS, DBA_EXTENTS, DBA_FREE_SPACE:
Displays information about data files in your oracle database, as well as segments, extents and free space in each data file respectively.

DBA_PROFILES:
Displays information about user profiled in Oracle. Profiles are a way for you as the DBA to restrict the physical resources of the host system (such as process memory allocation, CPU cycles, and so on) that users may utilize in conjunction with oracle processing.