Sunday, November 16, 2008

Additional V$ Views found in Oracle Database 10g Rel 2

Hi Friends,

Here is one more difference with my previous post on Additional V$ Views in Oracle Database 11g Release 1. 

I just found that I have a copy of Oracle 10g Release 2 Installation in my lapi.. and below are the views that are new in Oracle 10g Release 2

Sr. No.

Name

1

V$ASM_DISKGROUP_STAT

2

V$ASM_DISK_STAT

3

V$BACKUP_ARCHIVELOG_DETAILS

4

V$BACKUP_ARCHIVELOG_SUMMARY

5

V$BACKUP_CONTROLFILE_DETAILS

6

V$BACKUP_CONTROLFILE_SUMMARY

7

V$BACKUP_COPY_DETAILS

8

V$BACKUP_COPY_SUMMARY

9

V$BACKUP_DATAFILE_DETAILS

10

V$BACKUP_DATAFILE_SUMMARY

11

V$BACKUP_PIECE_DETAILS

12

V$BACKUP_SET_DETAILS

13

V$BACKUP_SET_SUMMARY

14

V$BACKUP_SPFILE_DETAILS

15

V$BACKUP_SPFILE_SUMMARY

16

V$BLOCKING_QUIESCE

17

V$CLUSTER_INTERCONNECTS

18

V$CONFIGURED_INTERCONNECTS

19

V$DATAGUARD_STATS

20

V$DB_TRANSPORTABLE_PLATFORM

21

V$FLASH_RECOVERY_AREA_USAGE

22

V$LOGMNR_DICTIONARY_LOAD

23

V$LOGSTDBY_PROCESS

24

V$LOGSTDBY_PROGRESS

25

V$LOGSTDBY_STATE

26

V$LOGSTDBY_TRANSACTION

27

V$MUTEX_SLEEP

28

V$MUTEX_SLEEP_HISTORY

29

V$PARAMETER_VALID_VALUES

30

V$PROCESS_MEMORY

31

V$PROCESS_MEMORY_DETAIL

32

V$PROCESS_MEMORY_DETAIL_PROG

33

V$PROXY_ARCHIVELOG_DETAILS

34

V$PROXY_ARCHIVELOG_SUMMARY

35

V$PROXY_COPY_DETAILS

36

V$PROXY_COPY_SUMMARY

37

V$RESTORE_POINT

38

V$RFS_THREAD

39

V$RMAN_BACKUP_JOB_DETAILS

40

V$RMAN_BACKUP_SUBJOB_DETAILS

41

V$RMAN_BACKUP_TYPE

42

V$RMAN_ENCRYPTION_ALGORITHMS

43

V$RSRC_CONS_GROUP_HISTORY

44

V$RSRC_PLAN_HISTORY

45

V$RSRC_SESSION_INFO

46

V$SGA_TARGET_ADVICE

47

V$SQLAREA_PLAN_HASH

48

V$SQLSTATS

49

V$SQL_JOIN_FILTER

50

V$STANDBY_APPLY_SNAPSHOT

51

V$STREAMS_POOL_ADVICE

52

V$STREAMS_TRANSACTION

53

V$TSM_SESSIONS

54

V$UNUSABLE_BACKUPFILE_DETAILS

55

V$WALLET

56

V$XML_AUDIT_TRAIL

 
Thanks for watching the blog... I hope that I am serving you better.... Please let me know if you have anything....

Once again Thanks to all...

:)