Blog

Q. List four possible ways (direct or indirect) to execute an SQL query against an Oracle Database? 1. Using the SQL*Plus command line tool. With this tool, you…

What is a listener? Listener is a process that resides on the Oracle server whose responsibility is to listen for incoming client connection requests and manage…

Profiles The PROFILE specifies the name of the profile to be created. Use profiles to limit the database resources available to a user for a single call or a s…

Control file management The control file is a small binary file necessary for the database to start and operate successfully. Each control file is associated w…

The most crucial structure for recovery operations is the redo log, which consists of two or more preallocated files that store all changes made to the database…

To list the grants made for objects, a user can query the following data dictionary views: All_col_privs, user_col_privs, dba_col_privs All_col_privs_made, …

REVOKE Use to revoke privileges already granted to other users. For example to revoke select, update, insert privilege you have granted to Sami then give the …

This section describes aspects of granting privileges and roles, and includes the below topics: Granting system privileges and roles: You can grant system PRI…

This section describes aspects of managing roles, and includes the following topics: Creating role. Predefined role. A ROLE groups several PRIVILEGES AND …

Privileges: A privilege is a permission to execute an action or to access another user’s objects. The following are a few examples of privileges: The right t…

Each oracle database has a list of USER NAMES. To access a database, a user must use a database application and attempt a connection with a valid user name of t…

Rdbms server comes into picture when oracle allocates space to a segment (like a table or index), or when a group of contiguous free blocks, called an extent, i…

The following data dictionary and dynamic performance views provide useful information about the tablespaces of a DATABASE.   View Description …

The following sections describe some uses for TRANSPORTABLE TABLESPACES: Transporting and attaching partitions for data warehousing:         Typical enterpris…

The following steps summarize the process of TRANSPORTING A TABLESPACE. Details for each step are provided in the subsequent example. 1. For cross-platform tra…

Introduction to transportable tablespaces: You can use the TRANSPORTABLE TABLESPACES feature to copy a set of tablespaces from one oracle database to another. …

Oracle database includes the dbms_space_admin package, which is a collection of aids for diagnosing and repairing problems in LOCALLY MANAGED TABLESPACES. Dbms…

The sysaux tablespace was installed as an auxiliary tablespace to the system tablespace when you created your database. Some database components that formerly c…

Renaming Tablespaces Using the rename to clause of the alter tablespace, you can rename a permanent or temporary tablespace. For example, the following stateme…

Making a tablespace read-only prevents write operations on the datafiles in the tablespace. The primary purpose of READ-ONLY TABLESPACES is to eliminate the nee…

Altering tablespace availability: You can take an online TABLESPACE offline so that it is temporarily unavailable for general use. The rest of the database rem…

This tutorial gives you an overview and talks about the fundamentals of Oracle DBA. ORACLE DATABASE 12C ARCHITECTURE This section highlights the concepts and …

ou can create tablespaces with block sizes different from the standard database block size, which is specified by the db_block_size initialization parameter. Th…

Automatic tuning of Undo Retention Oracle database automatically tunes the undo retention period based on how the undo tablespace is configured. 1. If the und…

Undo retention When automatic undo management is enabled, there is always a current undo retention period, which is the minimum amount of time that oracle data…

Managing the undo tablespace: This post describes how to manage the undo tablespace, which stores information used to roll back changes to the oracle database.…

Multiple Temporary Tablespaces Using tablespace groups:- It contains at least one tablespace. There is no explicit limit on the maximum number of tablespaces …

Temporary Tablespaces Temporary tablespaces can improve the concurrency of multiple sort operations, reduce their overhead and avoid oracle database space mana…

Bigfile Tablespaces A bigfile tablespace is a tablespace with a single, but very large (up to 4g blocks) datafile. Traditional smallfile tablespaces, in contra…

Locally managed tablespaces: Locally managed tablespaces track all extent information in the tablespace itself by using bitmaps, resulting in the following ben…

Overview of tablespaces A database is divided into one or more logical storage units called tablespaces. Tablespaces are divided into logical units of storage …

Startup    There are various stages which the database undergoes before a database is opened for use. Nomount State: This is the state when the control file,…

Steps to Create Database STEP 1:  Login as a oracle user and move to dbs directory, it is available in oracle_home  location $cd $oracle_home/dbs STEP 2: C…

Oracle Database 11g Installation System Administrator Task STEP1: Creating required operating system groups and user Create dba group # groupadd –g 700 …

Oracle Database Architecture In this post, you will learn about the ORACLE DATABASE Architecture components such as Log Writer, DB Writer,etc (Background Proce…