Useful Views

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