|
|
Re: Is there GV$ views for every V$ views in rac [message #344507 is a reply to message #344471] |
Sat, 30 August 2008 02:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
SQL> select view_name from v$fixed_view_definition
2 where view_name like 'V$%' and lower(VIEW_DEFINITION) not like '%gv%'
3 order by 1
4 /
VIEW_NAME
------------------------------
V$AW_AGGREGATE_OP
V$AW_ALLOCATE_OP
V$BACKUP_ARCHIVELOG_DETAILS
V$BACKUP_ARCHIVELOG_SUMMARY
V$BACKUP_CONTROLFILE_DETAILS
V$BACKUP_CONTROLFILE_SUMMARY
V$BACKUP_COPY_DETAILS
V$BACKUP_COPY_SUMMARY
V$BACKUP_DATAFILE_DETAILS
V$BACKUP_DATAFILE_SUMMARY
V$BACKUP_PIECE_DETAILS
V$BACKUP_SET_DETAILS
V$BACKUP_SET_SUMMARY
V$BACKUP_SPFILE_DETAILS
V$BACKUP_SPFILE_SUMMARY
V$BLOCK_CHANGE_TRACKING
V$CONTEXT
V$DATAGUARD_CONFIG
V$DATAGUARD_STATS
V$DB_TRANSPORTABLE_PLATFORM
V$FLASH_RECOVERY_AREA_USAGE
V$LOCKS_WITH_COLLISIONS
V$PROXY_ARCHIVELOG_DETAILS
V$PROXY_ARCHIVELOG_SUMMARY
V$PROXY_COPY_DETAILS
V$PROXY_COPY_SUMMARY
V$RECOVERY_FILE_DEST
V$RMAN_BACKUP_JOB_DETAILS
V$RMAN_BACKUP_SUBJOB_DETAILS
V$RMAN_BACKUP_TYPE
V$TRANSPORTABLE_PLATFORM
V$UNDOSTAT
V$UNUSABLE_BACKUPFILE_DETAILS
33 rows selected.
Regards
Michel
|
|
|