In this post, we are going to learn “how to create an Oracle database manually”. The database in Oracle can be created using DBCA and using the manual method. it would be a good idea to create a database manually at least once to understand how a database is created step by step in Oracle. Step …
In this post, we will discuss Oracle 11g Process Architecture that is background processes of Oracle database 11g in detail. We will discuss SMON, PMON, DBWn, LGWR, and CKPT in detail. Oracle background processes There are different types of processes in oracle server User Process: Starts when a database user requests to connect to an …
In this post, we will walk through some of the important scripts which we use in our day-to-day database instance administration.we will learn about spfile and pfile locations and how to create them in detail. How to create spfile from pfile SYS> create spfile from pfile; File created. SYS> How to create pfile from spfile SYS> create pfile …
We will now learn about Oracle database 11g System Global Area. In this post, we will discuss Database buffer cache, Redo buffer cache, shared pool and few more memory components that reside in SGA. Oracle database 11g System Global Area Oracle database 11g System Global Area (SGA) The main components of SGA are Database Buffer …
in this post, we are going to learn about undo and we will create undo tablespace. What is undo? Oracle maintains a mechanism to maintain information that is used to roll back or undo, changes to the database.such information consists of records of the actions of transactions before they are committed. These records are called …
In this post, we will perform an activity on startup and shutdown modes of Oracle database.The startup modes include startup open, startup mount, startup nomount and shutdown modes include shutdown abort, shutdown transactional, shutdown normal, shutdown immediate. Also read the startup and shutdown modes of Oracle database concept. Database shutdown modes They are of four …
Startup shutdown modes oracle database – Activity Read More »
The CREATE TABLESPACE statement is used to create a tablespace in Oracle database where schema objects are stored. The CREATE TABLESPACE statement can be used to create the 3 kinds of tablespaces: Permanent Tablespace Temporary Tablespace Undo Tablespace 1. Permanent Tablespace HOW TO CREATE A NEW TABLESPACE SYS> SYS> create tablespace NEWTS datafile ‘/u01/TEST/newts01.dbf’ size …
In this post, we are going to have a brief introduction to Oracle database 11g architecture. We are going to discuss more on the architecture when we discuss complete Oracle 11g in future posts Introduction to Oracle 11g Server Architecture An Oracle server is a combination of Oracle Instance and an Oracle database. Oracle instance …