Gv$views... That are related in day to day troubleshooting
| GV$ACCESS |
| GV$ACTIVE_INSTANCES |
| GV$ACTIVE_SERVICES |
| GV$ACTIVE_SESSION_HISTORY |
| GV$ALERT_TYPES |
| GV$AQ |
| GV$ARCHIVE |
| GV$ARCHIVED_LOG |
| GV$ARCHIVE_DEST |
| GV$ARCHIVE_DEST_STATUS |
| GV$ARCHIVE_GAP |
| GV$ARCHIVE_PROCESSES |
| GV$ASH_INFO |
| GV$ASM_ALIAS |
| GV$ASM_CLIENT |
| GV$ASM_DISK |
| GV$ASM_DISKGROUP |
| GV$ASM_DISKGROUP_STAT |
| GV$ASM_DISK_IOSTAT |
| GV$ASM_DISK_STAT |
| GV$ASM_FILE |
| GV$ASM_OPERATION |
| GV$BACKUP |
| GV$BGPROCESS |
| GV$BH |
| GV$BSP |
| GV$BUFFERED_PUBLISHERS |
| GV$BUFFERED_QUEUES |
| GV$BUFFERED_SUBSCRIBERS |
| GV$BUFFER_POOL |
| GV$BUFFER_POOL_STATISTICS |
| GV$CALLTAG |
| GV$CELL |
| GV$CELL_CONFIG |
| GV$CELL_REQUEST_TOTALS |
| GV$CELL_STATE |
| GV$CLUSTER_INTERCONNECTS |
| GV$CONFIGURED_INTERCONNECTS |
| GV$CONTEXT |
| GV$CONTROLFILE |
| GV$CONTROLFILE_RECORD_SECTION |
| GV$CR_BLOCK_SERVER |
| GV$CURRENT_BLOCK_SERVER |
| GV$DATABASE |
| GV$DATABASE_BLOCK_CORRUPTION |
| GV$DATABASE_INCARNATION |
| GV$DATAFILE |
| GV$DATAFILE_COPY |
| GV$DATAFILE_HEADER |
| GV$DATAGUARD_STATUS |
| GV$DATAPUMP_JOB |
| GV$DATAPUMP_SESSION |
| GV$DBLINK |
| GV$DB_CACHE_ADVICE |
| GV$DB_OBJECT_CACHE |
| GV$DB_PIPES |
| GV$DELETED_OBJECT |
| GV$DETACHED_SESSION |
| GV$DIAG_INFO |
| GV$DISPATCHER |
| GV$DISPATCHER_RATE |
| GV$DYNAMIC_REMASTER_STATS |
| GV$ENCRYPTED_TABLESPACES |
| GV$ENQUEUE_LOCK |
| GV$ENQUEUE_STAT |
| GV$ENQUEUE_STATISTICS |
| GV$EVENTMETRIC |
| GV$EVENT_NAME |
| GV$EXECUTION |
| GV$FILEMETRIC |
| GV$FILEMETRIC_HISTORY |
| GV$FILESPACE_USAGE |
| GV$FILESTAT |
| GV$FILE_CACHE_TRANSFER |
| GV$FILE_PING |
| GV$FIXED_TABLE |
| GV$FIXED_VIEW_DEFINITION |
| GV$FLASHBACK_DATABASE_LOG |
| GV$FLASHBACK_DATABASE_LOGFILE |
| GV$FLASHBACK_DATABASE_STAT |
| GV$GC_ELEMENT |
| GV$GC_ELEMENTS_WITH_COLLISIONS |
| GV$GES_BLOCKING_ENQUEUE |
| GV$GES_ENQUEUE |
| GV$GLOBALCONTEXT |
| GV$GLOBAL_BLOCKED_LOCKS |
| GV$GLOBAL_TRANSACTION |
| GV$HM_CHECK |
| GV$HM_FINDING |
| GV$HM_INFO |
| GV$HM_RECOMMENDATION |
| GV$INSTANCE |
| GV$INSTANCE_CACHE_TRANSFER |
| GV$INSTANCE_LOG_GROUP |
| GV$INSTANCE_RECOVERY |
| GV$IOFUNCMETRIC |
| GV$IOFUNCMETRIC_HISTORY |
| GV$IOSTAT_FILE |
| GV$IOSTAT_FUNCTION |
| GV$IOSTAT_FUNCTION_DETAIL |
| GV$IOSTAT_NETWORK |
| GV$IO_CALIBRATION_STATUS |
| GV$LATCH |
| GV$LATCHHOLDER |
| GV$LATCHNAME |
| GV$LATCH_CHILDREN |
| GV$LATCH_MISSES |
| GV$LATCH_PARENT |
| GV$LIBCACHE_LOCKS |
| GV$LIBRARYCACHE |
| GV$LIBRARY_CACHE_MEMORY |
| GV$LOCK |
| GV$LOCKED_OBJECT |
| GV$LOCKS_WITH_COLLISIONS |
| GV$LOCK_ACTIVITY |
| GV$LOCK_ELEMENT |
| GV$LOCK_TYPE |
| GV$LOG |
| GV$LOGFILE |
| GV$LOGHIST |
| GV$MANAGED_STANDBY |
| GV$MEMORY_CURRENT_RESIZE_OPS |
| GV$MEMORY_DYNAMIC_COMPONENTS |
| GV$MEMORY_RESIZE_OPS |
| GV$MEMORY_TARGET_ADVICE |
| GV$METRIC |
| GV$MUTEX_SLEEP |
| GV$MUTEX_SLEEP_HISTORY |
| GV$MVREFRESH |
| GV$MYSTAT |
| GV$OBSOLETE_PARAMETER |
| GV$OPEN_CURSOR |
| GV$OSSTAT |
| GV$PARALLEL_DEGREE_LIMIT_MTH |
| GV$PARAMETER |
| GV$PARAMETER2 |
| GV$PARAMETER_VALID_VALUES |
| GV$PGASTAT |
| GV$PGA_TARGET_ADVICE_HISTOGRAM |
| GV$PGA_TARGET_ADVICE |
| GV$POLICY_HISTORY |
| GV$PQ_SESSTAT |
| GV$PQ_SLAVE |
| GV$PQ_SYSSTAT |
| GV$PQ_TQSTAT |
| GV$PROCESS |
| GV$PROCESS_MEMORY |
| GV$PROCESS_MEMORY_DETAIL |
| GV$PROCESS_MEMORY_DETAIL_PROG |
| GV$PWFILE_USERS |
| GV$PX_BUFFER_ADVICE |
| GV$PX_INSTANCE_GROUP |
| GV$PX_PROCESS |
| GV$PX_PROCESS_SYSSTAT |
| GV$PX_SESSION |
| GV$PX_SESSTAT |
| GV$QUEUE |
| GV$QUEUEING_MTH |
| GV$RECOVERY_FILE_STATUS |
| GV$RECOVERY_LOG |
| GV$RECOVERY_PROGRESS |
| GV$RECOVERY_STATUS |
| GV$RECOVER_FILE |
| GV$RESOURCE |
| GV$RESOURCE_LIMIT |
| GV$RESTORE_POINT |
| GV$RESULT_CACHE_DEPENDENCY |
| GV$RESULT_CACHE_MEMORY |
| GV$RESULT_CACHE_OBJECTS |
| GV$RESULT_CACHE_STATISTICS |
| GV$ROWCACHE |
| GV$SCHEDULER_RUNNING_JOBS |
| GV$SEGMENT_STATISTICS |
| GV$SEGSTAT |
| GV$SEGSTAT_NAME |
| GV$SESSION |
| GV$SESSION_BLOCKERS |
| GV$SESSION_CURSOR_CACHE |
| GV$SESSION_EVENT |
| GV$SESSION_LONGOPS |
| GV$SESSION_WAIT |
| GV$SESSION_WAIT_CLASS |
| GV$SESSION_WAIT_HISTORY |
| GV$SESSTAT |
| GV$SESS_IO |
| GV$SGA |
| GV$SGAINFO |
| GV$SGASTAT |
| GV$SGA_DYNAMIC_COMPONENTS |
| GV$SGA_DYNAMIC_FREE_MEMORY |
| GV$SGA_TARGET_ADVICE |
| GV$SHARED_POOL_ADVICE |
| GV$SHARED_POOL_RESERVED |
| GV$SHARED_SERVER |
| GV$SORT_SEGMENT |
| GV$TEMPSEG_USAGE |
| GV$SORT_USAGE |
| GV$SPPARAMETER |
| GV$SQL |
| GV$SQLAREA |
| GV$SQLAREA_PLAN_HASH |
| GV$SQLCOMMAND |
| GV$SQLSTATS |
| GV$SQLSTATS_PLAN_HASH |
| GV$SQLTEXT |
| GV$SQL_BIND_CAPTURE |
| GV$SQL_BIND_DATA |
| GV$SQL_BIND_METADATA |
| GV$SQL_CURSOR |
| GV$SQL_FEATURE |
| GV$SQL_FEATURE_HIERARCHY |
| GV$SQL_HINT |
| GV$SQL_JOIN_FILTER |
| GV$SQL_MONITOR |
| GV$SQL_OPTIMIZER_ENV |
| GV$SQL_PLAN |
| GV$SQL_PLAN_MONITOR |
| GV$SQL_PLAN_STATISTICS |
| GV$SQL_PLAN_STATISTICS_ALL |
| GV$SQL_SHARED_CURSOR |
| GV$SQL_SHARED_MEMORY |
| GV$SQL_WORKAREA |
| GV$SQL_WORKAREA_ACTIVE |
| GV$SQL_WORKAREA_HISTOGRAM |
| GV$STATISTICS_LEVEL |
| GV$SYSAUX_OCCUPANTS |
| GV$SYSMETRIC |
| GV$SYSMETRIC_HISTORY |
| GV$SYSMETRIC_SUMMARY |
| GV$SYSSTAT |
| GV$SYSTEM_CURSOR_CACHE |
| GV$SYSTEM_EVENT |
| GV$SYSTEM_PARAMETER |
| GV$SYSTEM_PARAMETER2 |
| GV$TABLESPACE |
| GV$TEMPFILE |
| GV$TEMPORARY_LOBS |
| GV$TEMPSTAT |
| GV$TRANSACTION |
| GV$TRANSACTION_ENQUEUE |
| GV$UNDOSTAT |
| GV$VERSION |
| GV$WAITSTAT |
| GV$WORKLOAD_REPLAY_THREAD |
1 comment:
Sorry for my bad english. Thank you so much for your good post. Your post helped me in my college assignment, If you can provide me more details please email me.
Post a Comment