Topic : Architecture

What is the function of Optimizer?


Answer :

The goal of the optimizer is to choose the most efficient way to execute a SQL statement.

Show Answer Discuss

What Does DBWR do?


Answer :

Database writer writes modified blocks from the database buffer cache to the data files.

Show Answer Discuss

Which background process writes data from log buffer to redo log files?


Answer :

Log writer (LGWR)

Show Answer Discuss

What does COMMIT do?


Answer :

COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed.

Show Answer Discuss

How do you know whether the process is Server Side Process?


Answer :

By seeing the process in ps-ef as ORACLE_SID.

Show Answer Discuss