| Is there GV$ views for every V$ views in rac [message #344471] |
Fri, 29 August 2008 22:46  |
reyazan
Messages: 35
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  |
anacedent
Messages: 7064
Registered: July 2005
Location: surf meets turf in 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 |
Michel Cadot
Messages: 21459
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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
|
|
|
]
Members
Search
Help
Register
Login
Home
