• 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




Recent Posts

See All

How to plan database creation

Database creation process involves several operating system files to work together. You create database only once and later on keep on adding more data files. Before you can simply go ahead and start

Oracle Transportable Tablespace

Assume that you have a schema (IQS) on production server and you want to import the schema into test server. The ideal approach would be to perform entire schema export and import using data pump. Rig

Grant Select on all tables in a schema

I encountered this situation where I wanted to grant SELECT on all the tables owned by one user to another user. There are two simple ways to achieve this: Generate SQL for each table In this method,

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback