Wednesday, September 18, 2013

11g background Process

11g background Process


New background processes in 11g. As per Oracle documentation there are 56 new background processes added in 11g release 1

Some Important background Process

MMAN - this process is responsible for ASMM in 10g and AMM in 11g  which manages memory allocation to SGA and PGA

RCBG - this background process is responsible for processing data into server result cache

DIAG - In 11g we have a single location for all the trace files, alert log and other diagnostic files. DIAG is the process which performs  diagnostic dumps and executes oradebug commands

DIA0 – responsible for hang detection and deadlock resoultion

DBRM – Database resource manager is responsible for setting plans to users and all other database resource management activities

EMNC – Event Monitor Coordinator will coordinate with event management and notification activity

FBDA – Flashback Data Archiver process is responsible for all flashback related actions in 11g database

GEN0 - General task execution process which performs required tasks

SMCo – Space management coordinator executes various space management tasks like space reclaiming, allocation etc. It uses slave processes Wnnn whenever required

VKTM – Virtual keeper of time is  responsible for keeping track of the wall-clock time and used as a reference-time counter







Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog.  Chetan Yadav 

Monday, September 2, 2013


SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date date = sdf.parse(“2013-08-05 17:41:37”);
Calendar calendar = Calendar.getInstance();
calendar.setTime(date);
calendar.add(Calendar.HOUR,2);
String finaldate = sdf.format(calendar.getTime());

Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav

Friday, August 23, 2013

Oracle Webinars Coming Up In August 2013

Oracle Webinars Coming Up
Syed Jaffar Hussain (Oracle ACE Director) explains how to upgrade a 2 node 11gR2 clusterware and database to Oracle 12c. Register now (Limited spaces).
Kyle Hailey (Oracle ACE, OakTable) looks at different types of cloning technology and demonstrates how to setup risk-free database experiments. Register now(Limited spaces).
Cary Millsap (Oracle ACE Director, OakTable) explains why great performance at scale doesn't happen by accident and how performance should be measured.Watch video.






Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav