Home » Server Options » RAC & Failsafe » Is there GV$ views for every V$ views in rac (oracle 10g Linux 4 2 node)
Is there GV$ views for every V$ views in rac [message #344471] Fri, 29 August 2008 22:46 Go to next message
reyazan
Messages: 53
Registered: February 2005
Member
Is there GV$ views for every V$ views in rac?
Re: Is there GV$ views for every V$ views in rac [message #344473 is a reply to message #344471] Fri, 29 August 2008 22:51 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

>Is there GV$ views for every V$ views in rac?
I suggest you look inside the data dictionary to see for yourself.

Are there differences in data dictionary objects between RAC DB & non-RAC DB?

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
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
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
Previous Topic: Oracle Fail Safe
Next Topic: Not able to view ASM disks in OUI during ASM instance configuration
Goto Forum:
  


Current Time: Sun Nov 24 00:52:28 CST 2024