• 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


To check details about all the tablespaces inside the database


To check details about all the users inside the database


To check details about all the objects inside the database


To check details about all the data files inside the database


To check details about all the temp files inside the database


Dynamic Performance Views

Get details of currently connected users


Get details of database you are connected to


Get details of instance you are connected to


Get details of all control files in database


Get details of all data files in database


Get details of all temp files in database


Get details of all the log files in database


Gives details of SQLs statements running in memory


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