Steps in creating a database manually
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...
oracle background processes
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...
Oracle 11g – Database Instance Administration
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...
Oracle database 11g System Global Area
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....
Undo tablespace management
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,...
Startup shutdown modes oracle database – Activity
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...
Oracle 11g : Tablespace Management activity
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...
Oracle database architecture 11g
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...