Important Views

DATABASE PROPERTIES

DATABASE_PROPERTIES,

V$NLS_PARAMETERS

DATABASE

V$DATABASE,

V$VERSION,

V$INSTANCE

SHARED SERVER 
V$QUEUE,

V$DISPATCHER,

V$SHARED_SERVER

CONNECTION POOLING
DBA_CPOOL_INFO,

V$CPOOL_STAT,

V$CPOOL_CC_STATS

SPACE
DBA_DATA_FILES,

DBA_FREE_SPACE,

DBA_TS_QUOTAS

CONTROLFILES
V$CONTROLFILE,

V$PARAMETER,

V$CONTROLFILE_RECORD_SECTION

DATAFILES
V$DATAFILE,

V$DATAFILE_HEADER,

DBA_DATA_FILES

SEGMENTS=
DBA_SEGMENTS,

USER_SEGMENTS

EXTENTS
DBA_EXTENTS,

USER_EXTENTS

REDOLOG
V$THREAD,

V$LOG,

V$LOGFILE,

 V$LOG_HISTORY

UNDO
V$UNDOSTAT,

V$ROLLSTAT,

V$TRANSACTION

ARCHIVE
V$DATABASE,

V$LOG,

V$ARCHIVED_LOG,

V$ARCHIVE_DEST

INSTANCE
V$INSTANCE,

V$PARAMETER,

V$SYSTEM_PARAMETER

MEMORY=
V$SGA,

V$SGASTAT,

V$SGAINFO

V$SGA_DYNAMIC_COMPONENTS,

V$SGA_RESIZE_OPS

ADVICE
V$SGA_TARGET_ADVICE,

V$PGA_TARGET_ADVICE

PROCESSES
V$PROCESS,

V$BGPROCESS

PERFORMANCE
V$SYSSTAT,

V$SESSMETRIC,

V$SYSTEM_EVENT

ALERTS
DBA_THRESHOLDS,

 DBA_OUTSTANDING_ALERTS,

DBA_ALERT_HISTORY,

V$ALERT_TYPES,V$METRIC

LOCK & LATCH
V$LOCK,

V$LOCKED_OBJECTS,

DBA_LOCK,

V$SESSION_WAIT,

V$LATCH

TABLES
DBA_TABLES,

 ALL_TABLES,

USER_TABLES

INDEXES
DBA_INDEXES,

ALL_INDEXES,

USER_INDEXES

DATAPUMP
DBA_DATAPUMP_JOBS,

DBA_DATAPUMP_SESSIONS,(V$SESSION_LONGOPS|SOFAR|TOTALWORK|UNITS)

OBJECTSDBA_OBJECTS,

ALL_OBJECTS,

USER_OBJECTS

ASM Dynamic Viewsv$asm_alias – Lists all aliases in all currently mounted diskgroups
v$asm_client – Lists all the databases currently accessing the diskgroups
v$asm_disk – Lists all the disks discovered by the ASM instance
v$asm_diskgroup – Lists all the diskgroups discovered by the ASM instance
v$asm_file – Lists all files that belong to diskgroups mounted by the ASM instance
v$asm_operation – Reports information about current active operations.
Rebalance activity is reported in this view
v$asm_template – Lists all the templates currently mounted by the ASM instance
v$asm_diskgroup_stat – same as v$asm_diskgroup but it does discover new diskgroups. You should use this view instead of v$asm_diskgroup
v$asm_disk_stat – same as v$asm_disk but it does not discover new disks. You should use this view instead of v$asm_disk

Fixed Views
x$kfals – ASM aliases
x$kfdsk – ASM disks
x$kffil – ASM files
x$kfgrp – ASM diskgroups
x$kfgmg – ASM operations
x$kfkid – ASM disk performance
x$kfncl – ASM clients
x$kf??? – ASM templates
x$kffxp – ASM extents of ASM files relative to extents in the ASM diskgroup. Can use this view to see how well balancedindividual disks are.
x$kfdat – ASM extent of diskgroup relative to extents in the ASM file

Required parameter for ASM

*.db_cache_size=64m

*.large_pool_size=12M

*.shared_pool_size=128M

*.processes=300

The equation for the process parameters is:
Processes=25 + (10 + max number of concurrent db file creations, and file extend operations possible) * n.

 n :  is the number of databases connecting to ASM.

FLASH RECOVERY
V$RECOVERY_FILE_DEST

TRASPORT PLATFORM
V$TRANSPORTABLE_PLATFORM

RECYCLE BIN
DBA_RECYCLEBIN

MODIFIED TABLE
DBA_TAB_MODIFICATIONS (since last stats gather)

SQL TRACES
DBA_ENABLED_TRACES

DATA DICTIONARY HIT RATIO
V$ROWCACHE

LIBRARY CACHE | RELOAD RATIO
V$LIBRARYCACHE

HIST TABLES=
V$ACTIVE_SESSION_HISTORY,

DBA_HIST_SQLSTAT,

DBA_HIST_SQLTEXT,

DBA_HIST_SQLPLAN