• Arun Kumar

Basic Views You Must Know

Below I have listed basic views that every DBA must know. These views help you get information related to the database.


Data Dictionary Views


To check details about all the tables inside the database


DBA_TABLES

To check details about all the tablespaces inside the database


DBA_TABLESPACES

To check details about all the users inside the database


DBA_USERS

To check details about all the objects inside the database


DBA_OBJECTS

To check details about all the data files inside the database


DBA_DATA_FILES

To check details about all the temp files inside the database


DBA_TEMP_FILES


Dynamic Performance Views


Get details of currently connected users


V$SESSION

Get details of database you are connected to


V$DATABASE

Get details of instance you are connected to


V$INSTANCE

Get details of all control files in database


V$CONTROLFILE

Get details of all data files in database


V$DATAFILE

Get details of all temp files in database


V$TEMPFILE

Get details of all the log files in database


V$LOGFILE

Gives details of SQLs statements running in memory


V$SQL




171 views

Recent Posts

See All

Oracle 12c to 19c Database Upgrade

In this article we will be looking at two most commonly used methods of upgrading Oracle database from 12c to 19c Pre-upgrade tasks Upgrade using DBUA Upgrade using Manual Method You can perform a dir