Which Process read data from the datafiles in Oracle

Which process read data from the data files in Oracle

Server process is a process running on the database server machine that executes the SQL it receives from the user process.

This is your basic client-server split: a user process generating SQL, a server process executing it.

The execution of a SQL statement goes through four stages:
PARSE
BIND
EXECUTE
FETCH

Parse phase Server process works out what the statement actually means, and how best to execute it. Parsing involves interaction with the shared pool of the instance.

Bind Phase any variables used in SQL Statement are convert to its actual literal values.

Execute & Fetch phase During the execution of a statement, data in the database buffer cache will be read or updated and changes written to the redo log buffer but if the relevant blocks are not in the database buffer cache, your server process will fetch data into buffer cache from the data files.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s