Topic : Architecture

How many Dispatcher Processes are created ?


Answer :

Atleast one Dispatcher process is created for every communication protocol in use.

Show Answer Discuss

What is the function of Dispatcher (Dnnn) ?


Answer :

Dispatcher (Dnnn) process is responsible for routing requests from connected user processes to available shared server processes and returning the responses back to the appropriate user processes.

Show Answer Discuss

What is the function of Lock (LCKn) Process ?


Answer :

Lock (LCKn) are used for inter-instance locking when the ORACLE Parallel Server option is used.

Show Answer Discuss

How many maximum DBWn(Db writers) we can invoke?


  • 3
  • 1
  • 10
  • 20

Answer :

20

Show Answer Discuss

Which dynamic view can be queried when a database is started up in no mount state?


  • V$LOGFILE
  • V$INSTANCE
  • V$CONTROLFILE
  • $DATAFILE_HEADER

Answer :

V$INSTANCE

Show Answer Discuss