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.

No comments: