Views we use in the database.

Views we use in the database

====================================

VIEWS WE QUERY IN DATABASE

1} V$CONTROLFILE   à Lists the names and status of the control files.

2} V$DATABASE        à Contains database information from the control files.

3} V$DATAFILE          à Contains data file information from control file.

4} V$INSTANCE          à Displays the state of the current instance.

5} V$PARAMETER     à Lists parameters and values currently in effect for the

                                            Session also status and location of all parameters.

6} V$SESSION              à Lists session information for each current session.

7} V$SGA                     à Contains summary information on SGA.

8} V$SPPARAMETER à Lists the contents of SPFILE.

9} V$TABLESPACE     à Displays tablespace information from the control file.

10} V$THREAD           à Contains thread information from control file.

11} V$VERSION          à Version numbers of core library components in oracle server.

12} V$FIXED_TABLE à To find list of data dictionary views.

13} V$CONTROLFILE_RECORD_SECTION à Provides information about the                                                                                   Control file record section.

14}SHOW PARAMETER CONTROL_FILES à Lists the name, status and location of                                                                                                Control files.

15}V$THREAD           à To display the current redo log group, the no. of online redo log                                                                                                     groups and current sequence number.

16} V$LOGFILE         à Displays each redo log group, member and status of each Member.

17} V$LOG                 à Same as above.

18} V$DATABASE_PROPERTIES àName of default tablespaces.

19}V$DBA_TABLESPACES à Complete information about tablespaces.

20}V$DBA_DATA_FILES à Complete information of the files present in the                                              Tablespaces.

21} V$DBA_TEMP_FILES à File’s information of temporary tablespace.

22} V$DBA_EXTENTS       à To check the extents for a given segment.

23} V$DBA_SEGMENTS    à View to get number of  extents and blocks allocated to a                                                      Segment.

24} V$DBA_FREE_SPACE à Displays free extents in tablespace.

25} V$DBA_ROLLBACK_SEGS à To obtain information about all the undo segments                                                                  In the database.

{IMP*:-Information about undo segments that are offline can be seen only in this view.}

26}V$ROLLSTAT & V$ROLLNAME à Views to obtain the statistics of the undo                                                                                          Segments currently used by the instance.

27} V$TRANSACTION & V$SESSION à To check the use of a undo segment by                                                                                             Currently active transactions.

28} V$DBA_TABLES          à All the information about tables can be obtained here.

29} V$DBA_OBJECTS        à All the information about objects in table can be                                                       Obtained here.

30} V$DBA_UNUSED_COL_TABS à To identify tables with unused columns.

31} V$DBA_PARTIAL_DROP_TABS à To identify tables that have partially                                                                       Completed DROP columns operations.                                                                                   

32}V$DBA_INDEXES         à Provides information on the indexes.

33}V$DBA_IND_COLUMNS à Provides information on the columns indexed.

34}V$OBJECT _USAGE         à Provides information on the usage of an index.

35}V$DBA_CONSTRAINTS  àTo obtain name, type and status of  all constraints.

36}V$DBA_CONS_COLUMNS à To obtain the columns in the constraints on table.

37}V$DBA_USERS                 à To obtain information about account status, default                                                                  Tablespace for users.

38}V$DBA_PROPERTIES      à View to display passwd profile information.

39}V$DBA_TS_QUOTAS     à Amount of space a user can use in tablespaces.

40}V$DBA_SYS_PRIVS       à Lists system privileges granted to users and roles.

41} V$SESSION_PRIVS       à Lists the privileges that are currently available to user.

42} V$DBA_TAB_PRIVS    à Lists all grants on all objects in the database.

43}V$DBA_COL_PRIVS     àDescribes all object grants in the database.

44}V$DBA_ROLES             àAll roles that exist in the database.

45}V$DBA_ROLES_PRIVS à Roles granted to users and roles.

46}V$ROLE_ROL_PRIVS   à Roles that are granted to roles.

47}V$DBA_SYS_PRIVS      àSystem privileges granted to users and roles.

48}V$ROLE_SYS_PRIVS   à System privileges granted to roles.

49}V$ROLE_TAB_PRIVS  àObject privileges granted to roles.

50}V$SESSION_ROLES    à Roles that the user currently has enabled.