Temporary tablespace group in oracle database

  In this tutorial we will learn what is a temporary tablespace group, how to create a temporary tablespace group,how to add existing temporary tablespace to temporary tablespace group , how to set a temporary tablespace group to default temporary tablespace. Table Of Contents ...

Read More»

How to create Temporary tablespace in oracle database

In this tutorial we will learn  what is temporary tablespace in oracle ,   view temporary tablespace using oracle data dictionary table,  how to create temporary tablespace in oracle ,  how to resize temporary tablespace,  how to set default temporary...

Read More»

Tablespace and datafile management in oracle

In this article we will learnView tablespace in oracle,create Tablespace in oracle and create more than one datafile in Tablespace,rename Tablespace in oracle,rename datafile and online and offline mode of Tablespace,resize datafile in existing tablespace,extend Tablespace in Oracle database,drop...

Read More»

Memory structure in oracle database

 In this tutorial we will learn Memory structure in oracle database . Memory structure of oracle database consists of two types .1. SGA : Shared Global Area2. PGA: Program Global AreaSGA:SGA is sets of shared memory structures which stores data (program code)and control information of oracle database...

Read More»

What is tablespace in oracle In details

 In this tutorial we will learn what is tablespace in oracle ,different types of tablespace , what is the default tablespace in oracle database and mode of tablespace in oracle.What is tablespace in oracle: Tablespace is one of the logical structure of the oracle database. Oracle logically...

Read More»

How to shutdown oracle database on linux

  In this tutorial we learn about how to shutdown  oracle database on linux. There are different stages of shutdown of oracle database. There are also different mode for shutdown oracle database. All DBA should know about all the mode of shutdown for oracle database. Different stages...

Read More»

Startup oracle database

  In this tutorial we learn about startup concept of oracle database. There are different stage to startup oracle database.without startup oracle instance we can not access oracle database. Different stages for startup oracle database: There are three stages to startup oracle database.these...

Read More»

Background processes in oracle 11g database explain

  In this tutorial we will  learn about the background processes in oracle which is running in oracle instance to help data processing for oracle database. Table Of Contents   Background processes in oracle databaseDBWR: LGWR:  CKPT:  PMON: SMON: ARCn:...

Read More»

ORACLE DATABASE VS ORACLE INSTANCE

  In this tutorial we learn what is oracle instance and what is oracle database.Below picture will help you to know about oracle instance and oracle database. Oracle instance: Oracle instance combination of background process such as (dbwr,lgwr,ckpt,pmon,smon and so on) and allocated memory...

Read More»

pfile vs spfile in oracle database

 In this tutorial we learn what is pfile and what is spfile in oracle database.What is the difference between spfile and pfile in Oracle database .How to change these parameter file .Both spfile and pfile are the parameter files in oracle database which is store the instance parameter value such...

Read More»

Difference between OLTP vs OLAP in database

 OLTP vs OLAP in database In this tutorial we will learn  the concept of OLTP  vs  OLAP in database. Every dba should know the concept of OLTP and OLAP.What does OLTP stand for:- OLTP stands for online transaction processing. Normally we create OLTP database for ongoing transaction...

Read More»