1} V$CONTROLFILELists the names and status of the control files.
2} V$DATABASEContains database information from the control files.
3} V$DATAFILEContains data file information from control file.
4} V$INSTANCEDisplays the state of the current instance.
5} V$PARAMETERLists parameters and values currently in effect for the Session also status and location of all parameters.
6} V$SESSIONLists session information for each current session.
7} V$SGAContains summary information on SGA.
8} V$SPPARAMETERLists the contents of SPFILE.
9} V$TABLESPACEDisplays tablespace information from the control file.
10} V$THREADContains thread information from control file.
11} V$VERSIONVersion numbers of core library components in oracle server.
12} V$FIXED_TABLETo find list of data dictionary views.
13} V$CONTROLFILE_RECORD_SECTIONProvides information about the Control file record section.
14}SHOW PARAMETER CONTROL_FILESLists the name, status and location of Control files.
15}V$THREADTo display the current redo log group, the no. of online redo log groups and current sequence number.
16} V$LOGFILEDisplays each redo log group, member and status of each Member.
17} V$LOG Same as above.
18} V$DATABASE_PROPERTIESName of default tablespaces.
19}V$DBA_TABLESPACESComplete information about tablespaces.
20}V$DBA_DATA_FILESComplete information of the files present in the Tablespaces.
21} V$DBA_TEMP_FILESFile’s information of temporary tablespace.
22} V$DBA_EXTENTSTo check the extents for a given segment.
23} V$DBA_SEGMENTSView to get number of extents and blocks allocated to a Segment.
24} V$DBA_FREE_SPACEDisplays free extents in tablespace.
25} V$DBA_ROLLBACK_SEGSTo 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$ROLLNAMEViews to obtain the statistics of the undo Segments currently used by the instance.
27} V$TRANSACTION & V$SESSIONTo check the use of a undo segment by Currently active transactions.
28} V$DBA_TABLESAll the information about tables can be obtained here.
29} V$DBA_OBJECTSAll the information about objects in table can be obtained here.
30} V$DBA_UNUSED_COL_TABSTo identify tables with unused columns.
31} V$DBA_PARTIAL_DROP_TABSTo identify tables that have partially Completed DROP columns operations.
32}V$DBA_INDEXESProvides information on the indexes.
33}V$DBA_IND_COLUMNSProvides information on the columns indexed.
34}V$OBJECT _USAGEProvides information on the usage of an index.
35}V$DBA_CONSTRAINTSTo obtain name, type and status of all constraints.
36}V$DBA_CONS_COLUMNSTo obtain the columns in the constraints on table.
37}V$DBA_USERSTo 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_PRIVSLists all grants on all objects in the database.
43}V$DBA_COL_PRIVS Describes all object grants in the database.
44}V$DBA_ROLESAll roles that exist in the database.
45}V$DBA_ROLES_PRIVSRoles granted to users and roles.
46}V$ROLE_ROL_PRIVSRoles that are granted to roles.
47}V$DBA_SYS_PRIVS System privileges granted to users and roles.
48}V$ROLE_SYS_PRIVSSystem privileges granted to roles.
49}V$ROLE_TAB_PRIVSObject privileges granted to roles.
50}V$SESSION_ROLESRoles that the user currently has enabled
Comments
Tags: #dba_immam, #dbaimmam, #immam_dba, Happy Birthday Syed Ali Immam Rizvi, Oracle DBA, syed ali immam rizvi, Views In Database, Views We Qery In Database