Q&A Categories

System-Architecture

Why oracle is called kernel packagecomponents of oracle tablesql system variables local and global variables

Why oracle is called kernel packagecomponents of oracle tablesql system variables local and global variables '

Answers No Answers In: System-Architecture By: claire [1 Grey Star Level] Sep 6, 2010

When Does DBWR write to the database ?

When Does DBWR write to the database ? DBWR  writes  when  more  data  needs  to  be read into the SGA and too few database  buffers  are free. The least recently...

Answers No Answers In: System-Architecture By: vikas [ Grey Star Level] Sep 3, 2010

When does LGWR write to the database ?

When does LGWR write to the database ? LGWR   writes  redo  log  entries  into  an  on-line  redo  log  file  when transactions commit and the...

Answers No Answers In: System-Architecture By: claire [1 Grey Star Level] Sep 3, 2010

What are the different Oracle Kernel Layers

What are the different Oracle Kernel Layers '

Answers No Answers In: System-Architecture By: deva [1 Grey Star Level] Sep 2, 2010

What is User Process ?

What is User Process ? A user process is created and maintained to execute the software code of an application  program.  It  is  a  shadow  process  created automatically...

Answers No Answers In: System-Architecture By: priyanka [ Grey Star Level] Aug 31, 2010

What is the maximum number of Lock Processes used ?

What is the maximum number of Lock Processes used ? Though  a single LCK process is sufficient for most Parallel Server systemsupto Ten Locks (LCK0,....LCK9) are used for inter-instance locking.'

Answers No Answers In: System-Architecture By: neha [ Grey Star Level] Aug 28, 2010

What is the function of ARCH ?

What is the function of ARCH ? Archiver  (ARCH) copies the on-line redo log files to archival storage when they  are  full.  ARCH is active only when a database's redo log is used...

Answers No Answers In: System-Architecture By: pooja [ Grey Star Level] Aug 28, 2010

What is the function of checkpoint (CKPT)?

What is the function of checkpoint (CKPT)? The Checkpoint (CKPT) process is responsible for signaling  DBWR  at checkpoints  and updating all the data files and...

Answers No Answers In: System-Architecture By: faiz [ Grey Star Level] Aug 28, 2010

What is the function of Dispatcher (Dnnn) ?

What is the function of Dispatcher (Dnnn) ? Dispatcher   (Dnnn)  process  is  responsible  for  routing  requests  from connected user processes to available...

Answers No Answers In: System-Architecture By: shoeb [ Grey Star Level] Aug 28, 2010

What is the function of Lock (LCKn) Process ?

What is the function of Lock (LCKn) Process ? Lock  (LCKn)  are  used for inter-instance locking when the ORACLE Parallel Server option is used.'

Answers No Answers In: System-Architecture By: ashok [ Grey Star Level] Aug 28, 2010

Didn't find what you were looking for?

Add your Question to the site.

You must be Logged In to Add a Question.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]