American Database Consulting, LLC

RAC GV$ Views
Home
Downloads
BLOG
ORACLE
CommVault Consultation
Support
Useful Tips
Video Training
Contact Information
Resume

What Are the Names of All GV$ Views?

Simply query from DBA_OBJECTS as follows:

SQL> select object_name
                           from dba_objects 
where object_name like 'GV$%' order by 1;
 
OBJECT_NAME
---------------------------------------
GV$ACCESS
GV$ACTIVE_INSTANCES
GV$ACTIVE_SERVICES
GV$ACTIVE_SESSION_HISTORY
GV$ACTIVE_SESS_POOL_MTH
GV$ADVISOR_PROGRESS
GV$ALERT_TYPES
GV$AQ
GV$AQ1
GV$ARCHIVE
GV$ARCHIVED_LOG
GV$ARCHIVE_DEST
GV$ARCHIVE_DEST_STATUS
GV$ARCHIVE_GAP
GV$ARCHIVE_PROCESSES
GV$TRANSACTION
GV$TRANSACTION_ENQUEUE
GV$TRANSPORTABLE_PLATFORM
GV$TSM_SESSIONS
GV$TYPE_SIZE
GV$UNDOSTAT
GV$VERSION
GV$VPD_POLICY
GV$WAITCLASSMETRIC
GV$WAITCLASSMETRIC_HISTORY
GV$WAITSTAT
GV$WALLET
GV$XML_AUDIT_TRAIL
GV$_LOCK

American Database Consulting and Service Company
4765 Rustler Ct.
Colorado Springs, CO 80918