We can get information about the system global area (SGA)
Can get information about the dynamic SGA components. This summy provides details based on all completed SGA resize operations since instance startup. All sizes are expressed in bytes.
Can get information about the SGA, including the sizes of different SGA components, the granule size, and free memory.
We can get detailed information on the system global area (SGA).
We can get information on the shared server processes.
Can get tablespace information from the control file
Can get lists the active transactions in the system.
displays locks owned by transaction state objects.
We can get version numbers of core library components in the Oracle Database.
This view contains information about redo log files.
We can get information about restorable datafiles. It will include all datafiles backed in the backup set, image copies, and proxy copies.
Please browse the Oracle link to explore more views