How Oracle Works?

1.	How Oracle Works?
Answer» An instance has started on the database server. A client established a connection to the server, using the proper Oracle Net SERVICES driver. The server creates a dedicated server PROCESS on behalf of the user process. The user executes SQL statement and commits the transaction. The server process receives the statement and CHECKS for any shared SQL area that contains a similar SQL. The server process retrieves data from datafile (table) or SGA. The server process modifies data in the SGA area. The DBWn process writes modified BLOCKS permanently to disk. The LGWR process records the transaction in the redo log file. The server process sends a message to the application.

Answer»

An instance has started on the database server.
A client established a connection to the server, using the proper Oracle Net SERVICES driver.
The server creates a dedicated server PROCESS on behalf of the user process.
The user executes SQL statement and commits the transaction.
The server process receives the statement and CHECKS for any shared SQL area that contains a similar SQL.
The server process retrieves data from datafile (table) or SGA.
The server process modifies data in the SGA area. The DBWn process writes modified BLOCKS permanently to disk. The LGWR process records the transaction in the redo log file.
The server process sends a message to the application.

Discussion