SGA
V$DB_CACHE_ADVICE Buffer Cache Advisor
V$STREAMS_POOL_ADVICE Streams Pool Advisor
V$MTTR_TARGET_ADVICE
To see the ratio of the estimated number of cache writes under other MTTR settings to the
number of cache writes under the current MTTR.
ASM
V$ASM_ALIAS To see alias names for Automatic Storage Management files
database instance
V$DATAFILE
V$LOGFILE
V$CONTROLFILE
V$RECOVER_FILE