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:
Post a Comment